APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_RETRIEVAL_RANGE_RESOURCES

Line 819: INSERT INTO hxc_retrieval_range_resources

815: CLOSE csr_get_rr_id;
816:
817: p_rr_id := l_rr_id;
818: FORALL rrx IN p_resource_list.FIRST .. p_resource_list.LAST
819: INSERT INTO hxc_retrieval_range_resources
820: (retrieval_range_id, resource_id
821: )
822: VALUES (l_rr_id, p_resource_list (rrx)
823: );

Line 1312: , hxc_retrieval_range_resources rrr

1308: SELECT /*+ ordered */
1309: tbb_latest.time_building_block_id,
1310: tbb_latest.object_version_number insert_latest
1311: FROM hxc_retrieval_ranges rr
1312: , hxc_retrieval_range_resources rrr
1313: , hxc_latest_details tbb_latest ';
1314:
1315: l_where VARCHAR2 (1500)
1316: := '

Line 6329: hxc_retrieval_range_resources rrr,

6325: (select /*+ no_merge ordered */
6326: tbb_latest.time_building_block_id,
6327: tbb_latest.object_version_number
6328: from hxc_retrieval_ranges rr,
6329: hxc_retrieval_range_resources rrr,
6330: hxc_latest_details tbb_latest
6331: where rr.retrieval_range_id = :p_rr_id AND
6332: rr.retrieval_range_id = rrr.retrieval_range_id AND
6333: tbb_latest.resource_id = rrr.resource_id AND

Line 7785: DELETE FROM HXC_RETRIEVAL_RANGE_RESOURCES

7781: IS
7782: PRAGMA AUTONOMOUS_TRANSACTION;
7783: BEGIN
7784:
7785: DELETE FROM HXC_RETRIEVAL_RANGE_RESOURCES
7786: WHERE RETRIEVAL_RANGE_ID IN
7787: ( SELECT RETRIEVAL_RANGE_ID
7788: FROM HXC_RETRIEVAL_RANGES
7789: WHERE CONC_REQUEST_ID = g_conc_request_id