APPS.AP_INTEREST_INVOICE_PKG dependencies on AP_INVOICE_LINES

Line 161: * Step 4. Create ap_invoice_lines line

157: * Main Procedure: Create Interest Invoice and pay it
158: * Step 1. Call ap_int_inv_get_info to get some required fields
159: * Step 2. Create interest ap_invoices line
160: * Step 3. Create ap_invoice_relationships line
161: * Step 4. Create ap_invoice_lines line
162: * Step 5. Create ap_invoice_distributions line
163: * Step 6. Create ap_payment_schedules line
164: * Step 7. Create ap_invoice_payemnts line (Call ap_pay_invoice_pkg.ap_pay_
165: insert_invoice_payments)

Line 396: -- Call ap_int_inv_insert_ap_inv_line: Insert AP_INVOICE_LINES

392: P_replace_flag,
393: Current_calling_sequence);
394: ---------------------------------------------------------------------------
395: -- Step 4: Case for Pay : for Pay interest invoice only
396: -- Call ap_int_inv_insert_ap_inv_line: Insert AP_INVOICE_LINES
397: ---------------------------------------------------------------------------
398:
399: AP_INTEREST_INVOICE_PKG.ap_int_inv_insert_ap_inv_line(
400: P_int_invoice_id,

Line 1048: Insert AP_INVOICE_LINES

1044: END ap_int_inv_insert_ap_inv_rel;
1045:
1046:
1047: /*==========================================================================
1048: Insert AP_INVOICE_LINES
1049: *=====================================================================*/
1050:
1051: PROCEDURE ap_int_inv_insert_ap_inv_line(
1052: P_int_invoice_id IN NUMBER,

Line 1086: debug_info := 'Insert into ap_invoice_lines';

1082: P_calling_sequence;
1083:
1084: IF (P_payment_mode in ('PAY','PAYMENTBATCH')) THEN
1085:
1086: debug_info := 'Insert into ap_invoice_lines';
1087:
1088: INSERT INTO AP_INVOICE_LINES
1089: (INVOICE_ID,
1090: LINE_NUMBER,

Line 1088: INSERT INTO AP_INVOICE_LINES

1084: IF (P_payment_mode in ('PAY','PAYMENTBATCH')) THEN
1085:
1086: debug_info := 'Insert into ap_invoice_lines';
1087:
1088: INSERT INTO AP_INVOICE_LINES
1089: (INVOICE_ID,
1090: LINE_NUMBER,
1091: LINE_TYPE_LOOKUP_CODE,
1092: LAST_UPDATE_DATE,

Line 1868: -- Add the UPDATE statement UPDATE ap_invoice_lines AIL and MRC call

1864: BEGIN
1865:
1866: -- Interest Invoices project - Invoice Lines
1867: -- Add parameter P_last_update_login
1868: -- Add the UPDATE statement UPDATE ap_invoice_lines AIL and MRC call
1869: -- to Reverse the line.
1870: -- Add SELECT max(aid.distribution_line_number)
1871: -- Add cursor C_Interest_Inv_Cur and define Interest_Inv_Cur of rowtype
1872: -- Use cursor to loop and insert an equivalent number of distributions

Line 1961: UPDATE ap_invoice_lines_all AIL

1957: -- Interest Invoices project - Invoice Lines
1958:
1959: l_Debug_Info := 'Zero related invoice line';
1960: --Bug 5056061 Modified the update to prevent FTS
1961: UPDATE ap_invoice_lines_all AIL
1962: SET AIL.description = 'VOID '||AIL.description,
1963: AIL.amount = 0,
1964: AIL.base_amount = 0
1965: WHERE AIL.invoice_id IN