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_TEMP_TIMECARD_CHUNKS

Line 478: FROM hxc_temp_timecard_chunks temp,

474: IS SELECT /*+ LEADING(temp) */
475: transaction_detail_id,
476: transaction_id,
477: ROWIDTOCHAR(ar.ROWID)
478: FROM hxc_temp_timecard_chunks temp,
479: hxc_transaction_details ar
480: WHERE ar.time_building_block_id = temp.id
481: AND ar.time_building_block_ovn = temp.ref_ovn
482: AND thread_id = p_thread_id ;

Line 492: FROM hxc_temp_timecard_chunks temp,

488: IS SELECT /*+ LEADING(temp) */
489: transaction_detail_id,
490: transaction_id,
491: ROWIDTOCHAR(ar.ROWID)
492: FROM hxc_temp_timecard_chunks temp,
493: hxc_dep_transaction_details ar
494: WHERE ar.time_building_block_id = temp.id
495: AND ar.time_building_block_ovn = temp.ref_ovn
496: AND thread_id = p_thread_id ;

Line 505: FROM hxc_temp_timecard_chunks temp,

501: DISTINCT
502: time_attribute_usage_id,
503: time_attribute_id,
504: ROWIDTOCHAR(ar.ROWID)
505: FROM hxc_temp_timecard_chunks temp,
506: hxc_time_attribute_usages ar
507: WHERE ar.time_building_block_id = temp.id
508: AND thread_id = p_thread_id ;
509:

Line 512: FROM hxc_temp_timecard_chunks

508: AND thread_id = p_thread_id ;
509:
510: CURSOR get_tbb_rowid (p_scope VARCHAR2)
511: IS SELECT ref_rowid
512: FROM hxc_temp_timecard_chunks
513: WHERE scope = p_scope
514: AND thread_id = p_thread_id ;
515:
516: CURSOR get_dup_trans

Line 527: FROM hxc_temp_timecard_chunks temp,

523:
524: CURSOR get_latest_details
525: IS SELECT det.time_building_block_id,
526: ROWIDTOCHAR(det.ROWID)
527: FROM hxc_temp_timecard_chunks temp,
528: hxc_latest_details det
529: WHERE temp.scope = 'DETAIL'
530: AND temp.id = det.time_building_block_id ;
531:

Line 536: FROM hxc_temp_timecard_chunks temp

532:
533: CURSOR get_max_ovn
534: IS SELECT id,
535: max(ref_ovn)
536: FROM hxc_temp_timecard_chunks temp
537: WHERE scope = 'DETAIL'
538: AND thread_id = p_thread_id
539: GROUP by id ;
540:

Line 547: FROM hxc_temp_timecard_chunks temp,

543: CURSOR get_sum_hrs
544: IS SELECT DISTINCT
545: sum.id,
546: sum.tim_id
547: FROM hxc_temp_timecard_chunks temp,
548: hxt_sum_hours_worked_f sum
549: WHERE temp.id = sum.time_building_block_id
550: AND temp.thread_id = p_thread_id;
551:

Line 678: -- * Insert the above id-ovn combination into hxc_temp_timecard_chunks table.

674: -- Following are the steps.
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.

Line 681: -- * For the timecard records in hxc_temp_timecard_chunks, pick up all records

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.
685: -- * Delete these records from hxc_tc_ap_links table.

Line 683: -- * Join hxc_temp_timecard_chunks with hxc_tc_ap_links and insert into hxc_tc_ap_links_ar

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

Line 686: -- * For all the application_period records in hxc_temp_timecard_chunks table, select from

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

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 693: -- all DAY records for these timecards, insert them into hxc_temp_timecard_chunks.

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

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 698: -- all DETAIL 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.
702: -- * Loop to process transaction records.

Line 703: -- Pick up transaction detail records for the records in 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.
706: -- Using the rowids, insert the transaction detail records into
707: -- hxc_transaction_details_ar.

