APPS.EDR_UTILITIES dependencies on EDR_FINAL_XML_GT

Line 1352: from EDR_FINAL_XML_GT

1348: l_event_xml CLOB;
1349: BEGIN
1350: --read the xml from temp table
1351: select event_xml into l_event_xml
1352: from EDR_FINAL_XML_GT
1353: where event_name = p_event_name
1354: and event_key = p_event_key;
1355:
1356: --call the ecx api to get the value for the xpath

Line 1460: select count(*) into l_count from edr_final_xml_gt

1456: if (p_use_context = validate_setup_ui_ctx and p_raw_xml is not null) then
1457:
1458: --Check if row already exists in the global temp table for specified event
1459: --event name and event key.
1460: select count(*) into l_count from edr_final_xml_gt
1461: where event_name = p_event_name
1462: and event_key = p_document_id;
1463: if l_count > 0 then
1464: --A row exists, hence update the row.

Line 1465: update edr_final_xml_gt

1461: where event_name = p_event_name
1462: and event_key = p_document_id;
1463: if l_count > 0 then
1464: --A row exists, hence update the row.
1465: update edr_final_xml_gt
1466: set event_xml = X_XML_PAYLOAD
1467: where event_name = p_event_name
1468: and event_key = p_document_id;
1469:

Line 1473: insert into edr_final_xml_gt

1469:
1470: else
1471: --No row exists with the specified event name and event key.
1472: --Hence insert a row into the global temp table.
1473: insert into edr_final_xml_gt
1474: (event_name, event_key, event_xml)
1475: values
1476: (p_event_name, p_document_id, X_xml_PAYLOAD);
1477: