APPS.IBE_REPORTING_PVT dependencies on GL_CURRENCY_API

Line 850: l_rateexist := gl_currency_api.rate_exists(

846: getPeriodDate(pMode,pFactName, pFromDate, pToDate,l_factStartDate, l_factEndDate);
847:
848: for RateRec in RateExistCheckRecs (l_factStartDate, l_factEndDate )
849: loop
850: l_rateexist := gl_currency_api.rate_exists(
851: RateRec.Transactional_Curr_Code,
852: g_CurrencyCode,
853: RateRec.ordered_date,
854: g_ConversionType);

Line 937: gl_currency_api.convert_amount_sql(OH.Transactional_Curr_Code,p_currency_code,trunc(oh.ordered_date),

933: OH.SalesRep_ID,
934: Sum((decode(OL.line_category_code,'RETURN',-1,1)* nvl(OL.Pricing_Quantity,0))*
935: (nvl(OL.Unit_Selling_Price,0)*nvl(Oh.conversion_rate,1))) Functional_Amount,
936: Sum((decode(OL.line_category_code,'RETURN',-1,1)* nvl(OL.Pricing_Quantity,0))*
937: gl_currency_api.convert_amount_sql(OH.Transactional_Curr_Code,p_currency_code,trunc(oh.ordered_date),
938: g_conversionType,nvl(OL.Unit_Selling_Price,0))) Reported_Amount,
939: hca.customer_class_code, hca.party_id
940: FROM Oe_order_Sources OS,
941: Oe_order_headers_all OH,

Line 1006: gl_currency_api.convert_amount_sql( ift.Transactional_Curr_Code,g_CurrencyCode ,

1002: Count(ift.order_number) NUM_TIMES_ORDERED,
1003: Sum(decode(OL.line_category_code,'RETURN',-1,1)* nvl(OL.Pricing_Quantity,0)) AS Sale_Quantity,
1004: return_functional_amount(ol.inventory_item_id,osp.Master_Organization_id,ift.header_id,ol.item_type_code,OL.line_category_code,
1005: OL.ordered_Quantity,OL.Unit_Selling_Price,ift.conversion_rate) Functional_Amount,
1006: gl_currency_api.convert_amount_sql( ift.Transactional_Curr_Code,g_CurrencyCode ,
1007: trunc(ift.ordered_date),g_ConversionType,
1008: return_functional_amount(ol.inventory_item_id,osp.Master_Organization_id,ift.header_id,
1009: ol.item_type_code,OL.line_category_code,
1010: OL.ordered_Quantity,OL.Unit_Selling_Price,ift.conversion_rate) ) Reported_Amount