DBA Data[Home] [Help]

APPS.OZF_MASS_SETTLEMENT_PVT dependencies on OZF_CLAIM_PVT

Line 69: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

65: | HISTORY
66: | 30-OCT-2003 mchang Create.
67: *=======================================================================*/
68: PROCEDURE Pay_by_Open_Receipt(
69: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
70: ,p_deduction_type IN VARCHAR2
71: ,p_open_receipt_id IN NUMBER
72:
73: ,p_payment_claim_id IN NUMBER

Line 91: l_payment_claim_rec OZF_Claim_PVT.claim_rec_type;

87: l_application_ref_num AR_RECEIVABLE_APPLICATIONS.application_ref_num%TYPE;
88: l_receivable_application_id NUMBER;
89: l_applied_rec_app_id NUMBER;
90:
91: l_payment_claim_rec OZF_Claim_PVT.claim_rec_type;
92:
93: l_recpt_old_applied_amt NUMBER;
94: l_recpt_new_applied_amt NUMBER;
95:

Line 559: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

555: | HISTORY
556: | 15-MAR-2002 mchang Create.
557: *=======================================================================*/
558: PROCEDURE Pay_by_Credit_Memo(
559: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
560: ,p_deduction_type IN VARCHAR2
561: ,p_payment_reference_id IN NUMBER
562: ,p_credit_memo_amount IN NUMBER
563: ,p_settlement_doc_id IN NUMBER

Line 949: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

945: | HISTORY
946: | 15-MAR-2002 mchang Create.
947: *=======================================================================*/
948: PROCEDURE Pay_by_Debit_Memo(
949: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
950: ,p_deduction_type IN VARCHAR2
951: ,p_payment_reference_id IN NUMBER
952: ,p_debit_memo_amount IN NUMBER
953: ,p_settlement_doc_id IN NUMBER

Line 1212: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

1208: | HISTORY
1209: | 15-MAR-2002 mchang Create.
1210: *=======================================================================*/
1211: PROCEDURE Pay_by_Chargeback(
1212: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
1213: ,p_deduction_type IN VARCHAR2
1214: ,p_chargeback_amount IN NUMBER
1215: ,p_settlement_doc_id IN NUMBER
1216: ,p_gl_date IN DATE

Line 1348: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

1344: | HISTORY
1345: | 15-MAR-2002 mchang Create.
1346: *=======================================================================*/
1347: PROCEDURE Pay_by_Write_Off(
1348: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
1349: ,p_deduction_type IN VARCHAR2
1350: ,p_write_off_amount IN NUMBER
1351: ,p_settlement_doc_id IN NUMBER
1352: ,p_gl_date IN DATE

Line 1483: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

1479: | HISTORY
1480: | 15-MAR-2002 mchang Create.
1481: *=======================================================================*/
1482: PROCEDURE Pay_by_On_Account_Credit(
1483: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
1484: ,p_deduction_type IN VARCHAR2
1485: ,p_credit_amount IN NUMBER
1486: ,p_settlement_doc_id IN NUMBER
1487:

Line 1704: l_claim_group_tbl OZF_Claim_PVT.claim_tbl_type;

1700: TYPE l_csr_claim_tbl IS TABLE OF csr_claims%ROWTYPE
1701: INDEX BY BINARY_INTEGER;
1702: --l_claim_group_tbl l_csr_claim_tbl;
1703: --l_claim_netting_tbl l_csr_claim_tbl;
1704: l_claim_group_tbl OZF_Claim_PVT.claim_tbl_type;
1705: l_claim_netting_tbl OZF_Claim_PVT.claim_tbl_type;
1706: l_settle_doc_group_tbl OZF_Settlement_Doc_PVT.settlement_doc_tbl_type;
1707: l_settle_doc_tbl OZF_Settlement_Doc_PVT.settlement_doc_tbl_type;
1708: l_settle_doc_tbl2 OZF_Settlement_Doc_PVT.settlement_doc_tbl_type;

Line 1705: l_claim_netting_tbl OZF_Claim_PVT.claim_tbl_type;

1701: INDEX BY BINARY_INTEGER;
1702: --l_claim_group_tbl l_csr_claim_tbl;
1703: --l_claim_netting_tbl l_csr_claim_tbl;
1704: l_claim_group_tbl OZF_Claim_PVT.claim_tbl_type;
1705: l_claim_netting_tbl OZF_Claim_PVT.claim_tbl_type;
1706: l_settle_doc_group_tbl OZF_Settlement_Doc_PVT.settlement_doc_tbl_type;
1707: l_settle_doc_tbl OZF_Settlement_Doc_PVT.settlement_doc_tbl_type;
1708: l_settle_doc_tbl2 OZF_Settlement_Doc_PVT.settlement_doc_tbl_type;
1709: l_settle_doc_id_tbl JTF_NUMBER_TABLE;

Line 2199: x_claim_tbl OUT NOCOPY OZF_Claim_PVT.claim_tbl_type,

2195: | 20-OCT-2003 mchang Create.
2196: *=======================================================================*/
2197: PROCEDURE Complete_Mass_Settlement(
2198: p_group_claim_id IN NUMBER,
2199: x_claim_tbl OUT NOCOPY OZF_Claim_PVT.claim_tbl_type,
2200: x_return_status OUT NOCOPY VARCHAR2,
2201: x_msg_data OUT NOCOPY VARCHAR2,
2202: x_msg_count OUT NOCOPY NUMBER
2203: )

Line 2227: l_claim_pvt_rec OZF_Claim_PVT.claim_rec_type;

2223: i NUMBER := 1;
2224: l_claim_obj_ver_num NUMBER;
2225: l_gl_date_type VARCHAR2(30);
2226:
2227: l_claim_pvt_rec OZF_Claim_PVT.claim_rec_type;
2228:
2229:
2230: BEGIN
2231: -------------------- initialize -----------------------

Line 2278: OZF_Claim_PVT.Update_Claim (

2274: FND_MESSAGE.Set_Token('TEXT', x_claim_tbl(i).claim_number);
2275: FND_MSG_PUB.Add;
2276: END IF;
2277:
2278: OZF_Claim_PVT.Update_Claim (
2279: p_api_version => l_api_version
2280: ,p_init_msg_list => FND_API.G_FALSE
2281: ,p_commit => FND_API.G_FALSE
2282: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2351: p_complete_claim_group_tbl IN OZF_Claim_PVT.claim_tbl_type,

2347: | 20-OCT-2003 mchang Create.
2348: *=======================================================================*/
2349: PROCEDURE Approve_Mass_Settlement(
2350: p_group_claim_id IN NUMBER,
2351: p_complete_claim_group_tbl IN OZF_Claim_PVT.claim_tbl_type,
2352: x_return_status OUT NOCOPY VARCHAR2,
2353: x_msg_data OUT NOCOPY VARCHAR2,
2354: x_msg_count OUT NOCOPY NUMBER
2355: )

Line 2362: l_complete_claim_group_tbl OZF_Claim_PVT.claim_tbl_type := p_complete_claim_group_tbl;

2358: l_api_name CONSTANT VARCHAR2(30) := 'Approve_Mass_Settlement';
2359: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2360: l_return_status VARCHAR2(1);
2361: ---
2362: l_complete_claim_group_tbl OZF_Claim_PVT.claim_tbl_type := p_complete_claim_group_tbl;
2363: l_claim_pvt_rec OZF_Claim_PVT.claim_rec_type;
2364: l_claim_obj_ver_num NUMBER;
2365: i BINARY_INTEGER;
2366: l_group_claim_obj_ver NUMBER;

Line 2363: l_claim_pvt_rec OZF_Claim_PVT.claim_rec_type;

2359: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2360: l_return_status VARCHAR2(1);
2361: ---
2362: l_complete_claim_group_tbl OZF_Claim_PVT.claim_tbl_type := p_complete_claim_group_tbl;
2363: l_claim_pvt_rec OZF_Claim_PVT.claim_rec_type;
2364: l_claim_obj_ver_num NUMBER;
2365: i BINARY_INTEGER;
2366: l_group_claim_obj_ver NUMBER;
2367: l_orig_status_id NUMBER;

Line 2433: OZF_Claim_PVT.Update_Claim (

2429: ,'PENDING_APPROVAL'
2430: );
2431: l_claim_pvt_rec.status_code := 'PENDING_APPROVAL';
2432:
2433: OZF_Claim_PVT.Update_Claim (
2434: p_api_version => l_api_version
2435: ,p_init_msg_list => FND_API.G_FALSE
2436: ,p_commit => FND_API.G_FALSE
2437: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2735: l_claim_rec OZF_Claim_PVT.claim_rec_type;

2731: TYPE number_tbl IS TABLE OF NUMBER
2732: INDEX BY BINARY_INTEGER;
2733:
2734: l_claim_id_tbl number_tbl;
2735: l_claim_rec OZF_Claim_PVT.claim_rec_type;
2736: l_settlement_doc_tbl OZF_Settlement_Doc_PVT.settlement_doc_tbl_type;
2737: l_deduction_type VARCHAR2(30);
2738: l_settlement_id NUMBER;
2739: i NUMBER := 1;

Line 2751: l_claim_rec_hist OZF_CLAIM_PVT.claim_rec_type;

2747: l_claim_history_id NUMBER := null;
2748:
2749: l_status_code VARCHAR2(30) := NULL;
2750: l_user_status_id NUMBER := NULL;
2751: l_claim_rec_hist OZF_CLAIM_PVT.claim_rec_type;
2752:
2753: CURSOR cur_current_status (p_claim_id IN NUMBER)IS
2754: SELECT status_code,
2755: user_status_id

Line 3236: l_ded_claim_tbl OZF_Claim_PVT.claim_tbl_type;

3232: amount_adjusted
3233: FROM ozf_claims_all
3234: WHERE claim_id =p_claim_id;
3235:
3236: l_ded_claim_tbl OZF_Claim_PVT.claim_tbl_type;
3237: l_opm_claim_tbl OZF_Claim_PVT.claim_tbl_type;
3238: l_settle_doc_tbl OZF_Settlement_Doc_Pvt.settlement_doc_tbl_type;
3239: l_split_claim_tbl OZF_Split_Claim_PVT.child_claim_tbl_type;
3240: l_idx_ded NUMBER := 1;

Line 3237: l_opm_claim_tbl OZF_Claim_PVT.claim_tbl_type;

3233: FROM ozf_claims_all
3234: WHERE claim_id =p_claim_id;
3235:
3236: l_ded_claim_tbl OZF_Claim_PVT.claim_tbl_type;
3237: l_opm_claim_tbl OZF_Claim_PVT.claim_tbl_type;
3238: l_settle_doc_tbl OZF_Settlement_Doc_Pvt.settlement_doc_tbl_type;
3239: l_split_claim_tbl OZF_Split_Claim_PVT.child_claim_tbl_type;
3240: l_idx_ded NUMBER := 1;
3241: l_idx_opm NUMBER := 1;

Line 3243: l_group_claim_rec OZF_Claim_PVT.claim_rec_type;

3239: l_split_claim_tbl OZF_Split_Claim_PVT.child_claim_tbl_type;
3240: l_idx_ded NUMBER := 1;
3241: l_idx_opm NUMBER := 1;
3242:
3243: l_group_claim_rec OZF_Claim_PVT.claim_rec_type;
3244: l_group_claim_id NUMBER;
3245: l_group_claim_line_tbl OZF_Claim_Line_PVT.claim_line_tbl_type;
3246: l_group_settle_doc_tbl OZF_Settlement_Doc_Pvt.settlement_doc_tbl_type;
3247: l_group_settle_doc_id_tbl JTF_NUMBER_TABLE;

Line 3266: l_complete_claim_group_tbl OZF_Claim_PVT.claim_tbl_type;

3262: l_settlement_type VARCHAR2(30);
3263: l_claim_amount_rem NUMBER;
3264: l_obj_ver_num NUMBER;
3265:
3266: l_complete_claim_group_tbl OZF_Claim_PVT.claim_tbl_type;
3267: i BINARY_INTEGER;
3268: l_appr_req VARCHAR2(1);
3269:
3270:

Line 3543: OZF_Claim_PVT.Create_Claim (

3539: CLOSE csr_get_set_of_books;
3540: --l_group_claim_rec.currency_code := 'USD';
3541: l_group_claim_rec.payment_method := 'MASS_SETTLEMENT';
3542:
3543: OZF_Claim_PVT.Create_Claim (
3544: p_api_version => l_api_version
3545: ,p_init_msg_list => FND_API.G_FALSE
3546: ,p_commit => FND_API.G_FALSE
3547: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL