APPS.HXC_RDB_PRE_RETRIEVAL dependencies on HXC_RDB_PRE_TC_DETAILS

Line 1267: FROM hxc_rdb_pre_tc_details rdb,

1263: IS SELECT proj.name||' - '||
1264: task.task_number||' - '||
1265: rdb.attribute3,
1266: ROWIDTOCHAR(rdb.ROWID)
1267: FROM hxc_rdb_pre_tc_details rdb,
1268: pa_projects_all proj,
1269: pa_tasks_expend_v task
1270: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
1271: AND rdb.attribute1 = proj.project_id

Line 1277: FROM hxc_rdb_pre_tc_details rdb,

1273:
1274: CURSOR get_elements
1275: IS SELECT pay.element_name,
1276: ROWIDTOCHAR(rdb.ROWID)
1277: FROM hxc_rdb_pre_tc_details rdb,
1278: pay_element_types_f_tl pay
1279: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
1280: AND pay.language = USERENV('LANG')
1281: AND rdb.attribute1 = pay.element_type_id;

Line 1291: DELETE FROM hxc_rdb_pre_tc_details

1287: nametab VARCHARTAB;
1288:
1289: BEGIN
1290:
1291: DELETE FROM hxc_rdb_pre_tc_details
1292: WHERE ret_user_id = FND_GLOBAL.user_id;
1293: COMMIT;
1294:
1295: INSERT INTO hxc_rdb_pre_tc_details

Line 1295: INSERT INTO hxc_rdb_pre_tc_details

1291: DELETE FROM hxc_rdb_pre_tc_details
1292: WHERE ret_user_id = FND_GLOBAL.user_id;
1293: COMMIT;
1294:
1295: INSERT INTO hxc_rdb_pre_tc_details
1296: (time_building_block_id,
1297: date_worked,
1298: measure,
1299: attribute1,

Line 1334: UPDATE hxc_rdb_pre_tc_details

1330: rowtab LIMIT 500;
1331: EXIT WHEN atttab.COUNT = 0;
1332:
1333: FORALL i IN atttab.FIRST..atttab.LAST
1334: UPDATE hxc_rdb_pre_tc_details
1335: SET attribute_name = atttab(i)
1336: WHERE ROWID = CHARTOROWID(rowtab(i));
1337:
1338:

Line 1356: UPDATE hxc_rdb_pre_tc_details

1352: rowtab LIMIT 500;
1353: EXIT WHEN atttab.COUNT = 0;
1354:
1355: FORALL i IN atttab.FIRST..atttab.LAST
1356: UPDATE hxc_rdb_pre_tc_details
1357: SET attribute_name = atttab(i)
1358: WHERE ROWID = CHARTOROWID(rowtab(i));
1359:
1360: