M_GEBCOMM_SYST_CODE

M_GEBCOMM_SYST_CODE                CONSTANT VARCHAR2(30) := 'GEBCOMM_SYST_CODE';

FILE NAME..: gekd_gebcomm0.sql RELEASE....: 8.5 OBJECT NAME: DML_GEBCOMM PRODUCT....: GENERAL USAGE......: Package contains table DML procedures for the GEBCOMM table.
COPYRIGHT..: Copyright 2011 Sungard. All rights reserved.
 
DESCRIPTION:
 
Standard dml functions and procedures for the GEBCOMM table.
Table Comments : Rule table to specify the legal combinations of system and communication types
 
 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_GEBCOMM_CTYP_CODE

M_GEBCOMM_CTYP_CODE                CONSTANT VARCHAR2(30) := 'GEBCOMM_CTYP_CODE';

M_GEBCOMM_PER_NOTIFY_IND

M_GEBCOMM_PER_NOTIFY_IND           CONSTANT VARCHAR2(30) := 'GEBCOMM_PER_NOTIFY_IND';

M_GEBCOMM_ADMIN_NOTIFY_IND

M_GEBCOMM_ADMIN_NOTIFY_IND         CONSTANT VARCHAR2(30) := 'GEBCOMM_ADMIN_NOTIFY_IND';

M_GEBCOMM_PROXY_NOTIFY_IND

M_GEBCOMM_PROXY_NOTIFY_IND         CONSTANT VARCHAR2(30) := 'GEBCOMM_PROXY_NOTIFY_IND';

M_GEBCOMM_LETR_PER_NOTI_CODE

M_GEBCOMM_LETR_PER_NOTI_CODE       CONSTANT VARCHAR2(30) := 'GEBCOMM_LETR_PER_NOTI_CODE';

M_GEBCOMM_LETR_ADM_NOTI_CODE

M_GEBCOMM_LETR_ADM_NOTI_CODE       CONSTANT VARCHAR2(30) := 'GEBCOMM_LETR_ADM_NOTI_CODE';

M_GEBCOMM_LETR_PXY_NOTI_CODE

M_GEBCOMM_LETR_PXY_NOTI_CODE       CONSTANT VARCHAR2(30) := 'GEBCOMM_LETR_PXY_NOTI_CODE';

M_GEBCOMM_BCC_PER_IND

M_GEBCOMM_BCC_PER_IND              CONSTANT VARCHAR2(30) := 'GEBCOMM_BCC_PER_IND';

M_GEBCOMM_BCC_PXY_IND

M_GEBCOMM_BCC_PXY_IND              CONSTANT VARCHAR2(30) := 'GEBCOMM_BCC_PXY_IND';

M_GEBCOMM_HOST_NAME

M_GEBCOMM_HOST_NAME                CONSTANT VARCHAR2(30) := 'GEBCOMM_HOST_NAME';

M_GEBCOMM_ADMIN_EMAIL

M_GEBCOMM_ADMIN_EMAIL              CONSTANT VARCHAR2(30) := 'GEBCOMM_ADMIN_EMAIL';

M_GEBCOMM_SYSTEM_REQ_IND

M_GEBCOMM_SYSTEM_REQ_IND           CONSTANT VARCHAR2(30) := 'GEBCOMM_SYSTEM_REQ_IND';

M_GEBCOMM_ACTIVITY_DATE

M_GEBCOMM_ACTIVITY_DATE            CONSTANT VARCHAR2(30) := 'GEBCOMM_ACTIVITY_DATE';

M_GEBCOMM_USER_ID

M_GEBCOMM_USER_ID                  CONSTANT VARCHAR2(30) := 'GEBCOMM_USER_ID';

M_GEBCOMM_CREATE_DATE

M_GEBCOMM_CREATE_DATE              CONSTANT VARCHAR2(30) := 'GEBCOMM_CREATE_DATE';

M_GEBCOMM_CREATE_USER

M_GEBCOMM_CREATE_USER              CONSTANT VARCHAR2(30) := 'GEBCOMM_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       gebcomm%ROWTYPE,
                   p_rowid_out OUT VARCHAR2)

p_update

PROCEDURE p_update(p_rec   gebcomm%ROWTYPE,
                   p_rowid VARCHAR2)