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 145: CURSOR c_invoice_distributions (c_invoice_id IN ap_invoices.invoice_id%type,

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

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

502: Print (l_api_name, 'Insert_Distributions (-)');
503:
504: END Insert_Distributions;
505:
506: PROCEDURE Update_Payment_Schedules (x_invoice_id IN ap_invoices.invoice_id%type) AS
507:
508: CURSOR c_payment_schedules (c_invoice_id IN ap_invoices.invoice_id%type) IS
509: SELECT *
510: FROM ap_payment_schedules_all

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

504: END Insert_Distributions;
505:
506: PROCEDURE Update_Payment_Schedules (x_invoice_id IN ap_invoices.invoice_id%type) AS
507:
508: CURSOR c_payment_schedules (c_invoice_id IN ap_invoices.invoice_id%type) IS
509: SELECT *
510: FROM ap_payment_schedules_all
511: WHERE invoice_id = c_invoice_id
512: FOR UPDATE OF amount_remaining;

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;