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

Line 218: INSERT INTO EDR_ERECORDS(EVENT_ID,

214: /* Insert into Temp tables for Further Processing */
215: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Event Name Assigned');
216: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','CLOB Assignment Complete and insert being executed');
217:
218: INSERT INTO EDR_ERECORDS(EVENT_ID,
219: EVENT_NAME,
220: EVENT_KEY,
221: EVENT_USER_KEY_LABEL,
222: EVENT_USER_KEY_VALUE,

Line 246: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Insertion Complete in EDR_ERECORDS');

242: p_audit_group,
243: l_transaction_audit_id);
244:
245:
246: wf_log_pkg.string(1, 'EDR_PSIG_rule.create_pageflow','Insertion Complete in EDR_ERECORDS');
247: -- Bug Fix 3143107
248: -- Removed Open Docement
249: -- Post document parameters
250: -- Change status

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

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

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