APPS.HXC_ARCHIVE dependencies on HXC_APP_PERIOD_SUMMARY

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

685: -- * Delete these records from hxc_tc_ap_links table.
686: -- * For all the application_period records in hxc_temp_timecard_chunks table, select from
687: -- hxc_time_building_blocks and insert into hxc_time_building_blocks_ar.
688: -- * Delete from hxc_time_building_blocks these records.
689: -- * Pick up all records for the application_period from hxc_app_period_summary
690: -- table and insert into hxc_app_period_summary_ar table.
691: -- * Delete from hxc_app_period_summary table, the corresponding records.
692: -- * Join hxc_temp_timecard_chunks with hxc_time_building_blocks, DAY scope and pick up
693: -- all DAY records for these timecards, insert them into hxc_temp_timecard_chunks.

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

686: -- * For all the application_period records in hxc_temp_timecard_chunks table, select from
687: -- hxc_time_building_blocks and insert into hxc_time_building_blocks_ar.
688: -- * Delete from hxc_time_building_blocks these records.
689: -- * Pick up all records for the application_period from hxc_app_period_summary
690: -- table and insert into hxc_app_period_summary_ar table.
691: -- * Delete from hxc_app_period_summary table, the corresponding records.
692: -- * Join hxc_temp_timecard_chunks with hxc_time_building_blocks, DAY scope and pick up
693: -- all DAY records for these timecards, insert them into hxc_temp_timecard_chunks.
694: -- ( id, ovn, ROWID )

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

687: -- hxc_time_building_blocks and insert into hxc_time_building_blocks_ar.
688: -- * Delete from hxc_time_building_blocks these records.
689: -- * Pick up all records for the application_period from hxc_app_period_summary
690: -- table and insert into hxc_app_period_summary_ar table.
691: -- * Delete from hxc_app_period_summary table, the corresponding records.
692: -- * Join hxc_temp_timecard_chunks with hxc_time_building_blocks, DAY scope and pick up
693: -- all DAY records for these timecards, insert them into hxc_temp_timecard_chunks.
694: -- ( id, ovn, ROWID )
695: -- * Insert into hxc_time_building_blocks_ar these records, joining them by ROWID.

Line 989: INSERT INTO hxc_app_period_summary_ar

985: write_data_mismatch('Application Period ');
986: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
987: END IF;
988:
989: INSERT INTO hxc_app_period_summary_ar
990: (APPLICATION_PERIOD_ID,APPLICATION_PERIOD_OVN,APPROVAL_STATUS,TIME_RECIPIENT_ID,
991: TIME_CATEGORY_ID,START_TIME,STOP_TIME,RESOURCE_ID,RECIPIENT_SEQUENCE,
992: CATEGORY_SEQUENCE,CREATION_DATE,NOTIFICATION_STATUS,APPROVER_ID,APPROVAL_COMP_ID,
993: APPROVAL_ITEM_TYPE,APPROVAL_PROCESS_NAME,APPROVAL_ITEM_KEY,DATA_SET_ID)

Line 999: FROM hxc_app_period_summary apsbkup

995: TIME_RECIPIENT_ID,TIME_CATEGORY_ID,START_TIME,STOP_TIME,RESOURCE_ID,
996: RECIPIENT_SEQUENCE,CATEGORY_SEQUENCE,CREATION_DATE,NOTIFICATION_STATUS,
997: APPROVER_ID,APPROVAL_COMP_ID,APPROVAL_ITEM_TYPE,APPROVAL_PROCESS_NAME,
998: APPROVAL_ITEM_KEY,p_data_set_id
999: FROM hxc_app_period_summary apsbkup
1000: WHERE application_period_id IN (SELECT id
1001: FROM hxc_temp_timecard_chunks
1002: WHERE scope = 'APPLICATION_PERIOD'
1003: AND thread_id = p_thread_id );

Line 1008: DELETE FROM hxc_app_period_summary

1004:
1005: l_app_period_sum_count := SQL%ROWCOUNT;
1006:
1007:
1008: DELETE FROM hxc_app_period_summary
1009: WHERE application_period_id IN (SELECT id
1010: FROM hxc_temp_timecard_chunks
1011: WHERE scope = 'APPLICATION_PERIOD'
1012: AND thread_id = p_thread_id );