eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HXC_ARCHIVE dependencies on HXC_AP_DETAIL_LINKS

Line 11: -- hxc_ap_detail_links. It cancels open notifications. This

7: -- Description : This procedure is called during Archive Data Set process.
8: -- For a given data set, it copies the records FROM
9: -- base tables to archive tables AND DELETEs the records in base
10: -- table. It removes the links FROM hxc_tc_ap_links AND
11: -- hxc_ap_detail_links. It cancels open notifications. This
12: -- process is done in chunks.
13: ----------------------------------------------------------------------------
14: PROCEDURE archive_process(p_data_set_id NUMBER,
15: p_data_set_start_date DATE,

Line 732: -- * Select from hxc_ap_detail_links table, the records corresponding to the

728: -- Delete all attribute records from hxc_time_attributes table, if the attribute
729: -- id is present in hxc_archive_temp.
730: -- Delete from hxc_archive temp for the the next iteration of this loop.
731: -- * Delete all other scopes except DETAIL from hxc_temp_timecard_chunks.
732: -- * Select from hxc_ap_detail_links table, the records corresponding to the
733: -- details and insert into hxc_ap_detail_links_ar table.
734: -- * Delete from hxc_ap_detail_links table the above records.
735: -- * Delete from hxc_temp_timecard_chunks all records except the latest ovns.
736: -- * Insert these records into hxc_latest_details.

Line 733: -- details and insert into hxc_ap_detail_links_ar table.

729: -- id is present in hxc_archive_temp.
730: -- Delete from hxc_archive temp for the the next iteration of this loop.
731: -- * Delete all other scopes except DETAIL from hxc_temp_timecard_chunks.
732: -- * Select from hxc_ap_detail_links table, the records corresponding to the
733: -- details and insert into hxc_ap_detail_links_ar table.
734: -- * Delete from hxc_ap_detail_links table the above records.
735: -- * Delete from hxc_temp_timecard_chunks all records except the latest ovns.
736: -- * Insert these records into hxc_latest_details.
737: -- * COMMIT and pick up the next chunk.

Line 734: -- * Delete from hxc_ap_detail_links table the above records.

730: -- Delete from hxc_archive temp for the the next iteration of this loop.
731: -- * Delete all other scopes except DETAIL from hxc_temp_timecard_chunks.
732: -- * Select from hxc_ap_detail_links table, the records corresponding to the
733: -- details and insert into hxc_ap_detail_links_ar table.
734: -- * Delete from hxc_ap_detail_links table the above records.
735: -- * Delete from hxc_temp_timecard_chunks all records except the latest ovns.
736: -- * Insert these records into hxc_latest_details.
737: -- * COMMIT and pick up the next chunk.
738: --

Line 1753: INSERT INTO hxc_ap_detail_links_ar

1749: END IF;
1750:
1751:
1752:
1753: INSERT INTO hxc_ap_detail_links_ar
1754: (application_period_id,
1755: time_building_block_id,
1756: time_building_block_ovn)
1757: SELECT application_period_id, time_building_block_id, time_building_block_ovn

Line 1759: hxc_ap_detail_links adlbkup

1755: time_building_block_id,
1756: time_building_block_ovn)
1757: SELECT application_period_id, time_building_block_id, time_building_block_ovn
1758: FROM hxc_temp_timecard_chunks temp,
1759: hxc_ap_detail_links adlbkup
1760: WHERE temp.id = adlbkup.time_building_block_id
1761: AND temp.ref_ovn = adlbkup.time_building_block_ovn
1762: AND temp.scope = ('DETAIL')
1763: AND thread_id = p_thread_id ;

Line 1768: DELETE FROM hxc_ap_detail_links

1764:
1765: l_adl_count := SQL%ROWCOUNT;
1766:
1767:
1768: DELETE FROM hxc_ap_detail_links
1769: WHERE (time_building_block_id,time_building_block_ovn)
1770: IN ( SELECT id,
1771: ref_ovn
1772: FROM hxc_temp_timecard_chunks