APPS.PAY_NL_WTS_REPORT dependencies on FND_PROFILE

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

516: l_format VARCHAR2(40);
517:
518: BEGIN
519:
520: IF FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS') = ',.' THEN
521: execute immediate ('alter session set nls_numeric_characters ='',.''');
522: ELSE
523: execute immediate ('alter session set nls_numeric_characters =''.,''');
524: END IF;

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

521: execute immediate ('alter session set nls_numeric_characters ='',.''');
522: ELSE
523: execute immediate ('alter session set nls_numeric_characters =''.,''');
524: END IF;
525: l_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
526: execute immediate 'alter session set nls_date_format = ''' ||l_format ||'''';
527: --hr_utility.trace_on(null,'WTS_bug');
528: hr_utility.set_location('Inside populate_wts_report_data',2000);
529:

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

1131: l_format VARCHAR2(40);
1132:
1133: BEGIN
1134:
1135: IF FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS') = ',.' THEN
1136: execute immediate ('alter session set nls_numeric_characters ='',.''');
1137: ELSE
1138: execute immediate ('alter session set nls_numeric_characters =''.,''');
1139: END IF;

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

1136: execute immediate ('alter session set nls_numeric_characters ='',.''');
1137: ELSE
1138: execute immediate ('alter session set nls_numeric_characters =''.,''');
1139: END IF;
1140: l_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
1141: execute immediate 'alter session set nls_date_format = ''' ||l_format ||'''';
1142: --hr_utility.trace_on(null,'WTS_bug');
1143: hr_utility.set_location('Inside populate_wts_report_data',2000);
1144: