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.

[Home] [Help]

APPS.HXC_RESTORE dependencies on HXC_TEMP_TIMECARD_CHUNKS

Line 424: FROM hxc_temp_timecard_chunks temp,

420: IS SELECT /*+ LEADING(temp) */
421: transaction_detail_id,
422: transaction_id,
423: ROWIDTOCHAR(ar.ROWID)
424: FROM hxc_temp_timecard_chunks temp,
425: hxc_transaction_details_ar ar
426: WHERE ar.time_building_block_id = temp.id
427: AND ar.time_building_block_ovn = temp.ref_ovn
428: AND thread_id = p_thread_id ;

Line 437: FROM hxc_temp_timecard_chunks temp,

433: DISTINCT
434: time_attribute_usage_id,
435: time_attribute_id,
436: ROWIDTOCHAR(ar.ROWID)
437: FROM hxc_temp_timecard_chunks temp,
438: hxc_time_attribute_usages_ar ar
439: WHERE ar.time_building_block_id = temp.id
440: AND thread_id = p_thread_id ;
441:

Line 444: FROM hxc_temp_timecard_chunks

440: AND thread_id = p_thread_id ;
441:
442: CURSOR get_tbb_rowid (p_scope VARCHAR2)
443: IS SELECT ref_rowid
444: FROM hxc_temp_timecard_chunks
445: WHERE scope = p_scope
446: AND thread_id = p_thread_id ;
447:
448: CURSOR get_dup_trans

Line 460: FROM hxc_temp_timecard_chunks temp,

456: IS SELECT /*+ LEADING(temp) */
457: id,
458: ref_ovn,
459: ROWIDTOCHAR(temp.ROWID)
460: FROM hxc_temp_timecard_chunks temp,
461: hxc_latest_details det
462: WHERE temp.scope = 'DETAIL'
463: AND temp.id = det.time_building_block_id
464: AND thread_id = p_thread_id ;

Line 469: FROM hxc_temp_timecard_chunks temp

465:
466: CURSOR get_max_ovn
467: IS SELECT id,
468: MAX(ref_ovn)
469: FROM hxc_temp_timecard_chunks temp
470: WHERE scope = 'DETAIL'
471: AND thread_id = p_thread_id
472: GROUP by id ;
473:

Line 630: INSERT INTO hxc_temp_timecard_chunks

626: LOOP
627: iloop := 0;
628: BEGIN
629: FORALL i IN tc_id_tab.FIRST..tc_id_tab.LAST
630: INSERT INTO hxc_temp_timecard_chunks
631: ( id,
632: ref_ovn,
633: scope,
634: thread_id )

Line 657: FROM hxc_temp_timecard_chunks temp,

653: bkup.SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
654: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
655: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
656: TRANSLATION_DISPLAY_KEY
657: FROM hxc_temp_timecard_chunks temp,
658: hxc_time_building_blocks_ar bkup
659: WHERE bkup.scope = 'TIMECARD'
660: AND bkup.time_building_block_id = temp.id
661: AND bkup.object_version_number = temp.ref_ovn

Line 704: INSERT INTO hxc_temp_timecard_chunks

700: 'RESTORE',
701: p_thread_id,
702: l_chunk_no);
703:
704: INSERT INTO hxc_temp_timecard_chunks
705: ( id,
706: scope,
707: ref_rowid,
708: thread_id )

Line 715: FROM hxc_temp_timecard_chunks temp,

711: talbkup.application_period_id,
712: 'APPLICATION_PERIOD',
713: ROWIDTOCHAR(talbkup.ROWID),
714: thread_id
715: FROM hxc_temp_timecard_chunks temp,
716: hxc_tc_ap_links_ar talbkup
717: WHERE temp.id = talbkup.timecard_id
718: AND temp.scope IN ('TIMECARD')
719: AND thread_id = p_thread_id ;

Line 727: FROM hxc_temp_timecard_chunks temp,

723: ( timecard_id,
724: application_period_id)
725: SELECT timecard_id,
726: application_period_id
727: FROM hxc_temp_timecard_chunks temp,
728: hxc_tc_ap_links_ar talbkup
729: WHERE temp.ref_rowid = talbkup.ROWID
730: AND temp.scope = ('APPLICATION_PERIOD')
731: AND thread_id = p_thread_id ;

