APPS.PAY_NL_WTS_REPORT dependencies on FND_PROFILE

Line 451: IF FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS') = ',.' THEN

447: l_format VARCHAR2(40);
448:
449: BEGIN
450:
451: IF FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS') = ',.' THEN
452: execute immediate ('alter session set nls_numeric_characters ='',.''');
453: ELSE
454: execute immediate ('alter session set nls_numeric_characters =''.,''');
455: END IF;

Line 456: l_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');

452: execute immediate ('alter session set nls_numeric_characters ='',.''');
453: ELSE
454: execute immediate ('alter session set nls_numeric_characters =''.,''');
455: END IF;
456: l_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
457: execute immediate 'alter session set nls_date_format = ''' ||l_format ||'''';
458: --hr_utility.trace_on(null,'WTS_bug');
459: hr_utility.set_location('Inside populate_wts_report_data',2000);
460:

Line 1057: IF FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS') = ',.' THEN

1053: l_format VARCHAR2(40);
1054:
1055: BEGIN
1056:
1057: IF FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS') = ',.' THEN
1058: execute immediate ('alter session set nls_numeric_characters ='',.''');
1059: ELSE
1060: execute immediate ('alter session set nls_numeric_characters =''.,''');
1061: END IF;

Line 1062: l_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');

1058: execute immediate ('alter session set nls_numeric_characters ='',.''');
1059: ELSE
1060: execute immediate ('alter session set nls_numeric_characters =''.,''');
1061: END IF;
1062: l_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
1063: execute immediate 'alter session set nls_date_format = ''' ||l_format ||'''';
1064: --hr_utility.trace_on(null,'WTS_bug');
1065: hr_utility.set_location('Inside populate_wts_report_data',2000);
1066: