APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_PA_LATEST_DETAILS

Line 646: FROM hxc_pa_latest_details tbb

642: -- Retrieval performance upgrade, using the new tables in these new sql strings.
643: l_root_pa VARCHAR2(2500)
644: := '
645: SELECT DISTINCT tbb.resource_id
646: FROM hxc_pa_latest_details tbb
647: WHERE tbb.last_update_date > :p_since_date ';
648:
649: l_root_pay VARCHAR2(2500)
650: := '

Line 667: FROM hxc_pa_latest_details tbb

663: -- Bug 9394444
664: l_root_day_pa VARCHAR2 (2500)
665: := '
666: SELECT DISTINCT tbb.resource_id
667: FROM hxc_pa_latest_details tbb
668: WHERE tbb.last_update_date > :p_since_date ';
669:
670: l_root_day_pay VARCHAR2 (2500)
671: := '

Line 1183: l_rdb_process_sql := REPLACE(l_rdb_process_sql,'LATEST_DETAILS','HXC_PA_LATEST_DETAILS');

1179: -- Bug 9458888
1180: IF g_params.p_process = 'Projects Retrieval Process'
1181: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PA')
1182: THEN
1183: l_rdb_process_sql := REPLACE(l_rdb_process_sql,'LATEST_DETAILS','HXC_PA_LATEST_DETAILS');
1184: l_rdb_process_sql := REPLACE(l_rdb_process_sql,'RETRIEVALPROCESS',''''||g_params.p_process||'''');
1185: l_rdb_process_sql := l_rdb_process_sql||' '||l_org_strip||l_appln_strip;
1186: mark_for_retrieval(TRUNC(SYSDATE) - fnd_profile.value('HXC_RETRIEVAL_CHANGES_DATE'),
1187: l_rdb_process_sql);

Line 1753: , hxc_pa_latest_details tbb_latest ';

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: := '
1757: SELECT /*+ ordered */

Line 7066: from Hxc_pa_latest_details tbb_latest

7062: FROM
7063: (select /*+ no_merge ordered */
7064: time_building_block_id,
7065: object_version_number
7066: from Hxc_pa_latest_details tbb_latest
7067: where tbb_latest.resource_id BETWEEN :p_lower_range and :p_upper_range
7068: and tbb_latest.approval_status <> ''ERROR''
7069: AND NOT EXISTS (select ''x''
7070: FROM hxc_transaction_details txd

Line 7141: hxc_pa_latest_details tbb_latest

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
7145: tbb_latest.last_update_date > :p_since_date

Line 7227: , hxc_pa_latest_details hld

7223: , Hxc_time_attribute_usages detail_usage
7224: , Hxc_time_attributes detail_att
7225: , hxc_time_building_blocks day_block
7226: , hxc_time_building_blocks timecard_block
7227: , hxc_pa_latest_details hld
7228: , hxc_max_ovn detail_max_ovn';
7229:
7230: l_incremental_from_pay VARCHAR2 (400)
7231: := '

Line 9265: DELETE FROM hxc_pa_latest_details

9261: IF g_params.p_process = 'Projects Retrieval Process'
9262: THEN
9263: FORALL tx_error IN hxc_generic_retrieval_pkg.t_tx_detail_bb_id.FIRST ..
9264: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.LAST
9265: DELETE FROM hxc_pa_latest_details
9266: WHERE time_building_block_id = hxc_generic_retrieval_pkg.t_tx_detail_bb_id(tx_error)
9267: AND hxc_generic_retrieval_pkg.t_tx_detail_status
9268: (tx_error) = 'SUCCESS'
9269: RETURNING

Line 9299: -- If there are any successful deletes from hxc_pa_latest_details

9295: t_l_attribute3,
9296: t_l_measure,
9297: t_l_object_version_number;
9298:
9299: -- If there are any successful deletes from hxc_pa_latest_details
9300: -- move them to HXC_RET_PA_LATEST_DETAILS
9301: -- Keep recording whichever bb ids are updated.
9302:
9303: IF t_l_resource_id.COUNT > 0