DBA Data[Home] [Help]

APPS.FND_CURRENCY dependencies on FND_PROFILE

Line 177: profl_val:= fnd_profile.value('CURRENCY:THOUSANDS_SEPARATOR');

173:
174: /* process the arguments, defaulting in profile values if necessary*/
175:
176: if(disp_grp_sep is NULL) then
177: profl_val:= fnd_profile.value('CURRENCY:THOUSANDS_SEPARATOR');
178: if (profl_val = 'Y') then
179: x_disp_grp_sep := TRUE;
180: else
181: x_disp_grp_sep := FALSE;

Line 196: -- profl_val := fnd_profile.value('CURRENCY:NEGATIVE_FORMAT');

192: * PL/SQL package AFMLCURB.pls.
193: */
194:
195: -- if(neg_format is NULL) then
196: -- profl_val := fnd_profile.value('CURRENCY:NEGATIVE_FORMAT');
197: -- if(profl_val = '0' or profl_val = '1' or profl_val = '2') then
198: -- x_neg_format := '';
199: -- elsif (profl_val = '4') then /* '4' gives trailing sign */
200: -- x_neg_format := 'XXX-';

Line 214: profl_val := fnd_profile.value('CURRENCY:NEGATIVE_FORMAT');

210: -- x_neg_format := neg_format;
211: -- end if;
212:
213: if(neg_format is NULL) then
214: profl_val := fnd_profile.value('CURRENCY:NEGATIVE_FORMAT');
215: if( profl_val = '0' /* (XXX) */
216: or profl_val = '1') then /* [XXX] */
217: x_neg_format := '(XXX)'; -- Bug 5529158
218: elsif( profl_val = '2') then /* */

Line 236: profl_val := fnd_profile.value('CURRENCY:POSITIVE_FORMAT');

232: end if;
233:
234:
235: if(pos_format is NULL) then
236: profl_val := fnd_profile.value('CURRENCY:POSITIVE_FORMAT');
237: if(profl_val = '1') then
238: x_pos_format := '+XXX';
239: elsif (profl_val = '2') then
240: x_pos_format := 'XXX+';

Line 300: profl_val:= fnd_profile.value_specific('CURRENCY:THOUSANDS_SEPARATOR');

296:
297: /* process the arguments, defaulting in profile values if necessary*/
298:
299: if(disp_grp_sep is NULL) then
300: profl_val:= fnd_profile.value_specific('CURRENCY:THOUSANDS_SEPARATOR');
301: if (profl_val = 'Y') then
302: x_disp_grp_sep := TRUE;
303: else
304: x_disp_grp_sep := FALSE;

Line 320: -- profl_val := fnd_profile.value_specific('CURRENCY:NEGATIVE_FORMAT');

316: * FNDSQF.pld and AFMLCURB.pls with regards to handling (XXX).
317: */
318:
319: -- if(neg_format is NULL) then
320: -- profl_val := fnd_profile.value_specific('CURRENCY:NEGATIVE_FORMAT');
321: -- if(profl_val = '0' or profl_val = '1' or profl_val = '2') then
322: -- x_neg_format := '';
323: -- elsif (profl_val = '4') then /* '4' gives trailing sign */
324: -- x_neg_format := 'XXX-';

Line 338: profl_val := fnd_profile.value_specific('CURRENCY:NEGATIVE_FORMAT');

334: -- x_neg_format := neg_format;
335: -- end if;
336:
337: if(neg_format is NULL) then
338: profl_val := fnd_profile.value_specific('CURRENCY:NEGATIVE_FORMAT');
339: if( profl_val = '0' /* (XXX) */
340: or profl_val = '1') then /* [XXX] */
341: x_neg_format := '(XXX)'; -- Bug 5529158
342: elsif( profl_val = '2') then /* */

Line 359: profl_val := fnd_profile.value_specific('CURRENCY:POSITIVE_FORMAT');

355: x_neg_format := neg_format;
356: end if;
357:
358: if(pos_format is NULL) then
359: profl_val := fnd_profile.value_specific('CURRENCY:POSITIVE_FORMAT');
360: if(profl_val = '1') then
361: x_pos_format := '+XXX';
362: elsif (profl_val = '2') then
363: x_pos_format := 'XXX+';