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_RDB_POST_RETRIEVAL dependencies on HXC_RDB_POST_TIMECARDS

Line 146: FROM hxc_rdb_post_timecards rdb

142: retro_batch_id,
143: start_time,
144: stop_time,
145: ROWIDTOCHAR(rdb.rowid)
146: FROM hxc_rdb_post_timecards rdb
147: WHERE ret_user_id = FND_GLOBAL.user_id
148: AND old_batch_id IS NOT NULL
149: AND retro_batch_id IS NOT NULL
150: AND NOT EXISTS ( SELECT 1

Line 151: FROM hxc_rdb_post_timecards rdb2

147: WHERE ret_user_id = FND_GLOBAL.user_id
148: AND old_batch_id IS NOT NULL
149: AND retro_batch_id IS NOT NULL
150: AND NOT EXISTS ( SELECT 1
151: FROM hxc_rdb_post_timecards rdb2
152: WHERE rdb2.ret_user_id = FND_GLOBAL.user_id
153: AND rdb2.batch_id = rdb.old_batch_id );
154:
155: -- Bug 9705704

Line 162: FROM hxc_rdb_post_timecards rdb

158: IS SELECT MAX(ROWIDTOCHAR(rdb.rowid)),
159: timecard_id,
160: NVL(batch_id,'0'),
161: NVL(retro_batch_id,'0')
162: FROM hxc_rdb_post_timecards rdb
163: WHERE ret_user_id = FND_GLOBAL.user_id
164: GROUP BY timecard_id,batch_id,retro_batch_id;
165:
166: tctab NUMBERTAB;

Line 193: UPDATE hxc_rdb_post_timecards

189:
190: EXIT WHEN tctab.COUNT = 0;
191:
192: FORALL i IN tctab.FIRST..tctab.LAST
193: UPDATE hxc_rdb_post_timecards
194: SET old_batch_id = NULL
195: WHERE ROWID = CHARTOROWID(rowtab(i));
196:
197: FORALL i IN tctab.FIRST..tctab.LAST

Line 198: INSERT INTO hxc_rdb_post_timecards

194: SET old_batch_id = NULL
195: WHERE ROWID = CHARTOROWID(rowtab(i));
196:
197: FORALL i IN tctab.FIRST..tctab.LAST
198: INSERT INTO hxc_rdb_post_timecards
199: (timecard_id,
200: approval_status,
201: resource_id,
202: batch_id,

Line 225: UPDATE hxc_rdb_post_timecards

221: -- Update all the records with a NULL old_batch_id,
222: -- because now we have picked up all the old batches
223: -- as batch_id itself.
224:
225: UPDATE hxc_rdb_post_timecards
226: SET old_batch_id = NULL
227: WHERE ret_user_id = FND_GLOBAL.user_id;
228:
229: -- Pick up the unique combos.

Line 242: DELETE FROM hxc_rdb_post_timecards

238:
239: -- Delete those duplicates which do not have the max
240: -- rowid.
241: FORALL i IN rowtab.FIRST..rowtab.LAST
242: DELETE FROM hxc_rdb_post_timecards
243: WHERE ret_user_id = FND_GLOBAL.user_id
244: AND timecard_id = tctab(i)
245: AND NVL(batch_id,'0') = batchtab(i)
246: AND NVL(retro_batch_id,'0') = rettab(i)

Line 274: FROM hxc_rdb_post_timecards rdb

270: CURSOR get_rank
271: IS SELECT ROWIDTOCHAR(ROWID),
272: RANK() OVER ( PARTITION BY timecard_id
273: ORDER BY TO_NUMBER(approval_status) DESC ) rank
274: FROM hxc_rdb_post_timecards rdb
275: WHERE ret_user_id = FND_GLOBAL.user_id;
276:
277: tctab VARCHARTAB;
278: ovntab NUMBERTAB;

Line 290: DELETE FROM hxc_rdb_post_timecards

286: ranktab LIMIT 500;
287: EXIT WHEN tctab.COUNT = 0;
288:
289: FORALL i IN tctab.FIRST..tctab.LAST
290: DELETE FROM hxc_rdb_post_timecards
291: WHERE ret_user_id = FND_GLOBAL.user_id
292: AND ROWID = CHARTOROWID(tctab(i))
293: AND ranktab(i) <> 1 ;
294:

Line 313: FROM hxc_rdb_post_timecards tc,

309: asg.payroll_id,
310: asg.organization_id,
311: asg.job_id,
312: ROWIDTOCHAR(tc.ROWID)
313: FROM hxc_rdb_post_timecards tc,
314: per_assignments_f asg -- Bug 12605349
315: WHERE tc.ret_user_id = FND_GLOBAL.user_id
316: AND tc.resource_id = asg.person_id
317: AND tc.start_time BETWEEN asg.effective_start_date

Line 337: UPDATE hxc_rdb_post_timecards

333: rowtab LIMIT 500;
334: EXIT WHEN suptab.COUNT = 0;
335:
336: FORALL i IN suptab.FIRST..suptab.LAST
337: UPDATE hxc_rdb_post_timecards
338: SET supervisor_id = suptab(i),
339: payroll_id = paytab(i),
340: org_job_id = DECODE(p_application,'PAY', orgtab(i),
341: 'PA', jobtab(i))

Line 358: FROM hxc_rdb_post_timecards rdb,

354: DECODE(ppf.current_npw_flag,'Y',
355: ppf.npw_number,
356: ppf.employee_number),
357: ROWIDTOCHAR(rdb.ROWID)
358: FROM hxc_rdb_post_timecards rdb,
359: per_people_f ppf -- Bug 12605349
360: WHERE SYSDATE BETWEEN ppf.effective_start_date
361: AND ppf.effective_end_date
362: AND rdb.resource_id = ppf.person_id

Line 378: UPDATE hxc_rdb_post_timecards

374: rowtab LIMIT 500;
375: EXIT WHEN nametab.COUNT = 0;
376:
377: FORALL i IN nametab.FIRST..nametab.LAST
378: UPDATE hxc_rdb_post_timecards
379: SET emp_name = nametab(i),
380: emp_no = notab(i)
381: WHERE ROWID = CHARTOROWID(rowtab(i));
382:

Line 420: hxc_rdb_post_timecards tc

416: ret.request_id,
417: ret.old_request_id,
418: ret.old_batch_id
419: FROM hxc_ret_pay_latest_details ret,
420: hxc_rdb_post_timecards tc
421: WHERE ret.timecard_id = tc.timecard_id
422: AND NVL(tc.batch_id,''0'') = NVL(ret.batch_id,''0'')
423: AND NVL(tc.retro_batch_id,''0'') = NVL(ret.retro_batch_id,''0'')
424: AND tc.ret_user_id = USERID '

Line 451: hxc_rdb_post_timecards tc

447: ret.request_id,
448: ret.old_request_id,
449: ret.old_exp_group
450: FROM hxc_ret_pa_latest_details ret,
451: hxc_rdb_post_timecards tc
452: WHERE ret.timecard_id = tc.timecard_id
453: AND tc.ret_user_id = USERID
454: AND NVL(tc.batch_id,''0'') = NVL(ret.exp_group,''0'')
455: AND NVL(tc.retro_batch_id,''0'') = NVL(ret.retro_exp_group,''0'')

Line 631: hxc_rdb_post_timecards tc

627: ret.old_request_id,
628: NULL,
629: NULL
630: FROM hxc_ret_pay_latest_details ret,
631: hxc_rdb_post_timecards tc
632: WHERE ret.timecard_id = tc.timecard_id
633: AND tc.batch_id = ret.old_batch_id
634: AND ret.old_pbl_id <> NVL(ret.pbl_id,0)
635: AND tc.ret_user_id = USERID '

Line 662: hxc_rdb_post_timecards tc

658: ret.old_request_id,
659: NULL,
660: NULL
661: FROM hxc_ret_pa_latest_details ret,
662: hxc_rdb_post_timecards tc
663: WHERE ret.timecard_id = tc.timecard_id
664: AND tc.ret_user_id = USERID
665: AND tc.batch_id = ret.old_exp_group
666: AND ret.old_pei_id <> NVL(ret.pei_id,0)

Line 800: FROM hxc_rdb_post_timecards rdb,

796: -- To pick up the guys which are active now.
797: CURSOR get_summary
798: IS SELECT sum.approval_status,
799: rdb.timecard_id
800: FROM hxc_rdb_post_timecards rdb,
801: hxc_timecard_summary sum
802: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
803: AND rdb.timecard_id = sum.timecard_id;
804:

Line 811: FROM hxc_rdb_post_timecards

807: -- template, or deleted and recreated.
808:
809: CURSOR get_blocks
810: IS SELECT ROWIDTOCHAR(rowid)
811: FROM hxc_rdb_post_timecards
812: WHERE ret_user_id = FND_GLOBAL.user_id
813: AND approval_status NOT IN ( SELECT lookup_code
814: FROM fnd_lookup_values
815: WHERE lookup_type = 'HXC_APPROVAL_STATUS'

Line 826: FROM hxc_rdb_post_timecards rdb,

822: IS SELECT rdb.timecard_id,
823: sum.timecard_id,
824: sum.approval_status,
825: ROWIDTOCHAR(rdb.rowid)
826: FROM hxc_rdb_post_timecards rdb,
827: hxc_timecard_summary sum
828: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
829: AND rdb.approval_status = 'RDBDELETED'
830: AND rdb.resource_id = sum.resource_id

Line 858: UPDATE hxc_rdb_post_timecards

854: tctab LIMIT 500;
855: EXIT WHEN stattab.COUNT = 0;
856:
857: FORALL i IN tctab.FIRST..tctab.LAST
858: UPDATE hxc_rdb_post_timecards
859: SET approval_status = stattab(i)
860: WHERE ret_user_id = FND_GLOBAL.user_id
861: AND timecard_id = tctab(i);
862:

Line 874: UPDATE hxc_rdb_post_timecards

870: FETCH get_blocks BULK COLLECT INTO rowtab;
871: CLOSE get_blocks;
872:
873: FORALL i IN rowtab.FIRST..rowtab.LAST
874: UPDATE hxc_rdb_post_timecards
875: SET approval_status = 'RDBDELETED'
876: WHERE rowid = CHARTOROWID(rowtab(i));
877:
878: COMMIT;

Line 893: UPDATE hxc_rdb_post_timecards

889:
890:
891: -- Update the timecard ids and statuses for the timecards.
892: FORALL i IN rowidtab.FIRST..rowidtab.LAST
893: UPDATE hxc_rdb_post_timecards
894: SET approval_status = statustab(i),
895: timecard_id = sumtab(i)
896: WHERE ROWID = CHARTOROWID(rowidtab(i));
897:

Line 923: FROM hxc_rdb_post_timecards rdb

919: IS
920:
921: CURSOR pick_timecards
922: IS SELECT ROWIDTOCHAR(rdb.rowid)
923: FROM hxc_rdb_post_timecards rdb
924: WHERE ret_user_id = FND_GLOBAL.user_id
925: AND retro_batch_id IS NOT NULL;
926:
927:

Line 944: UPDATE hxc_rdb_post_timecards

940: LOOP
941: FETCH pick_timecards BULK COLLECT INTO rowtab LIMIT 500;
942: EXIT WHEN rowtab.COUNT = 0;
943: FORALL i IN rowtab.FIRST..rowtab.LAST
944: UPDATE hxc_rdb_post_timecards
945: SET retro_batch_id = retro_batch_id||'(Retro)'
946: WHERE rowid = CHARTOROWID(rowtab(i));
947:
948: COMMIT;

Line 974: FROM hxc_rdb_post_timecards tc,

970: IS
971:
972: CURSOR get_partially_retrieved_pay
973: IS SELECT ROWIDTOCHAR(tc.ROWID)
974: FROM hxc_rdb_post_timecards tc,
975: hxc_pay_latest_details pay
976: WHERE tc.ret_user_id = FND_GLOBAL.user_id
977: AND tc.timecard_id = pay.timecard_id;
978:

Line 981: FROM hxc_rdb_post_timecards tc,

977: AND tc.timecard_id = pay.timecard_id;
978:
979: CURSOR get_partially_retrieved_pa
980: IS SELECT ROWIDTOCHAR(tc.ROWID)
981: FROM hxc_rdb_post_timecards tc,
982: hxc_pa_latest_details pay
983: WHERE tc.ret_user_id = FND_GLOBAL.user_id
984: AND tc.timecard_id = pay.timecard_id;
985:

Line 998: UPDATE hxc_rdb_post_timecards

994: FETCH get_partially_retrieved_pay BULK COLLECT INTO rowtab LIMIT 500;
995: EXIT WHEN rowtab.COUNT = 0;
996:
997: FORALL i IN rowtab.FIRST..rowtab.LAST
998: UPDATE hxc_rdb_post_timecards
999: SET partially_retrieved = 'Y'
1000: WHERE ROWID = CHARTOROWID(rowtab(i));
1001: COMMIT;
1002: END LOOP;

Line 1014: UPDATE hxc_rdb_post_timecards

1010: FETCH get_partially_retrieved_pa BULK COLLECT INTO rowtab LIMIT 500;
1011: EXIT WHEN rowtab.COUNT = 0;
1012:
1013: FORALL i IN rowtab.FIRST..rowtab.LAST
1014: UPDATE hxc_rdb_post_timecards
1015: SET partially_retrieved = 'Y'
1016: WHERE ROWID = CHARTOROWID(rowtab(i));
1017: COMMIT;
1018: END LOOP;

Line 1041: FROM hxc_rdb_post_timecards

1037: SELECT DISTINCT batch_id,
1038: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id) Timecards,
1039: 'N',
1040: FND_GLOBAL.user_id
1041: FROM hxc_rdb_post_timecards
1042: WHERE ret_user_id = FND_GLOBAL.user_id
1043: AND batch_id IS NOT NULL
1044: UNION
1045: SELECT DISTINCT retro_batch_id,

Line 1049: FROM hxc_rdb_post_timecards

1045: SELECT DISTINCT retro_batch_id,
1046: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id) Timecards,
1047: 'Y',
1048: FND_GLOBAL.user_id
1049: FROM hxc_rdb_post_timecards
1050: WHERE ret_user_id = FND_GLOBAL.user_id
1051: AND retro_batch_id IS NOT NULL
1052: AND NVL(retro_batch_id,'0') <> NVL(batch_id,'0')
1053: AND NVL(retro_batch_id,'0') <> NVL(old_batch_id,'0') ;

Line 1184: FROM hxc_rdb_post_timecards

1180: supervisor_id,
1181: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id,
1182: supervisor_id) ,
1183: FND_GLOBAL.user_id
1184: FROM hxc_rdb_post_timecards
1185: WHERE ret_user_id = FND_GLOBAL.user_id
1186: AND supervisor_id IS NOT NULL
1187: AND batch_id IS NOT NULL
1188: UNION

