eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_RESALE_PVT dependencies on OZF_RESALE_LINES_INT_ALL

Line 1495: DELETE FROM ozf_resale_lines_int_all a

1491: -- Purge the records that have been successfully processed
1492: IF p_data_source_code IS NULL OR
1493: p_data_source_code = 'ALL' THEN
1494: BEGIN
1495: DELETE FROM ozf_resale_lines_int_all a
1496: WHERE a.resale_batch_id IN (
1497: SELECT b.resale_batch_id
1498: FROM ozf_resale_batches b
1499: WHERE b.purge_flag IS NULL

Line 1513: DELETE FROM ozf_resale_lines_int_all a

1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510: END;
1511: ELSE
1512: BEGIN
1513: DELETE FROM ozf_resale_lines_int_all a
1514: WHERE a.data_source_code = p_data_source_code
1515: AND a.resale_batch_id IN (
1516: SELECT b.resale_batch_id
1517: FROM ozf_resale_batches b

Line 1538: DELETE FROM ozf_resale_lines_int_all a

1534: -- Purge the records that have been successfully processed
1535: IF p_data_source_code IS NULL OR
1536: p_data_source_code = 'ALL' THEN
1537: BEGIN
1538: DELETE FROM ozf_resale_lines_int_all a
1539: WHERE a.resale_batch_id IN (
1540: SELECT b.resale_batch_id
1541: FROM ozf_resale_batches b
1542: WHERE b.purge_flag IS NULL

Line 1556: DELETE FROM ozf_resale_lines_int_all a

1552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1553: END;
1554: ELSE
1555: BEGIN
1556: DELETE FROM ozf_resale_lines_int_all a
1557: WHERE a.data_source_code = p_data_source_code
1558: AND a.resale_batch_id IN (
1559: SELECT b.resale_batch_id
1560: FROM ozf_resale_batches b