APPS.HXC_RDB_POST_RETRIEVAL dependencies on HXC_RDB_POST_TC_DETAILS

Line 2142: DELETE FROM hxc_rdb_post_tc_details

2138:
2139: DELETE FROM hxc_rdb_post_org_job
2140: WHERE ret_user_id = FND_GLOBAL.user_id;
2141:
2142: DELETE FROM hxc_rdb_post_tc_details
2143: WHERE ret_user_id = FND_GLOBAL.user_id;
2144:
2145:
2146: COMMIT;

Line 2163: FROM hxc_rdb_post_tc_details rdb,

2159: IS SELECT proj.name||' - '||
2160: task.task_number||' - '||
2161: rdb.attribute3,
2162: ROWIDTOCHAR(rdb.ROWID)
2163: FROM hxc_rdb_post_tc_details rdb,
2164: pa_projects_all proj,
2165: pa_tasks_expend_v task /*Bug 16391367*/
2166:
2167: WHERE rdb.ret_user_id = FND_GLOBAL.user_id

Line 2174: FROM hxc_rdb_post_tc_details rdb,

2170:
2171: CURSOR get_elements
2172: IS SELECT pay.element_name,
2173: ROWIDTOCHAR(rdb.ROWID)
2174: FROM hxc_rdb_post_tc_details rdb,
2175: pay_element_types_f_tl pay
2176: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
2177: AND pay.language = USERENV('LANG')
2178: AND rdb.attribute1 = pay.element_type_id;

Line 2187: FROM hxc_rdb_post_tc_details rdb,

2183: -- remove those. Works only for Payroll retro batches.
2184: CURSOR get_batch_name
2185: IS SELECT pbh.batch_name,
2186: ROWIDTOCHAR(rdb.ROWID)
2187: FROM hxc_rdb_post_tc_details rdb,
2188: pay_batch_headers pbh
2189: WHERE REPLACE(rdb.batch_id,'(Retro)') = pbh.batch_id
2190: AND rdb.ret_user_id = FND_GLOBAL.user_id;
2191:

Line 2195: FROM hxc_rdb_post_tc_details rdb,

2191:
2192: CURSOR get_batch_name_old
2193: IS SELECT pbh.batch_name,
2194: ROWIDTOCHAR(rdb.ROWID)
2195: FROM hxc_rdb_post_tc_details rdb,
2196: pay_batch_headers pbh
2197: WHERE rdb.old_batch_id = pbh.batch_id
2198: AND rdb.ret_user_id = FND_GLOBAL.user_id;
2199:

Line 2207: DELETE FROM hxc_rdb_post_tc_details

2203: nametab VARCHARTAB;
2204:
2205: BEGIN
2206:
2207: DELETE FROM hxc_rdb_post_tc_details
2208: WHERE ret_user_id = FND_GLOBAL.user_id;
2209: COMMIT;
2210:
2211: INSERT INTO hxc_rdb_post_tc_details

Line 2211: INSERT INTO hxc_rdb_post_tc_details

2207: DELETE FROM hxc_rdb_post_tc_details
2208: WHERE ret_user_id = FND_GLOBAL.user_id;
2209: COMMIT;
2210:
2211: INSERT INTO hxc_rdb_post_tc_details
2212: (time_building_block_id,
2213: date_worked,
2214: measure,
2215: attribute1,

Line 2276: UPDATE hxc_rdb_post_tc_details

2272: rowtab LIMIT 500;
2273: EXIT WHEN atttab.COUNT = 0;
2274:
2275: FORALL i IN atttab.FIRST..atttab.LAST
2276: UPDATE hxc_rdb_post_tc_details
2277: SET attribute_name = atttab(i)
2278: WHERE ROWID = CHARTOROWID(rowtab(i));
2279:
2280: COMMIT;

Line 2286: UPDATE hxc_rdb_post_tc_details

2282: END LOOP;
2283:
2284: CLOSE get_projects;
2285:
2286: UPDATE hxc_rdb_post_tc_details
2287: SET batch_name = batch_id,
2288: old_line_details = RTRIM(adj_rec_line_id||' - '||old_batch_id||' - '||old_request_id,' - ')
2289: WHERE timecard_id = p_timecard_id
2290: AND ret_user_id = FND_GLOBAL.user_id;

Line 2304: UPDATE hxc_rdb_post_tc_details

2300: rowtab LIMIT 500;
2301: EXIT WHEN atttab.COUNT = 0;
2302:
2303: FORALL i IN atttab.FIRST..atttab.LAST
2304: UPDATE hxc_rdb_post_tc_details
2305: SET attribute_name = atttab(i)
2306: WHERE ROWID = CHARTOROWID(rowtab(i));
2307:
2308: COMMIT;

Line 2320: UPDATE hxc_rdb_post_tc_details

2316: rowtab LIMIT 500;
2317: EXIT WHEN nametab.COUNT = 0;
2318:
2319: FORALL i IN nametab.FIRST..nametab.LAST
2320: UPDATE hxc_rdb_post_tc_details
2321: SET batch_name = nametab(i)
2322: WHERE ROWID = CHARTOROWID(rowtab(i));
2323:
2324: COMMIT;

Line 2336: UPDATE hxc_rdb_post_tc_details

2332: rowtab LIMIT 500;
2333: EXIT WHEN nametab.COUNT = 0;
2334:
2335: FORALL i IN nametab.FIRST..nametab.LAST
2336: UPDATE hxc_rdb_post_tc_details
2337: SET old_line_details = adj_rec_line_id||' - '||nametab(i)||' - '||old_request_id
2338: WHERE ROWID = CHARTOROWID(rowtab(i));
2339:
2340: COMMIT;