APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_BATCHES

Line 132: from ozf_resale_batches

128:
129: CURSOR batch_info_csr IS
130: SELECT status_code
131: , org_id
132: from ozf_resale_batches
133: WHERE resale_batch_id = p_resale_batch_id;
134:
135: l_status_code varchar2(30);
136: l_org_id NUMBER;

Line 532: FROM ozf_resale_adjustments a, ozf_resale_batches b

528: a.corrected_agreement_id,
529: a.corrected_agreement_name,
530: a.credit_code,
531: a.credit_advice_date
532: FROM ozf_resale_adjustments a, ozf_resale_batches b
533: WHERE a.resale_line_id = p_line_id
534: AND a.resale_batch_id = p_batch_id
535: AND a.line_agreement_flag = 'T'
536: AND a.resale_batch_id = b.resale_batch_id

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 3817: FROM ozf_resale_batches

3813: CURSOR batch_set_csr(p_data_source_code in VARCHAR2,
3814: p_start_date in date,
3815: p_END_date in date) IS
3816: SELECT resale_batch_id
3817: FROM ozf_resale_batches
3818: WHERE data_source_code = p_data_source_code;
3819: */
3820:
3821: TYPE batch_set_tbl_type is TABLE OF NUMBER INDEX BY binary_integer;

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

Line 4044: OZF_RESALE_BATCHES_PKG.Insert_Row(

4040: l_currency_code_tbl(j));
4041: FETCH start_end_date_csr into l_start_date, l_end_date;
4042: CLOSE start_end_date_csr;
4043:
4044: OZF_RESALE_BATCHES_PKG.Insert_Row(
4045: px_resale_batch_id => l_resale_batch_id,
4046: px_object_version_number => l_obj_number,
4047: p_last_update_date => SYSdate,
4048: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),