[Home] [Help]
186: G_asset_book_type_code fa_book_controls.book_type_code%TYPE;
187: G_inventory_organization_id financials_system_parameters.inventory_organization_id%TYPE;
188: G_allow_account_override ap_system_parameters.allow_flex_override_flag%TYPE;
189: G_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;
190: G_match_option po_line_locations.match_option%TYPE;
191: G_approval_workflow_flag ap_system_parameters.approval_workflow_flag%TYPE;
192: --G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE; - Bug 4277744
193: G_login_id number;
194: G_User_id number;
211: G_Org_Id ap_invoices.org_id%TYPE;
212: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
213:
214: --Contract Payments
215: G_Shipment_Type po_line_locations_all.shipment_type%TYPE;
216: G_Vendor_Id ap_invoices.vendor_id%TYPE;
217: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;
218: G_Po_Line_Id po_lines_all.po_line_id%TYPE;
219: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;
275: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
276: l_uom_code mtl_units_of_measure.uom_code%TYPE;
277: l_ref_doc_trx_id po_headers_all.po_header_id%TYPE;
278: l_error_code varchar2(2000);
279: l_po_line_location_id po_line_locations.line_location_id%TYPE;
280: l_dummy number;
281:
282: -- bug 8483345: start
283: l_product_org_id ap_invoices.org_id%TYPE;
606: l_retained_amount,
607: -1 * l_retained_amount
608: FROM ap_invoice_distributions aid,
609: po_distributions pd,
610: po_line_locations pll,
611: rcv_transactions rcv
612: WHERE aid.invoice_distribution_id = l_invoice_distribution_id
613: AND pd.po_distribution_id = aid.po_distribution_id
614: AND pll.line_location_id = pd.line_location_id
673: --end Bug 7483260
674: l_retained_amount,
675: -1 * l_retained_amount
676: FROM ap_invoice_lines ail1,
677: po_line_locations pll,
678: rcv_transactions rcv
679: WHERE ail1.invoice_id = x_invoice_id
680: AND ail1.line_number =x_invoice_line_number
681: AND pll.line_location_id = ail1.po_line_location_id
978: IF (x_po_line_location_id is not null) THEN
979:
980: SELECT pll.match_option,pll.shipment_type, pll.po_line_id, pl.recoupment_rate
981: INTO g_match_option,g_shipment_type, g_po_line_id, g_recoupment_rate
982: FROM po_line_locations pll, po_lines pl
983: WHERE pll.line_location_id = x_po_line_location_id
984: AND pll.po_line_id = pl.po_line_id;
985:
986: END IF;
1838:
1839: --For the case of RTS debit memos:
1840: --Quantity_Billed should be selected from rcv_transactions
1841: --only when the invoice is matched to a receipt and from
1842: --po_line_locations when the invoice is matched to a PO.
1843:
1844: IF X_Match_Quantity < 0 THEN
1845: --For credit/debit memos if match_option is receipt
1846: --then the total_quantity is the quantity_billed on
1857: x_total_quantity := l_billed_qty;
1858: ELSE
1859: SELECT quantity_billed
1860: INTO x_total_quantity
1861: FROM po_line_locations
1862: WHERE line_location_id = x_po_line_location_id;
1863: END IF;
1864:
1865: END IF;
3260: END IF;
3261:
3262: END LOOP;
3263:
3264: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
3265: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3266: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3267: END IF;
3268:
3611: --end Bug 7483260
3612: l_retained_amount,
3613: -1 * l_retained_amount
3614: FROM ap_invoice_lines ail1,
3615: po_line_locations pll
3616: WHERE ail1.invoice_id = x_invoice_id
3617: AND ail1.line_number =x_invoice_line_number
3618: AND pll.line_location_id = ail1.po_line_location_id)
3619: WHERE invoice_id = x_invoice_id
4168: END IF;
4169:
4170: END LOOP;
4171:
4172: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
4173: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4174: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4175: END IF;
4176:
4541: G_PAY_AWT_GROUP_ID, --bug 9689194
4542: AIL.RCV_SHIPMENT_LINE_ID /*BUG :15946088*/
4543: FROM ap_invoices ai,
4544: ap_invoice_lines ail,
4545: po_line_locations_ap_v pll
4546: WHERE ai.invoice_id = x_corrected_invoice_id
4547: AND ail.invoice_id = ai.invoice_id
4548: AND ail.line_number = x_corrected_line_number
4549: AND pll.line_location_id = ail.po_line_location_id;