APPS.ECX_INBOUND_TRIG dependencies on DUAL

Line 1791: from dual;

1787:
1788: cursor get_run_s
1789: is
1790: select ecx_output_runs_s.NEXTVAL
1791: from dual;
1792:
1793: cursor get_msg
1794: (
1795: p_msgid in raw

Line 2046: from dual;

2042:
2043: cursor get_run_s
2044: is
2045: select ecx_output_runs_s.NEXTVAL
2046: from dual;
2047:
2048:
2049: cursor get_msg
2050: (

Line 2260: from dual;

2256:
2257: cursor get_run_s
2258: is
2259: select ecx_output_runs_s.NEXTVAL
2260: from dual;
2261:
2262: ecx_logging_enabled boolean := false;
2263: logging_enabled varchar2(20);
2264: module varchar2(2000);

Line 2483: from dual;

2479: i_process_id raw(16);
2480: cursor c_ecx_trigger_id
2481: is
2482: select ecx_trigger_id_s.NEXTVAL
2483: from dual;
2484:
2485: begin
2486: /* open c_ecx_trigger_id;
2487: fetch c_ecx_trigger_id into i_trigger_id;

Line 2557: select decode(i_msgid,null,'Y','N') into l_msg_id_null from dual;

2553: l_process_id varchar2(200);
2554: l_msg_id_null varchar2(1);
2555: begin
2556: l_event_key := i_msgid;
2557: select decode(i_msgid,null,'Y','N') into l_msg_id_null from dual;
2558: if (l_msg_id_null = 'Y') then
2559: l_event_key := TO_CHAR(sysdate,'ddmmhhmiss');
2560: end if;
2561: