M_GPBPRXY_PROXY_IDM

M_GPBPRXY_PROXY_IDM                CONSTANT VARCHAR2(30) := 'GPBPRXY_PROXY_IDM';

FILE NAME..: gpkd_gpbprxy0.sql RELEASE....: 8.5 OBJECT NAME: DML_GPBPRXY PRODUCT....: GENERAL USAGE......: Package contains table DML procedures for the GPBPRXY table.
COPYRIGHT..: Copyright 2011 Sungard. All rights reserved.
 
DESCRIPTION:
 
Standard dml functions and procedures for the GPBPRXY table.
Table Comments : Proxy base table
 
 Cursors: None
 
 Functions: None
 
 Procedures:
   P_DELETE      Procedure to delete a record from the table.
   P_INSERT      Procedure to insert a record into the table.
   P_UPDATE      Procedure to update a record in the table.
 
DESCRIPTION END
 
 Constants

M_GPBPRXY_EMAIL_ADDRESS

M_GPBPRXY_EMAIL_ADDRESS            CONSTANT VARCHAR2(30) := 'GPBPRXY_EMAIL_ADDRESS';

M_GPBPRXY_LAST_NAME

M_GPBPRXY_LAST_NAME                CONSTANT VARCHAR2(30) := 'GPBPRXY_LAST_NAME';

M_GPBPRXY_PROXY_PIDM

M_GPBPRXY_PROXY_PIDM               CONSTANT VARCHAR2(30) := 'GPBPRXY_PROXY_PIDM';

M_GPBPRXY_EMAIL_VER_DATE

M_GPBPRXY_EMAIL_VER_DATE           CONSTANT VARCHAR2(30) := 'GPBPRXY_EMAIL_VER_DATE';

M_GPBPRXY_ACTIVITY_DATE

M_GPBPRXY_ACTIVITY_DATE            CONSTANT VARCHAR2(30) := 'GPBPRXY_ACTIVITY_DATE';

M_GPBPRXY_FIRST_NAME

M_GPBPRXY_FIRST_NAME               CONSTANT VARCHAR2(30) := 'GPBPRXY_FIRST_NAME';

M_GPBPRXY_PIN

M_GPBPRXY_PIN                      CONSTANT VARCHAR2(30) := 'GPBPRXY_PIN';

M_GPBPRXY_PIN_DISABLED_IND

M_GPBPRXY_PIN_DISABLED_IND         CONSTANT VARCHAR2(30) := 'GPBPRXY_PIN_DISABLED_IND';

M_GPBPRXY_PIN_EXP_DATE

M_GPBPRXY_PIN_EXP_DATE             CONSTANT VARCHAR2(30) := 'GPBPRXY_PIN_EXP_DATE';

M_GPBPRXY_LAST_LOGIN_DATE

M_GPBPRXY_LAST_LOGIN_DATE          CONSTANT VARCHAR2(30) := 'GPBPRXY_LAST_LOGIN_DATE';

M_GPBPRXY_INV_LOGIN_CNT

M_GPBPRXY_INV_LOGIN_CNT            CONSTANT VARCHAR2(30) := 'GPBPRXY_INV_LOGIN_CNT';

M_GPBPRXY_SALT

M_GPBPRXY_SALT                     CONSTANT VARCHAR2(30) := 'GPBPRXY_SALT';

M_GPBPRXY_CREATE_USER

M_GPBPRXY_CREATE_USER              CONSTANT VARCHAR2(30) := 'GPBPRXY_CREATE_USER';

M_GPBPRXY_CREATE_DATE

M_GPBPRXY_CREATE_DATE              CONSTANT VARCHAR2(30) := 'GPBPRXY_CREATE_DATE';

M_GPBPRXY_USER_ID

M_GPBPRXY_USER_ID                  CONSTANT VARCHAR2(30) := 'GPBPRXY_USER_ID';

M_GPBPRXY_OPT_OUT_ADV_DATE

M_GPBPRXY_OPT_OUT_ADV_DATE         CONSTANT VARCHAR2(30) := 'GPBPRXY_OPT_OUT_ADV_DATE';

M_GPBPRXY_ENTITY_CDE

M_GPBPRXY_ENTITY_CDE               CONSTANT VARCHAR2(30) := 'GPBPRXY_ENTITY_CDE';

M_GPBPRXY_MI

M_GPBPRXY_MI                       CONSTANT VARCHAR2(30) := 'GPBPRXY_MI';

M_GPBPRXY_ID

M_GPBPRXY_ID                       CONSTANT VARCHAR2(30) := 'GPBPRXY_ID';

M_GPBPRXY_STREET_LINE1

M_GPBPRXY_STREET_LINE1             CONSTANT VARCHAR2(30) := 'GPBPRXY_STREET_LINE1';

M_GPBPRXY_STREET_LINE2

M_GPBPRXY_STREET_LINE2             CONSTANT VARCHAR2(30) := 'GPBPRXY_STREET_LINE2';

