APPS.OZF_CHARGEBACK_PVT dependencies on OZF_RESALE_BATCHES

Line 98: FROM ozf_resale_batches

94: batch_number,
95: last_updated_by,
96: currency_code,
97: partner_claim_number
98: FROM ozf_resale_batches
99: WHERE resale_batch_id = p_id;
100:
101: CURSOR open_line_count_csr (p_id IN NUMBER) IS
102: SELECT count(1)

Line 306: UPDATE ozf_resale_batches_all

302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:
306: UPDATE ozf_resale_batches_all
307: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
308: WHERE resale_batch_id = p_resale_batch_id;
309:
310: RAISE error_no_rollback;

Line 590: UPDATE ozf_resale_batches

586: response_code = 'N'
587: WHERE resale_line_int_id = l_line_int_rec.resale_line_int_id;
588:
589: -- SET Batch as DISPUTED
590: UPDATE ozf_resale_batches
591: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
592: WHERE resale_batch_id = l_line_int_rec.resale_batch_id;
593:
594: GOTO END_ORDER_LINE;

Line 844: UPDATE ozf_resale_batches

840: */
841: -- BUG 4395931 (-)
842:
843: -- UPDATE batch status to closed -- might change later.
844: UPDATE ozf_resale_batches
845: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED,
846: paid_amount = l_amount_claimed
847: WHERE resale_batch_id = p_resale_batch_id;
848:

Line 1375: UPDATE ozf_resale_batches

1371: response_type = 'CA',
1372: response_code = 'N'
1373: WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id;
1374:
1375: UPDATE ozf_resale_batches
1376: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
1377: WHERE resale_batch_id = l_resale_int_rec.resale_batch_id;
1378: --
1379: GOTO END_LOOP3;

Line 1721: UPDATE ozf_resale_batches

1717: response_code = 'N'
1718: WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id;
1719:
1720: -- SET Batch as DISPUTED
1721: UPDATE ozf_resale_batches
1722: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
1723: WHERE resale_batch_id = l_resale_int_rec.resale_batch_id;
1724: END IF;
1725: END IF;

Line 2116: FROM ozf_resale_batches

2112: l_related_lines_tbl OZF_ORDER_PRICE_PVT.RLTD_LINE_TBL_TYPE;
2113:
2114: CURSOR batch_info_csr (p_id IN NUMBER) IS
2115: SELECT partner_party_id, report_start_date, report_end_date
2116: FROM ozf_resale_batches
2117: WHERE resale_batch_id = p_id;
2118:
2119: l_partner_party_id NUMBER;
2120: l_report_start_date DATE;