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_WITHHOLDING_PKG dependencies on AP_UTILITIES_PKG

Line 289: ap_utilities_pkg.ap_round_currency(

285: rec_temp_dists.accounting_date,
286: rec_temp_dists.period_name,
287: 'N',
288: rec_invoice.set_of_books_id,
289: ap_utilities_pkg.ap_round_currency(
290: -rec_temp_dists.withholding_amount/rec_invoice.exchange_rate,
291: p_currency_code),
292: ap_utilities_pkg.ap_round_currency(
293: -rec_temp_dists.base_withholding_amount,

Line 292: ap_utilities_pkg.ap_round_currency(

288: rec_invoice.set_of_books_id,
289: ap_utilities_pkg.ap_round_currency(
290: -rec_temp_dists.withholding_amount/rec_invoice.exchange_rate,
291: p_currency_code),
292: ap_utilities_pkg.ap_round_currency(
293: -rec_temp_dists.base_withholding_amount,
294: l_basecur),
295: 0,
296: 'NOT REQUIRED', /*bug 4994642, was 'NOT_REQUIRED' */

Line 425: ,ap_utilities_pkg.ap_round_currency(

421: ,SYSDATE
422: ,'AWT'
423: ,rec_temp_dists.period_name
424: ,rec_invoice.set_of_books_id
425: ,ap_utilities_pkg.ap_round_currency(
426: -rec_temp_dists.withholding_amount/rec_invoice.exchange_rate,
427: p_currency_code)
428: ,ap_utilities_pkg.ap_round_currency(-rec_temp_dists.base_withholding_amount,
429: l_basecur)

Line 428: ,ap_utilities_pkg.ap_round_currency(-rec_temp_dists.base_withholding_amount,

424: ,rec_invoice.set_of_books_id
425: ,ap_utilities_pkg.ap_round_currency(
426: -rec_temp_dists.withholding_amount/rec_invoice.exchange_rate,
427: p_currency_code)
428: ,ap_utilities_pkg.ap_round_currency(-rec_temp_dists.base_withholding_amount,
429: l_basecur)
430: ,rec_invoice.batch_id
431: ,P_Last_Updated_By
432: ,SYSDATE

Line 453: ,ap_utilities_pkg.ap_round_currency(

449: -- ,rec_invoice.ussgl_trx_code_context - Bug 4277744
450: ,decode (P_Calling_Module, 'AWT REPORT', 'P',
451: 'A')
452: ,rec_temp_dists.tax_rate_id
453: ,ap_utilities_pkg.ap_round_currency(
454: rec_temp_dists.gross_amount/rec_invoice.exchange_rate,
455: P_currency_code)
456: ,rec_temp_dists.group_id
457: ,rec_temp_dists.invoice_payment_id

Line 498: ap_utilities_pkg.ap_round_currency(

494: p_calling_sequence => current_calling_sequence);
495:
496:
497: withholding_total := withholding_total +
498: ap_utilities_pkg.ap_round_currency(
499: rec_temp_dists.withholding_amount/
500: rec_invoice.exchange_rate,
501: p_currency_code);
502: base_withholding_total := base_withholding_total +

Line 584: amount_to_subtract := Ap_Utilities_Pkg.Ap_Round_Currency

580: amount_to_subtract := withholding_total *
581: (rec_payment_sched.inv_curr_gross_amount /
582: inv_amount_before_withholding
583: );
584: amount_to_subtract := Ap_Utilities_Pkg.Ap_Round_Currency
585: (amount_to_subtract ,P_Currency_Code);
586:
587:
588: -- BUG 7000143 Old Code.

Line 613: pay_curr_amount_to_subtract := ap_utilities_pkg.ap_round_currency(

609: -- (this is due to rounding reasons):
610: amount_to_subtract := withholding_total - subtracting_cumulator;
611: END IF;
612:
613: pay_curr_amount_to_subtract := ap_utilities_pkg.ap_round_currency(
614: amount_to_subtract * rec_invoice.payment_cross_rate,
615: rec_invoice.payment_currency_code);
616:
617: -- Update current payment schedule:

Line 625: ap_utilities_pkg.ap_round_currency(

621: SET amount_remaining = amount_remaining -
622: pay_curr_amount_to_subtract,
623: -- iyas: Following code IS in DLD but was not found originally in file:
624: discount_amount_available = discount_amount_available -
625: ap_utilities_pkg.ap_round_currency(
626: discount_amount_available * l_disc_amt_factor,
627: rec_invoice.payment_currency_code),
628: second_disc_amt_available = second_disc_amt_available -
629: ap_utilities_pkg.ap_round_currency(

Line 629: ap_utilities_pkg.ap_round_currency(

625: ap_utilities_pkg.ap_round_currency(
626: discount_amount_available * l_disc_amt_factor,
627: rec_invoice.payment_currency_code),
628: second_disc_amt_available = second_disc_amt_available -
629: ap_utilities_pkg.ap_round_currency(
630: second_disc_amt_available * l_disc_amt_factor,
631: rec_invoice.payment_currency_code) ,
632: third_disc_amt_available = third_disc_amt_available -
633: ap_utilities_pkg.ap_round_currency(

Line 633: ap_utilities_pkg.ap_round_currency(

629: ap_utilities_pkg.ap_round_currency(
630: second_disc_amt_available * l_disc_amt_factor,
631: rec_invoice.payment_currency_code) ,
632: third_disc_amt_available = third_disc_amt_available -
633: ap_utilities_pkg.ap_round_currency(
634: third_disc_amt_available * l_disc_amt_factor,
635: rec_invoice.payment_currency_code)
636: WHERE CURRENT of c_payment_sched;
637:

Line 652: ap_utilities_pkg.ap_round_currency(

648: -- currency before substracting it FROM the amount remaining.
649:
650: UPDATE ap_payment_schedules_all
651: SET amount_remaining = (amount_remaining -
652: ap_utilities_pkg.ap_round_currency(
653: withholding_total * rec_invoice.payment_cross_rate,
654: rec_invoice.payment_currency_code))
655: WHERE current of c_payment_sched;
656:

Line 805: substrb(Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION' , 'AWT'),1,25)||

801: rec_awt_lines c_awt_lines%ROWTYPE;
802: --
803: CURSOR c_base_invoice_description (InvId IN NUMBER) IS
804: SELECT substrb(
805: substrb(Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION' , 'AWT'),1,25)||
806: ' - '||
807: v.vendor_name||
808: ' - '||
809: i.invoice_num||

Line 1066: substrb(Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION', 'AWT'),1,25)

1062: ,SYSDATE
1063: ,5
1064: ,tax_authority_id
1065: ,DECODE( p_calling_sequence, 'AP_WITHHOLDING_PKG.AP_Undo_Withholding',
1066: substrb(Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION', 'AWT'),1,25)
1067: ||' - '||to_char(P_invoice_id)||' - ' || to_char(rec_awt_lines.invoice_line_number)
1068: ||' - '|| to_char(rec_awt_lines.distribution_line_number)
1069: || ' - ' || Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION','CANCELLED'),
1070: substrb(Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION', 'AWT'),1,25)||

Line 1069: || ' - ' || Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION','CANCELLED'),

1065: ,DECODE( p_calling_sequence, 'AP_WITHHOLDING_PKG.AP_Undo_Withholding',
1066: substrb(Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION', 'AWT'),1,25)
1067: ||' - '||to_char(P_invoice_id)||' - ' || to_char(rec_awt_lines.invoice_line_number)
1068: ||' - '|| to_char(rec_awt_lines.distribution_line_number)
1069: || ' - ' || Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION','CANCELLED'),
1070: substrb(Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION', 'AWT'),1,25)||
1071: ' - '||to_char(P_invoice_id)||' - ' || to_char(rec_awt_lines.invoice_line_number)
1072: ||' - '||to_char(rec_awt_lines.distribution_line_number)
1073: )

Line 1070: substrb(Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION', 'AWT'),1,25)||

1066: substrb(Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION', 'AWT'),1,25)
1067: ||' - '||to_char(P_invoice_id)||' - ' || to_char(rec_awt_lines.invoice_line_number)
1068: ||' - '|| to_char(rec_awt_lines.distribution_line_number)
1069: || ' - ' || Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION','CANCELLED'),
1070: substrb(Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION', 'AWT'),1,25)||
1071: ' - '||to_char(P_invoice_id)||' - ' || to_char(rec_awt_lines.invoice_line_number)
1072: ||' - '||to_char(rec_awt_lines.distribution_line_number)
1073: )
1074: ,rec_awt_lines.set_of_books_id

Line 1091: ,substrb(Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION', 'AWT'),1,25)

1087: ,tax_authority_site_id
1088: ,0
1089: ,0
1090: ,NVL(P_Payment_Date,rec_awt_lines.accounting_date)
1091: ,substrb(Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('NLS TRANSLATION', 'AWT'),1,25)
1092: ,'AWT' -- It was: decode(sign(rec_awt_lines.amount),1,'CREDIT','STANDARD')
1093: ,new_invoice_base_descr
1094: ,rec_awt_lines.batch_id
1095: ,decode(sign(-NVL(rec_awt_lines.base_amount, rec_awt_lines.amount)),

Line 1202: NVL(ap_utilities_pkg.get_current_gl_date(P_Payment_Date, rec_awt_lines.org_id),

1198: 'D',
1199: 'NOT MATCHED',
1200: 'N',
1201: NVL(P_Payment_Date,rec_awt_lines.accounting_date),
1202: NVL(ap_utilities_pkg.get_current_gl_date(P_Payment_Date, rec_awt_lines.org_id),
1203: rec_awt_lines.period_name),
1204: 'N',
1205: rec_awt_lines.set_of_books_id,
1206: -NVL(rec_awt_lines.base_amount, rec_awt_lines.amount),

Line 1323: , NVL(ap_utilities_pkg.get_current_gl_date(P_Payment_Date, rec_awt_lines.org_id),

1319: ,1 -- invoice_line_number
1320: ,P_Last_Updated_By
1321: ,SYSDATE
1322: ,'ITEM'
1323: , NVL(ap_utilities_pkg.get_current_gl_date(P_Payment_Date, rec_awt_lines.org_id),
1324: rec_awt_lines.period_name)
1325: ,rec_awt_lines.set_of_books_id
1326: ,-NVL(rec_awt_lines.base_amount, rec_awt_lines.amount)
1327: ,NULL -- base amount bug 5190989

Line 2187: /* l_subject_amount := ap_utilities_pkg.ap_round_currency(

2183: END IF;
2184:
2185: END IF;
2186: /* Bug 4990575 removed the round currency function from below statement */
2187: /* l_subject_amount := ap_utilities_pkg.ap_round_currency(
2188: l_subject_amount /
2189: rec_ok_sel_invs.payment_cross_rate *
2190: rec_ok_sel_invs.invoice_exchange_rate,
2191: rec_ok_sel_invs.base_currency_code);*/

Line 2195: l_subject_amount := ap_utilities_pkg.ap_round_currency((l_subject_amount * l_invoice_amount/l_amount_payable)

2191: rec_ok_sel_invs.base_currency_code);*/
2192: l_subject_amount := l_subject_amount / rec_ok_sel_invs.payment_cross_rate
2193: * rec_ok_sel_invs.invoice_exchange_rate;
2194: l_amount_payable :=l_invoice_amount + l_total_awt_amount;
2195: l_subject_amount := ap_utilities_pkg.ap_round_currency((l_subject_amount * l_invoice_amount/l_amount_payable)
2196: ,rec_ok_sel_invs.payment_currency_code); --6660355
2197:
2198:
2199: Ap_Do_Withholding

Line 2226: l_withholding_amount := ap_utilities_pkg.ap_round_currency(

2222: AND AATD.invoice_id = rec_ok_sel_invs.invoice_id
2223: AND AATD.payment_num = rec_ok_sel_invs.payment_num
2224: and aatd.checkrun_id = p_checkrun_id;
2225:
2226: l_withholding_amount := ap_utilities_pkg.ap_round_currency(
2227: l_withholding_amount /
2228: rec_ok_sel_invs.invoice_exchange_rate *
2229: rec_ok_sel_invs.payment_cross_rate,
2230: rec_ok_sel_invs.payment_currency_code);

Line 2236: ap_utilities_pkg.ap_round_currency(

2232: debug_info := 'Update proposed payment in ap_selected_invoices';
2233:
2234: UPDATE ap_selected_invoices_all ASI
2235: SET ASI.proposed_payment_amount =
2236: ap_utilities_pkg.ap_round_currency(
2237: ASI.proposed_payment_amount,rec_ok_sel_invs.payment_currency_code) -
2238: l_withholding_amount
2239: -- We round proposed_payment_amount here because we couldn't round it earlier.
2240: ,ASI.payment_amount =

Line 2718: l_withholding_amount := ap_utilities_pkg.ap_round_currency(

2714:
2715: debug_info := 'CLOSE CURSOR c_curr_code';
2716: CLOSE c_curr_code;
2717:
2718: l_withholding_amount := ap_utilities_pkg.ap_round_currency(
2719: (rec_temp.withholding_amount/
2720: curr_code.invoice_exchange_rate) *
2721: curr_code.payment_cross_rate,
2722: curr_code.payment_currency_code);

Line 3222: ap_utilities_pkg.get_open_gl_date(P_Awt_Date, gl_period_name, gl_awt_date);

3218: AND ASP.org_id = l_org_id; /* Bug 4759178, added org_id condition*/
3219:
3220: EXCEPTION
3221: WHEN NO_DATA_FOUND THEN
3222: ap_utilities_pkg.get_open_gl_date(P_Awt_Date, gl_period_name, gl_awt_date);
3223: IF gl_awt_date IS NULL THEN
3224: RAISE NOT_AN_OPEN_GL_PERIOD;
3225: END IF;
3226: END;

Line 3548: ap_utilities_pkg.ap_round_currency(

3544: debug_info := 'Update the payment schedule';
3545:
3546: UPDATE ap_payment_schedules
3547: SET amount_remaining = (amount_remaining +
3548: ap_utilities_pkg.ap_round_currency(
3549: reversed_withholding *
3550: payment_cross_rate,
3551: rec_payment_sched.payment_currency_code))
3552: WHERE CURRENT of c_payment_sched;

Line 3619: ap_utilities_pkg.ap_round_currency(

3615: debug_info := 'Update the AWT bucket';
3616:
3617: UPDATE ap_awt_buckets
3618: SET gross_amount_to_date = (gross_amt_to_date -
3619: ap_utilities_pkg.ap_round_currency(
3620: rec_awt_dists.awt_gross_amount*
3621: NVL(l_invoice_exchange_rate,1),
3622: l_func_currency_code )),
3623: withheld_amount_to_date = (withheld_amt_to_date+

Line 3624: ap_utilities_pkg.ap_round_currency(

3620: rec_awt_dists.awt_gross_amount*
3621: NVL(l_invoice_exchange_rate,1),
3622: l_func_currency_code )),
3623: withheld_amount_to_date = (withheld_amt_to_date+
3624: ap_utilities_pkg.ap_round_currency(
3625: rec_awt_dists.amount*NVL(l_invoice_exchange_rate,1),
3626: l_func_currency_code ))
3627: WHERE CURRENT OF c_awt_bucket;
3628: ELSE

Line 3748: error_text := Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('AWT ERROR',

3744: WHEN NOT_AN_OPEN_GL_PERIOD THEN
3745: DECLARE
3746: error_text VARCHAR2(2000);
3747: BEGIN
3748: error_text := Ap_Utilities_Pkg.Ap_Get_DISplayed_Field('AWT ERROR',
3749: 'GL PERIOD NOT OPEN');
3750: P_AWT_Success := error_text;
3751: END;
3752: --