eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_RETAINAGE_PKG dependencies on AP_INVOICES

Line 32: Procedure Update_Payment_Schedules (x_invoice_id IN ap_invoices.invoice_id%type);

28: Procedure Insert_Distributions (x_invoice_id IN NUMBER,
29: x_invoice_line_number IN NUMBER,
30: x_retainage_dist_tab OUT NOCOPY retDistType);
31:
32: Procedure Update_Payment_Schedules (x_invoice_id IN ap_invoices.invoice_id%type);
33:
34: Procedure Update_PO_Shipment_Dists (x_line_location_id IN ap_invoice_lines_all.po_line_location_id%type,
35: x_retained_amount IN ap_invoice_lines_all.retained_amount%type,
36: x_retainage_dist_tab IN retDistType);

Line 41: CURSOR c_invoice_info(c_invoice_id IN ap_invoices.invoice_id%type,

37:
38: Procedure Print (x_api_name IN Varchar2, x_debug_info IN Varchar2);
39:
40:
41: CURSOR c_invoice_info(c_invoice_id IN ap_invoices.invoice_id%type,
42: c_invoice_line_number IN ap_invoice_lines.line_number%type) IS
43: Select ai.invoice_amount invoice_amount,
44: ai.exchange_rate exchange_rate,
45: ai.invoice_currency_code invoice_currency_code,

Line 63: From ap_invoices ai,

59: base_retained_amount,
60: fc.precision precision,
61: fc.minimum_accountable_unit minimum_accountable_unit,
62: fsp.retainage_code_combination_id retainage_code_combination_id
63: From ap_invoices ai,
64: ap_invoice_lines ail,
65: ap_system_parameters asp,
66: financials_system_parameters fsp,
67: fnd_currencies fc

Line 79: PROCEDURE Create_Retainage_Distributions(x_invoice_id IN ap_invoices.invoice_id%type,

75: g_invoice_info c_invoice_info%ROWTYPE;
76: g_user_id NUMBER;
77: g_login_id NUMBER;
78:
79: PROCEDURE Create_Retainage_Distributions(x_invoice_id IN ap_invoices.invoice_id%type,
80: x_invoice_line_number IN ap_invoice_lines.line_number%type) AS
81:
82: l_debug_info Varchar2(240);
83: l_api_name Constant Varchar2(100) := 'Create_Retainage_Distributions';

Line 147: CURSOR c_invoice_distributions (c_invoice_id IN ap_invoices.invoice_id%type,

143: PROCEDURE Insert_Distributions (x_invoice_id IN NUMBER,
144: x_invoice_line_number IN NUMBER,
145: x_retainage_dist_tab OUT NOCOPY retDistType) AS
146:
147: CURSOR c_invoice_distributions (c_invoice_id IN ap_invoices.invoice_id%type,
148: c_invoice_line_number IN ap_invoice_lines.line_number%type,
149: c_max_dist_line_number IN ap_invoice_lines.line_number%type,
150: c_retainage_rate IN number) IS
151: SELECT

Line 536: PROCEDURE Update_Payment_Schedules (x_invoice_id IN ap_invoices.invoice_id%type) AS

532: Print (l_api_name, 'Insert_Distributions (-)');
533:
534: END Insert_Distributions;
535:
536: PROCEDURE Update_Payment_Schedules (x_invoice_id IN ap_invoices.invoice_id%type) AS
537:
538: CURSOR c_payment_schedules (c_invoice_id IN ap_invoices.invoice_id%type) IS
539: SELECT *
540: FROM ap_payment_schedules_all

Line 538: CURSOR c_payment_schedules (c_invoice_id IN ap_invoices.invoice_id%type) IS

534: END Insert_Distributions;
535:
536: PROCEDURE Update_Payment_Schedules (x_invoice_id IN ap_invoices.invoice_id%type) AS
537:
538: CURSOR c_payment_schedules (c_invoice_id IN ap_invoices.invoice_id%type) IS
539: SELECT *
540: FROM ap_payment_schedules_all
541: WHERE invoice_id = c_invoice_id
542: FOR UPDATE OF amount_remaining;

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;