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 201: ap_invoice_lines

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

Line 325: C_Invoice_line_number ap_invoice_lines_all.line_number%TYPE;

321: C_overbilled VARCHAR2(1);
322: C_Quantity NUMBER;
323: C_Transfer_desc_flex_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
324: C_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
325: C_Invoice_line_number ap_invoice_lines_all.line_number%TYPE;
326: C_Price NUMBER;
327: C_Description ap_lookup_codes.description%TYPE;
328: C_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
329: C_inventory_org_id financials_system_parameters.inventory_organization_id%TYPE;

Line 330: C_asset_bt_code AP_INVOICE_LINES_ALL.ASSET_BOOK_TYPE_CODE%TYPE;

326: C_Price NUMBER;
327: C_Description ap_lookup_codes.description%TYPE;
328: C_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
329: C_inventory_org_id financials_system_parameters.inventory_organization_id%TYPE;
330: C_asset_bt_code AP_INVOICE_LINES_ALL.ASSET_BOOK_TYPE_CODE%TYPE;
331: C_dist_tab AP_MATCHING_PKG.dist_tab_type;
332: C_ship_to_location_id PO_VENDOR_SITES.ship_to_location_id%TYPE;
333: C_retained_amount Number; /*bug 5228301 */
334: C_match_type AP_INVOICE_LINES_ALL.Match_Type%TYPE;

Line 334: C_match_type AP_INVOICE_LINES_ALL.Match_Type%TYPE;

330: C_asset_bt_code AP_INVOICE_LINES_ALL.ASSET_BOOK_TYPE_CODE%TYPE;
331: C_dist_tab AP_MATCHING_PKG.dist_tab_type;
332: C_ship_to_location_id PO_VENDOR_SITES.ship_to_location_id%TYPE;
333: C_retained_amount Number; /*bug 5228301 */
334: C_match_type AP_INVOICE_LINES_ALL.Match_Type%TYPE;
335: C_sched_holds_count NUMBER; --bug 5452979
336:
337: -- eTax Uptake
338: l_inv_hdr_amount NUMBER;

Line 341: l_inv_line_tax_atts ap_invoice_lines%rowtype;

337: -- eTax Uptake
338: l_inv_hdr_amount NUMBER;
339: l_line_amount NUMBER;
340: l_base_line_amount NUMBER;
341: l_inv_line_tax_atts ap_invoice_lines%rowtype;
342:
343: l_invoice_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
344:
345: BEGIN

Line 343: l_invoice_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;

339: l_line_amount NUMBER;
340: l_base_line_amount NUMBER;
341: l_inv_line_tax_atts ap_invoice_lines%rowtype;
342:
343: l_invoice_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
344:
345: BEGIN
346: -- Update the calling sequence
347: --

Line 597: -- Insert AP_INVOICE_LINES

593: -- Step 5: Call AP_INVOICES_PKG.insert_children()
594: -- Inserts child records into AP_HOLDS,
595: -- AP_PAYMENT_SCHEDULES
596: -- If C_Disttribution_set_ID is not NULL
597: -- Insert AP_INVOICE_LINES
598: -- * If PO_match has been executed. Don't create ITEM lines
599: -------------------------------------------------------------------
600:
601: IF C_Distribution_Set_ID IS NOT NULL THEN

Line 954: P_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount

950: END IF;
951:
952:
953: /* bug 5228301. Retainage amount */
954: P_retained_amount := AP_INVOICE_LINES_UTILITY_PKG.Get_Retained_Amount
955: (p_po_shipment_id,
956: p_invoice_amount);
957:
958: END IF;

Line 2000: l_invoice_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;

1996: current_calling_sequence VARCHAR2(2000);
1997: debug_info VARCHAR2(100);
1998: l_User_Id number;
1999: l_Login_Id number;
2000: l_invoice_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
2001:
2002: BEGIN
2003:
2004: current_calling_sequence := 'Insert_Invoice_Line<-'||P_calling_sequence;

Line 2013: INSERT INTO AP_INVOICE_LINES (

2009: debug_info := 'Get line NUMBER for generation of line';
2010: l_invoice_line_number := AP_INVOICES_PKG.get_max_line_number(P_invoice_id) + 1;
2011:
2012: debug_info := 'Inserting Item Line Matched to a PO';
2013: INSERT INTO AP_INVOICE_LINES (
2014: INVOICE_ID,
2015: LINE_NUMBER,
2016: LINE_TYPE_LOOKUP_CODE,
2017: REQUESTER_ID,

Line 2387: l_invoice_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;

2383: l_asset_book_count NUMBER;
2384: l_inv_line_asset_bt_code NUMBER;
2385: l_inv_line_asset_category_id NUMBER;
2386: l_base_line_amount NUMBER;
2387: l_invoice_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
2388: l_dist_set_percent_number NUMBER := 0;
2389: l_dist_set_description AP_DISTRIBUTION_SETS.DESCRIPTION%TYPE;
2390: l_dist_set_attribute_category AP_DISTRIBUTION_SETS.ATTRIBUTE_CATEGORY%TYPE;
2391: l_dist_set_attribute1 AP_DISTRIBUTION_SETS.ATTRIBUTE1%TYPE;

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

2521: p_base_currency_code);
2522:
2523: l_invoice_line_number := ap_invoices_pkg.get_max_line_number(p_invoice_id)+1;
2524:
2525: debug_info := 'Insert line into ap_invoice_lines';
2526: BEGIN
2527: INSERT INTO ap_invoice_lines(
2528: invoice_id,
2529: line_number,

Line 2527: INSERT INTO ap_invoice_lines(

2523: l_invoice_line_number := ap_invoices_pkg.get_max_line_number(p_invoice_id)+1;
2524:
2525: debug_info := 'Insert line into ap_invoice_lines';
2526: BEGIN
2527: INSERT INTO ap_invoice_lines(
2528: invoice_id,
2529: line_number,
2530: line_type_lookup_code,
2531: requester_id,