Line 1194: FROM hxc_rdb_post_timecards

1190: supervisor_id,
1191: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id,
1192: supervisor_id) ,
1193: FND_GLOBAL.user_id
1194: FROM hxc_rdb_post_timecards
1195: WHERE ret_user_id = FND_GLOBAL.user_id
1196: AND supervisor_id IS NOT NULL
1197: AND retro_batch_id IS NOT NULL
1198: UNION

Line 1203: FROM hxc_rdb_post_timecards

1199: SELECT '0' batch_id,
1200: supervisor_id,
1201: COUNT(DISTINCT timecard_id) OVER (PARTITION BY supervisor_id) ,
1202: FND_GLOBAL.user_id
1203: FROM hxc_rdb_post_timecards
1204: WHERE ret_user_id = FND_GLOBAL.user_id
1205: AND supervisor_id IS NOT NULL;
1206: COMMIT;
1207: END IF;

Line 1265: FROM hxc_rdb_post_timecards

1261: payroll_id,
1262: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id,
1263: payroll_id) ,
1264: FND_GLOBAL.user_id
1265: FROM hxc_rdb_post_timecards
1266: WHERE ret_user_id = FND_GLOBAL.user_id
1267: AND payroll_id IS NOT NULL
1268: AND batch_id IS NOT NULL
1269: UNION

