DBA Data[Home] [Help]

APPS.OZF_SETTLEMENT_DOC_PVT dependencies on OZF_CLAIM_PVT

Line 696: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

692: | HISTORY
693: | 16-MAY-2002 mchang Create.
694: *=======================================================================*/
695: PROCEDURE Update_Claim_Tax_Amount(
696: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
697: ,x_return_status OUT NOCOPY VARCHAR2
698: ,x_msg_data OUT NOCOPY VARCHAR2
699: ,x_msg_count OUT NOCOPY NUMBER
700: )

Line 958: l_claim_rec OZF_CLAIM_PVT.claim_Rec_Type;

954: l_notif_id NUMBER;
955: l_note_id NUMBER;
956: l_sys_date DATE := SYSDATE;
957:
958: l_claim_rec OZF_CLAIM_PVT.claim_Rec_Type;
959:
960: CURSOR csr_customer_name(cv_cust_account_id IN NUMBER) IS
961: SELECT party_name
962: FROM hz_parties party,

Line 1015: OZF_CLAIM_PVT.Create_Claim_History (

1011: END IF;
1012:
1013:
1014: -- Make a call to maintain history
1015: OZF_CLAIM_PVT.Create_Claim_History (
1016: p_api_version => 1.0
1017: ,p_init_msg_list => FND_API.G_FALSE
1018: ,p_commit => FND_API.G_FALSE
1019: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1534: l_claim_rec OZF_CLAIM_PVT.claim_Rec_Type;

1530: l_api_name CONSTANT VARCHAR2(30) := 'Update_Claim_From_Settlement';
1531: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1532: l_return_status VARCHAR2(1);
1533:
1534: l_claim_rec OZF_CLAIM_PVT.claim_Rec_Type;
1535: l_claim_new_obj_num NUMBER;
1536:
1537: l_fund_rec OZF_Funds_PVT.fund_rec_type;
1538: l_function_currency VARCHAR2(15);

Line 2092: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type,

2088: -- HISTORY
2089: -- 28-MAR-2002 mchang Created.
2090: ---------------------------------------------------------------------
2091: PROCEDURE Split_Claim_Settlement(
2092: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type,
2093: p_difference_amount IN NUMBER,
2094:
2095: x_return_status OUT NOCOPY VARCHAR2,
2096: x_msg_count OUT NOCOPY NUMBER,

Line 2109: l_claim_rec OZF_CLAIM_PVT.claim_rec_type ;

2105: l_child_claim_tbl OZF_SPLIT_CLAIM_PVT.Child_Claim_tbl_type;
2106: l_claim_line_rec OZF_Claim_Line_PVT.claim_line_rec_type;
2107: l_claim_line_id NUMBER;
2108: l_root_claim_number VARCHAR2(30);
2109: l_claim_rec OZF_CLAIM_PVT.claim_rec_type ;
2110:
2111: BEGIN
2112: IF OZF_DEBUG_HIGH_ON THEN
2113: OZF_Utility_PVT.debug_message(l_full_name||' : start');

Line 2202: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type,

2198: -- HISTORY
2199: -- 19-Jan-2005 Sahana Created for Bug4087329
2200: ---------------------------------------------------------------------
2201: PROCEDURE Create_Write_Off(
2202: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type,
2203: p_customer_trx_id IN NUMBER,
2204: p_deduction_type IN VARCHAR2,
2205: p_difference_amount IN NUMBER,
2206:

Line 2229: l_claim_rec OZF_CLAIM_PVT.claim_rec_type ;

2225: l_claim_line_id NUMBER;
2226: l_settlement_doc_rec settlement_doc_rec_type;
2227: l_settlement_doc_id NUMBER;
2228: l_claim_object_version NUMBER;
2229: l_claim_rec OZF_CLAIM_PVT.claim_rec_type ;
2230: l_claim_line_rec OZF_Claim_Line_PVT.claim_line_rec_type;
2231:
2232: CURSOR csr_invoice_writeoff(cv_adjust_id IN NUMBER) IS
2233: SELECT adj.adjustment_id --"settlement_id"

Line 2363: p_claim_setl_rec IN OZF_CLAIM_PVT.claim_rec_type,

2359: -- HISTORY
2360: -- 14-NOV-2002 mchang Created.
2361: ---------------------------------------------------------------------
2362: PROCEDURE Process_RMA_settlement(
2363: p_claim_setl_rec IN OZF_CLAIM_PVT.claim_rec_type,
2364: p_settlement_doc_tbl IN settlement_doc_tbl_type,
2365: p_total_rma_cr_amount IN NUMBER,
2366:
2367: x_return_status OUT NOCOPY VARCHAR2,

Line 2378: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;

2374: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2375: l_return_status VARCHAR2(1);
2376:
2377: i NUMBER;
2378: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2379: l_upd_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2380: l_child_claim_tbl OZF_SPLIT_CLAIM_PVT.Child_Claim_tbl_type;
2381: l_settlement_doc_id NUMBER;
2382: l_unpaid_claim_line NUMBER;

Line 2379: l_upd_claim_rec OZF_CLAIM_PVT.claim_rec_type;

2375: l_return_status VARCHAR2(1);
2376:
2377: i NUMBER;
2378: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2379: l_upd_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2380: l_child_claim_tbl OZF_SPLIT_CLAIM_PVT.Child_Claim_tbl_type;
2381: l_settlement_doc_id NUMBER;
2382: l_unpaid_claim_line NUMBER;
2383: l_deduction_type VARCHAR2(30);

Line 2871: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;

2867: l_settlement_doc_rec settlement_doc_rec_type;
2868: l_settlement_doc_id NUMBER;
2869: l_upd_claim_status BOOLEAN := FALSE;
2870: l_deduction_type VARCHAR2(15);
2871: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2872: l_upd_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2873: l_cm_dm_total_amount NUMBER;
2874: l_difference_amount NUMBER;
2875: l_claim_new_obj_num NUMBER;

Line 2872: l_upd_claim_rec OZF_CLAIM_PVT.claim_rec_type;

2868: l_settlement_doc_id NUMBER;
2869: l_upd_claim_status BOOLEAN := FALSE;
2870: l_deduction_type VARCHAR2(15);
2871: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2872: l_upd_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2873: l_cm_dm_total_amount NUMBER;
2874: l_difference_amount NUMBER;
2875: l_claim_new_obj_num NUMBER;
2876:

Line 2882: l_claim_rma_fetch OZF_CLAIM_PVT.claim_tbl_type;

2878: TYPE ClaimCsrType IS REF CURSOR;
2879: c_get_claims_csr ClaimCsrType;
2880: --TYPE claim_id_ver_type IS TABLE OF c_get_claims_csr%ROWTYPE
2881: --INDEX BY BINARY_INTEGER;
2882: l_claim_rma_fetch OZF_CLAIM_PVT.claim_tbl_type;
2883: l_claim_rma_setl OZF_CLAIM_PVT.claim_tbl_type;
2884: l_claim_setl_rec OZF_CLAIM_PVT.claim_rec_type;
2885: l_counter NUMBER := 1;
2886: l_total_claim_line NUMBER;

Line 2883: l_claim_rma_setl OZF_CLAIM_PVT.claim_tbl_type;

2879: c_get_claims_csr ClaimCsrType;
2880: --TYPE claim_id_ver_type IS TABLE OF c_get_claims_csr%ROWTYPE
2881: --INDEX BY BINARY_INTEGER;
2882: l_claim_rma_fetch OZF_CLAIM_PVT.claim_tbl_type;
2883: l_claim_rma_setl OZF_CLAIM_PVT.claim_tbl_type;
2884: l_claim_setl_rec OZF_CLAIM_PVT.claim_rec_type;
2885: l_counter NUMBER := 1;
2886: l_total_claim_line NUMBER;
2887: l_paid_claim_line NUMBER;

Line 2884: l_claim_setl_rec OZF_CLAIM_PVT.claim_rec_type;

2880: --TYPE claim_id_ver_type IS TABLE OF c_get_claims_csr%ROWTYPE
2881: --INDEX BY BINARY_INTEGER;
2882: l_claim_rma_fetch OZF_CLAIM_PVT.claim_tbl_type;
2883: l_claim_rma_setl OZF_CLAIM_PVT.claim_tbl_type;
2884: l_claim_setl_rec OZF_CLAIM_PVT.claim_rec_type;
2885: l_counter NUMBER := 1;
2886: l_total_claim_line NUMBER;
2887: l_paid_claim_line NUMBER;
2888:

Line 3406: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;

3402: l_settlement_doc_rec settlement_doc_rec_type;
3403: l_settlement_doc_id NUMBER;
3404: l_upd_claim_status BOOLEAN := FALSE;
3405: l_deduction_type VARCHAR2(15);
3406: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
3407: l_upd_claim_rec OZF_CLAIM_PVT.claim_rec_type;
3408: l_cm_dm_total_amount NUMBER;
3409: l_cm_dm_amount NUMBER;
3410: l_cm_dm_tax_amount NUMBER;

Line 3407: l_upd_claim_rec OZF_CLAIM_PVT.claim_rec_type;

3403: l_settlement_doc_id NUMBER;
3404: l_upd_claim_status BOOLEAN := FALSE;
3405: l_deduction_type VARCHAR2(15);
3406: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
3407: l_upd_claim_rec OZF_CLAIM_PVT.claim_rec_type;
3408: l_cm_dm_total_amount NUMBER;
3409: l_cm_dm_amount NUMBER;
3410: l_cm_dm_tax_amount NUMBER;
3411: l_cm_dm_freight_amount NUMBER;

Line 3420: l_claim_id_ver OZF_CLAIM_PVT.claim_tbl_type;

3416: TYPE ClaimCsrType IS REF CURSOR;
3417: c_get_claims_csr ClaimCsrType;
3418: --TYPE claim_id_ver_type IS TABLE OF c_get_claims_csr%ROWTYPE
3419: --INDEX BY BINARY_INTEGER;
3420: l_claim_id_ver OZF_CLAIM_PVT.claim_tbl_type;
3421: l_counter NUMBER := 1;
3422:
3423: l_inv_bal_error BOOLEAN := FALSE;
3424: l_payment_method_tbl g_payment_method_tbl;

Line 4052: l_claim_id_ver OZF_CLAIM_PVT.claim_tbl_type;

4048: TYPE ClaimCsrType IS REF CURSOR;
4049: c_get_claims_csr ClaimCsrType;
4050: --TYPE claim_id_ver_type IS TABLE OF c_get_claims_csr%ROWTYPE
4051: --INDEX BY BINARY_INTEGER;
4052: l_claim_id_ver OZF_CLAIM_PVT.claim_tbl_type;
4053: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
4054: l_counter NUMBER := 1;
4055: l_invoice_amount NUMBER;
4056:

Line 4053: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;

4049: c_get_claims_csr ClaimCsrType;
4050: --TYPE claim_id_ver_type IS TABLE OF c_get_claims_csr%ROWTYPE
4051: --INDEX BY BINARY_INTEGER;
4052: l_claim_id_ver OZF_CLAIM_PVT.claim_tbl_type;
4053: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
4054: l_counter NUMBER := 1;
4055: l_invoice_amount NUMBER;
4056:
4057: l_payment_method_tbl g_payment_method_tbl;