APPS.OZF_REFRESH_SALES_PVT dependencies on GL_CURRENCY_API

Line 175: SET common_amount = gl_currency_api.convert_amount_sql(currency_code,

171:
172: ozf_utility_pvt.write_conc_log(' -- Updating errors from previous run., if any ');
173:
174: UPDATE ozf_sales_transactions_all
175: SET common_amount = gl_currency_api.convert_amount_sql(currency_code,
176: common_currency_code,
177: transaction_date,
178: l_curr_conv_type,
179: amount) ,

Line 196: sign(gl_currency_api.convert_amount_sql(currency_code,

192: NULL,
193: NULL)
194: ), -1, 'Y',
195: DECODE(
196: sign(gl_currency_api.convert_amount_sql(currency_code,
197: common_currency_code,
198: transaction_date,
199: l_curr_conv_type,
200: amount)

Line 300: gl_currency_api.convert_amount_sql(hdr.transactional_curr_code,

296: NULL,
297: NULL), --COMMON_QUANTITY ,
298: l_common_uom, --COMMON_UOM ,
299: l_common_currency_code, --COMMON_CURRENCY_CODE ,
300: gl_currency_api.convert_amount_sql(hdr.transactional_curr_code,
301: l_common_currency_code,
302: NVL(ln.actual_shipment_date,ln.request_date),
303: l_curr_conv_type,
304: ln.unit_selling_price*( NVL(ln.shipped_quantity,ln.ordered_quantity))

Line 315: sign(gl_currency_api.convert_amount_sql(hdr.transactional_curr_code,

311: NULL,
312: NULL)
313: ), -1, 'Y',
314: DECODE(
315: sign(gl_currency_api.convert_amount_sql(hdr.transactional_curr_code,
316: l_common_currency_code,
317: NVL(ln.actual_shipment_date,ln.request_date),
318: l_curr_conv_type,
319: (ln.unit_selling_price*NVL(ln.shipped_quantity,ln.ordered_quantity)))