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_RESTORE dependencies on HXC_TEMP_TIMECARD_CHUNKS

Line 435: FROM hxc_temp_timecard_chunks temp,

431: IS SELECT /*+ LEADING(temp) */
432: transaction_detail_id,
433: transaction_id,
434: ROWIDTOCHAR(ar.ROWID)
435: FROM hxc_temp_timecard_chunks temp,
436: hxc_transaction_details_ar ar
437: WHERE ar.time_building_block_id = temp.id
438: AND ar.time_building_block_ovn = temp.ref_ovn
439: AND EXISTS ( SELECT 1

Line 454: FROM hxc_temp_timecard_chunks temp,

450: IS SELECT /*+ LEADING(temp) */
451: transaction_detail_id,
452: transaction_id,
453: ROWIDTOCHAR(ar.ROWID)
454: FROM hxc_temp_timecard_chunks temp,
455: hxc_transaction_details_ar ar
456: WHERE ar.time_building_block_id = temp.id
457: AND ar.time_building_block_ovn = temp.ref_ovn
458: AND EXISTS ( SELECT 1

Line 470: FROM hxc_temp_timecard_chunks temp,

466: IS SELECT /*+ LEADING(temp) */
467: transaction_detail_id,
468: transaction_id,
469: ROWIDTOCHAR(ar.ROWID)
470: FROM hxc_temp_timecard_chunks temp,
471: hxc_dep_txn_details_ar ar
472: WHERE ar.time_building_block_id = temp.id
473: AND ar.time_building_block_ovn = temp.ref_ovn
474: 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 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 507: FROM hxc_temp_timecard_chunks temp,

503: IS SELECT /*+ LEADING(temp) */
504: id,
505: ref_ovn,
506: ROWIDTOCHAR(temp.ROWID)
507: FROM hxc_temp_timecard_chunks temp,
508: hxc_latest_details det
509: WHERE temp.scope = 'DETAIL'
510: AND temp.id = det.time_building_block_id
511: AND thread_id = p_thread_id ;

Line 516: FROM hxc_temp_timecard_chunks temp

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

Line 528: FROM hxc_temp_timecard_chunks temp,

524: id,
525: ref_ovn,
526: attribute1,
527: attribute2
528: FROM hxc_temp_timecard_chunks temp,
529: hxc_time_attribute_usages hau,
530: hxc_time_attributes hta
531: WHERE thread_id = p_thread_id
532: AND temp.id = hau.time_building_block_id

Line 545: FROM hxc_temp_timecard_chunks temp,

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

Line 725: INSERT INTO hxc_temp_timecard_chunks

721: LOOP
722: iloop := 0;
723: BEGIN
724: FORALL i IN tc_id_tab.FIRST..tc_id_tab.LAST
725: INSERT INTO hxc_temp_timecard_chunks
726: ( id,
727: ref_ovn,
728: scope,
729: thread_id )

Line 752: FROM hxc_temp_timecard_chunks temp,

748: bkup.SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
749: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
750: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
751: TRANSLATION_DISPLAY_KEY
752: FROM hxc_temp_timecard_chunks temp,
753: hxc_time_building_blocks_ar bkup
754: WHERE bkup.scope = 'TIMECARD'
755: AND bkup.time_building_block_id = temp.id
756: AND bkup.object_version_number = temp.ref_ovn

Line 799: INSERT INTO hxc_temp_timecard_chunks

795: 'RESTORE',
796: p_thread_id,
797: l_chunk_no);
798:
799: INSERT INTO hxc_temp_timecard_chunks
800: ( id,
801: scope,
802: ref_rowid,
803: thread_id )

Line 810: FROM hxc_temp_timecard_chunks temp,

806: talbkup.application_period_id,
807: 'APPLICATION_PERIOD',
808: ROWIDTOCHAR(talbkup.ROWID),
809: thread_id
810: FROM hxc_temp_timecard_chunks temp,
811: hxc_tc_ap_links_ar talbkup
812: WHERE temp.id = talbkup.timecard_id
813: AND temp.scope IN ('TIMECARD')
814: AND thread_id = p_thread_id ;

Line 822: FROM hxc_temp_timecard_chunks temp,

818: ( timecard_id,
819: application_period_id)
820: SELECT timecard_id,
821: application_period_id
822: FROM hxc_temp_timecard_chunks temp,
823: hxc_tc_ap_links_ar talbkup
824: WHERE temp.ref_rowid = talbkup.ROWID
825: AND temp.scope = ('APPLICATION_PERIOD')
826: AND thread_id = p_thread_id ;

Line 833: FROM hxc_temp_timecard_chunks

829: l_tal_count := SQL%ROWCOUNT;
830:
831: DELETE FROM hxc_tc_ap_links_ar
832: WHERE ROWID IN ( SELECT CHARTOROWID(ref_rowid)
833: FROM hxc_temp_timecard_chunks
834: WHERE scope = 'APPLICATION_PERIOD'
835: AND thread_id = p_thread_id );
836:
837: l_tal_del_count := SQL%ROWCOUNT;

Line 869: FROM hxc_temp_timecard_chunks temp

865: FROM hxc_time_building_blocks_ar appbkup
866: WHERE appbkup.scope = 'APPLICATION_PERIOD'
867: AND appbkup.data_set_id = p_data_set_id
868: AND appbkup.time_building_block_id IN ( SELECT id
869: FROM hxc_temp_timecard_chunks temp
870: WHERE temp.scope IN
871: ('APPLICATION_PERIOD')
872: AND thread_id = p_thread_id ) ;
873:

Line 879: FROM hxc_temp_timecard_chunks

875: l_app_period_count := SQL%ROWCOUNT;
876:
877: DELETE FROM hxc_time_building_blocks_ar
878: WHERE time_building_block_id IN ( SELECT id
879: FROM hxc_temp_timecard_chunks
880: WHERE scope IN
881: ('APPLICATION_PERIOD')
882: AND thread_id = p_thread_id )
883: AND data_set_id = p_data_set_id ;

Line 911: FROM hxc_temp_timecard_chunks

907: APPROVER_ID,APPROVAL_COMP_ID,APPROVAL_ITEM_TYPE,APPROVAL_PROCESS_NAME,
908: APPROVAL_ITEM_KEY,apsbkup.DATA_SET_ID
909: FROM hxc_app_period_summary_ar apsbkup
910: WHERE application_period_id IN (SELECT id
911: FROM hxc_temp_timecard_chunks
912: WHERE scope = 'APPLICATION_PERIOD'
913: AND thread_id = p_thread_id )
914: AND data_set_id = p_data_set_id ;
915:

Line 921: FROM hxc_temp_timecard_chunks

917:
918:
919: DELETE FROM hxc_app_period_summary_ar
920: WHERE application_period_id IN (SELECT id
921: FROM hxc_temp_timecard_chunks
922: WHERE scope = 'APPLICATION_PERIOD'
923: AND thread_id = p_thread_id )
924: AND data_set_id = p_data_set_id ;
925:

Line 939: INSERT INTO hxc_temp_timecard_chunks

935: write_data_mismatch('App Period Summary ');
936: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
937: END IF;
938:
939: INSERT INTO hxc_temp_timecard_chunks
940: ( id,
941: ref_ovn,
942: scope,
943: ref_rowid,

Line 955: FROM hxc_temp_timecard_chunks temp,

951: ROWIDTOCHAR(ar.ROWID),
952: ar.start_time,
953: ar.stop_time,
954: thread_id
955: FROM hxc_temp_timecard_chunks temp,
956: hxc_time_building_blocks_ar ar
957: WHERE parent_building_block_id = temp.id
958: AND parent_building_block_ovn = temp.ref_ovn
959: AND temp.scope = 'TIMECARD'

Line 978: FROM hxc_temp_timecard_chunks temp,

974: bkupday.SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
975: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
976: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
977: TRANSLATION_DISPLAY_KEY
978: FROM hxc_temp_timecard_chunks temp,
979: hxc_time_building_blocks_ar bkupday
980: WHERE bkupday.ROWID = CHARTOROWID(temp.ref_rowid)
981: AND temp.scope = 'DAY'
982: AND thread_id = p_thread_id

Line 1020: INSERT INTO hxc_temp_timecard_chunks

1016: write_data_mismatch('Day ');
1017: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
1018: END IF;
1019:
1020: INSERT INTO hxc_temp_timecard_chunks
1021: ( id,
1022: ref_ovn,
1023: scope,
1024: day_start_time,

Line 1036: FROM hxc_temp_timecard_chunks temp,

1032: nvl(day_start_time,ar.start_time),
1033: nvl(day_stop_time,ar.stop_time),
1034: ROWIDTOCHAR(ar.ROWID),
1035: thread_id
1036: FROM hxc_temp_timecard_chunks temp,
1037: hxc_time_building_blocks_ar ar
1038: WHERE parent_building_block_id = temp.id
1039: AND parent_building_block_ovn = temp.ref_ovn
1040: AND temp.scope = 'DAY'

Line 1059: FROM hxc_temp_timecard_chunks temp,

1055: bkupday.SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
1056: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
1057: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
1058: TRANSLATION_DISPLAY_KEY
1059: FROM hxc_temp_timecard_chunks temp,
1060: hxc_time_building_blocks_ar bkupday
1061: WHERE bkupday.ROWID = CHARTOROWID(temp.ref_rowid)
1062: AND temp.scope = 'DETAIL'
1063: AND thread_id = p_thread_id

Line 1660: DELETE FROM hxc_temp_timecard_chunks

1656: write_data_mismatch('Attributes ');
1657: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
1658: END IF;
1659:
1660: DELETE FROM hxc_temp_timecard_chunks
1661: WHERE scope IN ( 'TIMECARD', 'DAY','APPLICATION_PERIOD')
1662: AND thread_id = p_thread_id ;
1663:
1664: -- Bug 9790410

Line 1801: FROM hxc_temp_timecard_chunks temp,

1797: time_building_block_id,
1798: time_building_block_ovn)
1799: SELECT /*+ INDEX( adlbkup HXC_AP_DETAIL_LINKS_AR_FK1) */
1800: application_period_id, time_building_block_id, time_building_block_ovn
1801: FROM hxc_temp_timecard_chunks temp,
1802: hxc_ap_detail_links_ar adlbkup
1803: WHERE temp.id = adlbkup.time_building_block_id
1804: AND temp.ref_ovn = adlbkup.time_building_block_ovn
1805: AND temp.scope = ('DETAIL')

Line 1815: FROM hxc_temp_timecard_chunks

1811: DELETE FROM hxc_ap_detail_links_ar
1812: WHERE (time_building_block_id,time_building_block_ovn)
1813: IN ( SELECT id,
1814: ref_ovn
1815: FROM hxc_temp_timecard_chunks
1816: WHERE scope = 'DETAIL'
1817: AND thread_id = p_thread_id );
1818: l_adl_del_count := SQL%ROWCOUNT;
1819:

Line 1840: DELETE FROM hxc_temp_timecard_chunks

1836: latest_rowid_tab LIMIT 500;
1837: EXIT WHEN latest_id_tab.COUNT = 0;
1838:
1839: FORALL i IN latest_id_Tab.FIRST..latest_id_Tab.last
1840: DELETE FROM hxc_temp_timecard_chunks
1841: WHERE ROWID = CHARTOROWID(latest_rowid_tab(i))
1842: AND thread_id = p_thread_id ;
1843:
1844: latest_rowid_tab.DELETE;

Line 1858: DELETE FROM hxc_temp_timecard_chunks

1854: latest_ovn_tab
1855: LIMIT 500;
1856: EXIT WHEN latest_id_tab.count = 0;
1857: FORALL i IN latest_id_tab.first..latest_id_tab.last
1858: DELETE FROM hxc_temp_timecard_chunks
1859: WHERE id = latest_id_tab(i)
1860: AND ref_ovn <> latest_ovn_tab(i)
1861: AND thread_id = p_thread_id ;
1862:

Line 1893: FROM hxc_temp_timecard_chunks temp,

1889: resource_type,
1890: comment_text,
1891: day_start_time,
1892: day_stop_time
1893: FROM hxc_temp_timecard_chunks temp,
1894: hxc_time_building_blocks hxc
1895: WHERE temp.id = hxc.time_building_block_id
1896: AND temp.ref_ovn = hxc.object_version_number
1897: AND temp.scope = 'DETAIL'