APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_RETRIEVAL_RANGE_BLKS

Line 1303: FROM hxc_retrieval_range_blks;

1299: CURSOR csr_get_ret_range_blks
1300: IS
1301: SELECT TO_CHAR (time_building_block_id) tbb_id,
1302: TO_CHAR (object_version_number) tbb_ovn
1303: FROM hxc_retrieval_range_blks;
1304:
1305: l_ret_range_rec csr_get_ret_range_blks%ROWTYPE;
1306: l_select_from VARCHAR2 (250)
1307: := '

Line 1398: DELETE FROM hxc_retrieval_range_blks;

1394: THEN
1395: hr_utility.TRACE ('About to delete rows');
1396: END IF;
1397:
1398: DELETE FROM hxc_retrieval_range_blks;
1399:
1400: -- build query
1401: l_app_set :=
1402: g_app_set_id_string (g_retrieval_tr_id).app_set_id_string;

Line 1537: INSERT INTO hxc_retrieval_range_blks

1533: n_tab => t_tbb_ovn
1534: );
1535: -- populate retrieval range blks
1536: FORALL rrx IN t_tbb_id.FIRST .. t_tbb_id.LAST
1537: INSERT INTO hxc_retrieval_range_blks
1538: (time_building_block_id, object_version_number
1539: )
1540: VALUES (t_tbb_id (rrx), t_tbb_ovn (rrx)
1541: );

Line 1590: FROM hxc_retrieval_range_blks rrb,

1586: IS
1587: SELECT /*+ ORDERED INDEX(TXD) INDEX(TX) USE_NL(TXD, TX) */
1588: txd.time_building_block_id,
1589: NVL (MAX (txd.time_building_block_ovn), 0)
1590: FROM hxc_retrieval_range_blks rrb,
1591: hxc_transaction_details txd,
1592: hxc_transactions tx
1593: WHERE tx.transaction_process_id = p_retrieval_process_id
1594: AND tx.TYPE = 'RETRIEVAL'

Line 6360: hxc_retrieval_range_blks tbb

6356: , hxc_max_ovn detail_max_ovn';
6357: l_incremental_from VARCHAR2 (400)
6358: := '
6359: FROM
6360: hxc_retrieval_range_blks tbb
6361: , Hxc_time_building_blocks detail_block
6362: , Hxc_time_attribute_usages detail_usage
6363: , Hxc_time_attributes detail_att
6364: , hxc_time_building_blocks day_block