[Home] [Help]
174: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
175: -- Removed for bug 4277744
176: -- G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE;
177: G_Allow_Flex_Override_Flag ap_system_parameters.allow_flex_override_flag%TYPE;
178: G_Shipment_Type po_line_locations.shipment_type%TYPE;
179: G_Org_id ap_invoices.org_id%TYPE;
180: G_Encumbrance_Flag financials_system_parameters.purch_encumbrance_flag%TYPE;
181: G_match_option po_line_locations.match_option%TYPE;
182: G_User_Id number;
177: G_Allow_Flex_Override_Flag ap_system_parameters.allow_flex_override_flag%TYPE;
178: G_Shipment_Type po_line_locations.shipment_type%TYPE;
179: G_Org_id ap_invoices.org_id%TYPE;
180: G_Encumbrance_Flag financials_system_parameters.purch_encumbrance_flag%TYPE;
181: G_match_option po_line_locations.match_option%TYPE;
182: G_User_Id number;
183: G_Login_Id number;
184: G_Account_Segment ap_invoice_lines.account_segment%TYPE := NULL;
185: G_Balancing_Segment ap_invoice_lines.balancing_segment%TYPE := NULL;
258: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
259: l_uom_code mtl_units_of_measure.uom_code%TYPE;
260: l_ref_doc_trx_id po_headers_all.po_header_id%TYPE;
261: l_error_code varchar2(2000);
262: l_po_line_location_id po_line_locations.line_location_id%TYPE;
263: l_dummy number;
264:
265:
266: BEGIN
478: l_retained_amount,
479: -1 * l_retained_amount
480: FROM ap_invoice_distributions aid,
481: po_distributions pd,
482: po_line_locations pll,
483: rcv_transactions rtxn -- bug 5443250
484: WHERE aid.invoice_distribution_id = l_invoice_distribution_id
485: AND pd.po_distribution_id = aid.po_distribution_id
486: AND pll.line_location_id = pd.line_location_id
541: --end Bug 7483260
542: l_retained_amount,
543: -1 * l_retained_amount
544: FROM ap_invoice_lines ail1,
545: po_line_locations pll,
546: rcv_transactions rtxn -- bug 5443250
547: WHERE ail1.invoice_id = x_invoice_id
548: AND ail1.line_number =x_invoice_line_number
549: AND pll.line_location_id = ail1.po_line_location_id
818: IF (x_po_line_location_id is not null) THEN
819:
820: SELECT pll.match_option,pll.shipment_type, pll.po_line_id, pl.recoupment_rate
821: INTO g_match_option,g_shipment_type, g_po_line_id, g_recoupment_rate
822: FROM po_line_locations pll, po_lines pl
823: WHERE pll.line_location_id = x_po_line_location_id
824: AND pll.po_line_id = pl.po_line_id;
825:
826: END IF;
1566: ELSE
1567:
1568: SELECT amount_billed
1569: INTO x_total_amount
1570: FROM po_line_locations
1571: WHERE line_location_id = x_po_line_location_id;
1572:
1573: END IF;
1574:
1701: END IF;
1702:
1703: END LOOP;
1704:
1705: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
1706: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1707: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1708: END IF;
1709:
3099: --end Bug 7483260
3100: l_retained_amount,
3101: -1 * l_retained_amount
3102: FROM ap_invoice_lines ail1,
3103: po_line_locations pll
3104: WHERE ail1.invoice_id = x_invoice_id
3105: AND ail1.line_number =x_invoice_line_number
3106: AND pll.line_location_id = ail1.po_line_location_id)
3107: WHERE invoice_id = x_invoice_id
3441: END IF;
3442:
3443: END LOOP;
3444:
3445: l_debug_info := 'Call the PO_AP_INVOICE_MATCH_GRP to update the Po Distributions and Po Line Locations';
3446: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3447: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3448: END IF;
3449:
3805: AIL.PRODUCT_CATEGORY, --product_category
3806: AIL.USER_DEFINED_FISC_CLASS --user_defined_fisc_class
3807: FROM ap_invoices ai,
3808: ap_invoice_lines ail,
3809: po_line_locations_ap_v pll
3810: WHERE ai.invoice_id = x_corrected_invoice_id
3811: AND ail.invoice_id = ai.invoice_id
3812: AND ail.line_number = x_corrected_line_number
3813: AND pll.line_location_id = ail.po_line_location_id;