APPS.EDR_ATTACHMENTS_GRP dependencies on EDR_ERECORD_ID_TEMP

Line 890: from edr_erecord_id_temp;

886: p_pk5_value VARCHAR2,
887: p_category VARCHAR2) AS
888: CURSOR GET_TEMP_EREC_ID IS
889: select document_id
890: from edr_erecord_id_temp;
891: l_erecord_id number;
892: BEGIN
893: -- get the erecord id from the temporary table populate by the subscription
894: -- rule function before invoking XML Gateway

Line 900: -- because getting eRecord ID from edr_erecord_id_temp

896:
897: -- Bug 3186732
898: -- Issue if XML Map has attachment procedure call then
899: -- for those maps user used to get "NO DATA FOUND" Error
900: -- because getting eRecord ID from edr_erecord_id_temp
901: -- was using SELECT .. INTO .. for utility functions this
902: -- row is not present it used give error
903: -- modified the select statement and also added a condition
904: -- to call copy attachments API only when eRecord ID is present.

Line 1264: from edr_erecord_id_temp;

1260:
1261: PROCEDURE ATTACH_FILE (p_document_id VARCHAR2) AS
1262: CURSOR GET_TEMP_EREC_ID IS
1263: select document_id
1264: from edr_erecord_id_temp;
1265: l_erecord_id number;
1266:
1267: BEGIN
1268: -- get the erecord id from the temporary table populate by the subscription

Line 1274: -- because getting eRecord ID from edr_erecord_id_temp

1270: wf_log_pkg.string(6, 'ATTACH_FILE','Inside Attachment Package, ATTACH_FILE procedure');
1271: -- Bug 3186732
1272: -- Issue if XML Map has attachment procedure call then
1273: -- for those maps user used to get "NO DATA FOUND" Error
1274: -- because getting eRecord ID from edr_erecord_id_temp
1275: -- was using SELECT .. INTO .. for utility functions this
1276: -- row is not present it used give error
1277: -- modified the select statement and also added a condition
1278: -- to call copy attachments API only when eRecord ID is present.

Line 1286: -- select document_id into l_erecord_id from edr_erecord_id_temp;

1282: FETCH GET_TEMP_EREC_ID INTO l_erecord_id;
1283:
1284: CLOSE GET_TEMP_EREC_ID;
1285:
1286: -- select document_id into l_erecord_id from edr_erecord_id_temp;
1287: wf_log_pkg.string(6, 'ATTACH_FILE','Event ID '||l_erecord_id);
1288: IF l_eRecord_id is not null THEN
1289: ATTACH_FILE_AUT(p_document_id, l_erecord_id);
1290: END IF;