DBA Data[Home] [Help]

APPS.EDR_ERES_EVENT_PVT dependencies on DUAL

Line 181: --Copy the individual parameters to a structure

177: -- API Body
178:
179: -- CHANGE_SOURCE_TYPE(x_event.payload, EDR_CONSTANTS_GRP.g_db_mode);
180: --Bug 3136403: Start
181: --Copy the individual parameters to a structure
182: --of type fnd_wf_event.param_table
183: --start with 4 because in event of the payload with valid
184: --the first three parameters are set to specific values below
185: -- SKARIMIS Moved the code logic outside of follwing IF statment. Payload should

Line 836: select EDR_ERESMANAGER_T_S.nextval into X_ERES_PROCESS_ID from dual;

832: X_ERES_PROCESS_ID OUT NOCOPY NUMBER)
833: IS
834: BEGIN
835: --get the next pk value from sequence
836: select EDR_ERESMANAGER_T_S.nextval into X_ERES_PROCESS_ID from dual;
837:
838: --insert all the values in db
839: insert into EDR_ERESMANAGER_T(ERES_PROCESS_ID,
840: RETURN_URL,