APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_BATCHES_ALL

Line 1731: FROM ozf_resale_batches_all

1727: report_start_date,
1728: report_end_date,
1729: last_updated_by,
1730: NVL(direct_order_flag,'N') -- For Bug#9447673 SSD IDSM
1731: FROM ozf_resale_batches_all
1732: WHERE resale_batch_id = p_id;
1733:
1734: l_partner_cust_account_id NUMBER;
1735: l_partner_party_id NUMBER;

Line 2971: UPDATE ozf_resale_batches_all

2967: END IF;
2968:
2969: --Update Batch status to Pending Accruals in case locking happens, Batch Line status remains unchanged
2970: IF x_fund_update_status = 'PENDING_ACCRUALS' OR x_budget_update_status = 'PENDING_ACCRUALS' THEN
2971: UPDATE ozf_resale_batches_all
2972: SET status_code = 'PENDING_ACCRUALS'
2973: WHERE resale_batch_id = p_resale_batch_id;
2974:
2975: ozf_utility_pvt.write_conc_log('Updated batch status to Pending Accruals - p_resale_batch_id: ' || p_resale_batch_id);

Line 3233: FROM ozf_resale_batches_all

3229: FROM dual; */
3230: l_batch_org_id NUMBER;
3231: CURSOR org_id_csr(cv_resale_batch_id IN NUMBER) IS
3232: SELECT org_id
3233: FROM ozf_resale_batches_all
3234: WHERE resale_batch_id = cv_resale_batch_id;
3235: -- End: bug # 5997978 fixed
3236:
3237: CURSOR order_num_csr is

Line 3582: FROM ozf_resale_batches_all

3578: AND resale_batch_id = cv_batch_id;
3579:
3580: CURSOR csr_get_batch_number(cv_batch_id IN NUMBER) IS
3581: SELECT batch_number
3582: FROM ozf_resale_batches_all
3583: WHERE resale_batch_id = cv_batch_id;
3584:
3585: l_valid_line_count NUMBER;
3586: l_batch_number VARCHAR2(30);

Line 4555: UPDATE ozf_resale_batches_all

4551: CLOSE csr_valid_line_count;
4552:
4553: IF l_valid_line_count > 0 THEN
4554: -- close this batch
4555: UPDATE ozf_resale_batches_all
4556: SET status_code = l_batch_status
4557: , batch_count = l_valid_line_count
4558: WHERE resale_batch_id = p_resale_batch_id;
4559:

Line 4571: DELETE FROM ozf_resale_batches_all

4567: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Successfully Processed: '||l_valid_line_count);
4568: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4569:
4570: ELSE
4571: DELETE FROM ozf_resale_batches_all
4572: WHERE resale_batch_id = p_resale_batch_id;
4573: END IF;
4574: -- [END OF BUG 4233341 FIXING]
4575: END IF; -- Bug 14194884 - TPA In Draft Mode ER

Line 4712: SELECT ozf_resale_batches_all_s.nextval

4708:
4709: l_obj_number NUMBER := 1.0;
4710:
4711: CURSOR resale_batch_id_csr IS
4712: SELECT ozf_resale_batches_all_s.nextval
4713: FROM dual;
4714: l_resale_batch_id NUMBER;
4715:
4716: CURSOR resale_batch_number_csr IS

Line 5566: --Delete the data from OZF_RESALE_BATCHES_ALL for the request

5562: AND ORG_ID = l_org_id -- nepanda : Fix for bug # 15900683
5563: );
5564:
5565:
5566: --Delete the data from OZF_RESALE_BATCHES_ALL for the request
5567: DELETE FROM ozf_resale_batches_all
5568: WHERE request_id = G_CONC_REQUEST_ID
5569: AND org_id = l_org_id; -- nepanda : Fix for bug # 15900683
5570:

Line 5567: DELETE FROM ozf_resale_batches_all

5563: );
5564:
5565:
5566: --Delete the data from OZF_RESALE_BATCHES_ALL for the request
5567: DELETE FROM ozf_resale_batches_all
5568: WHERE request_id = G_CONC_REQUEST_ID
5569: AND org_id = l_org_id; -- nepanda : Fix for bug # 15900683
5570:
5571: OPEN csr_processed_lines_count;