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.HXT_RETRIEVAL_ROLLBACK dependencies on HXT_DET_HOURS_WORKED

Line 523: FROM hxt_det_hours_worked_f

519: IS
520:
521: CURSOR get_retro_details
522: IS SELECT DISTINCT retro_batch_id
523: FROM hxt_det_hours_worked_f
524: WHERE tim_id = p_tim_id
525: AND retro_batch_id IS NOT NULL
526: AND rollback_status IS NULL;
527:

Line 655: from hxt_det_hours_worked_f

651: retro_pbl_line_id,
652: retro_batch_id,
653: retro_batch_id_2,
654: retro_pbl_line_id_2
655: from hxt_det_hours_worked_f
656: WHERE id IN ';
657:
658: l_order_by VARCHAR2(150) :=
659: ' ORDER BY effective_end_date,id,date_worked, parent_id ';

Line 864: FROM hxt_det_hours_worked_f

860: IS
861:
862: CURSOR get_tim_id
863: IS SELECT tim_id
864: FROM hxt_det_hours_worked_f
865: WHERE retro_batch_id = p_batch_id;
866:
867: CURSOR get_details_adjusted(p_tim_id IN NUMBER,
868: p_batch_id IN NUMBER)

Line 870: FROM hxt_det_hours_worked_f

866:
867: CURSOR get_details_adjusted(p_tim_id IN NUMBER,
868: p_batch_id IN NUMBER)
869: IS SELECT id
870: FROM hxt_det_hours_worked_f
871: WHERE tim_id = p_tim_id
872: AND retro_batch_id_2 = p_batch_id
873: AND pay_status IN ('A','D');
874:

Line 878: FROM hxt_det_hours_worked_f det,

874:
875: CURSOR get_details_backed_out(p_tim_id IN NUMBER,
876: p_batch_id IN NUMBER)
877: IS SELECT id
878: FROM hxt_det_hours_worked_f det,
879: pay_batch_lines pbl
880: WHERE tim_id = p_tim_id
881: AND pbl.batch_id = p_batch_id
882: AND pbl.batch_line_id = retro_pbl_line_id

Line 888: FROM hxt_det_hours_worked_f

884:
885: CURSOR get_new_details(p_tim_id IN NUMBER,
886: p_batch_id IN NUMBER)
887: IS SELECT id
888: FROM hxt_det_hours_worked_f
889: WHERE tim_id = p_tim_id
890: AND retro_batch_id = p_batch_id
891: AND pay_status = 'C' ;
892:

Line 966: from hxt_det_hours_worked_f

962: retro_pbl_line_id,
963: retro_batch_id,
964: retro_batch_id_2,
965: retro_pbl_line_id_2
966: from hxt_det_hours_worked_f
967: WHERE tim_id =:1
968: ORDER BY effective_end_date,id,date_worked, parent_id ';
969:
970:

Line 1162: FROM hxt_det_hours_worked_f

1158: IS
1159:
1160: CURSOR get_tim_id
1161: IS SELECT tim_id
1162: FROM hxt_det_hours_worked_f
1163: WHERE retro_batch_id = p_batch_id;
1164:
1165: CURSOR get_details_adjusted(p_tim_id IN NUMBER,
1166: p_batch_id IN NUMBER)

Line 1168: FROM hxt_det_hours_worked_f

1164:
1165: CURSOR get_details_adjusted(p_tim_id IN NUMBER,
1166: p_batch_id IN NUMBER)
1167: IS SELECT id
1168: FROM hxt_det_hours_worked_f
1169: WHERE tim_id = p_tim_id
1170: AND retro_batch_id = p_batch_id
1171: AND pay_status = 'R';
1172:

Line 1176: FROM hxt_det_hours_worked_f

1172:
1173:
1174: CURSOR get_old_details(p_tim_id IN NUMBER)
1175: IS SELECT id
1176: FROM hxt_det_hours_worked_f
1177: WHERE tim_id = p_tim_id
1178: AND pay_status = 'C' ;
1179:
1180:

Line 1939: hxt_det_hours_worked_f det

