APPS.AP_PAY_INVOICE_PKG dependencies on AP_INVOICE_PAYMENTS

Line 245: * -- Step 4 : case for all : Insert AP_INVOICE_PAYMENTS

241:
242: end if;
243:
244: /*--------------------------------------------------------------------------
245: * -- Step 4 : case for all : Insert AP_INVOICE_PAYMENTS
246: * Call ap_pay_insert_invoice_payments :
247: *
248: *--------------------------------------------------------------------------*/
249: ap_pay_invoice_pkg.ap_pay_insert_invoice_payments(

Line 552: FROM ap_invoice_payments

548: 0-NVL(invoice_base_amount,0)),
549: DECODE(payment_base_amount ,'','',
550: 0-NVL(payment_base_amount,0))
551: INTO P_invoice_base_amount, P_payment_base_amount
552: FROM ap_invoice_payments
553: WHERE invoice_payment_id = P_old_invoice_payment_id;
554:
555: end if;
556:

Line 715: FROM ap_invoice_payments AIP

711: SUM(NVL(AIP.discount_taken,0))
712: , AP_INVOICES_UTILITY_PKG.get_payment_status( P_invoice_id )
713: , P_last_update_date
714: , P_last_updated_by
715: FROM ap_invoice_payments AIP
716: WHERE AIP.invoice_id = P_invoice_id
717: AND AIP.check_id = P_check_id
718: GROUP BY AI.invoice_id
719: , AI.amount_paid

Line 772: * This function: Update AP_INVOICE_PAYMENTS

768:
769: /*========================================================================
770: *** Pubilic Function ***
771: ************************
772: * This function: Update AP_INVOICE_PAYMENTS
773: * Inserts a new invoice payment line
774: *========================================================================*/
775: PROCEDURE ap_pay_insert_invoice_payments(
776: P_invoice_id IN NUMBER,

Line 863: debug_info := 'Insert ap_invoice_payments';

859: -- Update the calling sequence
860: --
861: current_calling_sequence := 'AP_PAY_INVOICE_PKG.ap_pay_insert_invoice_payments<-'||P_calling_sequence;
862:
863: debug_info := 'Insert ap_invoice_payments';
864: AP_AIP_TABLE_HANDLER_PKG.Insert_Row(
865: P_invoice_id,
866: P_check_id,
867: P_payment_num,

Line 1091: FROM ap_invoice_payments AIP,ap_invoices AI --bug2182168 added ap_invoices AI

1087: , DECODE(AI.amount_paid,SUM(AIP.amount),'N','P')
1088: -- 2182168 modified the decode statement to compare amount_paid to amount cancelled
1089: , P_last_update_date
1090: , P_last_updated_by
1091: FROM ap_invoice_payments AIP,ap_invoices AI --bug2182168 added ap_invoices AI
1092: WHERE AIP.invoice_id = P_invoice_id
1093: AND AIP.payment_num = P_payment_num
1094: AND AIP.check_id = P_check_id
1095: AND AI.invoice_id=P_invoice_id --bug2182168 added condition

Line 1127: FROM ap_invoice_payments AIP

1123: = (SELECT SUM(AIP.amount) + SUM(NVL(AIP.discount_taken, 0))
1124: , 'N'
1125: , P_last_update_date
1126: , P_last_updated_by
1127: FROM ap_invoice_payments AIP
1128: WHERE AIP.invoice_id = P_invoice_id
1129: AND AIP.check_id = P_check_id
1130: GROUP BY AIP.invoice_id)
1131: WHERE payment_num = P_payment_num -- Bug 4701565

Line 1189: FROM ap_invoice_payments aip

1185: BEGIN
1186:
1187: SELECT sum(amount)
1188: INTO check_amount
1189: FROM ap_invoice_payments aip
1190: WHERE aip.check_id = x_check_id;
1191:
1192: RETURN(check_amount);
1193:

Line 1234: FROM ap_invoice_payments

1230: -- Get amount_from org_invoice_pay_id
1231: --
1232: SELECT amount, discount_taken
1233: INTO p_amount, p_discount
1234: FROM ap_invoice_payments
1235: WHERE invoice_payment_id = p_org_invoice_pay_id;
1236:
1237:
1238: -- Bug 1544895 - The update statement for AP_INVOICES that appears below the update