DBA Data[Home] [Help]

APPS.AP_INVOICE_LINES_UTILITY_PKG dependencies on AP_UTILITIES_PKG

Line 566: -- we call ap_utilities_pkg.get_current_gl_date

562: BULK COLLECT INTO l_gl_date_list;
563: CLOSE dist_gl_date_Cur;
564:
565: -- For bug 5936290
566: -- we call ap_utilities_pkg.get_current_gl_date
567: -- and in ap_utilities_pkg.get_open_gl_date for getting the gl date and
568: -- period below.For both these procedures one parameter is org_id
569: -- and it's default value is mo_global.get_current_org_id.we do
570: -- were not passing the org_id in these procedures calls so

Line 567: -- and in ap_utilities_pkg.get_open_gl_date for getting the gl date and

563: CLOSE dist_gl_date_Cur;
564:
565: -- For bug 5936290
566: -- we call ap_utilities_pkg.get_current_gl_date
567: -- and in ap_utilities_pkg.get_open_gl_date for getting the gl date and
568: -- period below.For both these procedures one parameter is org_id
569: -- and it's default value is mo_global.get_current_org_id.we do
570: -- were not passing the org_id in these procedures calls so
571: -- the org_id was getting picked up from mo_global.get_current_org_id

Line 582: l_open_period := ap_utilities_pkg.get_current_gl_date(l_gl_date_list(i),l_org_id); --added for bug 5936290

578: WHERE invoice_id = p_line_rec.invoice_id;
579:
580: FOR i in NVL(l_gl_date_list.FIRST,0)..NVL(l_gl_date_list.LAST,-1)
581: LOOP
582: l_open_period := ap_utilities_pkg.get_current_gl_date(l_gl_date_list(i),l_org_id); --added for bug 5936290
583:
584: IF ( l_open_period IS NULL ) THEN
585: ap_utilities_pkg.get_open_gl_date(
586: l_gl_date_list(i),

Line 585: ap_utilities_pkg.get_open_gl_date(

581: LOOP
582: l_open_period := ap_utilities_pkg.get_current_gl_date(l_gl_date_list(i),l_org_id); --added for bug 5936290
583:
584: IF ( l_open_period IS NULL ) THEN
585: ap_utilities_pkg.get_open_gl_date(
586: l_gl_date_list(i),
587: l_open_period,
588: l_open_gl_date,
589: l_org_id); --added for bug 5936290

Line 2176: Return (ap_utilities_pkg.ap_round_currency(l_retained_amount, l_currency_code));

2172:
2173: End If;
2174:
2175: -- bug6882900
2176: Return (ap_utilities_pkg.ap_round_currency(l_retained_amount, l_currency_code));
2177:
2178: End Get_Retained_Amount;
2179:
2180: /* ==========================================================================================

Line 2224: ap_utilities_pkg.ap_round_currency(

2220: IF ((l_inv_amt_remaining <> 0) AND (p_manual_withhold_amount is not null))
2221: THEN
2222: update ap_payment_schedules
2223: set amount_remaining = (amount_remaining +
2224: ap_utilities_pkg.ap_round_currency(
2225: (amount_remaining * (p_manual_withhold_amount/l_inv_amt_remaining)
2226: * l_payment_cross_rate), l_payment_currency_code))
2227: where invoice_id = p_invoice_id;
2228:

Line 2233: ap_utilities_pkg.ap_round_currency(

2229: ELSIF ((l_inv_amt_remaining = 0) and (p_manual_withhold_amount is not null))
2230: THEN
2231: update ap_payment_schedules
2232: set amount_remaining = (amount_remaining +
2233: ap_utilities_pkg.ap_round_currency(
2234: (gross_amount * (p_manual_withhold_amount/l_gross_amount)
2235: * l_payment_cross_rate), l_payment_currency_code)),
2236: payment_status_flag = DECODE(payment_status_flag,'Y','P',payment_status_flag)
2237: where invoice_id = p_invoice_id;