M_GPBPRXY_STREET_LINE3

M_GPBPRXY_STREET_LINE3             CONSTANT VARCHAR2(30) := 'GPBPRXY_STREET_LINE3';

M_GPBPRXY_STREET_LINE4

M_GPBPRXY_STREET_LINE4             CONSTANT VARCHAR2(30) := 'GPBPRXY_STREET_LINE4';

M_GPBPRXY_CITY

M_GPBPRXY_CITY                     CONSTANT VARCHAR2(30) := 'GPBPRXY_CITY';

M_GPBPRXY_STAT_CODE

M_GPBPRXY_STAT_CODE                CONSTANT VARCHAR2(30) := 'GPBPRXY_STAT_CODE';

M_GPBPRXY_ZIP

M_GPBPRXY_ZIP                      CONSTANT VARCHAR2(30) := 'GPBPRXY_ZIP';

M_GPBPRXY_NATN_CODE

M_GPBPRXY_NATN_CODE                CONSTANT VARCHAR2(30) := 'GPBPRXY_NATN_CODE';

M_GPBPRXY_CNTY_CODE

M_GPBPRXY_CNTY_CODE                CONSTANT VARCHAR2(30) := 'GPBPRXY_CNTY_CODE';

M_GPBPRXY_SSN

M_GPBPRXY_SSN                      CONSTANT VARCHAR2(30) := 'GPBPRXY_SSN';

M_GPBPRXY_BIRTH_DATE

M_GPBPRXY_BIRTH_DATE               CONSTANT VARCHAR2(30) := 'GPBPRXY_BIRTH_DATE';

M_GPBPRXY_SEX

M_GPBPRXY_SEX                      CONSTANT VARCHAR2(30) := 'GPBPRXY_SEX';

M_GPBPRXY_ATYP_CODE

M_GPBPRXY_ATYP_CODE                CONSTANT VARCHAR2(30) := 'GPBPRXY_ATYP_CODE';

M_GPBPRXY_TELE_CODE

M_GPBPRXY_TELE_CODE                CONSTANT VARCHAR2(30) := 'GPBPRXY_TELE_CODE';

M_GPBPRXY_EMAL_CODE

M_GPBPRXY_EMAL_CODE                CONSTANT VARCHAR2(30) := 'GPBPRXY_EMAL_CODE';

M_GPBPRXY_ASRC_CODE

M_GPBPRXY_ASRC_CODE                CONSTANT VARCHAR2(30) := 'GPBPRXY_ASRC_CODE';

M_GPBPRXY_HOUSE_NUMBER

M_GPBPRXY_HOUSE_NUMBER             CONSTANT VARCHAR2(30) := 'GPBPRXY_HOUSE_NUMBER';

M_GPBPRXY_SURNAME_PREFIX

M_GPBPRXY_SURNAME_PREFIX           CONSTANT VARCHAR2(30) := 'GPBPRXY_SURNAME_PREFIX';

M_GPBPRXY_PHONE_AREA

M_GPBPRXY_PHONE_AREA               CONSTANT VARCHAR2(30) := 'GPBPRXY_PHONE_AREA';

M_GPBPRXY_PHONE_NUMBER

M_GPBPRXY_PHONE_NUMBER             CONSTANT VARCHAR2(30) := 'GPBPRXY_PHONE_NUMBER';

M_GPBPRXY_PHONE_EXT

M_GPBPRXY_PHONE_EXT                CONSTANT VARCHAR2(30) := 'GPBPRXY_PHONE_EXT';

M_GPBPRXY_CTRY_CODE_PHONE

M_GPBPRXY_CTRY_CODE_PHONE          CONSTANT VARCHAR2(30) := 'GPBPRXY_CTRY_CODE_PHONE';

M_GPBPRXY_NAME_PREFIX

M_GPBPRXY_NAME_PREFIX              CONSTANT VARCHAR2(30) := 'GPBPRXY_NAME_PREFIX';

M_GPBPRXY_NAME_SUFFIX

M_GPBPRXY_NAME_SUFFIX              CONSTANT VARCHAR2(30) := 'GPBPRXY_NAME_SUFFIX';

M_GPBPRXY_PREF_FIRST_NAME

M_GPBPRXY_PREF_FIRST_NAME          CONSTANT VARCHAR2(30) := 'GPBPRXY_PREF_FIRST_NAME';

M_INTERNAL_RECORD_ID

M_INTERNAL_RECORD_ID  CONSTANT VARCHAR2(30) := '@ROWID';

p_delete

PROCEDURE p_delete(p_rowid VARCHAR2)

Procedures

p_insert

PROCEDURE p_insert(p_rec       gpbprxy%ROWTYPE,
                   p_rowid_out OUT VARCHAR2)

p_update

PROCEDURE p_update(p_rec   gpbprxy%ROWTYPE,
                   p_rowid VARCHAR2)