APPS.EDR_PSIG_RULE dependencies on DUAL

Line 326: SELECT EDR_ESIGNATURES_S.NEXTVAL into l_edr_signature_id from DUAL;

322:
323: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Figured out overriding approver for '||l_fnd_user||' as '||l_overriding_approver);
324:
325: /* Insert into Temp tables for Further Processing */
326: SELECT EDR_ESIGNATURES_S.NEXTVAL into l_edr_signature_id from DUAL;
327: wf_log_pkg.string(3, 'EDR_PSIG_rule.create_pageflow','Signature Sequence Fetched '||l_edr_signature_id);
328:
329: INSERT into EDR_ESIGNATURES(SIGNATURE_ID,
330: EVENT_ID,

Line 1992: SELECT EDR_ERECORDS_S.NEXTVAL into l_edr_Event_id from DUAL;

1988: --This would be picked up by the procedures called by the XML Map for attacments
1989: --Delete the global temp table before inserting a row
1990: delete edr_erecord_id_temp;
1991:
1992: SELECT EDR_ERECORDS_S.NEXTVAL into l_edr_Event_id from DUAL;
1993: INSERT into edr_erecord_id_temp (document_id) values (l_edr_Event_id);
1994: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','eRecord id: '||l_edr_Event_id||' will be sent to ECX');
1995:
1996: --Bug 3893101: Start

Line 2488: --L_SQL_STR:= 'select '|| l_xml_generation_api || ' from dual';

2484: -- Check if call back function has been passed to generate XML document by product team
2485: begin
2486: --bug 4730592: start
2487: --changed the way the callback api is called dynamically
2488: --L_SQL_STR:= 'select '|| l_xml_generation_api || ' from dual';
2489: --execute immediate L_SQL_STR into L_XML_DOCUMENT;
2490: execute immediate 'begin :1:= '||l_xml_generation_api ||'; end;'
2491: using out l_xml_document;
2492: --bug 4730592: end

Line 2510: SELECT EDR_ERECORDS_S.NEXTVAL into l_edr_Event_id from DUAL;

2506: --Delete the global temp table before inserting a row
2507: delete edr_erecord_id_temp;
2508:
2509: --select Unique event Id to be posted in temp tables
2510: SELECT EDR_ERECORDS_S.NEXTVAL into l_edr_Event_id from DUAL;
2511:
2512: INSERT into edr_erecord_id_temp (document_id) values (l_edr_Event_id);
2513:
2514: --Obtain the attachment string parameter.

Line 2535: SELECT EDR_ERECORDS_S.NEXTVAL into l_edr_Event_id from DUAL;

2531: --Delete the global temp table before inserting a row
2532: delete edr_erecord_id_temp;
2533:
2534: --select Unique event Id to be posted in temp tables
2535: SELECT EDR_ERECORDS_S.NEXTVAL into l_edr_Event_id from DUAL;
2536:
2537:
2538: --Bug 3761813 : start
2539: --Bug 4306292: Start

Line 2847: /* SELECT EDR_ERECORDS_S.NEXTVAL into l_edr_Event_id from DUAL; */

2843: /* select Unique event Id to be posted in temp tables */
2844: /* 24-FEB-2003: CJ: commented one line below as the erecord id is already available
2845: in the local variable and added a line to delete the erecord id from temp
2846: table */
2847: /* SELECT EDR_ERECORDS_S.NEXTVAL into l_edr_Event_id from DUAL; */
2848: /* 24-FEB-2003: CJ : end */
2849: /* Set this value to correlation_id to be used by WF_RULE.DEFAULT_RULE funciton */
2850: P_EVENT.SETCORRELATIONID(l_edr_event_id);
2851: /* Select the workflow process for the subscription */