APPS.OZF_RESALE_PVT dependencies on OZF_RESALE_BATCHES_ALL

Line 19: FROM ozf_resale_batches_all

15: G_TPM_PROCESS_ENABLED VARCHAR2 (1) := NVL(fnd_profile.VALUE ('OZF_TPM_PROCESS_ENABLED'),'N');
16:
17: CURSOR g_org_id_csr(p_id number) IS
18: SELECT org_id
19: FROM ozf_resale_batches_all
20: WHERE resale_batch_id = p_id;
21:
22:
23: ---------------------------------------------------------------------

Line 587: update ozf_resale_batches_all

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

Line 1163: UPDATE ozf_resale_batches_all

1159: END IF;
1160:
1161: -- For TPA Parallel Execution ER - 9614703 (+)
1162: IF x_batch_status = 'CLOSED' THEN
1163: UPDATE ozf_resale_batches_all
1164: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED
1165: WHERE resale_batch_id = l_batch_id_tbl(j);
1166: ELSIF x_batch_status = 'PENDING_ACCRUALS' THEN
1167: UPDATE ozf_resale_batches_all

Line 1167: UPDATE ozf_resale_batches_all

1163: UPDATE ozf_resale_batches_all
1164: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED
1165: WHERE resale_batch_id = l_batch_id_tbl(j);
1166: ELSIF x_batch_status = 'PENDING_ACCRUALS' THEN
1167: UPDATE ozf_resale_batches_all
1168: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_ACCRUALS
1169: WHERE resale_batch_id = l_batch_id_tbl(j);
1170: END IF;
1171: -- For TPA Parallel Execution ER - 9614703 (-)

Line 1547: DELETE FROM ozf_resale_batches_all

1543: AND b.resale_batch_id = p_resale_batch_id
1544: AND b.status_code NOT IN ('CLOSED', 'PROCESSING', 'PENDING_PAYMENT')
1545: );
1546:
1547: DELETE FROM ozf_resale_batches_all
1548: WHERE resale_batch_id = p_resale_batch_id
1549: AND status_code NOT IN ('CLOSED', 'PROCESSING', 'PENDING_PAYMENT');
1550: EXCEPTION
1551: WHEN OTHERS THEN

Line 1566: DELETE FROM ozf_resale_batches_all

1562: AND b.data_source_code = p_data_source_code
1563: AND b.resale_batch_id = p_resale_batch_id
1564: );
1565:
1566: DELETE FROM ozf_resale_batches_all
1567: WHERE resale_batch_id = p_resale_batch_id
1568: AND data_source_code = p_data_source_code
1569: AND status_code NOT IN ('CLOSED', 'PROCESSING', 'PENDING_PAYMENT');
1570: EXCEPTION