1417: IS
1418:
1419: BEGIN
1420:
1421: INSERT INTO hxc_rdb_post_org_job
1422: (batch_id,
1423: org_job_id,
1424: timecards,
1425: ret_user_id)
1774:
1775: CURSOR get_org_name
1776: IS SELECT org.name,
1777: ROWIDTOCHAR(rdb.ROWID)
1778: FROM hxc_rdb_post_org_job rdb,
1779: hr_organization_units org -- Bug 12605349
1780: WHERE rdb.org_job_id = org.organization_id
1781: AND rdb.ret_user_id = FND_GLOBAL.user_id;
1782:
1782:
1783: CURSOR get_job_name
1784: IS SELECT job.name,
1785: ROWIDTOCHAR(rdb.ROWID)
1786: FROM hxc_rdb_post_org_job rdb,
1787: per_jobs job
1788: WHERE rdb.org_job_id = job.job_id
1789: AND rdb.ret_user_id = FND_GLOBAL.user_id;
1790:
1803: rowtab LIMIT 500;
1804: EXIT WHEN nametab.COUNT = 0;
1805:
1806: FORALL i IN nametab.FIRST..nametab.LAST
1807: UPDATE hxc_rdb_post_org_job
1808: SET org_job_name = nametab(i)
1809: WHERE ROWID = CHARTOROWID(rowtab(i));
1810:
1811: COMMIT;
1823: rowtab LIMIT 500;
1824: EXIT WHEN nametab.COUNT = 0;
1825:
1826: FORALL i IN nametab.FIRST..nametab.LAST
1827: UPDATE hxc_rdb_post_org_job
1828: SET org_job_name = nametab(i)
1829: WHERE ROWID = CHARTOROWID(rowtab(i));
1830:
1831: COMMIT;
2135:
2136: DELETE FROM hxc_rdb_post_dist_timecards
2137: WHERE ret_user_id = FND_GLOBAL.user_id;
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;