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.

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 689: -- * Select from hxc_ap_detail_links table, the records corresponding to the

685: -- Delete all attribute records from hxc_time_attributes table, if the attribute
686: -- id is present in hxc_archive_temp.
687: -- Delete from hxc_archive temp for the the next iteration of this loop.
688: -- * Delete all other scopes except DETAIL from hxc_temp_timecard_chunks.
689: -- * Select from hxc_ap_detail_links table, the records corresponding to the
690: -- details and insert into hxc_ap_detail_links_ar table.
691: -- * Delete from hxc_ap_detail_links table the above records.
692: -- * Delete from hxc_temp_timecard_chunks all records except the latest ovns.
693: -- * Insert these records into hxc_latest_details.

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

686: -- id is present in hxc_archive_temp.
687: -- Delete from hxc_archive temp for the the next iteration of this loop.
688: -- * Delete all other scopes except DETAIL from hxc_temp_timecard_chunks.
689: -- * Select from hxc_ap_detail_links table, the records corresponding to the
690: -- details and insert into hxc_ap_detail_links_ar table.
691: -- * Delete from hxc_ap_detail_links table the above records.
692: -- * Delete from hxc_temp_timecard_chunks all records except the latest ovns.
693: -- * Insert these records into hxc_latest_details.
694: -- * COMMIT and pick up the next chunk.

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

687: -- Delete from hxc_archive temp for the the next iteration of this loop.
688: -- * Delete all other scopes except DETAIL from hxc_temp_timecard_chunks.
689: -- * Select from hxc_ap_detail_links table, the records corresponding to the
690: -- details and insert into hxc_ap_detail_links_ar table.
691: -- * Delete from hxc_ap_detail_links table the above records.
692: -- * Delete from hxc_temp_timecard_chunks all records except the latest ovns.
693: -- * Insert these records into hxc_latest_details.
694: -- * COMMIT and pick up the next chunk.
695: --

Line 1404: INSERT INTO hxc_ap_detail_links_ar

1400: WHERE scope IN ( 'TIMECARD', 'DAY','APPLICATION_PERIOD')
1401: AND thread_id = p_thread_id ;
1402:
1403:
1404: INSERT INTO hxc_ap_detail_links_ar
1405: (application_period_id,
1406: time_building_block_id,
1407: time_building_block_ovn)
1408: SELECT application_period_id, time_building_block_id, time_building_block_ovn

Line 1410: hxc_ap_detail_links adlbkup

1406: time_building_block_id,
1407: time_building_block_ovn)
1408: SELECT application_period_id, time_building_block_id, time_building_block_ovn
1409: FROM hxc_temp_timecard_chunks temp,
1410: hxc_ap_detail_links adlbkup
1411: WHERE temp.id = adlbkup.time_building_block_id
1412: AND temp.ref_ovn = adlbkup.time_building_block_ovn
1413: AND temp.scope = ('DETAIL')
1414: AND thread_id = p_thread_id ;

Line 1419: DELETE FROM hxc_ap_detail_links

1415:
1416: l_adl_count := SQL%ROWCOUNT;
1417:
1418:
1419: DELETE FROM hxc_ap_detail_links
1420: WHERE (time_building_block_id,time_building_block_ovn)
1421: IN ( SELECT id,
1422: ref_ovn
1423: FROM hxc_temp_timecard_chunks