eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 2492: --L_SQL_STR:= 'select '|| l_xml_generation_api || ' from dual';

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

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

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

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

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

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

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