Line 1275: FROM hxc_rdb_post_timecards

1271: payroll_id,
1272: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id,
1273: payroll_id) ,
1274: FND_GLOBAL.user_id
1275: FROM hxc_rdb_post_timecards
1276: WHERE ret_user_id = FND_GLOBAL.user_id
1277: AND payroll_id IS NOT NULL
1278: AND retro_batch_id IS NOT NULL
1279: UNION

Line 1284: FROM hxc_rdb_post_timecards

1280: SELECT '0' batch_id,
1281: payroll_id,
1282: COUNT(DISTINCT timecard_id) OVER (PARTITION BY payroll_id) ,
1283: FND_GLOBAL.user_id
1284: FROM hxc_rdb_post_timecards
1285: WHERE ret_user_id = FND_GLOBAL.user_id
1286: AND payroll_id IS NOT NULL;
1287: COMMIT;
1288: END IF;

Line 1336: FROM hxc_rdb_post_timecards

1332: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id,
1333: start_time,
1334: stop_time),
1335: FND_GLOBAL.user_id
1336: FROM hxc_rdb_post_timecards
1337: WHERE partially_retrieved = 'Y'
1338: AND batch_id IS NOT NULL
1339: AND ret_user_id = FND_GLOBAL.user_id
1340: UNION

