APPS.AP_RETAINAGE_PKG dependencies on AP_INVOICES_ALL

Line 521: l_invoice_amount ap_invoices_all.invoice_amount%type

517: pay_num_tab payNum;
518: pay_sched_upd_tab paySchedUpd;
519:
520: l_inv_curr_gross_amount ap_payment_schedules_all.inv_curr_gross_amount%type;
521: l_invoice_amount ap_invoices_all.invoice_amount%type
522: := g_invoice_info.invoice_amount;
523: l_retained_amount ap_invoice_lines_all.retained_amount%type
524: := g_invoice_info.retained_amount;
525: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type

Line 525: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type

521: l_invoice_amount ap_invoices_all.invoice_amount%type
522: := g_invoice_info.invoice_amount;
523: l_retained_amount ap_invoice_lines_all.retained_amount%type
524: := g_invoice_info.retained_amount;
525: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type
526: := g_invoice_info.invoice_currency_code;
527: l_payment_currency_code ap_invoices_all.payment_currency_code%type
528: := g_invoice_info.payment_currency_code;
529: l_payment_cross_rate ap_invoices_all.payment_cross_rate%type

Line 527: l_payment_currency_code ap_invoices_all.payment_currency_code%type

523: l_retained_amount ap_invoice_lines_all.retained_amount%type
524: := g_invoice_info.retained_amount;
525: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type
526: := g_invoice_info.invoice_currency_code;
527: l_payment_currency_code ap_invoices_all.payment_currency_code%type
528: := g_invoice_info.payment_currency_code;
529: l_payment_cross_rate ap_invoices_all.payment_cross_rate%type
530: := g_invoice_info.payment_cross_rate;
531: l_amt_applicable_to_discount ap_invoices_all.amount_applicable_to_discount%type

Line 529: l_payment_cross_rate ap_invoices_all.payment_cross_rate%type

525: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type
526: := g_invoice_info.invoice_currency_code;
527: l_payment_currency_code ap_invoices_all.payment_currency_code%type
528: := g_invoice_info.payment_currency_code;
529: l_payment_cross_rate ap_invoices_all.payment_cross_rate%type
530: := g_invoice_info.payment_cross_rate;
531: l_amt_applicable_to_discount ap_invoices_all.amount_applicable_to_discount%type
532: := g_invoice_info.amount_applicable_to_discount;
533:

Line 531: l_amt_applicable_to_discount ap_invoices_all.amount_applicable_to_discount%type

527: l_payment_currency_code ap_invoices_all.payment_currency_code%type
528: := g_invoice_info.payment_currency_code;
529: l_payment_cross_rate ap_invoices_all.payment_cross_rate%type
530: := g_invoice_info.payment_cross_rate;
531: l_amt_applicable_to_discount ap_invoices_all.amount_applicable_to_discount%type
532: := g_invoice_info.amount_applicable_to_discount;
533:
534: l_amt_to_subtract NUMBER;
535: l_amt_to_subtract_pay_curr NUMBER;

Line 659: UPDATE ap_invoices_all

655: l_debug_info := 'Step 4: Update amount_applicable_to_discount';
656: Print (l_api_name, l_debug_info);
657: -----------------------------------------------------------------
658:
659: UPDATE ap_invoices_all
660: SET amount_applicable_to_discount = (amount_applicable_to_discount + l_retained_amount)
661: WHERE invoice_id = x_invoice_id;
662: */
663: pay_num_tab.delete;