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 263: l_release_base_amount := ap_utilities_pkg.ap_round_currency

259: --end bug13090879
260:
261: l_release_proration_factor := x_release_amount / x_release_amount_remaining;
262:
263: l_release_base_amount := ap_utilities_pkg.ap_round_currency
264: (x_release_amount * g_release_invoice_info.exchange_rate,
265: g_release_invoice_info.invoice_currency_code);
266:
267: SELECT nvl(max(line_number),0) + 1

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

293:
294: l_invoice_line_amount := l_release_proration_factor *
295: x_retained_lines_tab(i).retained_amount_remaining;
296:
297: x_released_lines_tab(i).amount := ap_utilities_pkg.ap_round_currency
298: (l_invoice_line_amount,
299: g_release_invoice_info.invoice_currency_code);
300:
301: x_released_lines_tab(i).base_amount := ap_utilities_pkg.ap_round_currency

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

297: x_released_lines_tab(i).amount := ap_utilities_pkg.ap_round_currency
298: (l_invoice_line_amount,
299: g_release_invoice_info.invoice_currency_code);
300:
301: x_released_lines_tab(i).base_amount := ap_utilities_pkg.ap_round_currency
302: (x_released_lines_tab(i).amount *
303: g_release_invoice_info.exchange_rate,
304: g_release_invoice_info.invoice_currency_code);
305:

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

605:
606: l_distribution_amount := -1 * l_release_proration_factor *
607: retained_dist_tab(j).amount;
608:
609: released_dist_tab(j).amount := ap_utilities_pkg.ap_round_currency
610: (l_distribution_amount,
611: g_release_invoice_info.invoice_currency_code);
612:
613: released_dist_tab(j).base_amount := ap_utilities_pkg.ap_round_currency

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

609: released_dist_tab(j).amount := ap_utilities_pkg.ap_round_currency
610: (l_distribution_amount,
611: g_release_invoice_info.invoice_currency_code);
612:
613: released_dist_tab(j).base_amount := ap_utilities_pkg.ap_round_currency
614: (released_dist_tab(j).amount,
615: g_release_invoice_info.invoice_currency_code);
616:
617: released_dist_tab(j).description := retained_dist_tab(j).description;

Line 799: l_amount_to_recoup := ap_utilities_pkg.ap_round_currency(

795: END IF;
796:
797: IF (l_recoupment_rate IS NOT NULL) THEN
798:
799: l_amount_to_recoup := ap_utilities_pkg.ap_round_currency(
800: (x_released_lines_tab(i).amount * l_recoupment_rate / 100), g_release_invoice_info.invoice_currency_code);
801:
802: l_success := ap_matching_utils_pkg.ap_recoup_invoice_line(
803: P_Invoice_Id => x_released_lines_tab(i).invoice_id,

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

835: l_final_release_rounding_amt NUMBER;
836:
837: Begin
838:
839: SELECT sum(ap_utilities_pkg.ap_round_currency(ail.retained_amount * ai.exchange_rate, ai.invoice_currency_code))
840: INTO l_sum_retained_base_amount
841: FROM ap_invoices ai,
842: ap_invoice_lines ail
843: WHERE ai.invoice_id = ail.invoice_id