Line 1348: FROM hxc_rdb_post_timecards

1344: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id,
1345: start_time,
1346: stop_time),
1347: FND_GLOBAL.user_id
1348: FROM hxc_rdb_post_timecards
1349: WHERE partially_retrieved = 'Y'
1350: AND retro_batch_id IS NOT NULL
1351: AND ret_user_id = FND_GLOBAL.user_id
1352: UNION

Line 1359: FROM hxc_rdb_post_timecards

1355: stop_time,
1356: COUNT(DISTINCT timecard_id) OVER (PARTITION BY start_time,
1357: stop_time),
1358: FND_GLOBAL.user_id
1359: FROM hxc_rdb_post_timecards
1360: WHERE partially_retrieved = 'Y'
1361: AND ret_user_id = FND_GLOBAL.user_id ;
1362: COMMIT;
1363:

Line 1387: FROM hxc_rdb_post_timecards

1383: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id,
1384: start_time,
1385: stop_time),
1386: FND_GLOBAL.user_id
1387: FROM hxc_rdb_post_timecards
1388: WHERE batch_id IS NOT NULL
1389: AND ret_user_id = FND_GLOBAL.user_id
1390: UNION
1391: SELECT DISTINCT retro_batch_id,

Line 1398: FROM hxc_rdb_post_timecards

