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_APP_PERIOD_SUMMARY

Line 646: -- * Pick up all records for the application_period from hxc_app_period_summary

642: -- * Delete these records from hxc_tc_ap_links table.
643: -- * For all the application_period records in hxc_temp_timecard_chunks table, select from
644: -- hxc_time_building_blocks and insert into hxc_time_building_blocks_ar.
645: -- * Delete from hxc_time_building_blocks these records.
646: -- * Pick up all records for the application_period from hxc_app_period_summary
647: -- table and insert into hxc_app_period_summary_ar table.
648: -- * Delete from hxc_app_period_summary table, the corresponding records.
649: -- * Join hxc_temp_timecard_chunks with hxc_time_building_blocks, DAY scope and pick up
650: -- all DAY records for these timecards, insert them into hxc_temp_timecard_chunks.

Line 647: -- table and insert into hxc_app_period_summary_ar table.

643: -- * For all the application_period records in hxc_temp_timecard_chunks table, select from
644: -- hxc_time_building_blocks and insert into hxc_time_building_blocks_ar.
645: -- * Delete from hxc_time_building_blocks these records.
646: -- * Pick up all records for the application_period from hxc_app_period_summary
647: -- table and insert into hxc_app_period_summary_ar table.
648: -- * Delete from hxc_app_period_summary table, the corresponding records.
649: -- * Join hxc_temp_timecard_chunks with hxc_time_building_blocks, DAY scope and pick up
650: -- all DAY records for these timecards, insert them into hxc_temp_timecard_chunks.
651: -- ( id, ovn, ROWID )

Line 648: -- * Delete from hxc_app_period_summary table, the corresponding records.

644: -- hxc_time_building_blocks and insert into hxc_time_building_blocks_ar.
645: -- * Delete from hxc_time_building_blocks these records.
646: -- * Pick up all records for the application_period from hxc_app_period_summary
647: -- table and insert into hxc_app_period_summary_ar table.
648: -- * Delete from hxc_app_period_summary table, the corresponding records.
649: -- * Join hxc_temp_timecard_chunks with hxc_time_building_blocks, DAY scope and pick up
650: -- all DAY records for these timecards, insert them into hxc_temp_timecard_chunks.
651: -- ( id, ovn, ROWID )
652: -- * Insert into hxc_time_building_blocks_ar these records, joining them by ROWID.

Line 946: INSERT INTO hxc_app_period_summary_ar

942: write_data_mismatch('Application Period ');
943: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
944: END IF;
945:
946: INSERT INTO hxc_app_period_summary_ar
947: (APPLICATION_PERIOD_ID,APPLICATION_PERIOD_OVN,APPROVAL_STATUS,TIME_RECIPIENT_ID,
948: TIME_CATEGORY_ID,START_TIME,STOP_TIME,RESOURCE_ID,RECIPIENT_SEQUENCE,
949: CATEGORY_SEQUENCE,CREATION_DATE,NOTIFICATION_STATUS,APPROVER_ID,APPROVAL_COMP_ID,
950: APPROVAL_ITEM_TYPE,APPROVAL_PROCESS_NAME,APPROVAL_ITEM_KEY,DATA_SET_ID)

Line 956: FROM hxc_app_period_summary apsbkup

952: TIME_RECIPIENT_ID,TIME_CATEGORY_ID,START_TIME,STOP_TIME,RESOURCE_ID,
953: RECIPIENT_SEQUENCE,CATEGORY_SEQUENCE,CREATION_DATE,NOTIFICATION_STATUS,
954: APPROVER_ID,APPROVAL_COMP_ID,APPROVAL_ITEM_TYPE,APPROVAL_PROCESS_NAME,
955: APPROVAL_ITEM_KEY,p_data_set_id
956: FROM hxc_app_period_summary apsbkup
957: WHERE application_period_id IN (SELECT id
958: FROM hxc_temp_timecard_chunks
959: WHERE scope = 'APPLICATION_PERIOD'
960: AND thread_id = p_thread_id );

Line 965: DELETE FROM hxc_app_period_summary

961:
962: l_app_period_sum_count := SQL%ROWCOUNT;
963:
964:
965: DELETE FROM hxc_app_period_summary
966: WHERE application_period_id IN (SELECT id
967: FROM hxc_temp_timecard_chunks
968: WHERE scope = 'APPLICATION_PERIOD'
969: AND thread_id = p_thread_id );