DBA Data[Home] [Help]

APPS.GL_EURO_USER_RATE_API dependencies on GL_CURRENCY_API

Line 65: gl_currency_api.get_relation(

61: IF (x_conversion_type <> 'User') THEN
62: RETURN('N');
63: END IF;
64:
65: gl_currency_api.get_relation(
66: x_from_currency,
67: x_to_currency,
68: trunc(x_conversion_date),
69: x_fixed_rate,

Line 78: WHEN gl_currency_api.INVALID_CURRENCY THEN

74: ELSE
75: RETURN('N');
76: END IF;
77: EXCEPTION
78: WHEN gl_currency_api.INVALID_CURRENCY THEN
79: RAISE INVALID_CURRENCY;
80: END is_cross_rate;
81:
82:

Line 116: gl_currency_api.get_relation(

112: x_relationship VARCHAR2(50);
113: x_fixed_rate BOOLEAN;
114: euro_code VARCHAR2(15);
115: BEGIN
116: gl_currency_api.get_relation(
117: x_from_currency,
118: x_to_currency,
119: trunc(x_conversion_date),
120: x_fixed_rate,

Line 123: euro_code := gl_currency_api.get_euro_code;

119: trunc(x_conversion_date),
120: x_fixed_rate,
121: x_relationship);
122:
123: euro_code := gl_currency_api.get_euro_code;
124:
125: IF (x_relationship = 'EMU-OTHER') THEN
126: fnd_message.set_name('SQLGL', 'GL_GLXFCMDR_CURRENCY');
127: fnd_message.set_token('CURRENCY1', euro_code);

Line 141: x_euro_to_emu_rate := gl_currency_api.get_rate(

137: fnd_message.set_token('CURRENCY1', x_from_currency);
138: fnd_message.set_token('CURRENCY2', x_to_currency);
139: x_emu_to_other_prompt := substrb(fnd_message.get, 1, 30);
140:
141: x_euro_to_emu_rate := gl_currency_api.get_rate(
142: euro_code,
143: x_from_currency,
144: trunc(x_conversion_date),
145: NULL);

Line 163: x_euro_to_emu_rate := gl_currency_api.get_rate(

159: fnd_message.set_token('CURRENCY1', x_from_currency);
160: fnd_message.set_token('CURRENCY2', x_to_currency);
161: x_emu_to_other_prompt := substrb(fnd_message.get, 1, 30);
162:
163: x_euro_to_emu_rate := gl_currency_api.get_rate(
164: euro_code,
165: x_to_currency,
166: trunc(x_conversion_date),
167: NULL);

Line 172: WHEN gl_currency_api.INVALID_CURRENCY THEN

168: ELSE
169: RAISE INVALID_RELATION;
170: END IF;
171: EXCEPTION
172: WHEN gl_currency_api.INVALID_CURRENCY THEN
173: RAISE INVALID_CURRENCY;
174: END get_prompts_and_rate;
175:
176: --

Line 204: gl_currency_api.get_relation(

200: x_euro_to_emu_rate NUMBER ) RETURN NUMBER IS
201: x_relationship VARCHAR2(50);
202: x_fixed_rate BOOLEAN;
203: BEGIN
204: gl_currency_api.get_relation(
205: x_from_currency,
206: x_to_currency,
207: trunc(x_conversion_date),
208: x_fixed_rate,

Line 219: WHEN gl_currency_api.INVALID_CURRENCY THEN

215: ELSE
216: RAISE INVALID_RELATION;
217: END IF;
218: EXCEPTION
219: WHEN gl_currency_api.INVALID_CURRENCY THEN
220: RAISE INVALID_CURRENCY;
221: END get_cross_rate;
222:
223: END gl_euro_user_rate_api;