1394: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id,
1395: start_time,
1396: stop_time),
1397: FND_GLOBAL.user_id
1398: FROM hxc_rdb_post_timecards
1399: WHERE retro_batch_id IS NOT NULL
1400: AND ret_user_id = FND_GLOBAL.user_id
1401: UNION
1402: SELECT DISTINCT '0' batch_id,

Line 1408: FROM hxc_rdb_post_timecards

1404: stop_time,
1405: COUNT(DISTINCT timecard_id) OVER (PARTITION BY start_time,
1406: stop_time),
1407: FND_GLOBAL.user_id
1408: FROM hxc_rdb_post_timecards
1409: WHERE ret_user_id = FND_GLOBAL.user_id ;
1410: COMMIT;
1411:
1412: END summarize_distinct;

Line 1431: FROM hxc_rdb_post_timecards

1427: org_job_id,
1428: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id,
1429: org_job_id) ,
1430: FND_GLOBAL.user_id
1431: FROM hxc_rdb_post_timecards
1432: WHERE ret_user_id = FND_GLOBAL.user_id
1433: AND org_job_id IS NOT NULL
1434: AND batch_id IS NOT NULL
1435: UNION

Line 1441: FROM hxc_rdb_post_timecards

1437: org_job_id,
1438: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id,
1439: org_job_id) ,
1440: FND_GLOBAL.user_id
1441: FROM hxc_rdb_post_timecards
1442: WHERE ret_user_id = FND_GLOBAL.user_id
1443: AND org_job_id IS NOT NULL
1444: AND retro_batch_id IS NOT NULL
1445: UNION

