APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_BATCHES_ALL

Line 1344: FROM ozf_resale_batches_all

1340: partner_party_id,
1341: report_start_date,
1342: report_end_date,
1343: last_updated_by
1344: FROM ozf_resale_batches_all
1345: WHERE resale_batch_id = p_id;
1346:
1347: l_partner_cust_account_id NUMBER;
1348: l_partner_party_id NUMBER;

Line 2599: FROM ozf_resale_batches_all

2595: FROM dual; */
2596: l_batch_org_id NUMBER;
2597: CURSOR org_id_csr(cv_resale_batch_id IN NUMBER) IS
2598: SELECT org_id
2599: FROM ozf_resale_batches_all
2600: WHERE resale_batch_id = cv_resale_batch_id;
2601: -- End: bug # 5997978 fixed
2602:
2603: CURSOR order_num_csr is

Line 2942: FROM ozf_resale_batches_all

2938: AND resale_batch_id = cv_batch_id;
2939:
2940: CURSOR csr_get_batch_number(cv_batch_id IN NUMBER) IS
2941: SELECT batch_number
2942: FROM ozf_resale_batches_all
2943: WHERE resale_batch_id = cv_batch_id;
2944:
2945: l_valid_line_count NUMBER;
2946: l_batch_number VARCHAR2(30);

Line 3711: UPDATE ozf_resale_batches_all

3707: CLOSE csr_valid_line_count;
3708:
3709: IF l_valid_line_count > 0 THEN
3710: -- close this batch
3711: UPDATE ozf_resale_batches_all
3712: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED
3713: , batch_count = l_valid_line_count
3714: WHERE resale_batch_id = p_resale_batch_id;
3715:

Line 3727: DELETE FROM ozf_resale_batches_all

3723: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Successfully Processed: '||l_valid_line_count);
3724: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3725:
3726: ELSE
3727: DELETE FROM ozf_resale_batches_all
3728: WHERE resale_batch_id = p_resale_batch_id;
3729: END IF;
3730: -- [END OF BUG 4233341 FIXING]
3731:

Line 3860: SELECT ozf_resale_batches_all_s.nextval

3856:
3857: l_obj_number NUMBER := 1.0;
3858:
3859: CURSOR resale_batch_id_csr IS
3860: SELECT ozf_resale_batches_all_s.nextval
3861: FROM dual;
3862: l_resale_batch_id NUMBER;
3863:
3864: CURSOR resale_batch_number_csr IS