Line 738: FROM hxc_temp_timecard_chunks

734: l_tal_count := SQL%ROWCOUNT;
735:
736: DELETE FROM hxc_tc_ap_links_ar
737: WHERE ROWID IN ( SELECT CHARTOROWID(ref_rowid)
738: FROM hxc_temp_timecard_chunks
739: WHERE scope = 'APPLICATION_PERIOD'
740: AND thread_id = p_thread_id );
741:
742: l_tal_del_count := SQL%ROWCOUNT;

Line 774: FROM hxc_temp_timecard_chunks temp

770: FROM hxc_time_building_blocks_ar appbkup
771: WHERE appbkup.scope = 'APPLICATION_PERIOD'
772: AND appbkup.data_set_id = p_data_set_id
773: AND appbkup.time_building_block_id IN ( SELECT id
774: FROM hxc_temp_timecard_chunks temp
775: WHERE temp.scope IN
776: ('APPLICATION_PERIOD')
777: AND thread_id = p_thread_id ) ;
778:

Line 784: FROM hxc_temp_timecard_chunks

780: l_app_period_count := SQL%ROWCOUNT;
781:
782: DELETE FROM hxc_time_building_blocks_ar
783: WHERE time_building_block_id IN ( SELECT id
784: FROM hxc_temp_timecard_chunks
785: WHERE scope IN
786: ('APPLICATION_PERIOD')
787: AND thread_id = p_thread_id )
788: AND data_set_id = p_data_set_id ;

Line 816: FROM hxc_temp_timecard_chunks

812: APPROVER_ID,APPROVAL_COMP_ID,APPROVAL_ITEM_TYPE,APPROVAL_PROCESS_NAME,
813: APPROVAL_ITEM_KEY,apsbkup.DATA_SET_ID
814: FROM hxc_app_period_summary_ar apsbkup
815: WHERE application_period_id IN (SELECT id
816: FROM hxc_temp_timecard_chunks
817: WHERE scope = 'APPLICATION_PERIOD'
818: AND thread_id = p_thread_id )
819: AND data_set_id = p_data_set_id ;
820:

Line 826: FROM hxc_temp_timecard_chunks

822:
823:
824: DELETE FROM hxc_app_period_summary_ar
825: WHERE application_period_id IN (SELECT id
826: FROM hxc_temp_timecard_chunks
827: WHERE scope = 'APPLICATION_PERIOD'
828: AND thread_id = p_thread_id )
829: AND data_set_id = p_data_set_id ;
830:

Line 844: INSERT INTO hxc_temp_timecard_chunks

