APPS.AP_AIP_TABLE_HANDLER_PKG dependencies on AP_INVOICE_PAYMENTS

Line 109: debug_info := 'Insert ap_invoice_payments';

105: l_iban_number := NULL;
106: END;
107: END IF;
108:
109: debug_info := 'Insert ap_invoice_payments';
110: INSERT INTO AP_INVOICE_PAYMENTS(
111: invoice_payment_id,
112: invoice_id,
113: payment_num,

Line 110: INSERT INTO AP_INVOICE_PAYMENTS(

106: END;
107: END IF;
108:
109: debug_info := 'Insert ap_invoice_payments';
110: INSERT INTO AP_INVOICE_PAYMENTS(
111: invoice_payment_id,
112: invoice_id,
113: payment_num,
114: check_id,

Line 268: (p_table_name => 'AP_INVOICE_PAYMENTS',

264: 'U');
265:
266: --Bug 4539462 DBI logging
267: AP_DBI_PKG.Maintain_DBI_Summary
268: (p_table_name => 'AP_INVOICE_PAYMENTS',
269: p_operation => 'I',
270: p_key_value1 => P_invoice_payment_id,
271: p_calling_sequence => current_calling_sequence);
272:

Line 275: update ap_invoice_payments

271: p_calling_sequence => current_calling_sequence);
272:
273: -- Mark old invoice payment as part of a reversal pair
274: if (p_old_invoice_payment_id is not null) then
275: update ap_invoice_payments
276: set reversal_flag = 'Y',
277: last_update_date = p_last_update_date,
278: last_updated_by = p_last_updated_by
279: where invoice_payment_id = p_old_invoice_payment_id;

Line 400: debug_info := 'update ap_invoice_payments amount';

396: --
397: current_calling_sequence := 'ap_pay_update_inv_pay_amounts<-'||
398: P_calling_sequence;
399:
400: debug_info := 'update ap_invoice_payments amount';
401:
402: -- Update ap_invoice_payments
403:
404: UPDATE ap_invoice_payments

Line 402: -- Update ap_invoice_payments

398: P_calling_sequence;
399:
400: debug_info := 'update ap_invoice_payments amount';
401:
402: -- Update ap_invoice_payments
403:
404: UPDATE ap_invoice_payments
405: SET amount = nvl(p_amount, amount),
406: invoice_base_amount = nvl(p_invoice_base_amount, invoice_base_amount),

Line 404: UPDATE ap_invoice_payments

400: debug_info := 'update ap_invoice_payments amount';
401:
402: -- Update ap_invoice_payments
403:
404: UPDATE ap_invoice_payments
405: SET amount = nvl(p_amount, amount),
406: invoice_base_amount = nvl(p_invoice_base_amount, invoice_base_amount),
407: payment_base_amount = nvl(p_payment_base_amount, payment_base_amount)
408: WHERE invoice_payment_id = p_invoice_payment_id;

Line 412: (p_table_name => 'AP_INVOICE_PAYMENTS',

408: WHERE invoice_payment_id = p_invoice_payment_id;
409:
410: --Bug 4539462 DBI logging
411: AP_DBI_PKG.Maintain_DBI_Summary
412: (p_table_name => 'AP_INVOICE_PAYMENTS',
413: p_operation => 'U',
414: p_key_value1 => P_invoice_payment_id,
415: p_calling_sequence => current_calling_sequence);
416: