APPS.HXC_RDB_PRE_RETRIEVAL dependencies on HXC_RDB_PRE_DETAILS

Line 280: INSERT INTO hxc_rdb_pre_details

276: hrspmtab LIMIT 500;
277: EXIT WHEN restab.count = 0;
278:
279: FORALL i IN restab.FIRST..restab.LAST
280: INSERT INTO hxc_rdb_pre_details
281: (resource_id,
282: time_building_block_id,
283: ovn,
284: approval_status,

Line 359: FROM hxc_rdb_pre_details

355: attribute1||
356: attribute2||
357: attribute3) measure,
358: FND_GLOBAL.user_id
359: FROM hxc_rdb_pre_details
360: WHERE ret_user_id = FND_GLOBAL.user_id
361: UNION
362: ALL
363: SELECT DISTINCT 'Total' approval_status,

Line 372: FROM hxc_rdb_pre_details

368: attribute1||
369: attribute2||
370: attribute3) measure,
371: fnd_global.user_id
372: FROM hxc_rdb_pre_details
373: WHERE ret_user_id = FND_GLOBAL.user_id;
374: COMMIT;
375:
376: END summarize_attributes;

Line 395: FROM hxc_rdb_pre_details

391: hrs_pm,
392: COUNT(DISTINCT timecard_id) OVER (PARTITION BY approval_status,
393: hrs_pm) ,
394: fnd_global.user_id
395: FROM hxc_rdb_pre_details
396: WHERE ret_user_id = FND_GLOBAL.user_id
397: UNION
398: ALL
399: SELECT DISTINCT 'Total' approval_status,

Line 403: FROM hxc_rdb_pre_details

399: SELECT DISTINCT 'Total' approval_status,
400: hrs_pm,
401: COUNT(DISTINCT timecard_id) OVER (PARTITION BY hrs_pm) measure,
402: fnd_global.user_id
403: FROM hxc_rdb_pre_details
404: WHERE ret_user_id = FND_GLOBAL.user_id;
405:
406: COMMIT;
407: END IF;

Line 1059: FROM hxc_rdb_pre_details

1055: WHERE ret_user_id = FND_GLOBAL.user_id;
1056:
1057: CURSOR get_old_details
1058: IS SELECT ROWIDTOCHAR(rowid)
1059: FROM hxc_rdb_pre_details
1060: WHERE ret_user_id = FND_GLOBAL.user_id;
1061:
1062: rowtab VARCHARTAB;
1063:

Line 1085: DELETE FROM hxc_rdb_pre_details

1081: FETCH get_old_details BULK COLLECT INTO rowtab LIMIT 500;
1082: EXIT WHEN rowtab.COUNT = 0;
1083:
1084: FORALL i IN rowtab.FIRST..rowtab.LAST
1085: DELETE FROM hxc_rdb_pre_details
1086: WHERE ROWID = CHARTOROWID(rowtab(i));
1087:
1088: COMMIT;
1089:

Line 1316: FROM hxc_rdb_pre_details det,

1312: TO_CHAR(detail.start_time,'HH24:MI'), -- Bug 9656636
1313: TO_CHAR(detail.stop_time,'HH24:MI'),
1314: timecard_id,
1315: FND_GLOBAL.user_id
1316: FROM hxc_rdb_pre_details det,
1317: hxc_time_building_blocks detail
1318: WHERE timecard_id = p_timecard_id
1319: AND det.time_building_block_id = detail.time_building_block_id
1320: AND det.ovn = detail.object_version_number