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;
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-';
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 /*
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+';
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;
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-';
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 /*
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+';