[Home] [Help]
185: G_asset_book_type_code fa_book_controls.book_type_code%TYPE;
186: G_inventory_organization_id financials_system_parameters.inventory_organization_id%TYPE;
187: G_allow_account_override ap_system_parameters.allow_flex_override_flag%TYPE;
188: G_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE;
189: G_match_option po_line_locations.match_option%TYPE;
190: G_approval_workflow_flag ap_system_parameters.approval_workflow_flag%TYPE;
191: --G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE; - Bug 4277744
192: G_login_id number;
193: G_User_id number;
209: G_Org_Id ap_invoices.org_id%TYPE;
210: G_Trx_Business_Category ap_invoices.trx_business_category%TYPE;
211:
212: --Contract Payments
213: G_Shipment_Type po_line_locations_all.shipment_type%TYPE;
214: G_Vendor_Id ap_invoices.vendor_id%TYPE;
215: G_Vendor_Site_Id ap_invoices.vendor_site_id%TYPE;
216: G_Po_Line_Id po_lines_all.po_line_id%TYPE;
217: G_Recoupment_Rate po_lines_all.recoupment_rate%TYPE;
273: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
274: l_uom_code mtl_units_of_measure.uom_code%TYPE;
275: l_ref_doc_trx_id po_headers_all.po_header_id%TYPE;
276: l_error_code varchar2(2000);
277: l_po_line_location_id po_line_locations.line_location_id%TYPE;
278: l_dummy number;
279:
280: BEGIN
281:
517: l_retained_amount,
518: -1 * l_retained_amount
519: FROM ap_invoice_distributions aid,
520: po_distributions pd,
521: po_line_locations pll,
522: rcv_transactions rcv
523: WHERE aid.invoice_distribution_id = l_invoice_distribution_id
524: AND pd.po_distribution_id = aid.po_distribution_id
525: AND pll.line_location_id = pd.line_location_id
584: --end Bug 7483260
585: l_retained_amount,
586: -1 * l_retained_amount
587: FROM ap_invoice_lines ail1,
588: po_line_locations pll,
589: rcv_transactions rcv
590: WHERE ail1.invoice_id = x_invoice_id
591: AND ail1.line_number =x_invoice_line_number
592: AND pll.line_location_id = ail1.po_line_location_id
885: IF (x_po_line_location_id is not null) THEN
886:
887: SELECT pll.match_option,pll.shipment_type, pll.po_line_id, pl.recoupment_rate
888: INTO g_match_option,g_shipment_type, g_po_line_id, g_recoupment_rate
889: FROM po_line_locations pll, po_lines pl
890: WHERE pll.line_location_id = x_po_line_location_id
891: AND pll.po_line_id = pl.po_line_id;
892:
893: END IF;
1696:
1697: --For the case of RTS debit memos:
1698: --Quantity_Billed should be selected from rcv_transactions
1699: --only when the invoice is matched to a receipt and from
1700: --po_line_locations when the invoice is matched to a PO.
1701:
1702: IF X_Match_Quantity < 0 THEN
1703: --For credit/debit memos if match_option is receipt
1704: --then the total_quantity is the quantity_billed on
1715: x_total_quantity := l_billed_qty;
1716: ELSE
1717: SELECT quantity_billed
1718: INTO x_total_quantity
1719: FROM po_line_locations
1720: WHERE line_location_id = x_po_line_location_id;
1721: END IF;
1722:
1723: END IF;
3052: END IF;
3053:
3054: END LOOP;
3055:
3056: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
3057: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3058: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3059: END IF;
3060:
3402: --end Bug 7483260
3403: l_retained_amount,
3404: -1 * l_retained_amount
3405: FROM ap_invoice_lines ail1,
3406: po_line_locations pll
3407: WHERE ail1.invoice_id = x_invoice_id
3408: AND ail1.line_number =x_invoice_line_number
3409: AND pll.line_location_id = ail1.po_line_location_id)
3410: WHERE invoice_id = x_invoice_id
3949: END IF;
3950:
3951: END LOOP;
3952:
3953: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
3954: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3955: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3956: END IF;
3957:
4318: AIL.PRODUCT_CATEGORY, --product_category
4319: AIL.USER_DEFINED_FISC_CLASS --user_defined_fisc_class
4320: FROM ap_invoices ai,
4321: ap_invoice_lines ail,
4322: po_line_locations_ap_v pll
4323: WHERE ai.invoice_id = x_corrected_invoice_id
4324: AND ail.invoice_id = ai.invoice_id
4325: AND ail.line_number = x_corrected_line_number
4326: AND pll.line_location_id = ail.po_line_location_id;