Line 718: -- Pick up attribute usage records for the records in hxc_temp_timecard_chunks

714: -- Delete all transaction records from hxc_transactions table, if the transaction
715: -- id is present in hxc_archive_temp.
716: -- Delete from hxc_archive temp for the the next iteration of this loop.
717: -- * Loop to process attribute records.
718: -- Pick up attribute usage records for the records in hxc_temp_timecard_chunks
719: -- as of now. ( usage_id, attribute_id, usage_rowid ), and insert into
720: -- hxc_archive_temp.
721: -- Using the rowids, insert the attribute usage records into
722: -- hxc_attribute_usages_ar.

Line 731: -- * Delete all other scopes except DETAIL from hxc_temp_timecard_chunks.

727: -- insert into hxc_time_attributes_ar table.
728: -- Delete all attribute records from hxc_time_attributes table, if the attribute
729: -- id is present in hxc_archive_temp.
730: -- Delete from hxc_archive temp for the the next iteration of this loop.
731: -- * Delete all other scopes except DETAIL from hxc_temp_timecard_chunks.
732: -- * Select from hxc_ap_detail_links table, the records corresponding to the
733: -- details and insert into hxc_ap_detail_links_ar table.
734: -- * Delete from hxc_ap_detail_links table the above records.
735: -- * Delete from hxc_temp_timecard_chunks all records except the latest ovns.

Line 735: -- * Delete from hxc_temp_timecard_chunks all records except the latest ovns.

731: -- * Delete all other scopes except DETAIL from hxc_temp_timecard_chunks.
732: -- * Select from hxc_ap_detail_links table, the records corresponding to the
733: -- details and insert into hxc_ap_detail_links_ar table.
734: -- * Delete from hxc_ap_detail_links table the above records.
735: -- * Delete from hxc_temp_timecard_chunks all records except the latest ovns.
736: -- * Insert these records into hxc_latest_details.
737: -- * COMMIT and pick up the next chunk.
738: --
739: -- Technical points to look for.

Line 825: INSERT INTO hxc_temp_timecard_chunks

821:
822: BEGIN
823:
824: FORALL i IN tc_id_tab.FIRST..tc_id_tab.LAST
825: INSERT INTO hxc_temp_timecard_chunks
826: ( id,
827: ref_ovn,
828: scope,
829: thread_id )

Line 851: FROM hxc_temp_timecard_chunks temp,

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

Line 894: INSERT INTO hxc_temp_timecard_chunks

890: p_thread_id,
891: l_chunk_no);
892:
893:
894: INSERT INTO hxc_temp_timecard_chunks
895: ( id,
896: scope,
897: ref_rowid,
898: thread_id )

Line 904: FROM hxc_temp_timecard_chunks temp,

900: DISTINCT talbkup.application_period_id,
901: 'APPLICATION_PERIOD',
902: ROWIDTOCHAR(talbkup.ROWID),
903: thread_id
904: FROM hxc_temp_timecard_chunks temp,
905: hxc_tc_ap_links talbkup
906: WHERE temp.id = talbkup.timecard_id
907: AND temp.scope IN ('TIMECARD')
908: AND thread_id = p_thread_id ;

Line 916: FROM hxc_temp_timecard_chunks temp,

912: ( timecard_id,
913: application_period_id)
914: SELECT timecard_id,
915: application_period_id
916: FROM hxc_temp_timecard_chunks temp,
917: hxc_tc_ap_links talbkup
918: WHERE temp.ref_rowid = talbkup.ROWID
919: AND temp.scope = ('APPLICATION_PERIOD')
920: AND thread_id = p_thread_id ;

Line 928: FROM hxc_temp_timecard_chunks

924:
925:
926: DELETE FROM hxc_tc_ap_links
927: WHERE ROWID IN ( SELECT CHARTOROWID(ref_rowid)
928: FROM hxc_temp_timecard_chunks
929: WHERE scope = 'APPLICATION_PERIOD'
930: AND thread_id = p_thread_id );
931:
932: l_tal_del_count := SQL%ROWCOUNT;

