APPS.HXC_RDB_POST_RETRIEVAL dependencies on HXC_RDB_POST_BATCHES

Line 1032: INTO hxc_rdb_post_batches

1028: IS
1029:
1030: BEGIN
1031: INSERT
1032: INTO hxc_rdb_post_batches
1033: (batch_id,
1034: timecards,
1035: retro_flag,
1036: ret_user_id)

Line 1561: FROM hxc_rdb_post_batches rdb,

1557: -- Add the tag to the batch name.
1558: CURSOR get_batch_name
1559: IS SELECT pbh.batch_name||DECODE(retro_flag,'Y','(Retro)'),
1560: ROWIDTOCHAR(rdb.ROWID)
1561: FROM hxc_rdb_post_batches rdb,
1562: pay_batch_headers pbh
1563: WHERE REPLACE(rdb.batch_id,'(Retro)') = pbh.batch_id
1564: AND rdb.ret_user_id = FND_GLOBAL.user_id;
1565:

Line 1581: UPDATE hxc_rdb_post_batches

1577: rowtab LIMIT 500;
1578: EXIT WHEN nametab.COUNT = 0;
1579:
1580: FORALL i IN nametab.FIRST..nametab.LAST
1581: UPDATE hxc_rdb_post_batches
1582: SET batch_name = nametab(i)
1583: WHERE ROWID = CHARTOROWID(rowtab(i));
1584:
1585: COMMIT;

Line 1594: UPDATE hxc_rdb_post_batches

1590: END IF;
1591:
1592: IF p_application = 'PA'
1593: THEN
1594: UPDATE hxc_rdb_post_batches
1595: SET batch_name = batch_id
1596: WHERE ret_user_id = FND_GLOBAL.user_id;
1597: END IF;
1598:

Line 2121: DELETE FROM hxc_rdb_post_batches

2117: END LOOP;
2118: CLOSE get_old_details;
2119:
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;