DBA Data[Home] [Help]

APPS.FND_OAM_DSCFG_MAPPED_KEYS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 50

      INSERT INTO fnd_oam_dscfg_mapped_keys (MAPPED_KEY_ID,
                                             CONFIG_INSTANCE_ID,
                                             PARENT_PROC_ID,
                                             MAPPED_KEY_TYPE,
                                             NUMBER_PK1,
                                             NUMBER_PK2,
                                             NUMBER_PK3,
                                             NUMBER_PK4,
                                             NUMBER_PK5,
                                             RAW_PK1,
                                             RAW_PK2,
                                             RAW_PK3,
                                             VARCHAR2_PK1,
                                             VARCHAR2_PK2,
                                             VARCHAR2_PK3,
                                             VARCHAR2_PK4,
                                             VARCHAR2_PK5,
                                             CREATED_BY,
                                             CREATION_DATE,
                                             LAST_UPDATED_BY,
                                             LAST_UPDATE_DATE,
                                             LAST_UPDATE_LOGIN)
         VALUES (FND_OAM_DSCFG_MAPPED_KEYS_S.NEXTVAL,
                 l_config_instance_id,
                 l_proc_id,
                 p_mapped_key_type,
                 p_number_pk1,
                 p_number_pk2,
                 p_number_pk3,
                 p_number_pk4,
                 p_number_pk5,
                 p_raw_pk1,
                 p_raw_pk2,
                 p_raw_pk3,
                 p_varchar2_pk1,
                 p_varchar2_pk2,
                 p_varchar2_pk3,
                 p_varchar2_pk4,
                 p_varchar2_pk5,
                 FND_GLOBAL.USER_ID,
                 SYSDATE,
                 FND_GLOBAL.USER_ID,
                 SYSDATE,
                 FND_GLOBAL.USER_ID)
         RETURNING MAPPED_KEY_ID INTO l_mapped_key_id;