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 471: FROM hxc_temp_timecard_chunks temp,

467: IS SELECT /*+ LEADING(temp) */
468: transaction_detail_id,
469: transaction_id,
470: ROWIDTOCHAR(ar.ROWID)
471: FROM hxc_temp_timecard_chunks temp,
472: hxc_transaction_details ar
473: WHERE ar.time_building_block_id = temp.id
474: AND ar.time_building_block_ovn = temp.ref_ovn
475: AND thread_id = p_thread_id ;

Line 484: FROM hxc_temp_timecard_chunks temp,

480: DISTINCT
481: time_attribute_usage_id,
482: time_attribute_id,
483: ROWIDTOCHAR(ar.ROWID)
484: FROM hxc_temp_timecard_chunks temp,
485: hxc_time_attribute_usages ar
486: WHERE ar.time_building_block_id = temp.id
487: AND thread_id = p_thread_id ;
488:

Line 491: FROM hxc_temp_timecard_chunks

487: AND thread_id = p_thread_id ;
488:
489: CURSOR get_tbb_rowid (p_scope VARCHAR2)
490: IS SELECT ref_rowid
491: FROM hxc_temp_timecard_chunks
492: WHERE scope = p_scope
493: AND thread_id = p_thread_id ;
494:
495: CURSOR get_dup_trans

Line 506: FROM hxc_temp_timecard_chunks temp,

502:
503: CURSOR get_latest_details
504: IS SELECT det.time_building_block_id,
505: ROWIDTOCHAR(det.ROWID)
506: FROM hxc_temp_timecard_chunks temp,
507: hxc_latest_details det
508: WHERE temp.scope = 'DETAIL'
509: AND temp.id = det.time_building_block_id ;
510:

Line 515: FROM hxc_temp_timecard_chunks temp

511:
512: CURSOR get_max_ovn
513: IS SELECT id,
514: max(ref_ovn)
515: FROM hxc_temp_timecard_chunks temp
516: WHERE scope = 'DETAIL'
517: AND thread_id = p_thread_id
518: GROUP by id ;
519:

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

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

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

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

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

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

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

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

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

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

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

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

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

671: -- Delete all transaction records from hxc_transactions table, if the transaction
672: -- id is present in hxc_archive_temp.
673: -- Delete from hxc_archive temp for the the next iteration of this loop.
674: -- * Loop to process attribute records.
675: -- Pick up attribute usage records for the records in hxc_temp_timecard_chunks
676: -- as of now. ( usage_id, attribute_id, usage_rowid ), and insert into
677: -- hxc_archive_temp.
678: -- Using the rowids, insert the attribute usage records into
679: -- hxc_attribute_usages_ar.

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

684: -- insert into hxc_time_attributes_ar table.
685: -- Delete all attribute records from hxc_time_attributes table, if the attribute
686: -- id is present in hxc_archive_temp.
687: -- Delete from hxc_archive temp for the the next iteration of this loop.
688: -- * Delete all other scopes except DETAIL from hxc_temp_timecard_chunks.
689: -- * Select from hxc_ap_detail_links table, the records corresponding to the
690: -- details and insert into hxc_ap_detail_links_ar table.
691: -- * Delete from hxc_ap_detail_links table the above records.
692: -- * Delete from hxc_temp_timecard_chunks all records except the latest ovns.

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

688: -- * Delete all other scopes except DETAIL from hxc_temp_timecard_chunks.
689: -- * Select from hxc_ap_detail_links table, the records corresponding to the
690: -- details and insert into hxc_ap_detail_links_ar table.
691: -- * Delete from hxc_ap_detail_links table the above records.
692: -- * Delete from hxc_temp_timecard_chunks all records except the latest ovns.
693: -- * Insert these records into hxc_latest_details.
694: -- * COMMIT and pick up the next chunk.
695: --
696: -- Technical points to look for.

Line 782: INSERT INTO hxc_temp_timecard_chunks

778:
779: BEGIN
780:
781: FORALL i IN tc_id_tab.FIRST..tc_id_tab.LAST
782: INSERT INTO hxc_temp_timecard_chunks
783: ( id,
784: ref_ovn,
785: scope,
786: thread_id )

Line 808: FROM hxc_temp_timecard_chunks temp,

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

Line 851: INSERT INTO hxc_temp_timecard_chunks

847: p_thread_id,
848: l_chunk_no);
849:
850:
851: INSERT INTO hxc_temp_timecard_chunks
852: ( id,
853: scope,
854: ref_rowid,
855: thread_id )

Line 861: FROM hxc_temp_timecard_chunks temp,

