APPS.AP_RETAINAGE_PKG dependencies on AP_INVOICES_ALL

Line 551: l_invoice_amount ap_invoices_all.invoice_amount%type

547: pay_num_tab payNum;
548: pay_sched_upd_tab paySchedUpd;
549:
550: l_inv_curr_gross_amount ap_payment_schedules_all.inv_curr_gross_amount%type;
551: l_invoice_amount ap_invoices_all.invoice_amount%type
552: := g_invoice_info.invoice_amount;
553: l_retained_amount ap_invoice_lines_all.retained_amount%type
554: := g_invoice_info.retained_amount;
555: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type

Line 555: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type

551: l_invoice_amount ap_invoices_all.invoice_amount%type
552: := g_invoice_info.invoice_amount;
553: l_retained_amount ap_invoice_lines_all.retained_amount%type
554: := g_invoice_info.retained_amount;
555: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type
556: := g_invoice_info.invoice_currency_code;
557: l_payment_currency_code ap_invoices_all.payment_currency_code%type
558: := g_invoice_info.payment_currency_code;
559: l_payment_cross_rate ap_invoices_all.payment_cross_rate%type

Line 557: l_payment_currency_code ap_invoices_all.payment_currency_code%type

553: l_retained_amount ap_invoice_lines_all.retained_amount%type
554: := g_invoice_info.retained_amount;
555: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type
556: := g_invoice_info.invoice_currency_code;
557: l_payment_currency_code ap_invoices_all.payment_currency_code%type
558: := g_invoice_info.payment_currency_code;
559: l_payment_cross_rate ap_invoices_all.payment_cross_rate%type
560: := g_invoice_info.payment_cross_rate;
561: l_amt_applicable_to_discount ap_invoices_all.amount_applicable_to_discount%type

Line 559: l_payment_cross_rate ap_invoices_all.payment_cross_rate%type

555: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type
556: := g_invoice_info.invoice_currency_code;
557: l_payment_currency_code ap_invoices_all.payment_currency_code%type
558: := g_invoice_info.payment_currency_code;
559: l_payment_cross_rate ap_invoices_all.payment_cross_rate%type
560: := g_invoice_info.payment_cross_rate;
561: l_amt_applicable_to_discount ap_invoices_all.amount_applicable_to_discount%type
562: := g_invoice_info.amount_applicable_to_discount;
563:

Line 561: l_amt_applicable_to_discount ap_invoices_all.amount_applicable_to_discount%type

557: l_payment_currency_code ap_invoices_all.payment_currency_code%type
558: := g_invoice_info.payment_currency_code;
559: l_payment_cross_rate ap_invoices_all.payment_cross_rate%type
560: := g_invoice_info.payment_cross_rate;
561: l_amt_applicable_to_discount ap_invoices_all.amount_applicable_to_discount%type
562: := g_invoice_info.amount_applicable_to_discount;
563:
564: l_amt_to_subtract NUMBER;
565: l_amt_to_subtract_pay_curr NUMBER;

Line 704: UPDATE ap_invoices_all

700: l_debug_info := 'Step 4: Update amount_applicable_to_discount';
701: Print (l_api_name, l_debug_info);
702: -----------------------------------------------------------------
703:
704: UPDATE ap_invoices_all
705: SET amount_applicable_to_discount = (amount_applicable_to_discount + l_retained_amount)
706: WHERE invoice_id = x_invoice_id;
707: */
708: pay_num_tab.delete;

Line 720: UPDATE ap_invoices_all

716: Print (l_api_name, l_debug_info);
717: ----------------------------------------------------------------------------------------------------------
718:
719: IF abs(l_retained_amount) > 0 then
720: UPDATE ap_invoices_all
721: SET amount_applicable_to_discount = (amount_applicable_to_discount + l_retained_amount),
722: pay_curr_invoice_amount = (pay_curr_invoice_amount + l_retained_amount),
723: validated_tax_amount = NVL(validated_tax_amount,0)+abs(l_retained_amount) /* Bug#14582311*/
724: WHERE invoice_id = x_invoice_id;