DBA Data[Home] [Help]

APPS.HR_PAY_RATE_SS dependencies on FND_PROFILE

Line 343: IF (fnd_profile.value('CURRENCY:THOUSANDS_SEPARATOR') = 'Y' AND

339: l_proc varchar2(200) := g_package || 'format_number';
340:
341: BEGIN
342: hr_utility.set_location(' Entering:' || l_proc,5);
343: IF (fnd_profile.value('CURRENCY:THOUSANDS_SEPARATOR') = 'Y' AND
344: p_number is not null) THEN
345:
346: declare
347: p_input varchar2(200);

Line 371: p_decimalSep := substr(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),1,1);

367: hr_utility.set_location( l_proc,15);
368: p_negative := true;
369: p_input := substr(p_input, 2, length(p_input));
370: END IF;
371: p_decimalSep := substr(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),1,1);
372: p_groupSep := substr(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),2,1);
373: if(p_decimalSep = ',') then
374: hr_utility.set_location( l_proc,20);
375: p_input := replace(p_input,p_decimalSep,p_groupSep);

Line 372: p_groupSep := substr(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),2,1);

368: p_negative := true;
369: p_input := substr(p_input, 2, length(p_input));
370: END IF;
371: p_decimalSep := substr(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),1,1);
372: p_groupSep := substr(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),2,1);
373: if(p_decimalSep = ',') then
374: hr_utility.set_location( l_proc,20);
375: p_input := replace(p_input,p_decimalSep,p_groupSep);
376: end if;