M_GENIDEN_GIDM

M_GENIDEN_GIDM                     CONSTANT VARCHAR2(30) := 'GENIDEN_GIDM';

FILE NAME..: gekd_geniden0.sql RELEASE....: 8.5 OBJECT NAME: DML_GENIDEN PRODUCT....: GENERAL USAGE......: Package contains table DML procedures for the GENIDEN table.
COPYRIGHT..: Copyright 2011 Sungard. All rights reserved.
 
DESCRIPTION:
 
Standard dml functions and procedures for the GENIDEN table.
Table Comments : General Person matching data, entered from various sources
 
 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_GENIDEN_SYST_CODE

M_GENIDEN_SYST_CODE                CONSTANT VARCHAR2(30) := 'GENIDEN_SYST_CODE';

M_GENIDEN_ENTITY_CODE

M_GENIDEN_ENTITY_CODE              CONSTANT VARCHAR2(30) := 'GENIDEN_ENTITY_CODE';

M_GENIDEN_ID

M_GENIDEN_ID                       CONSTANT VARCHAR2(30) := 'GENIDEN_ID';

M_GENIDEN_LAST_NAME

M_GENIDEN_LAST_NAME                CONSTANT VARCHAR2(30) := 'GENIDEN_LAST_NAME';

M_GENIDEN_FIRST_NAME

M_GENIDEN_FIRST_NAME               CONSTANT VARCHAR2(30) := 'GENIDEN_FIRST_NAME';

M_GENIDEN_MI

M_GENIDEN_MI                       CONSTANT VARCHAR2(30) := 'GENIDEN_MI';

M_GENIDEN_HOUSE_NUMBER

M_GENIDEN_HOUSE_NUMBER             CONSTANT VARCHAR2(30) := 'GENIDEN_HOUSE_NUMBER';

M_GENIDEN_STREET_LINE1

M_GENIDEN_STREET_LINE1             CONSTANT VARCHAR2(30) := 'GENIDEN_STREET_LINE1';

M_GENIDEN_STREET_LINE2

M_GENIDEN_STREET_LINE2             CONSTANT VARCHAR2(30) := 'GENIDEN_STREET_LINE2';

M_GENIDEN_STREET_LINE3

M_GENIDEN_STREET_LINE3             CONSTANT VARCHAR2(30) := 'GENIDEN_STREET_LINE3';

M_GENIDEN_STREET_LINE4

M_GENIDEN_STREET_LINE4             CONSTANT VARCHAR2(30) := 'GENIDEN_STREET_LINE4';

M_GENIDEN_CITY

M_GENIDEN_CITY                     CONSTANT VARCHAR2(30) := 'GENIDEN_CITY';

M_GENIDEN_STAT_CODE

M_GENIDEN_STAT_CODE                CONSTANT VARCHAR2(30) := 'GENIDEN_STAT_CODE';

M_GENIDEN_ZIP

M_GENIDEN_ZIP                      CONSTANT VARCHAR2(30) := 'GENIDEN_ZIP';

M_GENIDEN_NATN_CODE

M_GENIDEN_NATN_CODE                CONSTANT VARCHAR2(30) := 'GENIDEN_NATN_CODE';

M_GENIDEN_PHONE_AREA

M_GENIDEN_PHONE_AREA               CONSTANT VARCHAR2(30) := 'GENIDEN_PHONE_AREA';

M_GENIDEN_PHONE_NUMBER

M_GENIDEN_PHONE_NUMBER             CONSTANT VARCHAR2(30) := 'GENIDEN_PHONE_NUMBER';

M_GENIDEN_PHONE_EXT

M_GENIDEN_PHONE_EXT                CONSTANT VARCHAR2(30) := 'GENIDEN_PHONE_EXT';

M_GENIDEN_CTRY_CODE_PHONE

M_GENIDEN_CTRY_CODE_PHONE          CONSTANT VARCHAR2(30) := 'GENIDEN_CTRY_CODE_PHONE';

M_GENIDEN_SSN

M_GENIDEN_SSN                      CONSTANT VARCHAR2(30) := 'GENIDEN_SSN';

M_GENIDEN_BIRTH_DATE

M_GENIDEN_BIRTH_DATE               CONSTANT VARCHAR2(30) := 'GENIDEN_BIRTH_DATE';

M_GENIDEN_SEX

M_GENIDEN_SEX                      CONSTANT VARCHAR2(30) := 'GENIDEN_SEX';

M_GENIDEN_EMAIL_ADDRESS

M_GENIDEN_EMAIL_ADDRESS            CONSTANT VARCHAR2(30) := 'GENIDEN_EMAIL_ADDRESS';

M_GENIDEN_ATYP_CODE

M_GENIDEN_ATYP_CODE                CONSTANT VARCHAR2(30) := 'GENIDEN_ATYP_CODE';

M_GENIDEN_TELE_CODE

M_GENIDEN_TELE_CODE                CONSTANT VARCHAR2(30) := 'GENIDEN_TELE_CODE';

M_GENIDEN_EMAL_CODE

M_GENIDEN_EMAL_CODE                CONSTANT VARCHAR2(30) := 'GENIDEN_EMAL_CODE';

M_GENIDEN_ASRC_CODE

M_GENIDEN_ASRC_CODE                CONSTANT VARCHAR2(30) := 'GENIDEN_ASRC_CODE';

M_GENIDEN_SURNAME_PREFIX

M_GENIDEN_SURNAME_PREFIX           CONSTANT VARCHAR2(30) := 'GENIDEN_SURNAME_PREFIX';

M_GENIDEN_PIDM

M_GENIDEN_PIDM                     CONSTANT VARCHAR2(30) := 'GENIDEN_PIDM';

M_GENIDEN_MATCH_STATUS

M_GENIDEN_MATCH_STATUS             CONSTANT VARCHAR2(30) := 'GENIDEN_MATCH_STATUS';

M_GENIDEN_MATCH_DATE

M_GENIDEN_MATCH_DATE               CONSTANT VARCHAR2(30) := 'GENIDEN_MATCH_DATE';

M_GENIDEN_LOAD_STATUS

M_GENIDEN_LOAD_STATUS              CONSTANT VARCHAR2(30) := 'GENIDEN_LOAD_STATUS';

M_GENIDEN_LOAD_DATE

M_GENIDEN_LOAD_DATE                CONSTANT VARCHAR2(30) := 'GENIDEN_LOAD_DATE';

M_GENIDEN_ACTIVITY_DATE

M_GENIDEN_ACTIVITY_DATE            CONSTANT VARCHAR2(30) := 'GENIDEN_ACTIVITY_DATE';

M_GENIDEN_USER_ID

M_GENIDEN_USER_ID                  CONSTANT VARCHAR2(30) := 'GENIDEN_USER_ID';

M_GENIDEN_NAME_PREFIX

M_GENIDEN_NAME_PREFIX              CONSTANT VARCHAR2(30) := 'GENIDEN_NAME_PREFIX';

M_GENIDEN_NAME_SUFFIX

M_GENIDEN_NAME_SUFFIX              CONSTANT VARCHAR2(30) := 'GENIDEN_NAME_SUFFIX';

M_GENIDEN_PREF_FIRST_NAME

M_GENIDEN_PREF_FIRST_NAME          CONSTANT VARCHAR2(30) := 'GENIDEN_PREF_FIRST_NAME';

M_GENIDEN_CNTY_CODE

M_GENIDEN_CNTY_CODE                CONSTANT VARCHAR2(30) := 'GENIDEN_CNTY_CODE';

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

p_update

PROCEDURE p_update(p_rec   geniden%ROWTYPE,
                   p_rowid VARCHAR2)