DBA Data[Home] [Help]

APPS.ARP_EBS_AUTOINV_PREPROC dependencies on GL_CURRENCY_API

Line 45: SET amount = GL_CURRENCY_API.convert_amount( rec.currency_code,

41:
42: -- Updating dist rows
43: -- note use of sysdate - EMU currencies have fixed conversion
44: UPDATE ra_interface_distributions dist
45: SET amount = GL_CURRENCY_API.convert_amount( rec.currency_code,
46: p_func_curr_code,
47: sysdate,
48: 'EMU FIXED',
49: dist.amount ),

Line 62: SET sales_credit_amount_split = GL_CURRENCY_API.convert_amount( rec.currency_code,

58: AND amount is not null;
59:
60: -- Updating salescredit
61: UPDATE ra_interface_salescredits salescred
62: SET sales_credit_amount_split = GL_CURRENCY_API.convert_amount( rec.currency_code,
63: p_func_curr_code,
64: sysdate,
65: 'EMU FIXED',
66: salescred.sales_credit_amount_split )

Line 113: amount = GL_CURRENCY_API.convert_amount( l.currency_code,

109: UPDATE ra_interface_lines_gt l
110: SET currency_code = p_func_curr_code,
111: conversion_rate = 1,
112: conversion_type = 'User',
113: amount = GL_CURRENCY_API.convert_amount( l.currency_code,
114: p_func_curr_code,
115: l.trx_date,
116: 'EMU FIXED',
117: l.amount ) ,

Line 118: unit_selling_price = GL_CURRENCY_API.convert_amount( l.currency_code,

114: p_func_curr_code,
115: l.trx_date,
116: 'EMU FIXED',
117: l.amount ) ,
118: unit_selling_price = GL_CURRENCY_API.convert_amount( l.currency_code,
119: p_func_curr_code,
120: l.trx_date,
121: 'EMU FIXED',
122: l.unit_selling_price ) ,

Line 123: unit_standard_price = GL_CURRENCY_API.convert_amount( l.currency_code,

119: p_func_curr_code,
120: l.trx_date,
121: 'EMU FIXED',
122: l.unit_selling_price ) ,
123: unit_standard_price = GL_CURRENCY_API.convert_amount( l.currency_code,
124: p_func_curr_code,
125: l.trx_date,
126: 'EMU FIXED',
127: l.unit_standard_price )

Line 146: WHEN GL_CURRENCY_API.NO_RATE THEN

142: END LOOP;
143:
144:
145: EXCEPTION
146: WHEN GL_CURRENCY_API.NO_RATE THEN
147: arp_file.write_log( p_text => 'Exception : No rates defined between these 2 currencies');
148: arp_file.write_log( p_text => SQLERRM(SQLCODE) );
149: WHEN OTHERS THEN
150: arp_file.write_log( p_text => SQLERRM(SQLCODE) );