Line 1450: FROM hxc_rdb_post_timecards

1446: SELECT '0' batch_id,
1447: org_job_id,
1448: COUNT(DISTINCT timecard_id) OVER (PARTITION BY org_job_id) ,
1449: FND_GLOBAL.user_id
1450: FROM hxc_rdb_post_timecards
1451: WHERE ret_user_id = FND_GLOBAL.user_id
1452: AND org_job_id IS NOT NULL;
1453: COMMIT;
1454:

Line 1926: INSERT INTO hxc_rdb_post_timecards

1922: stoptab LIMIT 500;
1923: EXIT WHEN tctab.COUNT = 0;
1924:
1925: FORALL i IN tctab.FIRST..tctab.LAST
1926: INSERT INTO hxc_rdb_post_timecards
1927: (timecard_id,
1928: approval_status,
1929: resource_id,
1930: batch_id,

Line 2013: INSERT INTO hxc_rdb_post_timecards

2009:
2010: EXIT WHEN tctab.COUNT = 0;
2011:
2012: FORALL i IN tctab.FIRST..tctab.LAST
2013: INSERT INTO hxc_rdb_post_timecards
2014: (timecard_id,
2015: approval_status,
2016: resource_id,
2017: batch_id,

Line 2081: FROM hxc_rdb_post_timecards

2077: IS
2078:
2079: CURSOR get_old_timecards
2080: IS SELECT ROWIDTOCHAR(ROWID)
2081: FROM hxc_rdb_post_timecards
2082: WHERE ret_user_id = FND_GLOBAL.user_id;
2083:
2084: CURSOR get_old_details
2085: IS SELECT ROWIDTOCHAR(ROWID)

Line 2098: DELETE FROM hxc_rdb_post_timecards

2094: FETCH get_old_timecards BULK COLLECT INTO rowtab LIMIT 500;
2095: EXIT WHEN rowtab.COUNT = 0;
2096:
2097: FORALL i IN rowtab.FIRST..rowtab.LAST
2098: DELETE FROM hxc_rdb_post_timecards
2099: WHERE ROWID = CHARTOROWID(rowtab(i));
2100:
2101: COMMIT;
2102:

Line 2391: (person_name hxc_rdb_post_timecards.emp_name%TYPE,

2387: l_dynamic_cursor SYS_REFCURSOR;
2388:
2389:
2390: TYPE r_details IS RECORD
2391: (person_name hxc_rdb_post_timecards.emp_name%TYPE,
2392: person_number hxc_rdb_post_timecards.emp_no%TYPE,
2393: start_time varchar2(50),
2394: stop_time varchar2(50),
2395: status fnd_lookup_values.meaning%TYPE,

Line 2392: person_number hxc_rdb_post_timecards.emp_no%TYPE,

2388:
2389:
2390: TYPE r_details IS RECORD
2391: (person_name hxc_rdb_post_timecards.emp_name%TYPE,
2392: person_number hxc_rdb_post_timecards.emp_no%TYPE,
2393: start_time varchar2(50),
2394: stop_time varchar2(50),
2395: status fnd_lookup_values.meaning%TYPE,
2396: last_update_date varchar2(50),