APPS.OZF_RESALE_PVT dependencies on OZF_RESALE_BATCHES_ALL

Line 18: FROM ozf_resale_batches_all

14: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
15:
16: CURSOR g_org_id_csr(p_id number) IS
17: SELECT org_id
18: FROM ozf_resale_batches_all
19: WHERE resale_batch_id = p_id;
20:
21:
22: ---------------------------------------------------------------------

Line 586: update ozf_resale_batches_all

582: FETCH batch_count_csr into l_batch_count;
583: CLOSE batch_count_csr;
584:
585: IF l_duplicate_count = l_batch_count THEN
586: update ozf_resale_batches_all
587: set status_code = OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED
588: where resale_batch_id = p_resale_batch_id;
589: ELSE
590: */

Line 1395: DELETE FROM ozf_resale_batches_all

1391: AND b.resale_batch_id = p_resale_batch_id
1392: AND b.status_code NOT IN ('CLOSED', 'PROCESSING', 'PENDING_PAYMENT')
1393: );
1394:
1395: DELETE FROM ozf_resale_batches_all
1396: WHERE resale_batch_id = p_resale_batch_id
1397: AND status_code NOT IN ('CLOSED', 'PROCESSING', 'PENDING_PAYMENT');
1398: EXCEPTION
1399: WHEN OTHERS THEN

Line 1414: DELETE FROM ozf_resale_batches_all

1410: AND b.data_source_code = p_data_source_code
1411: AND b.resale_batch_id = p_resale_batch_id
1412: );
1413:
1414: DELETE FROM ozf_resale_batches_all
1415: WHERE resale_batch_id = p_resale_batch_id
1416: AND data_source_code = p_data_source_code
1417: AND status_code NOT IN ('CLOSED', 'PROCESSING', 'PENDING_PAYMENT');
1418: EXCEPTION