1935: CURSOR check_retro_batches(p_batch_id IN NUMBER)
1936: IS SELECT retro_batch_id,
1937: tim_id
1938: FROM hxt_timecards_f tim,
1939: hxt_det_hours_worked_f det
1940: WHERE tim.batch_id = p_batch_id
1941: AND tim.id = det.tim_id;
1942:
1943:

Line 1963: hxt_det_hours_worked_f det

1959: p_batch_id IN NUMBER)
1960: IS SELECT retro_batch_id,
1961: tim_id
1962: FROM hxt_timecards_f tim,
1963: hxt_det_hours_worked_f det
1964: WHERE tim.batch_id = p_batch_id
1965: AND tim.id = det.tim_id
1966: AND tim.for_person_id = p_person_id;
1967:

Line 2001: hxt_det_hours_worked_f det,

1997: ret2.request_id,
1998: rank() over ( partition by ret.time_building_block_id,ret.object_version_number
1999: ORDER by ret.ROWID) rank
2000: FROM hxt_sum_hours_worked_f sum,
2001: hxt_det_hours_worked_f det,
2002: hxc_ret_pay_latest_details ret,
2003: hxc_ret_pay_details ret2,
2004: FND_sessions sess,
2005: pay_batch_lines pbl

Line 2025: FROM hxt_det_hours_worked_f det,

2021: CURSOR get_details_not_in_ss(p_tim_id IN NUMBER)
2022: IS SELECT det.ROWID,
2023: det.pbl_line_id,
2024: pbl.object_version_number
2025: FROM hxt_det_hours_worked_f det,
2026: hxt_sum_hours_worked_f sum,
2027: pay_batch_lines pbl,
2028: FND_Sessions sess
2029: WHERE sum.tim_id = p_tim_id

Line 2164: UPDATE hxt_det_hours_worked_f

2160: THEN
2161:
2162: put_log('Updating hxt_det ');
2163: FORALL i IN l_det_rowtab.FIRST..l_det_rowtab.LAST
2164: UPDATE hxt_det_hours_worked_f
2165: SET pay_status = 'P',
2166: pbl_line_id = NULL
2167: WHERE ROWID = CHARTOROWID(l_det_rowtab(i));
2168:

Line 2220: UPDATE hxt_det_hours_worked_f

2216: THEN
2217:
2218: put_log('Updating hxt_det for OTLR only');
2219: FORALL i IN l_det_rowtab.FIRST..l_det_rowtab.LAST
2220: UPDATE hxt_det_hours_worked_f
2221: SET pay_status = 'P',
2222: pbl_line_id = NULL
2223: WHERE ROWID = CHARTOROWID(l_det_rowtab(i));
2224:

Line 2404: hxt_det_hours_worked_f det

2400:
2401: CURSOR get_timecards(p_batch_id IN NUMBER)
2402: IS SELECT DISTINCT tim_id
2403: FROM pay_batch_lines pbl,
2404: hxt_det_hours_worked_f det
2405: WHERE pbl.batch_id = p_batch_id
2406: AND ( pbl.batch_line_id = det.retro_pbl_line_id
2407: OR pbl.batch_id = det.retro_batch_id);
2408:

Line 2421: hxt_det_hours_worked_f det,

2417: ROWIDTOCHAR(det.ROWID),
2418: ROWIDTOCHAR(ret.ROWID),
2419: pbl.batch_line_id
2420: FROM pay_batch_lines pbl,
2421: hxt_det_hours_worked_f det,
2422: hxt_sum_hours_worked_f sum,
2423: hxc_ret_pay_latest_details ret
2424: WHERE pbl.batch_id = p_batch_id
2425: AND pbl.batch_line_id = det.retro_pbl_line_id

Line 2445: hxt_det_hours_worked_f det,

2441: ROWIDTOCHAR(det.ROWID),
2442: ROWIDTOCHAR(ret.ROWID),
2443: pbl.batch_line_id
2444: FROM pay_batch_lines pbl,
2445: hxt_det_hours_worked_f det,
2446: hxt_sum_hours_worked_f sum,
2447: hxc_ret_pay_latest_details ret
2448: WHERE pbl.batch_id = p_batch_id
2449: AND pbl.batch_line_id = det.retro_pbl_line_id

