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_RECURRING_INVOICES_PKG dependencies on AP_INVOICE_LINES

Line 205: ap_invoice_lines

201: * Step 2. Create ap_batches id it's a new batch
202: * Step 3. Create ap_invoices
203: * Step 4.1 Call ap_match to create ITEM invoice lines
204: * Step 4.2 Call AP_INVOICES_PKG.insert_children insert all the corrsponding
205: ap_invoice_lines
206: ap_payment_schedules, ap_holds
207:
208: *========================================================================*/
209: PROCEDURE ap_create_recurring_invoices(

Line 331: C_Invoice_line_number ap_invoice_lines_all.line_number%TYPE;

327: C_overbilled VARCHAR2(1);
328: C_Quantity NUMBER;
329: C_Transfer_desc_flex_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
330: C_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
331: C_Invoice_line_number ap_invoice_lines_all.line_number%TYPE;
332: C_Price NUMBER;
333: C_Description ap_lookup_codes.description%TYPE;
334: C_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
335: C_inventory_org_id financials_system_parameters.inventory_organization_id%TYPE;

Line 336: C_asset_bt_code AP_INVOICE_LINES_ALL.ASSET_BOOK_TYPE_CODE%TYPE;

332: C_Price NUMBER;
333: C_Description ap_lookup_codes.description%TYPE;
334: C_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
335: C_inventory_org_id financials_system_parameters.inventory_organization_id%TYPE;
336: C_asset_bt_code AP_INVOICE_LINES_ALL.ASSET_BOOK_TYPE_CODE%TYPE;
337: C_dist_tab AP_MATCHING_PKG.dist_tab_type;
338: C_ship_to_location_id PO_VENDOR_SITES.ship_to_location_id%TYPE;
339: C_retained_amount Number; /*bug 5228301 */
340: C_match_type AP_INVOICE_LINES_ALL.Match_Type%TYPE;

Line 340: C_match_type AP_INVOICE_LINES_ALL.Match_Type%TYPE;

336: C_asset_bt_code AP_INVOICE_LINES_ALL.ASSET_BOOK_TYPE_CODE%TYPE;
337: C_dist_tab AP_MATCHING_PKG.dist_tab_type;
338: C_ship_to_location_id PO_VENDOR_SITES.ship_to_location_id%TYPE;
339: C_retained_amount Number; /*bug 5228301 */
340: C_match_type AP_INVOICE_LINES_ALL.Match_Type%TYPE;
341: C_sched_holds_count NUMBER; --bug 5452979
342:
343: -- eTax Uptake
344: l_inv_hdr_amount NUMBER;

Line 348: l_inv_line_tax_atts ap_invoice_lines%rowtype;

344: l_inv_hdr_amount NUMBER;
345: l_inv_hdr_base_amount NUMBER; -- BUG 14621772
346: l_line_amount NUMBER;
347: l_base_line_amount NUMBER;
348: l_inv_line_tax_atts ap_invoice_lines%rowtype;
349:
350: l_invoice_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
351:
352: BEGIN

Line 350: l_invoice_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;

346: l_line_amount NUMBER;
347: l_base_line_amount NUMBER;
348: l_inv_line_tax_atts ap_invoice_lines%rowtype;
349:
350: l_invoice_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
351:
352: BEGIN
353: -- Update the calling sequence
354: --

Line 619: -- Insert AP_INVOICE_LINES

615: -- Step 5: Call AP_INVOICES_PKG.insert_children()
616: -- Inserts child records into AP_HOLDS,
617: -- AP_PAYMENT_SCHEDULES
618: -- If C_Disttribution_set_ID is not NULL
619: -- Insert AP_INVOICE_LINES
620: -- * If PO_match has been executed. Don't create ITEM lines
621: -------------------------------------------------------------------
622:
623: IF C_Distribution_Set_ID IS NOT NULL THEN

Line 978: P_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount

974: END IF;
975:
976:
977: /* bug 5228301. Retainage amount */
978: P_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount
979: (p_po_shipment_id,
980: p_invoice_amount);
981:
982: END IF;

Line 2026: l_invoice_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;

2022: current_calling_sequence VARCHAR2(2000);
2023: debug_info VARCHAR2(100);
2024: l_User_Id number;
2025: l_Login_Id number;
2026: l_invoice_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
2027:
2028: BEGIN
2029:
2030: current_calling_sequence := 'Insert_Invoice_Line<-'||P_calling_sequence;

Line 2039: INSERT INTO AP_INVOICE_LINES (

2035: debug_info := 'Get line NUMBER for generation of line';
2036: l_invoice_line_number := AP_INVOICES_PKG.get_max_line_number(P_invoice_id) + 1;
2037:
2038: debug_info := 'Inserting Item Line Matched to a PO';
2039: INSERT INTO AP_INVOICE_LINES (
2040: INVOICE_ID,
2041: LINE_NUMBER,
2042: LINE_TYPE_LOOKUP_CODE,
2043: REQUESTER_ID,

Line 2420: l_invoice_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;

2416: l_asset_book_count NUMBER;
2417: l_inv_line_asset_bt_code NUMBER;
2418: l_inv_line_asset_category_id NUMBER;
2419: l_base_line_amount NUMBER;
2420: l_invoice_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
2421: l_dist_set_percent_number NUMBER := 0;
2422: l_dist_set_description AP_DISTRIBUTION_SETS.DESCRIPTION%TYPE;
2423: l_dist_set_attribute_category AP_DISTRIBUTION_SETS.ATTRIBUTE_CATEGORY%TYPE;
2424: l_dist_set_attribute1 AP_DISTRIBUTION_SETS.ATTRIBUTE1%TYPE;

Line 2558: debug_info := 'Insert line into ap_invoice_lines';

2554: p_base_currency_code);
2555:
2556: l_invoice_line_number := ap_invoices_pkg.get_max_line_number(p_invoice_id)+1;
2557:
2558: debug_info := 'Insert line into ap_invoice_lines';
2559: BEGIN
2560: INSERT INTO ap_invoice_lines(
2561: invoice_id,
2562: line_number,

Line 2560: INSERT INTO ap_invoice_lines(

2556: l_invoice_line_number := ap_invoices_pkg.get_max_line_number(p_invoice_id)+1;
2557:
2558: debug_info := 'Insert line into ap_invoice_lines';
2559: BEGIN
2560: INSERT INTO ap_invoice_lines(
2561: invoice_id,
2562: line_number,
2563: line_type_lookup_code,
2564: requester_id,