DBA Data[Home] [Help]

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;