M_GPBELTR_SYST_CODE

M_GPBELTR_SYST_CODE                CONSTANT VARCHAR2(30) := 'GPBELTR_SYST_CODE';

FILE NAME..: gpkd_gpbeltr0.sql RELEASE....: 8.5 OBJECT NAME: DML_GPBELTR PRODUCT....: GENERAL USAGE......: Package contains table DML procedures for the GPBELTR table.
COPYRIGHT..: Copyright 2011 Sungard. All rights reserved.
 
DESCRIPTION:
 
Standard dml functions and procedures for the GPBELTR table.
Table Comments :
 
 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_GPBELTR_CTYP_CODE

M_GPBELTR_CTYP_CODE                CONSTANT VARCHAR2(30) := 'GPBELTR_CTYP_CODE';

M_GPBELTR_CTYP_URL

M_GPBELTR_CTYP_URL                 CONSTANT VARCHAR2(30) := 'GPBELTR_CTYP_URL';

M_GPBELTR_CTYP_EXP_DATE

M_GPBELTR_CTYP_EXP_DATE            CONSTANT VARCHAR2(30) := 'GPBELTR_CTYP_EXP_DATE';

M_GPBELTR_CTYP_EXE_DATE

M_GPBELTR_CTYP_EXE_DATE            CONSTANT VARCHAR2(30) := 'GPBELTR_CTYP_EXE_DATE';

M_GPBELTR_TRANSMIT_DATE

M_GPBELTR_TRANSMIT_DATE            CONSTANT VARCHAR2(30) := 'GPBELTR_TRANSMIT_DATE';

M_GPBELTR_PROXY_IDM

M_GPBELTR_PROXY_IDM                CONSTANT VARCHAR2(30) := 'GPBELTR_PROXY_IDM';

M_GPBELTR_PROXY_OLD_DATA

M_GPBELTR_PROXY_OLD_DATA           CONSTANT VARCHAR2(30) := 'GPBELTR_PROXY_OLD_DATA';

M_GPBELTR_PROXY_NEW_DATA

M_GPBELTR_PROXY_NEW_DATA           CONSTANT VARCHAR2(30) := 'GPBELTR_PROXY_NEW_DATA';

M_GPBELTR_PERSON_PIDM

M_GPBELTR_PERSON_PIDM              CONSTANT VARCHAR2(30) := 'GPBELTR_PERSON_PIDM';

M_GPBELTR_ACTIVITY_DATE

M_GPBELTR_ACTIVITY_DATE            CONSTANT VARCHAR2(30) := 'GPBELTR_ACTIVITY_DATE';

M_GPBELTR_USER_ID

M_GPBELTR_USER_ID                  CONSTANT VARCHAR2(30) := 'GPBELTR_USER_ID';

M_GPBELTR_CREATE_DATE

M_GPBELTR_CREATE_DATE              CONSTANT VARCHAR2(30) := 'GPBELTR_CREATE_DATE';

M_GPBELTR_CREATE_USER

M_GPBELTR_CREATE_USER              CONSTANT VARCHAR2(30) := 'GPBELTR_CREATE_USER';

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       gpbeltr%ROWTYPE,
                   p_rowid_out OUT VARCHAR2)

p_update

PROCEDURE p_update(p_rec   gpbeltr%ROWTYPE,
                   p_rowid VARCHAR2)