Line 2480: FROM hxt_det_hours_worked_f det,

2476: IS SELECT DISTINCT
2477: ROWIDTOCHAR(det.ROWID),
2478: ROWIDTOCHAR(ret.ROWID),
2479: pbl.batch_line_id
2480: FROM hxt_det_hours_worked_f det,
2481: hxt_sum_hours_worked_f sum,
2482: hxc_ret_pay_latest_details ret,
2483: pay_batch_lines pbl
2484: WHERE det.pay_status = 'C'

Line 2506: FROM hxt_det_hours_worked_f det,

2502: pbl.batch_line_id,
2503: RANK() OVER ( PARTITION BY ret.time_building_block_id,
2504: ret.object_version_number
2505: ORDER BY det.ROWID) rank
2506: FROM hxt_det_hours_worked_f det,
2507: hxt_sum_hours_worked_f sum,
2508: hxc_ret_pay_latest_details ret,
2509: pay_batch_lines pbl
2510: WHERE det.pay_status = 'C'

Line 2528: FROM hxt_det_hours_worked_f det

2524: CURSOR get_adjusted_records(p_batch_id IN NUMBER,
2525: p_tim_id IN NUMBER)
2526: IS SELECT DISTINCT
2527: ROWIDTOCHAR(det.ROWID)
2528: FROM hxt_det_hours_worked_f det
2529: WHERE det.pay_status IN ('A','D')
2530: AND det.tim_id = p_tim_id
2531: AND retro_batch_id_2 = p_batch_id;
2532:

Line 2540: hxt_det_hours_worked_f det

2536: p_tim_id IN NUMBER)
2537: IS SELECT ROWIDTOCHAR(det.ROWID),
2538: pbl.batch_line_id
2539: FROM pay_batch_lines pbl,
2540: hxt_det_hours_worked_f det
2541: WHERE pbl.batch_id = p_batch_id
2542: AND pbl.batch_line_id = det.retro_pbl_line_id
2543: AND det.tim_id = p_tim_id
2544: AND det.pay_status = 'B'

Line 2551: FROM hxt_det_hours_worked_f det

2547:
2548: CURSOR get_untouched_not_in_ss(p_batch_id IN NUMBER,
2549: p_tim_id IN NUMBER)
2550: IS SELECT ROWIDTOCHAR(det.ROWID)
2551: FROM hxt_det_hours_worked_f det
2552: WHERE retro_batch_id = p_batch_id
2553: AND pay_status = 'C'
2554: AND det.tim_id = p_tim_id
2555: AND retro_pbl_line_id IS NULL;

Line 2562: hxt_det_hours_worked_f det

2558: p_tim_id IN NUMBER)
2559: IS SELECT ROWIDTOCHAR(det.ROWID),
2560: pbl.batch_line_id
2561: FROM pay_batch_lines pbl,
2562: hxt_det_hours_worked_f det
2563: WHERE pbl.batch_id = p_batch_id
2564: AND pbl.batch_line_id = det.retro_pbl_line_id
2565: AND det.tim_id = p_tim_id
2566: AND det.retro_batch_id = pbl.batch_id

Line 2624: UPDATE hxt_det_hours_worked_f

2620: IF l_det_rowtab.COUNT > 0
2621: THEN
2622:
2623: FORALL i IN l_det_rowtab.FIRST..l_det_rowtab.LAST
2624: UPDATE hxt_det_hours_worked_f
2625: SET pay_status = 'C',
2626: retro_pbl_line_id = retro_pbl_line_id_2
2627: WHERE ROWID = CHARTOROWID(l_det_rowtab(i));
2628:

Line 2664: UPDATE hxt_det_hours_worked_f

2660: IF l_det_rowtab.COUNT > 0
2661: THEN
2662:
2663: FORALL i IN l_det_rowtab.FIRST..l_det_rowtab.LAST
2664: UPDATE hxt_det_hours_worked_f
2665: SET pay_status = 'C',
2666: retro_pbl_line_id = retro_pbl_line_id_2
2667: WHERE ROWID = CHARTOROWID(l_det_rowtab(i));
2668:

