APPS.AP_RETAINAGE_RELEASE_PKG dependencies on AP_UTILITIES_PKG

Line 99: g_period_name := AP_UTILITIES_PKG.get_current_gl_date(g_release_invoice_info.gl_date, g_release_invoice_info.org_id);

95:
96: g_user_id := fnd_profile.value('USER_ID');
97: g_login_id := fnd_profile.value('LOGIN_ID');
98:
99: g_period_name := AP_UTILITIES_PKG.get_current_gl_date(g_release_invoice_info.gl_date, g_release_invoice_info.org_id);
100:
101: IF (g_period_name IS NULL) THEN
102: -- Get gl_period and Date from a future period for the accounting date
103: ap_utilities_pkg.get_open_gl_date(p_date => g_release_invoice_info.gl_date,

Line 103: ap_utilities_pkg.get_open_gl_date(p_date => g_release_invoice_info.gl_date,

99: g_period_name := AP_UTILITIES_PKG.get_current_gl_date(g_release_invoice_info.gl_date, g_release_invoice_info.org_id);
100:
101: IF (g_period_name IS NULL) THEN
102: -- Get gl_period and Date from a future period for the accounting date
103: ap_utilities_pkg.get_open_gl_date(p_date => g_release_invoice_info.gl_date,
104: p_period_name => g_period_name,
105: p_gl_date => g_release_invoice_info.gl_date);
106:
107: IF (g_release_invoice_info.gl_date IS NULL) THEN

Line 245: l_release_base_amount := ap_utilities_pkg.ap_round_currency

241: Begin
242:
243: l_release_proration_factor := x_release_amount / x_release_amount_remaining;
244:
245: l_release_base_amount := ap_utilities_pkg.ap_round_currency
246: (x_release_amount * g_release_invoice_info.exchange_rate,
247: g_release_invoice_info.invoice_currency_code);
248:
249: SELECT nvl(max(line_number),0) + 1

Line 279: x_released_lines_tab(i).amount := ap_utilities_pkg.ap_round_currency

275:
276: l_invoice_line_amount := l_release_proration_factor *
277: x_retained_lines_tab(i).retained_amount_remaining;
278:
279: x_released_lines_tab(i).amount := ap_utilities_pkg.ap_round_currency
280: (l_invoice_line_amount,
281: g_release_invoice_info.invoice_currency_code);
282:
283: x_released_lines_tab(i).base_amount := ap_utilities_pkg.ap_round_currency

Line 283: x_released_lines_tab(i).base_amount := ap_utilities_pkg.ap_round_currency

279: x_released_lines_tab(i).amount := ap_utilities_pkg.ap_round_currency
280: (l_invoice_line_amount,
281: g_release_invoice_info.invoice_currency_code);
282:
283: x_released_lines_tab(i).base_amount := ap_utilities_pkg.ap_round_currency
284: (x_released_lines_tab(i).amount *
285: g_release_invoice_info.exchange_rate,
286: g_release_invoice_info.invoice_currency_code);
287:

Line 579: released_dist_tab(j).amount := ap_utilities_pkg.ap_round_currency

575:
576: l_distribution_amount := -1 * l_release_proration_factor *
577: retained_dist_tab(j).amount;
578:
579: released_dist_tab(j).amount := ap_utilities_pkg.ap_round_currency
580: (l_distribution_amount,
581: g_release_invoice_info.invoice_currency_code);
582:
583: released_dist_tab(j).base_amount := ap_utilities_pkg.ap_round_currency

Line 583: released_dist_tab(j).base_amount := ap_utilities_pkg.ap_round_currency

579: released_dist_tab(j).amount := ap_utilities_pkg.ap_round_currency
580: (l_distribution_amount,
581: g_release_invoice_info.invoice_currency_code);
582:
583: released_dist_tab(j).base_amount := ap_utilities_pkg.ap_round_currency
584: (released_dist_tab(j).amount,
585: g_release_invoice_info.invoice_currency_code);
586:
587: released_dist_tab(j).description := retained_dist_tab(j).description;

Line 763: l_amount_to_recoup := ap_utilities_pkg.ap_round_currency(

759: END IF;
760:
761: IF (l_recoupment_rate IS NOT NULL) THEN
762:
763: l_amount_to_recoup := ap_utilities_pkg.ap_round_currency(
764: (x_released_lines_tab(i).amount * l_recoupment_rate / 100), g_release_invoice_info.invoice_currency_code);
765:
766: l_success := ap_matching_utils_pkg.ap_recoup_invoice_line(
767: P_Invoice_Id => x_released_lines_tab(i).invoice_id,

Line 803: SELECT sum(ap_utilities_pkg.ap_round_currency(ail.retained_amount * ai.exchange_rate, ai.invoice_currency_code))

799: l_final_release_rounding_amt NUMBER;
800:
801: Begin
802:
803: SELECT sum(ap_utilities_pkg.ap_round_currency(ail.retained_amount * ai.exchange_rate, ai.invoice_currency_code))
804: INTO l_sum_retained_base_amount
805: FROM ap_invoices ai,
806: ap_invoice_lines ail
807: WHERE ai.invoice_id = ail.invoice_id