857: DISTINCT talbkup.application_period_id,
858: 'APPLICATION_PERIOD',
859: ROWIDTOCHAR(talbkup.ROWID),
860: thread_id
861: FROM hxc_temp_timecard_chunks temp,
862: hxc_tc_ap_links talbkup
863: WHERE temp.id = talbkup.timecard_id
864: AND temp.scope IN ('TIMECARD')
865: AND thread_id = p_thread_id ;

Line 873: FROM hxc_temp_timecard_chunks temp,

869: ( timecard_id,
870: application_period_id)
871: SELECT timecard_id,
872: application_period_id
873: FROM hxc_temp_timecard_chunks temp,
874: hxc_tc_ap_links talbkup
875: WHERE temp.ref_rowid = talbkup.ROWID
876: AND temp.scope = ('APPLICATION_PERIOD')
877: AND thread_id = p_thread_id ;

Line 885: FROM hxc_temp_timecard_chunks

881:
882:
883: DELETE FROM hxc_tc_ap_links
884: WHERE ROWID IN ( SELECT CHARTOROWID(ref_rowid)
885: FROM hxc_temp_timecard_chunks
886: WHERE scope = 'APPLICATION_PERIOD'
887: AND thread_id = p_thread_id );
888:
889: l_tal_del_count := SQL%ROWCOUNT;

Line 919: FROM hxc_temp_timecard_chunks temp

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
921: ('APPLICATION_PERIOD')
922: AND thread_id = p_thread_id ) ;
923:

Line 928: FROM hxc_temp_timecard_chunks

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

Line 958: FROM hxc_temp_timecard_chunks

954: APPROVER_ID,APPROVAL_COMP_ID,APPROVAL_ITEM_TYPE,APPROVAL_PROCESS_NAME,
955: APPROVAL_ITEM_KEY,p_data_set_id
956: FROM hxc_app_period_summary apsbkup
957: WHERE application_period_id IN (SELECT id
958: FROM hxc_temp_timecard_chunks
959: WHERE scope = 'APPLICATION_PERIOD'
960: AND thread_id = p_thread_id );
961:
962: l_app_period_sum_count := SQL%ROWCOUNT;

Line 967: FROM hxc_temp_timecard_chunks

963:
964:
965: DELETE FROM hxc_app_period_summary
966: WHERE application_period_id IN (SELECT id
967: FROM hxc_temp_timecard_chunks
968: WHERE scope = 'APPLICATION_PERIOD'
969: AND thread_id = p_thread_id );
970:
971: l_app_sum_del_count := SQL%ROWCOUNT;

Line 984: INSERT INTO hxc_temp_timecard_chunks

980: write_data_mismatch('App Period Summary ');
981: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
982: END IF;
983:
984: INSERT INTO hxc_temp_timecard_chunks
985: ( id,
986: ref_ovn,
987: scope,
988: ref_rowid,

Line 1000: FROM hxc_temp_timecard_chunks temp,

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

Line 1022: FROM hxc_temp_timecard_chunks temp,

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

Line 1060: INSERT INTO hxc_temp_timecard_chunks

1056: write_data_mismatch('Day ');
1057: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
1058: END IF;
1059:
1060: INSERT INTO hxc_temp_timecard_chunks
1061: ( id,
1062: ref_ovn,
1063: scope,
1064: day_start_time,

Line 1076: FROM hxc_temp_timecard_chunks temp,

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

Line 1098: FROM hxc_temp_timecard_chunks temp,

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

Line 1399: DELETE FROM hxc_temp_timecard_chunks

1395: write_data_mismatch('Attributes ');
1396: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
1397: END IF;
1398:
1399: DELETE FROM hxc_temp_timecard_chunks
1400: WHERE scope IN ( 'TIMECARD', 'DAY','APPLICATION_PERIOD')
1401: AND thread_id = p_thread_id ;
1402:
1403:

Line 1409: FROM hxc_temp_timecard_chunks temp,

1405: (application_period_id,
1406: time_building_block_id,
1407: time_building_block_ovn)
1408: SELECT application_period_id, time_building_block_id, time_building_block_ovn
1409: FROM hxc_temp_timecard_chunks temp,
1410: hxc_ap_detail_links adlbkup
1411: WHERE temp.id = adlbkup.time_building_block_id
1412: AND temp.ref_ovn = adlbkup.time_building_block_ovn
1413: AND temp.scope = ('DETAIL')

Line 1423: FROM hxc_temp_timecard_chunks

1419: DELETE FROM hxc_ap_detail_links
1420: WHERE (time_building_block_id,time_building_block_ovn)
1421: IN ( SELECT id,
1422: ref_ovn
1423: FROM hxc_temp_timecard_chunks
1424: WHERE scope = 'DETAIL'
1425: AND thread_id = p_thread_id );
1426:
1427: l_adl_del_count := SQL%ROWCOUNT;