APPS.OZF_CHARGEBACK_PVT dependencies on OZF_RESALE_BATCHES

Line 162: FROM ozf_resale_batches_all

158: last_updated_by,
159: currency_code,
160: partner_claim_number,
161: org_id
162: FROM ozf_resale_batches_all
163: WHERE resale_batch_id = p_id;
164:
165: CURSOR open_line_count_csr (p_id IN NUMBER) IS
166: SELECT count(1)

Line 289: ozf_resale_batches_all orba

285: CURSOR sysparam_accrual_flag_csr (p_resale_batch_id IN NUMBER)
286: IS
287: SELECT NVL(ospa.ship_debit_accrual_flag, 'F')
288: FROM ozf_sys_parameters_all ospa,
289: ozf_resale_batches_all orba
290: WHERE ospa.org_id = orba.org_id
291: AND orba.resale_batch_id = p_resale_batch_id;
292:
293: -- For Bug#8867381

Line 420: UPDATE ozf_resale_batches_all

416: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418: END IF;
419:
420: UPDATE ozf_resale_batches_all
421: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
422: WHERE resale_batch_id = p_resale_batch_id;
423:
424: RAISE error_no_rollback;

Line 767: UPDATE ozf_resale_batches

763: response_code = 'N'
764: WHERE resale_line_int_id = l_line_int_rec.resale_line_int_id;
765:
766: -- SET Batch as DISPUTED
767: UPDATE ozf_resale_batches
768: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
769: WHERE resale_batch_id = l_line_int_rec.resale_batch_id;
770:
771: GOTO END_ORDER_LINE;

Line 1085: UPDATE ozf_resale_batches

1081: -- UPDATE batch status to PENDING_CLOSE as the records are stored in the staging tables
1082: -- and run the concurrent prgm to update the main tables.
1083: IF x_fund_table_status = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_CLOSE
1084: OR x_budget_table_status = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_CLOSE THEN
1085: UPDATE ozf_resale_batches
1086: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_CLOSE,
1087: paid_amount = l_amount_claimed,
1088: last_updated_by = NVL(fnd_global.user_id, -1),
1089: last_update_date = SYSDATE

Line 1094: UPDATE ozf_resale_batches

1090: WHERE resale_batch_id = p_resale_batch_id;
1091:
1092: ELSE
1093: -- UPDATE batch status to closed.
1094: UPDATE ozf_resale_batches
1095: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED,
1096: paid_amount = l_amount_claimed,
1097: last_updated_by = NVL(fnd_global.user_id, -1),
1098: last_update_date = SYSDATE

Line 1640: UPDATE ozf_resale_batches

1636: response_type = 'CA',
1637: response_code = 'N'
1638: WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id;
1639:
1640: UPDATE ozf_resale_batches
1641: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
1642: WHERE resale_batch_id = l_resale_int_rec.resale_batch_id;
1643: --
1644: GOTO END_LOOP3;

Line 1986: UPDATE ozf_resale_batches

1982: response_code = 'N'
1983: WHERE resale_line_int_id = l_resale_int_rec.resale_line_int_id;
1984:
1985: -- SET Batch as DISPUTED
1986: UPDATE ozf_resale_batches
1987: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
1988: WHERE resale_batch_id = l_resale_int_rec.resale_batch_id;
1989: END IF;
1990: END IF;

Line 2381: FROM ozf_resale_batches

2377: l_related_lines_tbl OZF_ORDER_PRICE_PVT.RLTD_LINE_TBL_TYPE;
2378:
2379: CURSOR batch_info_csr (p_id IN NUMBER) IS
2380: SELECT partner_party_id, report_start_date, report_end_date
2381: FROM ozf_resale_batches
2382: WHERE resale_batch_id = p_id;
2383:
2384: l_partner_party_id NUMBER;
2385: l_report_start_date DATE;