APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_RETRIEVAL_RANGE_RESOURCES

Line 1232: INSERT INTO hxc_retrieval_range_resources

1228: CLOSE csr_get_rr_id;
1229:
1230: p_rr_id := l_rr_id;
1231: FORALL rrx IN p_resource_list.FIRST .. p_resource_list.LAST
1232: INSERT INTO hxc_retrieval_range_resources
1233: (retrieval_range_id, resource_id
1234: )
1235: VALUES (l_rr_id, p_resource_list (rrx)
1236: );

Line 1740: , hxc_retrieval_range_resources rrr

1736: SELECT /*+ ordered */
1737: tbb_latest.time_building_block_id,
1738: tbb_latest.object_version_number insert_latest
1739: FROM hxc_retrieval_ranges rr
1740: , hxc_retrieval_range_resources rrr
1741: , hxc_latest_details tbb_latest ';
1742:
1743: -- Bug 9394444
1744: -- The Application specific version of the queries.

Line 1752: , hxc_retrieval_range_resources rrr

1748: SELECT /*+ ordered */
1749: tbb_latest.time_building_block_id,
1750: tbb_latest.object_version_number insert_latest
1751: FROM hxc_retrieval_ranges rr
1752: , hxc_retrieval_range_resources rrr
1753: , hxc_pa_latest_details tbb_latest ';
1754:
1755: l_select_from_pay VARCHAR2 (250)
1756: := '

Line 1761: , hxc_retrieval_range_resources rrr

1757: SELECT /*+ ordered */
1758: tbb_latest.time_building_block_id,
1759: tbb_latest.object_version_number insert_latest
1760: FROM hxc_retrieval_ranges rr
1761: , hxc_retrieval_range_resources rrr
1762: , hxc_pay_latest_details tbb_latest ';
1763:
1764:
1765:

Line 7113: hxc_retrieval_range_resources rrr,

7109: (select /*+ no_merge ordered */
7110: tbb_latest.time_building_block_id,
7111: tbb_latest.object_version_number
7112: from hxc_retrieval_ranges rr,
7113: hxc_retrieval_range_resources rrr,
7114: hxc_latest_details tbb_latest
7115: where rr.retrieval_range_id = :p_rr_id AND
7116: rr.retrieval_range_id = rrr.retrieval_range_id AND
7117: tbb_latest.resource_id = rrr.resource_id AND

Line 7140: hxc_retrieval_range_resources rrr,

7136: (select /*+ no_merge ordered */
7137: tbb_latest.time_building_block_id,
7138: tbb_latest.object_version_number
7139: from hxc_retrieval_ranges rr,
7140: hxc_retrieval_range_resources rrr,
7141: hxc_pa_latest_details tbb_latest
7142: where rr.retrieval_range_id = :p_rr_id AND
7143: rr.retrieval_range_id = rrr.retrieval_range_id AND
7144: tbb_latest.resource_id = rrr.resource_id AND

Line 7167: hxc_retrieval_range_resources rrr,

7163: (select /*+ no_merge ordered */
7164: tbb_latest.time_building_block_id,
7165: tbb_latest.object_version_number
7166: from hxc_retrieval_ranges rr,
7167: hxc_retrieval_range_resources rrr,
7168: hxc_pay_latest_details tbb_latest
7169: where rr.retrieval_range_id = :p_rr_id AND
7170: rr.retrieval_range_id = rrr.retrieval_range_id AND
7171: tbb_latest.resource_id = rrr.resource_id AND

Line 8890: DELETE FROM HXC_RETRIEVAL_RANGE_RESOURCES

8886: IS
8887: PRAGMA AUTONOMOUS_TRANSACTION;
8888: BEGIN
8889:
8890: DELETE FROM HXC_RETRIEVAL_RANGE_RESOURCES
8891: WHERE RETRIEVAL_RANGE_ID IN
8892: ( SELECT RETRIEVAL_RANGE_ID
8893: FROM HXC_RETRIEVAL_RANGES
8894: WHERE CONC_REQUEST_ID = g_conc_request_id