DBA Data[Home] [Help]

APPS.ECX_RULE dependencies on DUAL

Line 805: select to_char(WF_ERROR_PROCESSES_S.nextval) into l_ikey from dual;

801:
802: p_event.parameter_List := l_paramlist;
803:
804: if (l_wftype = 'WFERROR') then
805: select to_char(WF_ERROR_PROCESSES_S.nextval) into l_ikey from dual;
806: else
807: l_ikey := nvl(p_event.Correlation_ID, p_event.Event_Key);
808: end if;
809:

Line 1270: from dual;

1266: rule_exception exception;
1267:
1268: cursor c_ecx_trigger_id is
1269: select ecx_trigger_id_s.NEXTVAL
1270: from dual;
1271:
1272: begin
1273:
1274: l_module := 'ecx.plsql.ecx_rule.TPPreProcessing';

Line 1533: from dual;

1529: isTPCheck boolean;
1530: err_msg varchar2(500);
1531: cursor c_ecx_trigger_id is
1532: select ecx_trigger_id_s.NEXTVAL
1533: from dual;
1534:
1535: begin
1536: l_module := 'ecx.plsql.ecx_rule.ReceiveTPMessage';
1537: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

Line 1694: select ecx_inlstn_s.nextval into l_internal_control_number from dual;

1690: l_attribute5 := p_event.getValueForParameter('ECX_ATTRIBUTE5');
1691: l_internal_control_number := p_event.getValueForParameter('ECX_ICN');
1692:
1693: if l_internal_control_number is null then
1694: select ecx_inlstn_s.nextval into l_internal_control_number from dual;
1695: p_event.AddParameterToList('ECX_ICN', l_internal_control_number);
1696: end if;
1697:
1698: -- Save the Copy of the Document