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 523: TYPE NUMTABLE IS TABLE OF hxc_time_building_blocks_ar.time_building_block_id%TYPE;

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;

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

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

Line 637: -- and insert into hxc_time_building_blocks_ar

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.

Line 644: -- hxc_time_building_blocks and insert into hxc_time_building_blocks_ar.

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.

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

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

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

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 )
652: -- * Insert into hxc_time_building_blocks_ar these records, joining them by ROWID.
653: -- * Delete the above records from hxc_time_building_blocks.

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

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 )

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

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

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

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

Line 658: -- * 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
662: -- hxc_archive_temp.

Line 793: INSERT INTO hxc_time_building_blocks_ar

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,

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

797: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,
798: RESOURCE_TYPE,APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,
799: PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
800: TRANSLATION_DISPLAY_KEY)
801: SELECT /*+ INDEX(bkup HXC_TIME_BUILDING_BLOCKS_PK) */
802: bkup.DATA_SET_ID,TIME_BUILDING_BLOCK_ID,TYPE,MEASURE,
803: UNIT_OF_MEASURE,START_TIME,STOP_TIME,PARENT_BUILDING_BLOCK_ID,
804: bkup.SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
805: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,

Line 809: hxc_time_building_blocks bkup

805: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
806: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
807: TRANSLATION_DISPLAY_KEY
808: FROM hxc_temp_timecard_chunks temp,
809: hxc_time_building_blocks bkup
810: WHERE bkup.scope = 'TIMECARD'
811: AND bkup.time_building_block_id = temp.id
812: AND bkup.object_version_number = temp.ref_ovn
813: AND bkup.data_set_id = p_data_set_id

Line 820: FROM hxc_time_building_blocks

816: l_tc_count := sql%rowcount;
817:
818: FORALL i IN tc_id_tab.FIRST..tc_id_tab.LAST
819: DELETE
820: FROM hxc_time_building_blocks
821: WHERE time_building_block_id = tc_id_tab(i)
822: AND object_version_number = tc_ovn_tab(i) ;
823:
824: l_tc_del_count := sql%rowcount;

Line 902: INSERT INTO hxc_time_building_blocks_ar

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,

Line 916: FROM hxc_time_building_blocks appbkup

912: appbkup.SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
913: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
914: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,
915: APPLICATION_SET_ID,TRANSLATION_DISPLAY_KEY
916: FROM hxc_time_building_blocks appbkup
917: WHERE appbkup.scope = 'APPLICATION_PERIOD'
918: AND appbkup.time_building_block_id IN ( SELECT id
919: FROM hxc_temp_timecard_chunks temp
920: WHERE temp.scope IN

Line 926: DELETE FROM hxc_time_building_blocks

922: AND thread_id = p_thread_id ) ;
923:
924: l_app_period_count := SQL%ROWCOUNT;
925:
926: DELETE FROM hxc_time_building_blocks
927: WHERE time_building_block_id IN ( SELECT id
928: FROM hxc_temp_timecard_chunks
929: WHERE scope IN
930: ('APPLICATION_PERIOD')

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

988: ref_rowid,
989: day_start_time,
990: day_stop_time,
991: thread_id )
992: SELECT /*+ LEADING(TEMP) INDEX(AR HXC_TIME_BUILDING_BLOCKS_FK3) */
993: time_building_block_id,
994: object_version_number,
995: 'DAY',
996: ROWIDTOCHAR(ar.ROWID),

Line 1001: hxc_time_building_blocks ar

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 ;

Line 1008: INSERT INTO hxc_time_building_blocks_ar

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,

Line 1023: hxc_time_building_blocks bkupday

1019: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
1020: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
1021: TRANSLATION_DISPLAY_KEY
1022: FROM hxc_temp_timecard_chunks temp,
1023: hxc_time_building_blocks bkupday
1024: WHERE bkupday.ROWID = CHARTOROWID(temp.ref_rowid)
1025: AND temp.scope = 'DAY'
1026: AND thread_id = p_thread_id;
1027:

Line 1041: DELETE FROM hxc_time_building_blocks

1037:
1038: EXIT WHEN rowid_tab.COUNT = 0;
1039:
1040: FORALL i IN rowid_tab.FIRST..rowid_tab.LAST
1041: DELETE FROM hxc_time_building_blocks
1042: WHERE ROWID = CHARTOROWID(rowid_tab(i));
1043:
1044: l_day_del_count := l_day_del_count + SQL%ROWCOUNT;
1045: rowid_tab.DELETE;

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

1064: day_start_time,
1065: day_stop_time,
1066: ref_rowid,
1067: thread_id )
1068: SELECT /*+ LEADING(TEMP) INDEX(AR HXC_TIME_BUILDING_BLOCKS_FK3) */
1069: time_building_block_id,
1070: object_version_number,
1071: 'DETAIL',
1072: nvl(day_start_time,ar.start_time),

Line 1077: hxc_time_building_blocks ar

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 ;

Line 1084: INSERT INTO hxc_time_building_blocks_ar

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,

Line 1099: hxc_time_building_blocks bkupday

1095: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
1096: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
1097: TRANSLATION_DISPLAY_KEY
1098: FROM hxc_temp_timecard_chunks temp,
1099: hxc_time_building_blocks bkupday
1100: WHERE bkupday.ROWID = CHARTOROWID(temp.ref_rowid)
1101: AND temp.scope = 'DETAIL'
1102: AND thread_id = p_thread_id ;
1103:

Line 1116: DELETE FROM hxc_time_building_blocks

1112:
1113: EXIT WHEN rowid_tab.COUNT = 0;
1114:
1115: FORALL i IN rowid_tab.FIRST..rowid_tab.LAST
1116: DELETE FROM hxc_time_building_blocks
1117: WHERE ROWID = CHARTOROWID(rowid_tab(i));
1118:
1119: l_det_del_count := l_det_del_count + SQL%ROWCOUNT;
1120: rowid_tab.DELETE;