DBA Data[Home] [Help]

APPS.IGF_SL_CL_ORIG_ACK dependencies on DUAL

Line 1987: -- Since there are Possiblly 5 Messages in the same record we need to insert them individually

1983: gv_debug_str := '';
1984:
1985:
1986: -- Need to insert all the Error Messages in the current @1 record into Edit Table
1987: -- Since there are Possiblly 5 Messages in the same record we need to insert them individually
1988: --
1989: gv_debug_str := gv_debug_str || 'MAIN - 6' || ' ';
1990: err_mesg_array.delete;
1991: gv_debug_str := gv_debug_str || 'MAIN - 7' || ' ';

Line 5683: FROM DUAL;

5679: -- IGF_SL_CL_APP_FORM_CODE has the complete set of lookup_code for Application Form Code
5680: ------------------------------------------------------------------
5681: CURSOR c_wf_event_key IS
5682: SELECT igf_sl_cl_scr_seq.NEXTVAL
5683: FROM DUAL;
5684:
5685: l_wf_event_t wf_event_t;
5686: l_wf_parameter_list_t wf_parameter_list_t;
5687: l_wf_event_name VARCHAR2(255);

Line 6395: FROM DUAL;

6391: ------------------------------------------------------------------
6392: CURSOR c_wf_event_key IS
6393: SELECT igf_sl_cl_scr_seq.NEXTVAL -- MN 12-Jan-2005 - As the WorkFlow in use is common between
6394: -- Amt Diff and SCR Diff using same sequence and removing igf_sl_cl_gamt_seq
6395: FROM DUAL;
6396:
6397: l_wf_event_t wf_event_t;
6398: l_wf_parameter_list_t wf_parameter_list_t;
6399: l_wf_event_name VARCHAR2(255);