APPS.AP_INTEREST_INVOICE_PKG dependencies on AP_INVOICE_LINES

Line 163: * Step 4. Create ap_invoice_lines line

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

Line 400: -- Call ap_int_inv_insert_ap_inv_line: Insert AP_INVOICE_LINES

396: P_replace_flag,
397: Current_calling_sequence);
398: ---------------------------------------------------------------------------
399: -- Step 4: Case for Pay : for Pay interest invoice only
400: -- Call ap_int_inv_insert_ap_inv_line: Insert AP_INVOICE_LINES
401: ---------------------------------------------------------------------------
402:
403: AP_INTEREST_INVOICE_PKG.ap_int_inv_insert_ap_inv_line(
404: P_int_invoice_id,

Line 1090: Insert AP_INVOICE_LINES

1086: END ap_int_inv_insert_ap_inv_rel;
1087:
1088:
1089: /*==========================================================================
1090: Insert AP_INVOICE_LINES
1091: *=====================================================================*/
1092:
1093: PROCEDURE ap_int_inv_insert_ap_inv_line(
1094: P_int_invoice_id IN NUMBER,

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

1124: P_calling_sequence;
1125:
1126: IF (P_payment_mode in ('PAY','PAYMENTBATCH')) THEN
1127:
1128: debug_info := 'Insert into ap_invoice_lines';
1129:
1130: INSERT INTO AP_INVOICE_LINES
1131: (INVOICE_ID,
1132: LINE_NUMBER,

Line 1130: INSERT INTO AP_INVOICE_LINES

1126: IF (P_payment_mode in ('PAY','PAYMENTBATCH')) THEN
1127:
1128: debug_info := 'Insert into ap_invoice_lines';
1129:
1130: INSERT INTO AP_INVOICE_LINES
1131: (INVOICE_ID,
1132: LINE_NUMBER,
1133: LINE_TYPE_LOOKUP_CODE,
1134: LAST_UPDATE_DATE,

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

1960: BEGIN
1961:
1962: -- Interest Invoices project - Invoice Lines
1963: -- Add parameter P_last_update_login
1964: -- Add the UPDATE statement UPDATE ap_invoice_lines AIL and MRC call
1965: -- to Reverse the line.
1966: -- Add SELECT max(aid.distribution_line_number)
1967: -- Add cursor C_Interest_Inv_Cur and define Interest_Inv_Cur of rowtype
1968: -- Use cursor to loop and insert an equivalent number of distributions

Line 2057: UPDATE ap_invoice_lines_all AIL

2053: -- Interest Invoices project - Invoice Lines
2054:
2055: l_Debug_Info := 'Zero related invoice line';
2056: --Bug 5056061 Modified the update to prevent FTS
2057: UPDATE ap_invoice_lines_all AIL
2058: SET AIL.description = 'VOID '||AIL.description,
2059: AIL.amount = 0,
2060: AIL.base_amount = 0
2061: WHERE AIL.invoice_id IN