eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_ISP_UTILITIES_PKG dependencies on AP_INVOICE_LINES

Line 344: FROM po_headers_all p, ap_invoice_lines_all l

340: END IF;
341: BEGIN
342: SELECT p.terms_id
343: INTO p_terms_id
344: FROM po_headers_all p, ap_invoice_lines_all l
345: WHERE p.type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')
346: AND l.po_header_id = p.po_header_id
347: AND l.invoice_id = p_invoice_id
348: AND p.terms_id IS NOT NULL

Line 368: ap_invoice_lines_all l

364: SELECT p.terms_id
365: INTO p_terms_id
366: FROM rcv_shipment_lines r,
367: po_headers_all p,
368: ap_invoice_lines_all l
369: WHERE p.po_header_id = r.po_header_id
370: AND r.shipment_line_id = l.rcv_shipment_line_id
371: AND l.invoice_id = p_invoice_id
372: AND p.terms_id IS NOT NULL

Line 644: | ap_invoice_lines_pkg.discard_inv_line().

640: /*=============================================================================
641: | public FUNCTION Discard_Inv_Line
642: |
643: | This is a wrapper function based on
644: | ap_invoice_lines_pkg.discard_inv_line().
645: |
646: | Discard or cancel the invoice line depending on calling mode. If error
647: | occurs, it return 1 and error code will be populated. Otherwise,
648: | It return 0.

Line 663: p_invoice_id IN ap_invoice_lines.invoice_id%TYPE,

659: *===========================================================================*/
660: /* Bug 5470344 XBuild11 Code cleanup
661: This code is not being used
662: PROCEDURE Discard_Inv_Line(
663: p_invoice_id IN ap_invoice_lines.invoice_id%TYPE,
664: p_line_number IN ap_invoice_lines.line_number%TYPE,
665: p_calling_mode IN VARCHAR2,
666: p_inv_cancellable IN VARCHAR2 DEFAULT NULL,
667: P_last_updated_by IN NUMBER,

Line 664: p_line_number IN ap_invoice_lines.line_number%TYPE,

660: /* Bug 5470344 XBuild11 Code cleanup
661: This code is not being used
662: PROCEDURE Discard_Inv_Line(
663: p_invoice_id IN ap_invoice_lines.invoice_id%TYPE,
664: p_line_number IN ap_invoice_lines.line_number%TYPE,
665: p_calling_mode IN VARCHAR2,
666: p_inv_cancellable IN VARCHAR2 DEFAULT NULL,
667: P_last_updated_by IN NUMBER,
668: P_last_update_login IN NUMBER,

Line 674: l_line_rec ap_invoice_lines%ROWTYPE;

670: P_token OUT NOCOPY VARCHAR2,
671: P_calling_sequence IN VARCHAR2)
672: IS
673:
674: l_line_rec ap_invoice_lines%ROWTYPE;
675: l_curr_calling_sequence VARCHAR2(2000);
676: l_debug_info VARCHAR2(2000);
677: l_api_name VARCHAR2(50);
678: l_result NUMBER;

Line 713: from ap_invoice_lines_all

709: l_line_rec.discarded_flag, l_line_rec.cancelled_flag,
710: l_line_rec.period_name,
711: l_line_rec.line_type_lookup_code,
712: l_line_rec.match_type
713: from ap_invoice_lines_all
714: where invoice_id = p_invoice_id
715: and line_number = p_line_number;
716:
717: l_debug_info := 'invoice_id = ' || l_line_rec.invoice_id ||

Line 723: if ( ap_invoice_lines_pkg.discard_inv_line(p_line_rec => l_line_rec,

719: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
720: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
721: END IF;
722:
723: if ( ap_invoice_lines_pkg.discard_inv_line(p_line_rec => l_line_rec,
724: p_calling_mode => p_calling_mode,
725: p_inv_cancellable => p_inv_cancellable,
726: p_last_updated_by => p_last_updated_by,
727: p_last_update_login => p_last_update_login,

Line 1204: FROM ap_invoice_lines_all

1200: SUM(DECODE(line_type_lookup_code,'MISCELLANEOUS',NVL(amount, 0) - NVL(included_tax_amount, 0),0)) MISC_SUM, --Bug
1201: SUM(DECODE(line_type_lookup_code,'FREIGHT',NVL(amount, 0) - NVL(included_tax_amount, 0),0)) FREIGHT_SUM,
1202: sum(decode(line_type_lookup_code, 'ITEM', NVL(retained_amount, 0), 0)) RETAINAGE_SUM
1203: INTO l_item_sum, l_tax_sum, l_misc_sum, l_frt_sum, l_retained_sum
1204: FROM ap_invoice_lines_all
1205: WHERE invoice_id = p_invoice_id;
1206:
1207: EXCEPTION
1208: WHEN NO_DATA_FOUND THEN

Line 1297: UPDATE ap_invoice_lines_all

1293: WHERE invoice_id = p_invoice_id;
1294: END IF;
1295:
1296: --Bug 5500186
1297: UPDATE ap_invoice_lines_all
1298: SET requester_id = l_requester_id
1299: WHERE line_type_lookup_code = 'ITEM'
1300: AND requester_id is NULL
1301: AND invoice_id = p_invoice_id;

Line 1497: l_period_name ap_invoice_lines_all.period_name%TYPE;

1493:
1494: l_wfitemkey VARCHAR2(50);
1495: l_dist_set_id ap_supplier_sites_all.distribution_set_id%TYPE;
1496: -- Bug 6859035
1497: l_period_name ap_invoice_lines_all.period_name%TYPE;
1498: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
1499: l_org_id ap_invoices_all.org_id%TYPE;
1500:
1501: -- Bug 7706967 : Start

Line 1498: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;

1494: l_wfitemkey VARCHAR2(50);
1495: l_dist_set_id ap_supplier_sites_all.distribution_set_id%TYPE;
1496: -- Bug 6859035
1497: l_period_name ap_invoice_lines_all.period_name%TYPE;
1498: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
1499: l_org_id ap_invoices_all.org_id%TYPE;
1500:
1501: -- Bug 7706967 : Start
1502: l_vendor_name ap_suppliers.vendor_name%TYPE;

Line 1580: UPDATE ap_invoice_lines_all

1576: relationship_id = -1
1577: WHERE invoice_id = p_invoice_id;
1578: -- Bug 7706967 - End
1579:
1580: UPDATE ap_invoice_lines_all
1581: SET accounting_date = l_gl_date,
1582: period_name = l_period_name
1583: WHERE invoice_id = p_invoice_id ;
1584:

Line 1607: FROM ap_invoice_lines_all

1603: SUM(DECODE(line_type_lookup_code,'MISCELLANEOUS',NVL(amount, 0) - NVL(included_tax_amount, 0),0)) MISC_SUM, --Bug
1604: SUM(DECODE(line_type_lookup_code,'FREIGHT',NVL(amount, 0) - NVL(included_tax_amount, 0),0)) FREIGHT_SUM,
1605: sum(decode(line_type_lookup_code, 'ITEM', NVL(retained_amount, 0), 0)) RETAINAGE_SUM
1606: INTO l_item_sum, l_tax_sum, l_misc_sum, l_frt_sum, l_retained_sum
1607: FROM ap_invoice_lines_all
1608: WHERE invoice_id = p_invoice_id;
1609:
1610: EXCEPTION
1611: WHEN NO_DATA_FOUND THEN

Line 1709: FROM ap_invoice_lines_all

1705: P_Calling_Sequence IN VARCHAR2) IS
1706:
1707: CURSOR Invoice_Lines_cur IS
1708: SELECT line_number, quantity_invoiced, amount, po_line_location_id
1709: FROM ap_invoice_lines_all
1710: WHERE invoice_id = P_invoice_id
1711: AND NVL(discarded_flag, 'N' ) <> 'Y'
1712: AND nvl(generate_dists,'Y') <> 'D' --5090119
1713: AND line_type_lookup_code = 'ITEM';

Line 1715: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;

1711: AND NVL(discarded_flag, 'N' ) <> 'Y'
1712: AND nvl(generate_dists,'Y') <> 'D' --5090119
1713: AND line_type_lookup_code = 'ITEM';
1714:
1715: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
1716: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1717: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
1718: l_amount ap_invoice_lines_all.amount%TYPE;
1719: l_billed ap_invoice_lines_all.amount%TYPE;

Line 1716: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;

1712: AND nvl(generate_dists,'Y') <> 'D' --5090119
1713: AND line_type_lookup_code = 'ITEM';
1714:
1715: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
1716: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1717: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
1718: l_amount ap_invoice_lines_all.amount%TYPE;
1719: l_billed ap_invoice_lines_all.amount%TYPE;
1720: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;

Line 1717: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;

1713: AND line_type_lookup_code = 'ITEM';
1714:
1715: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
1716: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1717: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
1718: l_amount ap_invoice_lines_all.amount%TYPE;
1719: l_billed ap_invoice_lines_all.amount%TYPE;
1720: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;
1721: l_amount_ordered ap_invoice_lines_all.amount%TYPE;

Line 1718: l_amount ap_invoice_lines_all.amount%TYPE;

1714:
1715: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
1716: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1717: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
1718: l_amount ap_invoice_lines_all.amount%TYPE;
1719: l_billed ap_invoice_lines_all.amount%TYPE;
1720: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;
1721: l_amount_ordered ap_invoice_lines_all.amount%TYPE;
1722: l_matching_basis po_line_locations_all.matching_basis%TYPE;

Line 1719: l_billed ap_invoice_lines_all.amount%TYPE;

1715: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
1716: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1717: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
1718: l_amount ap_invoice_lines_all.amount%TYPE;
1719: l_billed ap_invoice_lines_all.amount%TYPE;
1720: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;
1721: l_amount_ordered ap_invoice_lines_all.amount%TYPE;
1722: l_matching_basis po_line_locations_all.matching_basis%TYPE;
1723: l_overbill_flag VARCHAR2(2);

Line 1720: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;

1716: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1717: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
1718: l_amount ap_invoice_lines_all.amount%TYPE;
1719: l_billed ap_invoice_lines_all.amount%TYPE;
1720: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;
1721: l_amount_ordered ap_invoice_lines_all.amount%TYPE;
1722: l_matching_basis po_line_locations_all.matching_basis%TYPE;
1723: l_overbill_flag VARCHAR2(2);
1724: l_curr_calling_sequence VARCHAR2(2000);

Line 1721: l_amount_ordered ap_invoice_lines_all.amount%TYPE;

1717: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
1718: l_amount ap_invoice_lines_all.amount%TYPE;
1719: l_billed ap_invoice_lines_all.amount%TYPE;
1720: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;
1721: l_amount_ordered ap_invoice_lines_all.amount%TYPE;
1722: l_matching_basis po_line_locations_all.matching_basis%TYPE;
1723: l_overbill_flag VARCHAR2(2);
1724: l_curr_calling_sequence VARCHAR2(2000);
1725: l_debug_info VARCHAR2(2000);

Line 1989: l_match_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;

1985: l_po_distribution_id PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
1986: l_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
1987: l_rcv_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;
1988: l_match_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
1989: l_match_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
1990: l_total_quantity_billed AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
1991: l_total_amount_billed AP_INVOICE_LINES.AMOUNT%TYPE;
1992: l_rounding_index PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
1993: l_sum_prorated_amount AP_INVOICE_LINES.AMOUNT%TYPE;

Line 1990: l_total_quantity_billed AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;

1986: l_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
1987: l_rcv_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;
1988: l_match_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
1989: l_match_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
1990: l_total_quantity_billed AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
1991: l_total_amount_billed AP_INVOICE_LINES.AMOUNT%TYPE;
1992: l_rounding_index PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
1993: l_sum_prorated_amount AP_INVOICE_LINES.AMOUNT%TYPE;
1994: l_sum_prorated_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;

Line 1991: l_total_amount_billed AP_INVOICE_LINES.AMOUNT%TYPE;

1987: l_rcv_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;
1988: l_match_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
1989: l_match_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
1990: l_total_quantity_billed AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
1991: l_total_amount_billed AP_INVOICE_LINES.AMOUNT%TYPE;
1992: l_rounding_index PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
1993: l_sum_prorated_amount AP_INVOICE_LINES.AMOUNT%TYPE;
1994: l_sum_prorated_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
1995: l_max_dist_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;

Line 1993: l_sum_prorated_amount AP_INVOICE_LINES.AMOUNT%TYPE;

1989: l_match_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
1990: l_total_quantity_billed AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
1991: l_total_amount_billed AP_INVOICE_LINES.AMOUNT%TYPE;
1992: l_rounding_index PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
1993: l_sum_prorated_amount AP_INVOICE_LINES.AMOUNT%TYPE;
1994: l_sum_prorated_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
1995: l_max_dist_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
1996: l_unit_meas_lookup_code AP_INVOICE_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
1997: l_api_name VARCHAR2(32);

Line 1994: l_sum_prorated_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;

1990: l_total_quantity_billed AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
1991: l_total_amount_billed AP_INVOICE_LINES.AMOUNT%TYPE;
1992: l_rounding_index PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
1993: l_sum_prorated_amount AP_INVOICE_LINES.AMOUNT%TYPE;
1994: l_sum_prorated_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
1995: l_max_dist_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
1996: l_unit_meas_lookup_code AP_INVOICE_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
1997: l_api_name VARCHAR2(32);
1998: l_msg_data VARCHAR2(4000);

Line 1996: l_unit_meas_lookup_code AP_INVOICE_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;

1992: l_rounding_index PO_DISTRIBUTIONS.PO_DISTRIBUTION_ID%TYPE;
1993: l_sum_prorated_amount AP_INVOICE_LINES.AMOUNT%TYPE;
1994: l_sum_prorated_quantity AP_INVOICE_LINES.QUANTITY_INVOICED%TYPE;
1995: l_max_dist_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
1996: l_unit_meas_lookup_code AP_INVOICE_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
1997: l_api_name VARCHAR2(32);
1998: l_msg_data VARCHAR2(4000);
1999: l_return_status VARCHAR2(100);
2000: l_debug_info VARCHAR2(1000);

Line 2214: l_line_rec ap_invoice_lines%rowtype;

2210: PROCEDURE discard_and_rematch (p_invoice_id in number,
2211: p_line_number in number,
2212: p_error_code out nocopy varchar2,
2213: p_token out nocopy varchar2) is
2214: l_line_rec ap_invoice_lines%rowtype;
2215: l_error_code varchar2(100);
2216: l_token varchar2(100);
2217:
2218: begin

Line 2222: from ap_invoice_lines_all

2218: begin
2219:
2220: select *
2221: into l_line_rec
2222: from ap_invoice_lines_all
2223: where invoice_id = p_invoice_id
2224: and line_number = p_line_number;
2225:
2226:

Line 2227: if ap_invoice_lines_pkg.Discard_Inv_Line(

2223: where invoice_id = p_invoice_id
2224: and line_number = p_line_number;
2225:
2226:
2227: if ap_invoice_lines_pkg.Discard_Inv_Line(
2228: P_line_rec => l_line_rec,
2229: P_calling_mode => 'DISCARD',
2230: P_last_updated_by => l_line_rec.last_updated_by,
2231: P_last_update_login => l_line_rec.last_update_login,

Line 2243: from ap_invoice_lines_all

2239:
2240:
2241: select max(line_number)+1
2242: into l_line_rec.line_number
2243: from ap_invoice_lines_all
2244: where invoice_id = p_invoice_id;
2245:
2246: INSERT INTO AP_INVOICE_LINES (
2247: INVOICE_ID,

Line 2246: INSERT INTO AP_INVOICE_LINES (

2242: into l_line_rec.line_number
2243: from ap_invoice_lines_all
2244: where invoice_id = p_invoice_id;
2245:
2246: INSERT INTO AP_INVOICE_LINES (
2247: INVOICE_ID,
2248: LINE_NUMBER,
2249: LINE_TYPE_LOOKUP_CODE,
2250: REQUESTER_ID,

Line 2580: FROM ap_invoice_lines_all

2576: BEGIN
2577: --
2578: SELECT COUNT(*)
2579: INTO l_count
2580: FROM ap_invoice_lines_all
2581: WHERE po_header_id IS NOT NULL
2582: AND invoice_id = p_invoice_id;
2583:
2584: IF l_count = 0 THEN

Line 2591: FROM ap_invoice_lines_All

2587: SELECT count(*)
2588: INTO l_po_count
2589: FROM po_headers_all
2590: WHERE po_header_id IN (SELECT po_header_id
2591: FROM ap_invoice_lines_All
2592: WHERE invoice_id = p_invoice_id);
2593:
2594: IF l_po_count = 1 THEN
2595: --

Line 2600: FROM ap_invoice_lines_All

2596: SELECT COUNT(*)
2597: INTO l_release_count
2598: FROM po_releases_all pr
2599: WHERE po_header_id IN (SELECT po_header_id
2600: FROM ap_invoice_lines_All
2601: WHERE invoice_id = p_invoice_id);
2602: --
2603: IF (l_release_count = 0 OR l_release_count = 1) THEN
2604: RETURN 'SINGLE';

Line 2638: FROM ap_invoice_lines_All

2634: INTO l_po_number,
2635: l_po_header_id
2636: FROM po_headers_all POH
2637: WHERE po_header_id IN ( SELECT po_header_id
2638: FROM ap_invoice_lines_All
2639: WHERE invoice_id = p_invoice_id);
2640:
2641: SELECT COUNT(*)
2642: INTO l_release_count

Line 2675: FROM ap_invoice_lines_all

2671: BEGIN
2672: --
2673: SELECT COUNT(*)
2674: INTO l_count
2675: FROM ap_invoice_lines_all
2676: WHERE po_header_id IS NOT NULL
2677: AND invoice_id = p_invoice_id;
2678:
2679: IF l_count <> 0 THEN

Line 2685: FROM ap_invoice_lines_All

2681: SELECT count(*)
2682: INTO l_po_count
2683: FROM po_headers_all
2684: WHERE po_header_id IN (SELECT po_header_id
2685: FROM ap_invoice_lines_All
2686: WHERE invoice_id = p_invoice_id);
2687:
2688: IF l_po_count = 1 THEN
2689: SELECT po_header_id

Line 2693: FROM ap_invoice_lines_All

2689: SELECT po_header_id
2690: INTO l_po_header_id
2691: FROM po_headers_all POH
2692: WHERE po_header_id IN ( SELECT po_header_id
2693: FROM ap_invoice_lines_All
2694: WHERE invoice_id = p_invoice_id);
2695: END IF;
2696: END IF;
2697: --

Line 2722: FROM ap_invoice_lines_All

2718: SELECT COUNT(*)
2719: INTO l_release_count
2720: FROM po_releases_all pr
2721: WHERE po_header_id IN (SELECT po_header_id
2722: FROM ap_invoice_lines_All
2723: WHERE invoice_id = p_invoice_id);
2724: --
2725: IF l_release_count = 1 THEN
2726: --