[Home] [Help]
175: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
176: -- Removed for bug 4277744
177: -- G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE;
178: G_Allow_Flex_Override_Flag ap_system_parameters.allow_flex_override_flag%TYPE;
179: G_Shipment_Type po_line_locations.shipment_type%TYPE;
180: G_Org_id ap_invoices.org_id%TYPE;
181: G_Encumbrance_Flag financials_system_parameters.purch_encumbrance_flag%TYPE;
182: G_match_option po_line_locations.match_option%TYPE;
183: G_User_Id number;
178: G_Allow_Flex_Override_Flag ap_system_parameters.allow_flex_override_flag%TYPE;
179: G_Shipment_Type po_line_locations.shipment_type%TYPE;
180: G_Org_id ap_invoices.org_id%TYPE;
181: G_Encumbrance_Flag financials_system_parameters.purch_encumbrance_flag%TYPE;
182: G_match_option po_line_locations.match_option%TYPE;
183: G_User_Id number;
184: G_Login_Id number;
185: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
186: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
260: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
261: l_uom_code mtl_units_of_measure.uom_code%TYPE;
262: l_ref_doc_trx_id po_headers_all.po_header_id%TYPE;
263: l_error_code varchar2(2000);
264: l_po_line_location_id po_line_locations.line_location_id%TYPE;
265: l_dummy number;
266:
267: -- bug 8483345: start
268: l_product_org_id ap_invoices.org_id%TYPE;
565: l_retained_amount,
566: -1 * l_retained_amount
567: FROM ap_invoice_distributions aid,
568: po_distributions pd,
569: po_line_locations pll,
570: rcv_transactions rtxn -- bug 5443250
571: WHERE aid.invoice_distribution_id = l_invoice_distribution_id
572: AND pd.po_distribution_id = aid.po_distribution_id
573: AND pll.line_location_id = pd.line_location_id
628: --end Bug 7483260
629: l_retained_amount,
630: -1 * l_retained_amount
631: FROM ap_invoice_lines ail1,
632: po_line_locations pll,
633: rcv_transactions rtxn -- bug 5443250
634: WHERE ail1.invoice_id = x_invoice_id
635: AND ail1.line_number =x_invoice_line_number
636: AND pll.line_location_id = ail1.po_line_location_id
910: IF (x_po_line_location_id is not null) THEN
911:
912: SELECT pll.match_option,pll.shipment_type, pll.po_line_id, pl.recoupment_rate
913: INTO g_match_option,g_shipment_type, g_po_line_id, g_recoupment_rate
914: FROM po_line_locations pll, po_lines pl
915: WHERE pll.line_location_id = x_po_line_location_id
916: AND pll.po_line_id = pl.po_line_id;
917:
918: END IF;
1679: ELSE
1680:
1681: SELECT amount_billed
1682: INTO x_total_amount
1683: FROM po_line_locations
1684: WHERE line_location_id = x_po_line_location_id;
1685:
1686: END IF;
1687:
1814: END IF;
1815:
1816: END LOOP;
1817:
1818: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
1819: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1820: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1821: END IF;
1822:
3264: --end Bug 7483260
3265: l_retained_amount,
3266: -1 * l_retained_amount
3267: FROM ap_invoice_lines ail1,
3268: po_line_locations pll
3269: WHERE ail1.invoice_id = x_invoice_id
3270: AND ail1.line_number =x_invoice_line_number
3271: AND pll.line_location_id = ail1.po_line_location_id)
3272: WHERE invoice_id = x_invoice_id
3608: END IF;
3609:
3610: END LOOP;
3611:
3612: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
3613: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3614: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3615: END IF;
3616:
3976: g_pay_awt_group_id, --pay_awt_group_id bug 9689194
3977: AIL.RCV_SHIPMENT_LINE_ID --rcv_shipment_line_id /*Bug :15946088*/
3978: FROM ap_invoices ai,
3979: ap_invoice_lines ail,
3980: po_line_locations_ap_v pll
3981: WHERE ai.invoice_id = x_corrected_invoice_id
3982: AND ail.invoice_id = ai.invoice_id
3983: AND ail.line_number = x_corrected_line_number
3984: AND pll.line_location_id = ail.po_line_location_id;