DBA Data[Home] [Help]

APPS.OZF_SETTLEMENT_DOC_PVT dependencies on OZF_CLAIM_PVT

Line 920: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

916: | HISTORY
917: | 16-MAY-2002 mchang Create.
918: *=======================================================================*/
919: PROCEDURE Update_Claim_Tax_Amount(
920: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
921: ,x_return_status OUT NOCOPY VARCHAR2
922: ,x_msg_data OUT NOCOPY VARCHAR2
923: ,x_msg_count OUT NOCOPY NUMBER
924: )

Line 1193: l_claim_rec OZF_CLAIM_PVT.claim_Rec_Type;

1189: l_notif_id NUMBER;
1190: l_note_id NUMBER;
1191: l_sys_date DATE := SYSDATE;
1192:
1193: l_claim_rec OZF_CLAIM_PVT.claim_Rec_Type;
1194:
1195: CURSOR csr_customer_name(cv_cust_account_id IN NUMBER) IS
1196: SELECT party_name
1197: FROM hz_parties party,

Line 1250: OZF_CLAIM_PVT.Create_Claim_History (

1246: END IF;
1247:
1248:
1249: -- Make a call to maintain history
1250: OZF_CLAIM_PVT.Create_Claim_History (
1251: p_api_version => 1.0
1252: ,p_init_msg_list => FND_API.G_FALSE
1253: ,p_commit => FND_API.G_FALSE
1254: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1883: l_claim_rec OZF_CLAIM_PVT.claim_Rec_Type;

1879: l_api_name CONSTANT VARCHAR2(30) := 'Update_Claim_From_Settlement';
1880: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1881: l_return_status VARCHAR2(1);
1882:
1883: l_claim_rec OZF_CLAIM_PVT.claim_Rec_Type;
1884: l_claim_new_obj_num NUMBER;
1885:
1886: l_fund_rec OZF_Funds_PVT.fund_rec_type;
1887: l_function_currency VARCHAR2(15);

Line 2564: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type,

2560: -- HISTORY
2561: -- 28-MAR-2002 mchang Created.
2562: ---------------------------------------------------------------------
2563: PROCEDURE Split_Claim_Settlement(
2564: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type,
2565: p_difference_amount IN NUMBER,
2566:
2567: x_return_status OUT NOCOPY VARCHAR2,
2568: x_msg_count OUT NOCOPY NUMBER,

Line 2581: l_claim_rec OZF_CLAIM_PVT.claim_rec_type ;

2577: l_child_claim_tbl OZF_SPLIT_CLAIM_PVT.Child_Claim_tbl_type;
2578: l_claim_line_rec OZF_Claim_Line_PVT.claim_line_rec_type;
2579: l_claim_line_id NUMBER;
2580: l_root_claim_number VARCHAR2(30);
2581: l_claim_rec OZF_CLAIM_PVT.claim_rec_type ;
2582:
2583: BEGIN
2584: IF OZF_DEBUG_HIGH_ON THEN
2585: OZF_Utility_PVT.debug_message(l_full_name||' : start');

Line 2674: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type,

2670: -- HISTORY
2671: -- 19-Jan-2005 Sahana Created for Bug4087329
2672: ---------------------------------------------------------------------
2673: PROCEDURE Create_Write_Off(
2674: p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type,
2675: p_customer_trx_id IN NUMBER,
2676: p_deduction_type IN VARCHAR2,
2677: p_difference_amount IN NUMBER,
2678:

Line 2701: l_claim_rec OZF_CLAIM_PVT.claim_rec_type ;

2697: l_claim_line_id NUMBER;
2698: l_settlement_doc_rec settlement_doc_rec_type;
2699: l_settlement_doc_id NUMBER;
2700: l_claim_object_version NUMBER;
2701: l_claim_rec OZF_CLAIM_PVT.claim_rec_type ;
2702: l_claim_line_rec OZF_Claim_Line_PVT.claim_line_rec_type;
2703:
2704: CURSOR csr_invoice_writeoff(cv_adjust_id IN NUMBER) IS
2705: SELECT adj.adjustment_id --"settlement_id"

Line 2835: p_claim_setl_rec IN OZF_CLAIM_PVT.claim_rec_type,

2831: -- HISTORY
2832: -- 14-NOV-2002 mchang Created.
2833: ---------------------------------------------------------------------
2834: PROCEDURE Process_RMA_settlement(
2835: p_claim_setl_rec IN OZF_CLAIM_PVT.claim_rec_type,
2836: p_settlement_doc_tbl IN settlement_doc_tbl_type,
2837: p_total_rma_cr_amount IN NUMBER,
2838:
2839: x_return_status OUT NOCOPY VARCHAR2,

Line 2850: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;

2846: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2847: l_return_status VARCHAR2(1);
2848:
2849: i NUMBER;
2850: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2851: l_upd_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2852: l_child_claim_tbl OZF_SPLIT_CLAIM_PVT.Child_Claim_tbl_type;
2853: l_settlement_doc_id NUMBER;
2854: l_unpaid_claim_line NUMBER;

Line 2851: l_upd_claim_rec OZF_CLAIM_PVT.claim_rec_type;

2847: l_return_status VARCHAR2(1);
2848:
2849: i NUMBER;
2850: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2851: l_upd_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2852: l_child_claim_tbl OZF_SPLIT_CLAIM_PVT.Child_Claim_tbl_type;
2853: l_settlement_doc_id NUMBER;
2854: l_unpaid_claim_line NUMBER;
2855: l_deduction_type VARCHAR2(30);

Line 3343: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;

3339: l_settlement_doc_rec settlement_doc_rec_type;
3340: l_settlement_doc_id NUMBER;
3341: l_upd_claim_status BOOLEAN := FALSE;
3342: l_deduction_type VARCHAR2(15);
3343: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
3344: l_upd_claim_rec OZF_CLAIM_PVT.claim_rec_type;
3345: l_cm_dm_total_amount NUMBER;
3346: l_difference_amount NUMBER;
3347: l_claim_new_obj_num NUMBER;

Line 3344: l_upd_claim_rec OZF_CLAIM_PVT.claim_rec_type;

3340: l_settlement_doc_id NUMBER;
3341: l_upd_claim_status BOOLEAN := FALSE;
3342: l_deduction_type VARCHAR2(15);
3343: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
3344: l_upd_claim_rec OZF_CLAIM_PVT.claim_rec_type;
3345: l_cm_dm_total_amount NUMBER;
3346: l_difference_amount NUMBER;
3347: l_claim_new_obj_num NUMBER;
3348:

Line 3354: l_claim_rma_fetch OZF_CLAIM_PVT.claim_tbl_type;

3350: TYPE ClaimCsrType IS REF CURSOR;
3351: c_get_claims_csr ClaimCsrType;
3352: --TYPE claim_id_ver_type IS TABLE OF c_get_claims_csr%ROWTYPE
3353: --INDEX BY BINARY_INTEGER;
3354: l_claim_rma_fetch OZF_CLAIM_PVT.claim_tbl_type;
3355: l_claim_rma_setl OZF_CLAIM_PVT.claim_tbl_type;
3356: l_claim_setl_rec OZF_CLAIM_PVT.claim_rec_type;
3357: l_counter NUMBER := 1;
3358: l_total_claim_line NUMBER;

Line 3355: l_claim_rma_setl OZF_CLAIM_PVT.claim_tbl_type;

3351: c_get_claims_csr ClaimCsrType;
3352: --TYPE claim_id_ver_type IS TABLE OF c_get_claims_csr%ROWTYPE
3353: --INDEX BY BINARY_INTEGER;
3354: l_claim_rma_fetch OZF_CLAIM_PVT.claim_tbl_type;
3355: l_claim_rma_setl OZF_CLAIM_PVT.claim_tbl_type;
3356: l_claim_setl_rec OZF_CLAIM_PVT.claim_rec_type;
3357: l_counter NUMBER := 1;
3358: l_total_claim_line NUMBER;
3359: l_paid_claim_line NUMBER;

Line 3356: l_claim_setl_rec OZF_CLAIM_PVT.claim_rec_type;

3352: --TYPE claim_id_ver_type IS TABLE OF c_get_claims_csr%ROWTYPE
3353: --INDEX BY BINARY_INTEGER;
3354: l_claim_rma_fetch OZF_CLAIM_PVT.claim_tbl_type;
3355: l_claim_rma_setl OZF_CLAIM_PVT.claim_tbl_type;
3356: l_claim_setl_rec OZF_CLAIM_PVT.claim_rec_type;
3357: l_counter NUMBER := 1;
3358: l_total_claim_line NUMBER;
3359: l_paid_claim_line NUMBER;
3360:

Line 3878: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;

3874: l_settlement_doc_rec settlement_doc_rec_type;
3875: l_settlement_doc_id NUMBER;
3876: l_upd_claim_status BOOLEAN := FALSE;
3877: l_deduction_type VARCHAR2(15);
3878: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
3879: l_upd_claim_rec OZF_CLAIM_PVT.claim_rec_type;
3880: l_cm_dm_total_amount NUMBER;
3881: l_cm_dm_amount NUMBER;
3882: l_cm_dm_tax_amount NUMBER;

Line 3879: l_upd_claim_rec OZF_CLAIM_PVT.claim_rec_type;

3875: l_settlement_doc_id NUMBER;
3876: l_upd_claim_status BOOLEAN := FALSE;
3877: l_deduction_type VARCHAR2(15);
3878: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
3879: l_upd_claim_rec OZF_CLAIM_PVT.claim_rec_type;
3880: l_cm_dm_total_amount NUMBER;
3881: l_cm_dm_amount NUMBER;
3882: l_cm_dm_tax_amount NUMBER;
3883: l_cm_dm_freight_amount NUMBER;

Line 3892: l_claim_id_ver OZF_CLAIM_PVT.claim_tbl_type;

3888: TYPE ClaimCsrType IS REF CURSOR;
3889: c_get_claims_csr ClaimCsrType;
3890: --TYPE claim_id_ver_type IS TABLE OF c_get_claims_csr%ROWTYPE
3891: --INDEX BY BINARY_INTEGER;
3892: l_claim_id_ver OZF_CLAIM_PVT.claim_tbl_type;
3893: l_counter NUMBER := 1;
3894:
3895: l_inv_bal_error BOOLEAN := FALSE;
3896: l_payment_method_tbl g_payment_method_tbl;

Line 4537: l_claim_id_ver OZF_CLAIM_PVT.claim_tbl_type;

4533: TYPE ClaimCsrType IS REF CURSOR;
4534: c_get_claims_csr ClaimCsrType;
4535: --TYPE claim_id_ver_type IS TABLE OF c_get_claims_csr%ROWTYPE
4536: --INDEX BY BINARY_INTEGER;
4537: l_claim_id_ver OZF_CLAIM_PVT.claim_tbl_type;
4538: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
4539: l_counter NUMBER := 1;
4540: l_invoice_amount NUMBER;
4541:

Line 4538: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;

4534: c_get_claims_csr ClaimCsrType;
4535: --TYPE claim_id_ver_type IS TABLE OF c_get_claims_csr%ROWTYPE
4536: --INDEX BY BINARY_INTEGER;
4537: l_claim_id_ver OZF_CLAIM_PVT.claim_tbl_type;
4538: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
4539: l_counter NUMBER := 1;
4540: l_invoice_amount NUMBER;
4541:
4542: l_payment_method_tbl g_payment_method_tbl;