DBA Data[Home] [Help]

APPS.HXC_ARCHIVE dependencies on HXC_APP_PERIOD_SUMMARY_AR

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 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)