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_TIME_BUILDING_BLOCKS

Line 23: IS SELECT /+ INDEX (HXC HXC_TIME_BUILDING_BLOCKS_N2)/

19: -- For the given data set id, pick up all the timecard scope records
20: -- to be dumped into the temp table for processing.
21:
22: CURSOR get_timecards( p_data_set_id IN NUMBER)
23: IS SELECT /*+ INDEX (HXC HXC_TIME_BUILDING_BLOCKS_N2)*/
24: TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,UNIT_OF_MEASURE,
25: START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,PARENT_BUILDING_BLOCK_OVN,
26: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
27: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,

Line 30: FROM hxc_time_building_blocks hxc

26: SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
27: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
28: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,APPLICATION_SET_ID,DATA_SET_ID,
29: TRANSLATION_DISPLAY_KEY
30: FROM hxc_time_building_blocks hxc
31: WHERE data_set_id = p_data_set_id
32: AND scope = 'TIMECARD'
33: ORDER BY time_building_block_id;
34:

Line 79: TYPE NUMTABLE IS TABLE OF hxc_time_building_blocks_ar.time_building_block_id%TYPE;

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;

Line 556: TYPE NUMTABLE IS TABLE OF hxc_time_building_blocks_ar.time_building_block_id%TYPE;

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;

Line 679: -- * Pick up all records from hxc_time_building_blocks for these combinations

675: --
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

Line 680: -- and insert into hxc_time_building_blocks_ar

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.

Line 687: -- hxc_time_building_blocks and insert into hxc_time_building_blocks_ar.

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.

Line 688: -- * Delete from hxc_time_building_blocks these records.

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.
692: -- * Join hxc_temp_timecard_chunks with hxc_time_building_blocks, DAY scope and pick up

Line 692: -- * Join hxc_temp_timecard_chunks with hxc_time_building_blocks, DAY scope and pick up

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.
696: -- * Delete the above records from hxc_time_building_blocks.

Line 695: -- * Insert into hxc_time_building_blocks_ar these records, joining them by ROWID.

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 )

Line 696: -- * Delete the above records from hxc_time_building_blocks.

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 )
700: -- * Insert into hxc_time_building_blocks_ar these records, joining them by ROWID.

Line 697: -- * Join hxc_temp_timecard_chunks with hxc_time_building_blocks, DETAIL 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 )
700: -- * Insert into hxc_time_building_blocks_ar these records, joining them by ROWID.
701: -- * Delete the above records from hxc_time_building_blocks.

Line 700: -- * 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 )
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

Line 701: -- * 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
705: -- hxc_archive_temp.

Line 836: INSERT INTO hxc_time_building_blocks_ar

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,

Line 844: SELECT /+ INDEX(bkup HXC_TIME_BUILDING_BLOCKS_PK) /

840: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,
841: RESOURCE_TYPE,APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,
842: PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
843: TRANSLATION_DISPLAY_KEY)
844: SELECT /*+ INDEX(bkup HXC_TIME_BUILDING_BLOCKS_PK) */
845: bkup.DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
846: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
847: bkup.SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
848: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,

Line 852: hxc_time_building_blocks bkup

848: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
849: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
850: TRANSLATION_DISPLAY_KEY
851: FROM hxc_temp_timecard_chunks temp,
852: hxc_time_building_blocks bkup
853: WHERE bkup.scope = 'TIMECARD'
854: AND bkup.time_building_block_id = temp.id
855: AND bkup.object_version_number = temp.ref_ovn
856: AND bkup.data_set_id = p_data_set_id

Line 863: FROM hxc_time_building_blocks

859: l_tc_count := sql%rowcount;
860:
861: FORALL i IN tc_id_tab.FIRST..tc_id_tab.LAST
862: DELETE
863: FROM hxc_time_building_blocks
864: WHERE time_building_block_id = tc_id_tab(i)
865: AND object_version_number = tc_ovn_tab(i) ;
866:
867: l_tc_del_count := sql%rowcount;

Line 945: INSERT INTO hxc_time_building_blocks_ar

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,

