APPS.HXC_RDB_PRE_RETRIEVAL dependencies on HXC_RDB_PRE_ATTRIBUTES

Line 343: INTO hxc_rdb_pre_attributes

339: IS
340:
341: BEGIN
342: INSERT
343: INTO hxc_rdb_pre_attributes
344: (approval_status,
345: attribute1,
346: attribute2,
347: attribute3,

Line 566: FROM hxc_rdb_pre_attributes rdb,

562: IS SELECT proj.name||' - '||
563: task.task_number||' - '||
564: rdb.attribute3,
565: ROWIDTOCHAR(rdb.rowid)
566: FROM hxc_rdb_pre_attributes rdb,
567: pa_projects_all proj,
568: pa_tasks_expend_v task
569: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
570: AND rdb.attribute1 = proj.project_id

Line 576: FROM hxc_rdb_pre_attributes rdb,

572:
573: CURSOR get_elements
574: IS SELECT pay.element_name,
575: ROWIDTOCHAR(rdb.rowid)
576: FROM hxc_rdb_pre_attributes rdb,
577: pay_element_types_f_tl pay
578: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
579: AND pay.language = USERENV('LANG')
580: AND rdb.attribute1 = pay.element_type_id;

Line 598: UPDATE hxc_rdb_pre_attributes

594: rowtab LIMIT 500;
595: EXIT WHEN atttab.COUNT = 0;
596:
597: FORALL i IN atttab.FIRST..atttab.LAST
598: UPDATE hxc_rdb_pre_attributes
599: SET attribute_name = atttab(i)
600: WHERE rowid = CHARTOROWID(rowtab(i));
601:
602:

Line 620: UPDATE hxc_rdb_pre_attributes

616: rowtab LIMIT 500;
617: EXIT WHEN atttab.COUNT = 0;
618:
619: FORALL i IN atttab.FIRST..atttab.LAST
620: UPDATE hxc_rdb_pre_attributes
621: SET attribute_name = atttab(i)
622: WHERE rowid = CHARTOROWID(rowtab(i));
623:
624:

Line 1097: DELETE FROM hxc_rdb_pre_attributes

1093:
1094: DELETE FROM hxc_rdb_pre_status
1095: WHERE ret_user_id = FND_GLOBAL.user_id;
1096:
1097: DELETE FROM hxc_rdb_pre_attributes
1098: WHERE ret_user_id = FND_GLOBAL.user_id;
1099:
1100: DELETE FROM hxc_rdb_pre_hrs_pm
1101: WHERE ret_user_id = FND_GLOBAL.user_id;