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 EDR_ERECORDS_S

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 2506: --We need to obtain the next sequence value from EDR_ERECORDS_S.

2502: raise API_EXECUTION_ERROR;
2503: end;
2504:
2505: --Bug 4529417: Start
2506: --We need to obtain the next sequence value from EDR_ERECORDS_S.
2507:
2508: --insert the erecord id into the temp table
2509: --This would be picked up by the procedures called by the XML Map for attacments
2510: --Delete the global temp table before inserting a row

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 */