Line 2712: UPDATE hxt_det_hours_worked_f

2708: DELETE FROM hxc_ret_pay_latest_details
2709: WHERE ROWID = CHARTOROWID(l_ret_rowtab(i));
2710:
2711: FORALL i IN l_det_rowtab.FIRST..l_det_rowtab.LAST
2712: UPDATE hxt_det_hours_worked_f
2713: SET retro_pbl_line_id = NULL,
2714: pay_status = 'R'
2715: WHERE ROWID = CHARTOROWID(l_det_rowtab(i));
2716:

Line 2759: UPDATE hxt_det_hours_worked_f

2755: AND l_rank_tab(i) = 1;
2756:
2757:
2758: FORALL i IN l_det_rowtab.FIRST..l_det_rowtab.LAST
2759: UPDATE hxt_det_hours_worked_f
2760: SET retro_pbl_line_id = NULL,
2761: pay_status = 'R'
2762: WHERE ROWID = CHARTOROWID(l_det_rowtab(i));
2763:

Line 2818: UPDATE hxt_det_hours_worked_f

2814: IF l_det_rowtab.COUNT > 0
2815: THEN
2816:
2817: FORALL i IN l_det_rowtab.FIRST..l_det_rowtab.LAST
2818: UPDATE hxt_det_hours_worked_f
2819: SET pay_status = 'C'
2820: WHERE ROWID = CHARTOROWID(l_det_rowtab(i));
2821:
2822: END IF;

Line 2837: UPDATE hxt_det_hours_worked_f

2833: IF l_det_rowtab.COUNT > 0
2834: THEN
2835:
2836: FORALL i IN l_det_rowtab.FIRST..l_det_rowtab.LAST
2837: UPDATE hxt_det_hours_worked_f
2838: SET pay_status = 'C',
2839: retro_pbl_line_id = retro_pbl_line_id_2,
2840: retro_pbl_line_id_2 = NULL
2841: WHERE ROWID = CHARTOROWID(l_det_rowtab(i));

Line 2858: UPDATE hxt_det_hours_worked_f

2854: IF l_det_rowtab.COUNT > 0
2855: THEN
2856:
2857: FORALL i IN l_det_rowtab.FIRST..l_det_rowtab.LAST
2858: UPDATE hxt_det_hours_worked_f
2859: SET pay_status = 'R'
2860: WHERE ROWID = CHARTOROWID(l_det_rowtab(i));
2861:
2862:

Line 2877: UPDATE hxt_det_hours_worked_f

2873: IF l_det_rowtab.COUNT > 0
2874: THEN
2875:
2876: FORALL i IN l_det_rowtab.FIRST..l_det_rowtab.LAST
2877: UPDATE hxt_det_hours_worked_f
2878: SET pay_status = 'R',
2879: retro_pbl_line_id = NULL
2880: WHERE ROWID = CHARTOROWID(l_det_rowtab(i));
2881:

Line 3075: FROM hxt_det_hours_worked

3071: STATE_NAME ,
3072: COUNTY_NAME ,
3073: CITY_NAME ,
3074: ZIP_CODE
3075: FROM hxt_det_hours_worked
3076: WHERE tim_id = p_tim_id;
3077:
3078: -- Bug 13832327
3079:

Line 3107: UPDATE hxt_det_hours_worked_f

3103:
3104:
3105: -- Bug 13814489
3106: -- Added 'R' in the IN list.
3107: UPDATE hxt_det_hours_worked_f
3108: SET effective_end_date = SYSDATE -1
3109: WHERE tim_id = p_tim_id
3110: AND effective_end_date = hr_general.end_of_time
3111: AND pay_status IN ('A','B','D','R');

Line 3114: UPDATE hxt_det_hours_worked_f