840: write_data_mismatch('App Period Summary ');
841: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
842: END IF;
843:
844: INSERT INTO hxc_temp_timecard_chunks
845: ( id,
846: ref_ovn,
847: scope,
848: ref_rowid,

Line 860: FROM hxc_temp_timecard_chunks temp,

856: ROWIDTOCHAR(ar.ROWID),
857: ar.start_time,
858: ar.stop_time,
859: thread_id
860: FROM hxc_temp_timecard_chunks temp,
861: hxc_time_building_blocks_ar ar
862: WHERE parent_building_block_id = temp.id
863: AND parent_building_block_ovn = temp.ref_ovn
864: AND temp.scope = 'TIMECARD'

Line 883: FROM hxc_temp_timecard_chunks temp,

879: bkupday.SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
880: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
881: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
882: TRANSLATION_DISPLAY_KEY
883: FROM hxc_temp_timecard_chunks temp,
884: hxc_time_building_blocks_ar bkupday
885: WHERE bkupday.ROWID = CHARTOROWID(temp.ref_rowid)
886: AND temp.scope = 'DAY'
887: AND thread_id = p_thread_id

Line 925: INSERT INTO hxc_temp_timecard_chunks

921: write_data_mismatch('Day ');
922: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
923: END IF;
924:
925: INSERT INTO hxc_temp_timecard_chunks
926: ( id,
927: ref_ovn,
928: scope,
929: day_start_time,

Line 941: FROM hxc_temp_timecard_chunks temp,

937: nvl(day_start_time,ar.start_time),
938: nvl(day_stop_time,ar.stop_time),
939: ROWIDTOCHAR(ar.ROWID),
940: thread_id
941: FROM hxc_temp_timecard_chunks temp,
942: hxc_time_building_blocks_ar ar
943: WHERE parent_building_block_id = temp.id
944: AND parent_building_block_ovn = temp.ref_ovn
945: AND temp.scope = 'DAY'

Line 964: FROM hxc_temp_timecard_chunks temp,

960: bkupday.SCOPE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
961: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,APPROVAL_STATUS,RESOURCE_ID,RESOURCE_TYPE,
962: APPROVAL_STYLE_ID,DATE_FROM,DATE_TO,COMMENT_TEXT,PARENT_BUILDING_BLOCK_OVN,APPLICATION_SET_ID,
963: TRANSLATION_DISPLAY_KEY
964: FROM hxc_temp_timecard_chunks temp,
965: hxc_time_building_blocks_ar bkupday
966: WHERE bkupday.ROWID = CHARTOROWID(temp.ref_rowid)
967: AND temp.scope = 'DETAIL'
968: AND thread_id = p_thread_id

Line 1291: DELETE FROM hxc_temp_timecard_chunks

1287: write_data_mismatch('Attributes ');
1288: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
1289: END IF;
1290:
1291: DELETE FROM hxc_temp_timecard_chunks
1292: WHERE scope IN ( 'TIMECARD', 'DAY','APPLICATION_PERIOD')
1293: AND thread_id = p_thread_id ;
1294:
1295:

Line 1302: FROM hxc_temp_timecard_chunks temp,

1298: time_building_block_id,
1299: time_building_block_ovn)
1300: SELECT /*+ INDEX( adlbkup HXC_AP_DETAIL_LINKS_AR_FK1) */
1301: application_period_id, time_building_block_id, time_building_block_ovn
1302: FROM hxc_temp_timecard_chunks temp,
1303: hxc_ap_detail_links_ar adlbkup
1304: WHERE temp.id = adlbkup.time_building_block_id
1305: AND temp.ref_ovn = adlbkup.time_building_block_ovn
1306: AND temp.scope = ('DETAIL')

Line 1316: FROM hxc_temp_timecard_chunks

1312: DELETE FROM hxc_ap_detail_links_ar
1313: WHERE (time_building_block_id,time_building_block_ovn)
1314: IN ( SELECT id,
1315: ref_ovn
1316: FROM hxc_temp_timecard_chunks
1317: WHERE scope = 'DETAIL'
1318: AND thread_id = p_thread_id );
1319: l_adl_del_count := SQL%ROWCOUNT;
1320:

Line 1341: DELETE FROM hxc_temp_timecard_chunks

1337: latest_rowid_tab LIMIT 500;
1338: EXIT WHEN latest_id_tab.COUNT = 0;
1339:
1340: FORALL i IN latest_id_Tab.FIRST..latest_id_Tab.last
1341: DELETE FROM hxc_temp_timecard_chunks
1342: WHERE ROWID = CHARTOROWID(latest_rowid_tab(i))
1343: AND thread_id = p_thread_id ;
1344:
1345: latest_rowid_tab.DELETE;

Line 1359: DELETE FROM hxc_temp_timecard_chunks

1355: latest_ovn_tab
1356: LIMIT 500;
1357: EXIT WHEN latest_id_tab.count = 0;
1358: FORALL i IN latest_id_tab.first..latest_id_tab.last
1359: DELETE FROM hxc_temp_timecard_chunks
1360: WHERE id = latest_id_tab(i)
1361: AND ref_ovn <> latest_ovn_tab(i)
1362: AND thread_id = p_thread_id ;
1363:

Line 1394: FROM hxc_temp_timecard_chunks temp,

1390: resource_type,
1391: comment_text,
1392: day_start_time,
1393: day_stop_time
1394: FROM hxc_temp_timecard_chunks temp,
1395: hxc_time_building_blocks hxc
1396: WHERE temp.id = hxc.time_building_block_id
1397: AND temp.ref_ovn = hxc.object_version_number
1398: AND temp.scope = 'DETAIL'