Line 959: FROM hxc_time_building_blocks appbkup

955: appbkup.SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
956: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
957: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,
958: APPLICATION_SET_ID,TRANSLATION_DISPLAY_KEY
959: FROM hxc_time_building_blocks appbkup
960: WHERE appbkup.scope = 'APPLICATION_PERIOD'
961: AND appbkup.time_building_block_id IN ( SELECT id
962: FROM hxc_temp_timecard_chunks temp
963: WHERE temp.scope IN

Line 969: DELETE FROM hxc_time_building_blocks

965: AND thread_id = p_thread_id ) ;
966:
967: l_app_period_count := SQL%ROWCOUNT;
968:
969: DELETE FROM hxc_time_building_blocks
970: WHERE time_building_block_id IN ( SELECT id
971: FROM hxc_temp_timecard_chunks
972: WHERE scope IN
973: ('APPLICATION_PERIOD')

Line 1035: SELECT /+ LEADING(TEMP) INDEX(AR HXC_TIME_BUILDING_BLOCKS_FK3) /

1031: ref_rowid,
1032: day_start_time,
1033: day_stop_time,
1034: thread_id )
1035: SELECT /*+ LEADING(TEMP) INDEX(AR HXC_TIME_BUILDING_BLOCKS_FK3) */
1036: time_building_block_id,
1037: object_version_number,
1038: 'DAY',
1039: ROWIDTOCHAR(ar.ROWID),

Line 1044: hxc_time_building_blocks ar

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 ;

Line 1051: INSERT INTO hxc_time_building_blocks_ar

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,

Line 1066: hxc_time_building_blocks bkupday

1062: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
1063: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
1064: TRANSLATION_DISPLAY_KEY
1065: FROM hxc_temp_timecard_chunks temp,
1066: hxc_time_building_blocks bkupday
1067: WHERE bkupday.ROWID = CHARTOROWID(temp.ref_rowid)
1068: AND temp.scope = 'DAY'
1069: AND thread_id = p_thread_id;
1070:

Line 1084: DELETE FROM hxc_time_building_blocks

1080:
1081: EXIT WHEN rowid_tab.COUNT = 0;
1082:
1083: FORALL i IN rowid_tab.FIRST..rowid_tab.LAST
1084: DELETE FROM hxc_time_building_blocks
1085: WHERE ROWID = CHARTOROWID(rowid_tab(i));
1086:
1087: l_day_del_count := l_day_del_count + SQL%ROWCOUNT;
1088: rowid_tab.DELETE;

Line 1111: SELECT /+ LEADING(TEMP) INDEX(AR HXC_TIME_BUILDING_BLOCKS_FK3) /

1107: day_start_time,
1108: day_stop_time,
1109: ref_rowid,
1110: thread_id )
1111: SELECT /*+ LEADING(TEMP) INDEX(AR HXC_TIME_BUILDING_BLOCKS_FK3) */
1112: time_building_block_id,
1113: object_version_number,
1114: 'DETAIL',
1115: nvl(day_start_time,ar.start_time),

Line 1120: hxc_time_building_blocks ar

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 ;

Line 1127: INSERT INTO hxc_time_building_blocks_ar

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,

Line 1142: hxc_time_building_blocks bkupday

1138: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
1139: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
1140: TRANSLATION_DISPLAY_KEY
1141: FROM hxc_temp_timecard_chunks temp,
1142: hxc_time_building_blocks bkupday
1143: WHERE bkupday.ROWID = CHARTOROWID(temp.ref_rowid)
1144: AND temp.scope = 'DETAIL'
1145: AND thread_id = p_thread_id ;
1146:

Line 1159: DELETE FROM hxc_time_building_blocks

1155:
1156: EXIT WHEN rowid_tab.COUNT = 0;
1157:
1158: FORALL i IN rowid_tab.FIRST..rowid_tab.LAST
1159: DELETE FROM hxc_time_building_blocks
1160: WHERE ROWID = CHARTOROWID(rowid_tab(i));
1161:
1162: l_det_del_count := l_det_del_count + SQL%ROWCOUNT;
1163: rowid_tab.DELETE;