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 1278: from dual;

1274: rule_exception exception;
1275:
1276: cursor c_ecx_trigger_id is
1277: select ecx_trigger_id_s.NEXTVAL
1278: from dual;
1279:
1280: begin
1281:
1282: l_module := 'ecx.plsql.ecx_rule.TPPreProcessing';

Line 1541: from dual;

1537: isTPCheck boolean;
1538: err_msg varchar2(500);
1539: cursor c_ecx_trigger_id is
1540: select ecx_trigger_id_s.NEXTVAL
1541: from dual;
1542:
1543: begin
1544: l_module := 'ecx.plsql.ecx_rule.ReceiveTPMessage';
1545: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

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

1698: l_attribute5 := p_event.getValueForParameter('ECX_ATTRIBUTE5');
1699: l_internal_control_number := p_event.getValueForParameter('ECX_ICN');
1700:
1701: if l_internal_control_number is null then
1702: select ecx_inlstn_s.nextval into l_internal_control_number from dual;
1703: p_event.AddParameterToList('ECX_ICN', l_internal_control_number);
1704: end if;
1705:
1706: -- Save the Copy of the Document