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_PRE_RETRIEVAL dependencies on HXC_RDB_PRE_TIMECARDS

Line 114: FROM hxc_rdb_pre_timecards rdb,

110:
111: CURSOR get_last_touched
112: IS SELECT det.last_updated_by,
113: ROWIDTOCHAR(rdb.rowid)
114: FROM hxc_rdb_pre_timecards rdb,
115: hxc_time_building_blocks det,
116: fnd_user fnd
117: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
118: AND rdb.lu_bb_id = det.time_building_block_id

Line 134: UPDATE hxc_rdb_pre_timecards

130: rowtab LIMIT 1000;
131: EXIT WHEN usertab.COUNT = 0;
132:
133: FORALL i IN usertab.FIRST..usertab.LAST
134: UPDATE hxc_rdb_pre_timecards
135: SET last_updated_by = usertab(i)
136: WHERE rowid = CHARTOROWID(rowtab(i));
137:
138: COMMIT;

Line 150: FROM hxc_rdb_pre_timecards tc,

146:
147: CURSOR get_supervisor
148: IS SELECT paf.supervisor_id,
149: ROWIDTOCHAR(tc.rowid)
150: FROM hxc_rdb_pre_timecards tc,
151: per_assignments_f paf -- Bug 12605349
152: WHERE tc.ret_user_id = FND_GLOBAL.user_id
153: AND tc.resource_id = paf.person_id
154: AND tc.start_time BETWEEN paf.effective_start_date

Line 168: UPDATE hxc_rdb_pre_timecards

164: rowtab LIMIT 500;
165: EXIT WHEN suptab.COUNT = 0;
166:
167: FORALL i IN suptab.FIRST..suptab.LAST
168: UPDATE hxc_rdb_pre_timecards
169: SET supervisor_id = suptab(i)
170: WHERE ROWID = CHARTOROWID(rowtab(i));
171: COMMIT;
172: END LOOP;

Line 186: FROM hxc_rdb_pre_timecards rdb,

182: DECODE(ppf.current_npw_flag,'Y',
183: ppf.npw_number,
184: ppf.employee_number),
185: ROWIDTOCHAR(rdb.rowid)
186: FROM hxc_rdb_pre_timecards rdb,
187: per_people_f ppf -- Bug 12605349
188: WHERE trunc(SYSDATE) BETWEEN ppf.effective_start_date --Bug 14026118
189: AND ppf.effective_end_date
190: AND rdb.resource_id = ppf.person_id

Line 206: UPDATE hxc_rdb_pre_timecards

202: rowtab LIMIT 500;
203: EXIT WHEN nametab.COUNT = 0;
204:
205: FORALL i IN nametab.FIRST..nametab.LAST
206: UPDATE hxc_rdb_pre_timecards
207: SET emp_name = nametab(i),
208: emp_no = notab(i)
209: WHERE rowid = chartorowid(rowtab(i));
210:

Line 236: hxc_rdb_pre_timecards tc

232: ret.attribute3,
233: ret.measure,
234: ret.attribute1
235: from LATEST_DETAILS ret,
236: hxc_rdb_pre_timecards tc
237: where ret.timecard_id = tc.timecard_id
238: and tc.ret_user_id = USERID '
239: ;
240:

Line 325: FROM hxc_rdb_pre_timecards

321: ret_user_id)
322: SELECT approval_status,
323: count(timecard_id) Timecards,
324: FND_GLOBAL.user_id
325: FROM hxc_rdb_pre_timecards
326: WHERE ret_user_id = FND_GLOBAL.user_id
327: GROUP by approval_status
328: UNION
329: SELECT 'Total',count(*),

Line 331: FROM hxc_rdb_pre_timecards

327: GROUP by approval_status
328: UNION
329: SELECT 'Total',count(*),
330: FND_GLOBAL.user_id
331: FROM hxc_rdb_pre_timecards
332: WHERE ret_user_id = FND_GLOBAL.user_id;
333: COMMIT;
334:
335: END summarize_statuses;

Line 421: FROM hxc_rdb_pre_timecards

417: supervisor_id,
418: COUNT(*) OVER (PARTITION BY approval_status,
419: supervisor_id) ,
420: FND_GLOBAL.user_id
421: FROM hxc_rdb_pre_timecards
422: WHERE ret_user_id = FND_GLOBAL.user_id
423: AND supervisor_id IS NOT NULL
424: UNION
425: ALL

Line 430: FROM hxc_rdb_pre_timecards

