APPS.OKL_SSC_WF dependencies on FND_PROFILE

Line 294: select decode(fnd_profile.value('AR_MASK_BANK_ACCOUNT_NUMBERS'),'F',rpad(substr(cc_number,1,4),length(cc_number),l_mask_string),'L',lpad(substr(cc_number,length(cc_number)-3),length(cc_number),l_mask_string),'N','N')

290: masked_cc varchar2(20);
291: l_result varchar2(20);
292: BEGIN
293: l_mask_string := '*';
294: select decode(fnd_profile.value('AR_MASK_BANK_ACCOUNT_NUMBERS'),'F',rpad(substr(cc_number,1,4),length(cc_number),l_mask_string),'L',lpad(substr(cc_number,length(cc_number)-3),length(cc_number),l_mask_string),'N','N')
295: into l_result
296: from dual;
297: if l_result='N' then
298: masked_cc := cc_number;

Line 820: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),

816: -- For html notification in Hijrah calendar, the MMM date format would be displayed correctly only when tag is used.
817: -- Use NVL for NLS_CALENDAR
818: l_trx_date_text := '' ||
819: to_char(l_trx_date,
820: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
821: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''')
822: || '';
823:
824: else

Line 821: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''')

817: -- Use NVL for NLS_CALENDAR
818: l_trx_date_text := '' ||
819: to_char(l_trx_date,
820: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
821: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''')
822: || '';
823:
824: else
825: -- Use NVL for NLS_CALENDAR

Line 827: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),

823:
824: else
825: -- Use NVL for NLS_CALENDAR
826: l_trx_date_text := to_char(l_trx_date,
827: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
828: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''');
829:
830: end if;
831:

Line 828: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''');

824: else
825: -- Use NVL for NLS_CALENDAR
826: l_trx_date_text := to_char(l_trx_date,
827: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
828: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''');
829:
830: end if;
831:
832: ELSE