3110: AND effective_end_date = hr_general.end_of_time
3111: AND pay_status IN ('A','B','D','R');
3112:
3113: -- Bug 13777315
3114: UPDATE hxt_det_hours_worked_f
3115: SET pay_status = 'Z'
3116: WHERE tim_id = p_tim_id
3117: AND effective_end_date <> hr_general.end_of_time
3118: AND pay_status = 'C';

Line 3120: UPDATE hxt_det_hours_worked_f

3116: WHERE tim_id = p_tim_id
3117: AND effective_end_date <> hr_general.end_of_time
3118: AND pay_status = 'C';
3119:
3120: UPDATE hxt_det_hours_worked_f
3121: SET effective_end_date = SYSDATE -1,
3122: pay_status = 'Z'
3123: WHERE tim_id = p_tim_id
3124: AND effective_end_date = hr_general.end_of_time

Line 3127: UPDATE hxt_det_hours_worked_f

3123: WHERE tim_id = p_tim_id
3124: AND effective_end_date = hr_general.end_of_time
3125: AND pay_status = 'C';
3126:
3127: UPDATE hxt_det_hours_worked_f
3128: SET rollback_status = 'R'
3129: WHERE tim_id = p_tim_id
3130: AND rollback_status IS NULL;
3131:

Line 3143: HXT_DML.insert_HXT_DET_HOURS_WORKED

3139:
3140: -- l_id := hxt_seqno.NEXTVAL;
3141: -- Commented this statement and added the above cursor for the Bug 13832327
3142:
3143: HXT_DML.insert_HXT_DET_HOURS_WORKED
3144: (p_rowid => l_rowid
3145: ,p_id => l_ids_tab(i) -- Bug 13832327
3146: ,p_parent_id => l_det_tab(i).parent_id
3147: ,p_tim_id => l_det_tab(i).tim_id

Line 3224: DELETE FROM hxt_det_hours_worked_f

3220: BEGIN
3221:
3222: put_log('Purging this timecard '||p_tim_id);
3223:
3224: DELETE FROM hxt_det_hours_worked_f
3225: WHERE tim_id = p_tim_id;
3226:
3227: DELETE FROM hxt_sum_hours_worked_f
3228: WHERE tim_id = p_tim_id;

Line 3247: hxt_det_hours_worked det,

3243:
3244: CURSOR get_outstanding_details
3245: IS SELECT det.tim_id
3246: FROM hxt_timecards tim,
3247: hxt_det_hours_worked det,
3248: hxt_batch_states hbs
3249: WHERE tim.id = p_tim_id
3250: AND det.tim_id = tim.id
3251: AND hbs.batch_id = tim.batch_id

Line 3263: FROM hxt_det_hours_worked_f

3259: retro_pbl_line_id_2,
3260: retro_batch_id,
3261: retro_batch_id_2,
3262: pay_status
3263: FROM hxt_det_hours_worked_f
3264: WHERE tim_id = p_tim_id
3265: AND pay_status IN ('A','B','C','D')
3266: ORDER BY pay_status;
3267:

Line 3399: UPDATE hxt_det_hours_worked_f

3395:
3396: END LOOP;
3397:
3398: FORALL i IN l_id_tab.FIRST..l_id_tab.LAST
3399: UPDATE hxt_det_hours_worked_f
3400: SET rollback_status = 'X'
3401: WHERE id = l_id_tab(i);
3402:
3403:

Line 3479: hxt_det_hours_worked det,

3475:
3476: CURSOR get_outstanding_details
3477: IS SELECT det.tim_id
3478: FROM hxt_timecards tim,
3479: hxt_det_hours_worked det,
3480: hxt_batch_states hbs
3481: WHERE tim.id = p_tim_id
3482: AND det.tim_id = tim.id
3483: AND hbs.batch_id = tim.batch_id

Line 3495: FROM hxt_det_hours_worked_f

3491: retro_pbl_line_id_2,
3492: retro_batch_id,
3493: retro_batch_id_2,
3494: pay_status
3495: FROM hxt_det_hours_worked_f
3496: WHERE tim_id = p_tim_id
3497: AND pay_status IN ('A','B','C','D')
3498: ORDER BY pay_status;
3499: