APPS.ECX_ERRORLOG dependencies on DUAL

Line 7: from dual;

3:
4: cursor c_ecx_errorno
5: is
6: select ecx_error_no_s.nextval
7: from dual;
8: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
9: l_statement PLS_INTEGER := ecx_debug.g_statement;
10: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
11: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;

Line 224: from dual;

220:
221: cursor c_trigger_id
222: is
223: select ecx_trigger_id_s.NEXTVAL
224: from dual;
225:
226: PRAGMA AUTONOMOUS_TRANSACTION;
227: i_method_name varchar2(2000) := 'ecx_errorlog.external_system';
228:

Line 685: select sysdate from dual;

681: i_error_no number(15);
682:
683: cursor c1
684: is
685: select sysdate from dual;
686:
687: begin
688:
689: /* Since ret_code tells us whether there was an error,

Line 783: select sysdate from dual;

779: )
780: is
781: cursor c1
782: is
783: select sysdate from dual;
784:
785: cursor c_party_type(i_transaction_type in varchar2, i_transaction_subtype in varchar2)
786: is
787: select party_type

Line 1648: from dual;

1644:
1645: cursor c1
1646: is
1647: select ecx_trigger_id_s.NEXTVAL
1648: from dual;
1649:
1650: begin
1651: if (p_event is null) then
1652: return;

Line 1863: select ecx_inlstn_s.nextval into i_message_counter from dual ;

1859: l_retcode pls_integer := 0;
1860: l_retmsg varchar2(2000) := null;
1861:
1862: begin
1863: select ecx_inlstn_s.nextval into i_message_counter from dual ;
1864: status := 2;
1865: if (status_text = 'SUCCESS') then
1866: status := 10;
1867: end if;