[Home] [Help]
75:
76: l_chunk_size number;
77:
78:
79: TYPE NUMTABLE IS TABLE OF hxc_time_building_blocks_ar.time_building_block_id%TYPE;
80: TYPE VARCHARTABLE IS TABLE OF VARCHAR2(4000);
81:
82:
83: TYPE NUMBERTABLE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
519:
520:
521: l_chunk_size number;
522:
523: TYPE NUMTABLE IS TABLE OF hxc_time_building_blocks_ar.time_building_block_id%TYPE;
524: TYPE VARCHARTABLE IS TABLE OF VARCHAR2(4000);
525:
526: tc_id_tab NUMTABLE;
527: tc_ovn_tab NUMTABLE;
633: -- * Pick up the timecards(id-ovn) from hxc_ar_tc_ids_temp table, limited by
634: -- chunk size profile option.
635: -- * Insert the above id-ovn combination into hxc_temp_timecard_chunks table.
636: -- * Pick up all records from hxc_time_building_blocks for these combinations
637: -- and insert into hxc_time_building_blocks_ar
638: -- * For the timecard records in hxc_temp_timecard_chunks, pick up all records
639: -- from hxc_tc_ap_links, and insert into itself with application_period scope.
640: -- * Join hxc_temp_timecard_chunks with hxc_tc_ap_links and insert into hxc_tc_ap_links_ar
641: -- table.
640: -- * Join hxc_temp_timecard_chunks with hxc_tc_ap_links and insert into hxc_tc_ap_links_ar
641: -- table.
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.
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.
653: -- * Delete the above records from hxc_time_building_blocks.
654: -- * Join hxc_temp_timecard_chunks with hxc_time_building_blocks, DETAIL scope and pick up
655: -- all DETAIL records for these timecards, insert them into hxc_temp_timecard_chunks.
656: -- ( id, ovn, ROWID )
653: -- * Delete the above records from hxc_time_building_blocks.
654: -- * Join hxc_temp_timecard_chunks with hxc_time_building_blocks, DETAIL scope and pick up
655: -- all DETAIL records for these timecards, insert them into hxc_temp_timecard_chunks.
656: -- ( id, ovn, ROWID )
657: -- * Insert into hxc_time_building_blocks_ar these records, joining them by ROWID.
658: -- * Delete the above records from hxc_time_building_blocks.
659: -- * Loop to process transaction records.
660: -- Pick up transaction detail records for the records in hxc_temp_timecard_chunks
661: -- as of now. ( detail_id, transaction_id, detail_rowid ), and insert into
789: 'TIMECARD',
790: p_thread_id );
791:
792:
793: INSERT INTO hxc_time_building_blocks_ar
794: (DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
795: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
796: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
797: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,
898: write_data_mismatch('TC App LINKs ');
899: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
900: END IF;
901:
902: INSERT INTO hxc_time_building_blocks_ar
903: (DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
904: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
905: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
906: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,
997: ar.start_time,
998: ar.stop_time,
999: thread_id
1000: FROM hxc_temp_timecard_chunks temp,
1001: hxc_time_building_blocks ar
1002: WHERE parent_building_block_id = temp.id
1003: AND parent_building_block_ovn = temp.ref_ovn
1004: AND temp.scope = 'TIMECARD'
1005: AND thread_id = p_thread_id ;
1004: AND temp.scope = 'TIMECARD'
1005: AND thread_id = p_thread_id ;
1006:
1007:
1008: INSERT INTO hxc_time_building_blocks_ar
1009: (DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
1010: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
1011: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
1012: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,
1073: nvl(day_stop_time,ar.stop_time),
1074: ROWIDTOCHAR(ar.ROWID),
1075: thread_id
1076: FROM hxc_temp_timecard_chunks temp,
1077: hxc_time_building_blocks ar
1078: WHERE parent_building_block_id = temp.id
1079: AND parent_building_block_ovn = temp.ref_ovn
1080: AND temp.scope = 'DAY'
1081: AND thread_id = p_thread_id ;
1080: AND temp.scope = 'DAY'
1081: AND thread_id = p_thread_id ;
1082:
1083:
1084: INSERT INTO hxc_time_building_blocks_ar
1085: (DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
1086: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
1087: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
1088: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,