[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;
552:
553:
554: l_chunk_size number;
555:
556: TYPE NUMTABLE IS TABLE OF hxc_time_building_blocks_ar.time_building_block_id%TYPE;
557: TYPE VARCHARTABLE IS TABLE OF VARCHAR2(4000);
558:
559: tc_id_tab NUMTABLE;
560: tc_ovn_tab NUMTABLE;
676: -- * Pick up the timecards(id-ovn) from hxc_ar_tc_ids_temp table, limited by
677: -- chunk size profile option.
678: -- * Insert the above id-ovn combination into hxc_temp_timecard_chunks table.
679: -- * Pick up all records from hxc_time_building_blocks for these combinations
680: -- and insert into hxc_time_building_blocks_ar
681: -- * For the timecard records in hxc_temp_timecard_chunks, pick up all records
682: -- from hxc_tc_ap_links, and insert into itself with application_period scope.
683: -- * Join hxc_temp_timecard_chunks with hxc_tc_ap_links and insert into hxc_tc_ap_links_ar
684: -- table.
683: -- * Join hxc_temp_timecard_chunks with hxc_tc_ap_links and insert into hxc_tc_ap_links_ar
684: -- table.
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.
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.
696: -- * Delete the above records from hxc_time_building_blocks.
697: -- * Join hxc_temp_timecard_chunks with hxc_time_building_blocks, DETAIL scope and pick up
698: -- all DETAIL records for these timecards, insert them into hxc_temp_timecard_chunks.
699: -- ( id, ovn, ROWID )
696: -- * Delete the above records from hxc_time_building_blocks.
697: -- * Join hxc_temp_timecard_chunks with hxc_time_building_blocks, DETAIL scope and pick up
698: -- all DETAIL records for these timecards, insert them into hxc_temp_timecard_chunks.
699: -- ( id, ovn, ROWID )
700: -- * Insert into hxc_time_building_blocks_ar these records, joining them by ROWID.
701: -- * Delete the above records from hxc_time_building_blocks.
702: -- * Loop to process transaction records.
703: -- Pick up transaction detail records for the records in hxc_temp_timecard_chunks
704: -- as of now. ( detail_id, transaction_id, detail_rowid ), and insert into
832: 'TIMECARD',
833: p_thread_id );
834:
835:
836: INSERT INTO hxc_time_building_blocks_ar
837: (DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
838: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
839: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
840: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,
941: write_data_mismatch('TC App LINKs ');
942: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
943: END IF;
944:
945: INSERT INTO hxc_time_building_blocks_ar
946: (DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
947: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
948: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
949: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,
1040: ar.start_time,
1041: ar.stop_time,
1042: thread_id
1043: FROM hxc_temp_timecard_chunks temp,
1044: hxc_time_building_blocks ar
1045: WHERE parent_building_block_id = temp.id
1046: AND parent_building_block_ovn = temp.ref_ovn
1047: AND temp.scope = 'TIMECARD'
1048: AND thread_id = p_thread_id ;
1047: AND temp.scope = 'TIMECARD'
1048: AND thread_id = p_thread_id ;
1049:
1050:
1051: INSERT INTO hxc_time_building_blocks_ar
1052: (DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
1053: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
1054: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
1055: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,
1116: nvl(day_stop_time,ar.stop_time),
1117: ROWIDTOCHAR(ar.ROWID),
1118: thread_id
1119: FROM hxc_temp_timecard_chunks temp,
1120: hxc_time_building_blocks ar
1121: WHERE parent_building_block_id = temp.id
1122: AND parent_building_block_ovn = temp.ref_ovn
1123: AND temp.scope = 'DAY'
1124: AND thread_id = p_thread_id ;
1123: AND temp.scope = 'DAY'
1124: AND thread_id = p_thread_id ;
1125:
1126:
1127: INSERT INTO hxc_time_building_blocks_ar
1128: (DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
1129: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
1130: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
1131: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,