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 947: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

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

Line 1208: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

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

Line 1344: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

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

Line 1477: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

1473: | HISTORY
1474: | 15-MAR-2002 mchang Create.
1475: *=======================================================================*/
1476: PROCEDURE Pay_by_On_Account_Credit(
1477: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
1478: ,p_deduction_type IN VARCHAR2
1479: ,p_credit_amount IN NUMBER
1480: ,p_settlement_doc_id IN NUMBER
1481:

Line 1698: l_claim_group_tbl OZF_Claim_PVT.claim_tbl_type;

1694: TYPE l_csr_claim_tbl IS TABLE OF csr_claims%ROWTYPE
1695: INDEX BY BINARY_INTEGER;
1696: --l_claim_group_tbl l_csr_claim_tbl;
1697: --l_claim_netting_tbl l_csr_claim_tbl;
1698: l_claim_group_tbl OZF_Claim_PVT.claim_tbl_type;
1699: l_claim_netting_tbl OZF_Claim_PVT.claim_tbl_type;
1700: l_settle_doc_group_tbl OZF_Settlement_Doc_PVT.settlement_doc_tbl_type;
1701: l_settle_doc_tbl OZF_Settlement_Doc_PVT.settlement_doc_tbl_type;
1702: l_settle_doc_tbl2 OZF_Settlement_Doc_PVT.settlement_doc_tbl_type;

Line 1699: l_claim_netting_tbl OZF_Claim_PVT.claim_tbl_type;

1695: INDEX BY BINARY_INTEGER;
1696: --l_claim_group_tbl l_csr_claim_tbl;
1697: --l_claim_netting_tbl l_csr_claim_tbl;
1698: l_claim_group_tbl OZF_Claim_PVT.claim_tbl_type;
1699: l_claim_netting_tbl OZF_Claim_PVT.claim_tbl_type;
1700: l_settle_doc_group_tbl OZF_Settlement_Doc_PVT.settlement_doc_tbl_type;
1701: l_settle_doc_tbl OZF_Settlement_Doc_PVT.settlement_doc_tbl_type;
1702: l_settle_doc_tbl2 OZF_Settlement_Doc_PVT.settlement_doc_tbl_type;
1703: l_settle_doc_id_tbl JTF_NUMBER_TABLE;

Line 2193: x_claim_tbl OUT NOCOPY OZF_Claim_PVT.claim_tbl_type,

2189: | 20-OCT-2003 mchang Create.
2190: *=======================================================================*/
2191: PROCEDURE Complete_Mass_Settlement(
2192: p_group_claim_id IN NUMBER,
2193: x_claim_tbl OUT NOCOPY OZF_Claim_PVT.claim_tbl_type,
2194: x_return_status OUT NOCOPY VARCHAR2,
2195: x_msg_data OUT NOCOPY VARCHAR2,
2196: x_msg_count OUT NOCOPY NUMBER
2197: )

Line 2221: l_claim_pvt_rec OZF_Claim_PVT.claim_rec_type;

2217: i NUMBER := 1;
2218: l_claim_obj_ver_num NUMBER;
2219: l_gl_date_type VARCHAR2(30);
2220:
2221: l_claim_pvt_rec OZF_Claim_PVT.claim_rec_type;
2222:
2223:
2224: BEGIN
2225: -------------------- initialize -----------------------

Line 2272: OZF_Claim_PVT.Update_Claim (

2268: FND_MESSAGE.Set_Token('TEXT', x_claim_tbl(i).claim_number);
2269: FND_MSG_PUB.Add;
2270: END IF;
2271:
2272: OZF_Claim_PVT.Update_Claim (
2273: p_api_version => l_api_version
2274: ,p_init_msg_list => FND_API.G_FALSE
2275: ,p_commit => FND_API.G_FALSE
2276: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2345: p_complete_claim_group_tbl IN OZF_Claim_PVT.claim_tbl_type,

2341: | 20-OCT-2003 mchang Create.
2342: *=======================================================================*/
2343: PROCEDURE Approve_Mass_Settlement(
2344: p_group_claim_id IN NUMBER,
2345: p_complete_claim_group_tbl IN OZF_Claim_PVT.claim_tbl_type,
2346: x_return_status OUT NOCOPY VARCHAR2,
2347: x_msg_data OUT NOCOPY VARCHAR2,
2348: x_msg_count OUT NOCOPY NUMBER
2349: )

Line 2356: l_complete_claim_group_tbl OZF_Claim_PVT.claim_tbl_type := p_complete_claim_group_tbl;

2352: l_api_name CONSTANT VARCHAR2(30) := 'Approve_Mass_Settlement';
2353: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2354: l_return_status VARCHAR2(1);
2355: ---
2356: l_complete_claim_group_tbl OZF_Claim_PVT.claim_tbl_type := p_complete_claim_group_tbl;
2357: l_claim_pvt_rec OZF_Claim_PVT.claim_rec_type;
2358: l_claim_obj_ver_num NUMBER;
2359: i BINARY_INTEGER;
2360: l_group_claim_obj_ver NUMBER;

Line 2357: l_claim_pvt_rec OZF_Claim_PVT.claim_rec_type;

2353: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2354: l_return_status VARCHAR2(1);
2355: ---
2356: l_complete_claim_group_tbl OZF_Claim_PVT.claim_tbl_type := p_complete_claim_group_tbl;
2357: l_claim_pvt_rec OZF_Claim_PVT.claim_rec_type;
2358: l_claim_obj_ver_num NUMBER;
2359: i BINARY_INTEGER;
2360: l_group_claim_obj_ver NUMBER;
2361: l_orig_status_id NUMBER;

Line 2412: OZF_Claim_PVT.Update_Claim (

2408: ,'PENDING_APPROVAL'
2409: );
2410: l_claim_pvt_rec.status_code := 'PENDING_APPROVAL';
2411:
2412: OZF_Claim_PVT.Update_Claim (
2413: p_api_version => l_api_version
2414: ,p_init_msg_list => FND_API.G_FALSE
2415: ,p_commit => FND_API.G_FALSE
2416: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2714: l_claim_rec OZF_Claim_PVT.claim_rec_type;

2710: TYPE number_tbl IS TABLE OF NUMBER
2711: INDEX BY BINARY_INTEGER;
2712:
2713: l_claim_id_tbl number_tbl;
2714: l_claim_rec OZF_Claim_PVT.claim_rec_type;
2715: l_settlement_doc_tbl OZF_Settlement_Doc_PVT.settlement_doc_tbl_type;
2716: l_deduction_type VARCHAR2(30);
2717: l_settlement_id NUMBER;
2718: i NUMBER := 1;

Line 3096: l_ded_claim_tbl OZF_Claim_PVT.claim_tbl_type;

3092: acctd_amount_adjusted
3093: FROM ozf_claims_all
3094: WHERE claim_id =p_claim_id;
3095:
3096: l_ded_claim_tbl OZF_Claim_PVT.claim_tbl_type;
3097: l_opm_claim_tbl OZF_Claim_PVT.claim_tbl_type;
3098: l_settle_doc_tbl OZF_Settlement_Doc_Pvt.settlement_doc_tbl_type;
3099: l_split_claim_tbl OZF_Split_Claim_PVT.child_claim_tbl_type;
3100: l_idx_ded NUMBER := 1;

Line 3097: l_opm_claim_tbl OZF_Claim_PVT.claim_tbl_type;

3093: FROM ozf_claims_all
3094: WHERE claim_id =p_claim_id;
3095:
3096: l_ded_claim_tbl OZF_Claim_PVT.claim_tbl_type;
3097: l_opm_claim_tbl OZF_Claim_PVT.claim_tbl_type;
3098: l_settle_doc_tbl OZF_Settlement_Doc_Pvt.settlement_doc_tbl_type;
3099: l_split_claim_tbl OZF_Split_Claim_PVT.child_claim_tbl_type;
3100: l_idx_ded NUMBER := 1;
3101: l_idx_opm NUMBER := 1;

Line 3103: l_group_claim_rec OZF_Claim_PVT.claim_rec_type;

3099: l_split_claim_tbl OZF_Split_Claim_PVT.child_claim_tbl_type;
3100: l_idx_ded NUMBER := 1;
3101: l_idx_opm NUMBER := 1;
3102:
3103: l_group_claim_rec OZF_Claim_PVT.claim_rec_type;
3104: l_group_claim_id NUMBER;
3105: l_group_claim_line_tbl OZF_Claim_Line_PVT.claim_line_tbl_type;
3106: l_group_settle_doc_tbl OZF_Settlement_Doc_Pvt.settlement_doc_tbl_type;
3107: l_group_settle_doc_id_tbl JTF_NUMBER_TABLE;

Line 3126: l_complete_claim_group_tbl OZF_Claim_PVT.claim_tbl_type;

3122: l_settlement_type VARCHAR2(30);
3123: l_claim_amount_rem NUMBER;
3124: l_obj_ver_num NUMBER;
3125:
3126: l_complete_claim_group_tbl OZF_Claim_PVT.claim_tbl_type;
3127: i BINARY_INTEGER;
3128: l_appr_req VARCHAR2(1);
3129:
3130:

Line 3388: OZF_Claim_PVT.Create_Claim (

3384: CLOSE csr_get_set_of_books;
3385: --l_group_claim_rec.currency_code := 'USD';
3386: l_group_claim_rec.payment_method := 'MASS_SETTLEMENT';
3387:
3388: OZF_Claim_PVT.Create_Claim (
3389: p_api_version => l_api_version
3390: ,p_init_msg_list => FND_API.G_FALSE
3391: ,p_commit => FND_API.G_FALSE
3392: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL