[Home] [Help]
1840: IS
1841: SELECT apsi.invoice_id invoice_id,
1842: apsi.payment_num payment_num,
1843: apin.invoice_currency_code invoice_curr_code
1844: FROM ap_selected_invoices apsi,
1845: ap_selected_invoice_checks apsic,
1846: unique_ref2 invoice_id,
1847: docs.calling_app_doc_uniq
1848: ap_invoices apin
2261: jl_zz_ap_inv_dis_wh jlwh,
2262: ap_invoices apin,
2263: ap_invoice_distributions apid,
2264: -- Payment Exchange Rate ER 8648739 Start 3
2265: ap_selected_invoices apsi,
2266: -- Payment Exchange Rate ER 8648739 End 3
2267: iby_hook_docs_in_pmt_t docs,
2268: jl_zz_ap_supp_awt_types jlst,
2269: jl_zz_ap_sup_awt_cd jlsc,
3455: docs.document_amount* nvl(apsi.invoice_exchange_rate,1) payment_amount,
3456: docs.calling_app_doc_unique_ref3 payment_num
3457: FROM ap_invoices apin,
3458: ap_invoice_distributions apid,
3459: ap_selected_invoices apsi,
3460: iby_hook_docs_in_pmt_t docs
3461: WHERE apin.invoice_id = apid.invoice_id
3462: AND apin.invoice_id = apsi.invoice_id
3463: -- AND apsi.pay_selected_check_id = P_Selected_Check_Id
3489: -- Payment Exchange Rate ER 8648739 End 8
3490: docs.calling_app_doc_unique_ref3 payment_num
3491: FROM ap_invoices apin,
3492: ap_invoice_distributions apid,
3493: ap_selected_invoices apsi,
3494: iby_hook_docs_in_pmt_t docs
3495: WHERE apin.invoice_id = apid.invoice_id
3496: AND apin.invoice_id = apsi.invoice_id
3497: -- AND apsi.pay_selected_check_id = P_Selected_Check_Id
5006: apsi.payment_num payment_num,
5007: apsi.payment_amount payment_amount,
5008: nvl(apsi.invoice_exchange_rate, 1) invoice_exchange_rate,
5009: nvl(apsi.payment_cross_rate, 1) payment_cross_rate
5010: FROM ap_selected_invoices apsi
5011: WHERE apsi.pay_selected_check_id = P_Selected_Check_id
5012: AND nvl(apsi.ok_to_pay_flag, 'Y') = 'Y'
5013: AND apsi.original_invoice_id IS NULL
5014: FOR UPDATE;
5022: nvl(apsi.payment_exchange_rate, 1) payment_exchange_rate,
5023: -- Payment Exchange Rate ER 8648739 End 9
5024: nvl(apsi.payment_cross_rate, 1) payment_cross_rate
5025: FROM iby_hook_docs_in_pmt_t docs,
5026: ap_selected_invoices apsi
5027: WHERE docs.payment_id = P_Selected_Check_id
5028: AND docs.calling_app_id = 200
5029: AND apsi.invoice_id = docs.calling_app_doc_unique_ref2
5030: AND nvl(docs.dont_pay_flag,'N')='N';
5089: -----------------------------------------------------------------------------
5090: SELECT count(*)
5091: INTO l_count_inv
5092: FROM iby_hook_docs_in_pmt_t docs,
5093: -- RG ap_selected_invoices apsi,
5094: ap_awt_temp_distributions awtd
5095: WHERE docs.payment_id = P_Selected_Check_Id
5096: AND nvl(docs.dont_pay_flag,'N') ='N'
5097: AND docs.calling_app_doc_unique_ref2 = awtd.invoice_id
5112: return;
5113: END IF;
5114:
5115: -- Bug2175168. Store the the Proposed Payment Amount so that this can be utilized to correct
5116: -- the check amount. Since the standard AP build only updates the AP_SELECTED_INVOICES while
5117: -- updating the check amount we need to consider this rather than the existing check amount.
5118: -- This would however be redundant when we Rebuild the batch.
5119:
5120: SELECT SUM(docs.document_amount)
5119:
5120: SELECT SUM(docs.document_amount)
5121: INTO l_prop_payment_amount
5122: FROM iby_hook_docs_in_pmt_t docs
5123: -- ap_selected_invoices apsi
5124: WHERE docs.payment_id = P_Selected_Check_Id
5125: AND nvl(docs.dont_pay_flag,'N') ='N'
5126: AND docs.calling_app_id =200;
5127:
5219: -- using the local variable instead.
5220: -------------------------------------------------------
5221:
5222: -- RG Update Documents in PMT table
5223: -- As discussed with Ryan , we will keep updating ap selected invoices
5224:
5225: UPDATE ap_selected_invoices apsi
5226: SET apsi.proposed_payment_amount = ap_utilities_pkg.ap_round_currency(
5227: apsi.proposed_payment_amount - l_withholding_amount,
5221:
5222: -- RG Update Documents in PMT table
5223: -- As discussed with Ryan , we will keep updating ap selected invoices
5224:
5225: UPDATE ap_selected_invoices apsi
5226: SET apsi.proposed_payment_amount = ap_utilities_pkg.ap_round_currency(
5227: apsi.proposed_payment_amount - l_withholding_amount,
5228: l_payment_currency_code),
5229: apsi.payment_amount = ap_utilities_pkg.ap_round_currency(
5567: nvl(apsi.payment_cross_rate, 1) *
5568: nvl(apsi.invoice_exchange_rate, 1)), 0)
5569: INTO l_payment_amount
5570: FROM iby_hook_docs_in_pmt_t docs,
5571: ap_selected_invoices apsi
5572: WHERE docs.payment_id = P_Selected_Check_id
5573: AND apsi.invoice_id = docs.calling_app_doc_unique_ref2
5574: AND docs.dont_pay_flag = 'N'
5575: -- AND apsi.pay_selected_check_id = P_Selected_Check_id
5588: asi.vendor_site_code
5589: INTO l_vendor_name,
5590: l_vendor_site_code
5591: FROM IBY_HOOK_DOCS_IN_PMT_T docs,
5592: ap_selected_invoices_all asi
5593: WHERE docs.payment_id = P_Selected_Check_id
5594: AND docs.calling_app_doc_unique_ref2 = asi.invoice_id
5595: AND docs.calling_app_id=200;
5596: */
5789: -- apsi.ok_to_pay_flag ok_to_pay_flag,
5790: -- apsi.dont_pay_reason_code dont_pay_reason_code,
5791: -- apsi.dont_pay_description dont_pay_description
5792: FROM iby_hook_docs_in_pmt_t docs
5793: -- ap_selected_invoices apsi
5794: WHERE docs.payment_id = P_Selected_Check_id
5795: AND docs.dont_pay_flag = 'N'
5796: AND docs.calling_app_id = 200
5797: -- apsi.pay_selected_check_id = P_Selected_Check_id
5831: SET docs.dont_pay_flag = 'Y',
5832: docs.dont_pay_reason_code = AWT_ERROR
5833: WHERE CURRENT OF c_selected_invoices;
5834:
5835: UPDATE ap_selected_invoices
5836: SET ok_to_pay_flag = 'N',
5837: dont_pay_reason_code = AWT_ERROR
5838: WHERE invoice_id = l_invoice_id;
5839: