[Home] [Help]
200: * Step 1. Call ap_rec_inv_get_info to get some required fields
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: *========================================================================*/
611: --
612: C_Distribution_Set_ID := '';
613: END IF;
614: -------------------------------------------------------------------
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
667:
668:
669:
670: debug_info := 'Insert Holds, Payment Schedules ';
671: AP_INVOICES_PKG.insert_children (
672: X_invoice_id => C_invoice_id,
673: X_Payment_Priority => C_Payment_Priority,
674: X_Hold_count => C_Hold_count,
675: X_Line_count => C_Line_count,
2032: l_user_id := FND_PROFILE.VALUE('USER_ID');
2033: l_login_id := FND_PROFILE.VALUE('LOGIN_ID');
2034:
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,
2552: l_base_line_amount := AP_UTILITIES_PKG.Ap_Round_Currency(
2553: NVL(p_line_amount,0) * p_exchange_rate ,
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(