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_ERECORD_ID_TEMP

Line 105: INSERT into edr_erecord_id_temp (document_id) values (p_Event_id);

101: retcode pls_integer;
102: errmsg varchar2(2000);
103: logfile varchar2(200);
104: begin
105: INSERT into edr_erecord_id_temp (document_id) values (p_Event_id);
106: ecx_outbound.getXML
107: (
108: i_map_code => p_MAPCODE,
109: i_document_id => P_DOCUMENT,

Line 1990: delete edr_erecord_id_temp;

1986:
1987: --insert the erecord id into the temp table
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');

Line 1993: INSERT into edr_erecord_id_temp (document_id) values (l_edr_Event_id);

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
1997: --Obtain the value of transform xml parameter.

Line 2507: delete edr_erecord_id_temp;

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
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:

Line 2512: INSERT into edr_erecord_id_temp (document_id) values (l_edr_Event_id);

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.
2515: l_attachment_string_details := wf_event.getValueForParameter('EDR_PSIG_ATTACHMENT',p_event.Parameter_List);
2516:

Line 2532: delete edr_erecord_id_temp;

2528: --otherwise call XML gateway
2529: --insert the erecord id into the temp table
2530: --This would be picked up by the procedures called by the XML Map for attacments
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:

Line 2549: INSERT into edr_erecord_id_temp (document_id) values (l_edr_Event_id);

2545: END IF;
2546: --Bug 4306292: End
2547: -- Bug 3761813 : end
2548:
2549: INSERT into edr_erecord_id_temp (document_id) values (l_edr_Event_id);
2550: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','eRecord id: '||l_edr_Event_id||' has been sent to ECX');
2551:
2552: L_XML_DOCUMENT:=ECX_STANDARD.GENERATE(p_event_name => P_EVENT.getEventName(),
2553: p_event_key => P_EVENT.getEventKey(),