426: SELECT DISTINCT 'Total' approval_status,
427: supervisor_id,
428: COUNT(*) OVER (PARTITION BY supervisor_id),
429: FND_GLOBAL.user_id
430: FROM hxc_rdb_pre_timecards
431: WHERE ret_user_id = FND_GLOBAL.user_id
432: AND supervisor_id IS NOT NULL;
433: COMMIT;
434: END IF;

Line 453: FROM hxc_rdb_pre_timecards

449: last_updated_by,
450: COUNT(*) OVER (PARTITION BY approval_status,
451: last_updated_by) ,
452: FND_GLOBAL.user_id
453: FROM hxc_rdb_pre_timecards
454: WHERE ret_user_id = FND_GLOBAL.user_id
455: AND last_updated_by IS NOT NULL
456: UNION
457: ALL

Line 462: FROM hxc_rdb_pre_timecards

458: SELECT distinct 'Total' approval_status,
459: last_updated_by,
460: COUNT(*) OVER (PARTITION BY last_updated_by),
461: FND_GLOBAL.user_id
462: FROM hxc_rdb_pre_timecards
463: WHERE ret_user_id = FND_GLOBAL.user_id
464: AND last_updated_by IS NOT NULL;
465: COMMIT;
466:

Line 800: INSERT INTO hxc_rdb_pre_timecards

796:
797: EXIT WHEN restab.COUNT = 0;
798:
799: FORALL i IN restab.FIRST..restab.LAST
800: INSERT INTO hxc_rdb_pre_timecards
801: ( resource_id,
802: timecard_id,
803: approval_status,
804: start_time,

Line 938: INSERT INTO hxc_rdb_pre_timecards

934: ovntab,ludtab LIMIT 500;
935: EXIT WHEN restab.COUNT = 0;
936:
937: FORALL i IN restab.FIRST..restab.LAST
938: INSERT INTO hxc_rdb_pre_timecards
939: ( resource_id,
940: timecard_id,
941: approval_status,
942: start_time,

Line 1022: FROM hxc_rdb_pre_timecards rdb,

1018: IS
1019:
1020: CURSOR pick_lock_rowid
1021: IS SELECT ROWIDTOCHAR(loc.rowid)
1022: FROM hxc_rdb_pre_timecards rdb,
1023: hxc_locks loc
1024: WHERE rdb.resource_id = loc.resource_id
1025: AND rdb.start_time = loc.start_time
1026: AND TRUNC(rdb.stop_time) = TRUNC(loc.stop_time)

Line 1054: FROM hxc_rdb_pre_timecards

1050: IS
1051:
1052: CURSOR get_old_timecards
1053: IS SELECT ROWIDTOCHAR(rowid)
1054: FROM hxc_rdb_pre_timecards
1055: WHERE ret_user_id = FND_GLOBAL.user_id;
1056:
1057: CURSOR get_old_details
1058: IS SELECT ROWIDTOCHAR(rowid)

Line 1071: DELETE FROM hxc_rdb_pre_timecards

1067: FETCH get_old_timecards BULK COLLECT INTO rowtab LIMIT 500;
1068: EXIT WHEN rowtab.COUNT = 0;
1069:
1070: FORALL i IN rowtab.FIRST..rowtab.LAST
1071: DELETE FROM hxc_rdb_pre_timecards
1072: WHERE ROWID = CHARTOROWID(rowtab(i));
1073:
1074: COMMIT;
1075:

Line 1150: (person_name hxc_rdb_pre_timecards.emp_name%TYPE,

1146: l_dynamic_cursor SYS_REFCURSOR; -- new code
1147:
1148:
1149: TYPE r_details IS RECORD
1150: (person_name hxc_rdb_pre_timecards.emp_name%TYPE,
1151: person_number hxc_rdb_pre_timecards.emp_no%TYPE,
1152: start_time varchar2(50),
1153: stop_time varchar2(50),
1154: status fnd_lookup_values.meaning%TYPE,

Line 1151: person_number hxc_rdb_pre_timecards.emp_no%TYPE,

1147:
1148:
1149: TYPE r_details IS RECORD
1150: (person_name hxc_rdb_pre_timecards.emp_name%TYPE,
1151: person_number hxc_rdb_pre_timecards.emp_no%TYPE,
1152: start_time varchar2(50),
1153: stop_time varchar2(50),
1154: status fnd_lookup_values.meaning%TYPE,
1155: last_update_date varchar2(50),