APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_RETRIEVAL_RANGE_BLKS

Line 1731: FROM hxc_retrieval_range_blks;

1727: CURSOR csr_get_ret_range_blks
1728: IS
1729: SELECT TO_CHAR (time_building_block_id) tbb_id,
1730: TO_CHAR (object_version_number) tbb_ovn
1731: FROM hxc_retrieval_range_blks;
1732:
1733: l_ret_range_rec csr_get_ret_range_blks%ROWTYPE;
1734: l_select_from VARCHAR2 (250)
1735: := '

Line 1979: DELETE FROM hxc_retrieval_range_blks;

1975: THEN
1976: hr_utility.TRACE ('About to delete rows');
1977: END IF;
1978:
1979: DELETE FROM hxc_retrieval_range_blks;
1980:
1981: -- build query
1982: l_app_set :=
1983: g_app_set_id_string (g_retrieval_tr_id).app_set_id_string;

Line 2131: INSERT INTO hxc_retrieval_range_blks

2127: n_tab => t_tbb_ovn
2128: );
2129: -- populate retrieval range blks
2130: FORALL rrx IN t_tbb_id.FIRST .. t_tbb_id.LAST
2131: INSERT INTO hxc_retrieval_range_blks
2132: (time_building_block_id, object_version_number
2133: )
2134: VALUES (t_tbb_id (rrx), t_tbb_ovn (rrx)
2135: );

Line 2189: FROM hxc_retrieval_range_blks rrb,

2185: INDEX(TX HXC_TRANSACTIONS_PK)
2186: USE_NL(TXD, TX) */
2187: txd.time_building_block_id,
2188: NVL (MAX (txd.time_building_block_ovn), 0)
2189: FROM hxc_retrieval_range_blks rrb,
2190: hxc_transaction_details txd,
2191: hxc_transactions tx
2192: WHERE tx.transaction_process_id = p_retrieval_process_id
2193: AND tx.TYPE = 'RETRIEVAL'

Line 7200: hxc_retrieval_range_blks tbb

7196: , hxc_max_ovn detail_max_ovn';
7197: l_incremental_from VARCHAR2 (400)
7198: := '
7199: FROM
7200: hxc_retrieval_range_blks tbb
7201: , Hxc_time_building_blocks detail_block
7202: , Hxc_time_attribute_usages detail_usage
7203: , Hxc_time_attributes detail_att
7204: , hxc_time_building_blocks day_block

Line 7221: hxc_retrieval_range_blks tbb

7217: -- Bug 9394444
7218: l_incremental_from_pa VARCHAR2 (400)
7219: := '
7220: FROM
7221: hxc_retrieval_range_blks tbb
7222: , Hxc_time_building_blocks detail_block
7223: , Hxc_time_attribute_usages detail_usage
7224: , Hxc_time_attributes detail_att
7225: , hxc_time_building_blocks day_block

Line 7233: hxc_retrieval_range_blks tbb

7229:
7230: l_incremental_from_pay VARCHAR2 (400)
7231: := '
7232: FROM
7233: hxc_retrieval_range_blks tbb
7234: , Hxc_time_building_blocks detail_block
7235: , Hxc_time_attribute_usages detail_usage
7236: , Hxc_time_attributes detail_att
7237: , hxc_time_building_blocks day_block