DBA Data[Home] [Help]

APPS.HRI_OLTP_DISC_TRAINING dependencies on HRI_BPL_CURRENCY

Line 145: l_pro_rata_amount := hri_bpl_currency.convert_currency_amount(

141:
142: --------------------------------------------------------------------
143: -- Convert to currency of BG AND update total for all program events
144: --------------------------------------------------------------------
145: l_pro_rata_amount := hri_bpl_currency.convert_currency_amount(
146: p_from_currency => p_currency_code
147: ,p_to_currency => g_bg_currency_code
148: ,p_conversion_date => SYSDATE
149: ,p_amount => l_pro_rata_amount

Line 211: l_converted_amount := hri_bpl_currency.convert_currency_amount(

207: -- Set package global variables
208: set_training_globals(p_event_id => p_event_id);
209:
210: -- Convert Budget Cost to business group currency
211: l_converted_amount := hri_bpl_currency.convert_currency_amount(
212: p_from_currency => l_budget_currency_code
213: ,p_to_currency => g_bg_currency_code
214: ,p_conversion_date => SYSDATE
215: ,p_amount => l_budget_cost

Line 312: l_resource_cost := hri_bpl_currency.convert_currency_amount(

308: -- Calculate total cost of resource bookings against the event
309: FOR resource_bookings_rec IN resource_bookings_csr(p_event_id) LOOP
310:
311: -- Convert to currency of BG
312: l_resource_cost := hri_bpl_currency.convert_currency_amount(
313: p_from_currency => resource_bookings_rec.currency_code
314: ,p_to_currency => g_bg_currency_code
315: ,p_conversion_date => SYSDATE
316: ,p_amount => resource_bookings_rec.cost

Line 326: l_event_cost := hri_bpl_currency.convert_currency_amount(

322:
323: -- Default to the actual cost on the event if necessary
324: IF l_event_cost = 0 THEN
325:
326: l_event_cost := hri_bpl_currency.convert_currency_amount(
327: p_from_currency => l_actual_currency_code
328: ,p_to_currency => g_bg_currency_code
329: ,p_conversion_date => SYSDATE
330: ,p_amount => l_actual_cost

Line 394: l_internal_revenue := hri_bpl_currency.convert_currency_amount(

390: -- Calculate internal revenue
391: l_internal_revenue := l_total_int_students * l_standard_price;
392:
393: -- Convert to currency of business group
394: l_internal_revenue := hri_bpl_currency.convert_currency_amount(
395: p_from_currency => l_currency_code
396: ,p_to_currency => g_bg_currency_code
397: ,p_conversion_date => SYSDATE
398: ,p_amount => l_internal_revenue

Line 453: l_line_amount := hri_bpl_currency.convert_currency_amount(

449:
450: FOR finance_lines_rec IN finance_lines_csr(external_bookings_rec.booking_id) LOOP
451:
452: -- Convert to currency of business group
453: l_line_amount := hri_bpl_currency.convert_currency_amount(
454: p_FROM_currency => finance_lines_rec.currency_code
455: ,p_to_currency => g_bg_currency_code
456: ,p_conversion_date => SYSDATE
457: ,p_amount => finance_lines_rec.amount

Line 534: l_internal_revenue := hri_bpl_currency.convert_currency_amount(

530: -- Calculate internal revenue
531: l_internal_revenue := l_total_int_students * l_stANDard_price;
532:
533: -- Convert to currency of business group
534: l_internal_revenue := hri_bpl_currency.convert_currency_amount(
535: p_from_currency => l_currency_code
536: ,p_to_currency => g_bg_currency_code
537: ,p_conversion_date => SYSDATE
538: ,p_amount => l_internal_revenue

Line 601: l_line_amount := hri_bpl_currency.convert_currency_amount(

597:
598: FOR finance_lines_rec IN finance_lines_csr(external_bookings_rec.booking_id) LOOP
599:
600: -- Convert to currency of business group
601: l_line_amount := hri_bpl_currency.convert_currency_amount(
602: p_from_currency => finance_lines_rec.currency_code
603: ,p_to_currency => g_bg_currency_code
604: ,p_conversion_date => SYSDATE
605: ,p_amount => finance_lines_rec.amount

Line 681: l_internal_revenue := hri_bpl_currency.convert_currency_amount(

677: -- Calculate internal revenue
678: l_internal_revenue := l_total_int_students * l_stANDard_price;
679:
680: -- Convert to currency of business group
681: l_internal_revenue := hri_bpl_currency.convert_currency_amount(
682: p_FROM_currency => l_currency_code
683: ,p_to_currency => g_bg_currency_code
684: ,p_conversion_date => SYSDATE
685: ,p_amount => l_internal_revenue

Line 748: l_line_amount := hri_bpl_currency.convert_currency_amount(

744:
745: FOR finance_lines_rec IN finance_lines_csr(external_bookings_rec.booking_id) LOOP
746:
747: -- Convert to currency of business group
748: l_line_amount := hri_bpl_currency.convert_currency_amount(
749: p_from_currency => finance_lines_rec.currency_code
750: ,p_to_currency => g_bg_currency_code
751: ,p_conversion_date => SYSDATE
752: ,p_amount => finance_lines_rec.amount