Line 962: FROM hxc_temp_timecard_chunks temp

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
964: ('APPLICATION_PERIOD')
965: AND thread_id = p_thread_id ) ;
966:

Line 971: FROM hxc_temp_timecard_chunks

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')
974: AND thread_id = p_thread_id );
975:

Line 1001: FROM hxc_temp_timecard_chunks

997: APPROVER_ID,APPROVAL_COMP_ID,APPROVAL_ITEM_TYPE,APPROVAL_PROCESS_NAME,
998: APPROVAL_ITEM_KEY,p_data_set_id
999: FROM hxc_app_period_summary apsbkup
1000: WHERE application_period_id IN (SELECT id
1001: FROM hxc_temp_timecard_chunks
1002: WHERE scope = 'APPLICATION_PERIOD'
1003: AND thread_id = p_thread_id );
1004:
1005: l_app_period_sum_count := SQL%ROWCOUNT;

Line 1010: FROM hxc_temp_timecard_chunks

1006:
1007:
1008: DELETE FROM hxc_app_period_summary
1009: WHERE application_period_id IN (SELECT id
1010: FROM hxc_temp_timecard_chunks
1011: WHERE scope = 'APPLICATION_PERIOD'
1012: AND thread_id = p_thread_id );
1013:
1014: l_app_sum_del_count := SQL%ROWCOUNT;

Line 1027: INSERT INTO hxc_temp_timecard_chunks

1023: write_data_mismatch('App Period Summary ');
1024: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
1025: END IF;
1026:
1027: INSERT INTO hxc_temp_timecard_chunks
1028: ( id,
1029: ref_ovn,
1030: scope,
1031: ref_rowid,

Line 1043: FROM hxc_temp_timecard_chunks temp,

1039: ROWIDTOCHAR(ar.ROWID),
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'

Line 1065: FROM hxc_temp_timecard_chunks temp,

1061: bkupday.SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
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;

Line 1103: INSERT INTO hxc_temp_timecard_chunks

1099: write_data_mismatch('Day ');
1100: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
1101: END IF;
1102:
1103: INSERT INTO hxc_temp_timecard_chunks
1104: ( id,
1105: ref_ovn,
1106: scope,
1107: day_start_time,

Line 1119: FROM hxc_temp_timecard_chunks temp,

1115: nvl(day_start_time,ar.start_time),
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'

Line 1141: FROM hxc_temp_timecard_chunks temp,

1137: bkupday.SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
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 ;

Line 1614: DELETE FROM hxc_temp_timecard_chunks

1610: write_data_mismatch('Attributes ');
1611: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
1612: END IF;
1613:
1614: DELETE FROM hxc_temp_timecard_chunks
1615: WHERE scope IN ( 'TIMECARD', 'DAY','APPLICATION_PERIOD')
1616: AND thread_id = p_thread_id ;
1617:
1618:

Line 1758: FROM hxc_temp_timecard_chunks temp,

1754: (application_period_id,
1755: time_building_block_id,
1756: time_building_block_ovn)
1757: SELECT application_period_id, time_building_block_id, time_building_block_ovn
1758: FROM hxc_temp_timecard_chunks temp,
1759: hxc_ap_detail_links adlbkup
1760: WHERE temp.id = adlbkup.time_building_block_id
1761: AND temp.ref_ovn = adlbkup.time_building_block_ovn
1762: AND temp.scope = ('DETAIL')

Line 1772: FROM hxc_temp_timecard_chunks

1768: DELETE FROM hxc_ap_detail_links
1769: WHERE (time_building_block_id,time_building_block_ovn)
1770: IN ( SELECT id,
1771: ref_ovn
1772: FROM hxc_temp_timecard_chunks
1773: WHERE scope = 'DETAIL'
1774: AND thread_id = p_thread_id );
1775:
1776: l_adl_del_count := SQL%ROWCOUNT;