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 2511: delete edr_erecord_id_temp;

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

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

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

Line 2536: delete edr_erecord_id_temp;

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

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

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