[Home] [Help]
83: l_api_name CONSTANT VARCHAR2(30) := 'Pay_by_Open_Receipt';
84: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
85: l_return_status VARCHAR2(1);
86: ---
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;
95:
96: CURSOR csr_old_claim_investigation( cv_cash_receipt_id IN NUMBER
97: , cv_root_claim_id IN NUMBER) IS
98: SELECT rec.amount_applied
99: FROM ar_receivable_applications rec
100: WHERE rec.applied_payment_schedule_id = -4
101: AND rec.cash_receipt_id = cv_cash_receipt_id
102: AND rec.application_ref_type = 'CLAIM'
103: AND rec.display = 'Y'
115: , rec.application_ref_reason
116: , rec.customer_reference
117: , rec.amount_applied
118: , pay.amount_due_remaining
119: FROM ar_receivable_applications rec
120: , ar_payment_schedules pay
121: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
122: AND rec.cash_receipt_id = cv_cash_receipt_id
123: AND pay.customer_trx_id = cv_customer_trx_id
221: p_attribute_rec => NULL,
222: /*
223: -- ******* Global Flexfield parameters *******
224: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
225: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
226: */
227: x_application_ref_num => l_application_ref_num,
228: x_receivable_application_id => l_receivable_application_id,
229: x_applied_rec_app_id => l_applied_rec_app_id
407: p_attribute_rec => NULL,
408: /*
409: -- ******* Global Flexfield parameters *******
410: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
411: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
412: */
413: x_application_ref_num => l_application_ref_num,
414: x_receivable_application_id => l_receivable_application_id,
415: x_applied_rec_app_id => l_applied_rec_app_id
579: l_cm_amount NUMBER;
580: l_online_upd_ded_status BOOLEAN := FALSE;
581: l_orig_dispute_amount NUMBER;
582: l_cm_applied_on_rec_amt NUMBER;
583: l_apply_date ar_receivable_applications.apply_date%TYPE; -- Fix for Bug 3091401. TM passes old apply date
584:
585: CURSOR csr_old_applied_invoice( cv_cash_receipt_id IN NUMBER
586: , cv_customer_trx_id IN NUMBER
587: , cv_root_claim_id IN NUMBER ) IS
594: , rec.application_ref_reason
595: , rec.customer_reference
596: , rec.amount_applied
597: , pay.amount_due_remaining
598: FROM ar_receivable_applications rec
599: , ar_payment_schedules pay
600: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
601: AND rec.cash_receipt_id = cv_cash_receipt_id
602: AND pay.customer_trx_id = cv_customer_trx_id
607: l_old_applied_invoice csr_old_applied_invoice%ROWTYPE;
608:
609: CURSOR csr_claim_investigation_amount(cv_root_claim_id IN NUMBER) IS
610: SELECT amount_applied
611: FROM ar_receivable_applications
612: WHERE application_ref_type = 'CLAIM'
613: AND applied_payment_schedule_id = -4
614: AND display = 'Y'
615: AND secondary_application_ref_id = cv_root_claim_id;
615: AND secondary_application_ref_id = cv_root_claim_id;
616:
617: CURSOR csr_cm_exist_on_rec(cv_cash_receipt_id IN NUMBER, cv_customer_trx_id IN NUMBER) IS
618: SELECT amount_applied, apply_date -- Fix for Bug 3091401. TM passes old apply date
619: FROM ar_receivable_applications
620: WHERE cash_receipt_id = cv_cash_receipt_id
621: AND applied_customer_trx_id = cv_customer_trx_id
622: AND display = 'Y'
623: AND status = 'APP';
966: l_online_upd_ded_status BOOLEAN := FALSE;
967: l_orig_dispute_amount NUMBER;
968: l_payment_trx_number VARCHAR2(30);
969: l_dm_applied_on_rec_amt NUMBER;
970: l_apply_date ar_receivable_applications.apply_date%TYPE; -- Fix for Bug 3091401. TM passes old apply date
971:
972: CURSOR csr_dm_trx_type_id(cv_claim_type_id IN NUMBER) IS
973: SELECT dm_trx_type_id
974: FROM ozf_claim_types_all_b
975: WHERE claim_type_id = cv_claim_type_id;
976:
977: CURSOR csr_claim_investigation_amount(cv_root_claim_id IN NUMBER) IS
978: SELECT amount_applied
979: FROM ar_receivable_applications
980: WHERE application_ref_type = 'CLAIM'
981: AND applied_payment_schedule_id = -4
982: AND display = 'Y'
983: AND secondary_application_ref_id = cv_root_claim_id;
988: WHERE customer_trx_id = cv_customer_trx_id;
989:
990: CURSOR csr_dm_exist_on_rec(cv_cash_receipt_id IN NUMBER, cv_customer_trx_id IN NUMBER) IS
991: SELECT amount_applied, apply_date -- Fix for Bug 3091401. TM passes old apply date
992: FROM ar_receivable_applications
993: WHERE cash_receipt_id = cv_cash_receipt_id
994: AND applied_customer_trx_id = cv_customer_trx_id
995: AND display = 'Y'
996: AND status = 'APP';
1498: CURSOR csr_old_claim_investigation( cv_cash_receipt_id IN NUMBER
1499: , cv_root_claim_id IN NUMBER
1500: ) IS
1501: SELECT rec.amount_applied
1502: FROM ar_receivable_applications rec
1503: WHERE rec.applied_payment_schedule_id = -4
1504: AND rec.cash_receipt_id = cv_cash_receipt_id
1505: AND rec.application_ref_type = 'CLAIM'
1506: AND rec.display = 'Y'