APPS.HXC_RDB_POST_RETRIEVAL dependencies on HXC_RDB_POST_ATTRIBUTES

Line 1064: INTO hxc_rdb_post_attributes

1060: IS
1061:
1062: BEGIN
1063: INSERT
1064: INTO hxc_rdb_post_attributes
1065: (batch_id,
1066: attribute1,
1067: attribute2,
1068: attribute3,

Line 1101: INTO hxc_rdb_post_attributes

1097: AND ret_user_id = FND_GLOBAL.user_id;
1098:
1099:
1100: INSERT
1101: INTO hxc_rdb_post_attributes
1102: (batch_id,
1103: attribute1,
1104: attribute2,
1105: attribute3,

Line 1137: INSERT INTO HXC_RDB_POST_ATTRIBUTES

1133: WHERE rec_retro_line_id IS NOT NULL
1134: AND ret_user_id = FND_GLOBAL.user_id;
1135:
1136:
1137: INSERT INTO HXC_RDB_POST_ATTRIBUTES
1138: ( attribute1,
1139: attribute2,
1140: attribute3,
1141: measure,

Line 1155: FROM hxc_rdb_post_attributes

1151: batch_id,
1152: ' (Total) 'total,
1153: 1,
1154: FND_GLOBAL.user_id
1155: FROM hxc_rdb_post_attributes
1156: WHERE ret_user_id = FND_GLOBAL.user_id
1157: GROUP BY batch_id,
1158: attribute1,
1159: attribute2,

Line 1306: FROM hxc_rdb_post_attributes

1302: attribute3,
1303: SUM(measure) OVER (PARTITION BY batch_id,
1304: attribute3) ,
1305: FND_GLOBAL.user_id
1306: FROM hxc_rdb_post_attributes
1307: WHERE ret_user_id = FND_GLOBAL.user_id
1308: AND total IS NULL ;
1309: COMMIT;
1310: END IF;

Line 1613: FROM hxc_rdb_post_attributes rdb,

1609: IS SELECT proj.name||' - '||
1610: task.task_number||' - '||
1611: rdb.attribute3,
1612: ROWIDTOCHAR(rdb.ROWID)
1613: FROM hxc_rdb_post_attributes rdb,
1614: pa_projects_all proj,
1615: pa_tasks_expend_v task /*Bug 16391367*/
1616:
1617: WHERE rdb.ret_user_id = FND_GLOBAL.user_id

Line 1624: FROM hxc_rdb_post_attributes rdb,

1620:
1621: CURSOR get_elements
1622: IS SELECT pay.element_name,
1623: ROWIDTOCHAR(rdb.ROWID)
1624: FROM hxc_rdb_post_attributes rdb,
1625: pay_element_types_f_tl pay
1626: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
1627: AND pay.language = USERENV('LANG')
1628: AND rdb.attribute1 = pay.element_type_id;

Line 1646: UPDATE hxc_rdb_post_attributes

1642: rowtab LIMIT 500;
1643: EXIT WHEN atttab.COUNT = 0;
1644:
1645: FORALL i IN atttab.FIRST..atttab.LAST
1646: UPDATE hxc_rdb_post_attributes
1647: SET attribute_name = atttab(i)
1648: WHERE ROWID = CHARTOROWID(rowtab(i));
1649:
1650:

Line 1668: UPDATE hxc_rdb_post_attributes

1664: rowtab LIMIT 500;
1665: EXIT WHEN atttab.COUNT = 0;
1666:
1667: FORALL i IN atttab.FIRST..atttab.LAST
1668: UPDATE hxc_rdb_post_attributes
1669: SET attribute_name = atttab(i)
1670: WHERE ROWID = CHARTOROWID(rowtab(i));
1671:
1672:

Line 2124: DELETE FROM hxc_rdb_post_attributes

2120:
2121: DELETE FROM hxc_rdb_post_batches
2122: WHERE ret_user_id = FND_GLOBAL.user_id;
2123:
2124: DELETE FROM hxc_rdb_post_attributes
2125: WHERE ret_user_id = FND_GLOBAL.user_id;
2126:
2127: DELETE FROM hxc_rdb_post_hrs_pm
2128: WHERE ret_user_id = FND_GLOBAL.user_id;