DBA Data[Home] [Help]

APPS.IGS_FI_GEN_008 dependencies on FND_PROFILE

Line 1186: SELECT DECODE( NVL(FND_PROFILE.VALUE('IGS_FI_MASK_CREDIT_CARD_NUMBERS'),'F'),

1182: Who When What
1183: uudayapr 8-Oct-2005 BUG 4660773 Added the Function mask_card_number for masking the CC Number
1184: ***********************************************************************************************/
1185: CURSOR cur_mask_card IS
1186: SELECT DECODE( NVL(FND_PROFILE.VALUE('IGS_FI_MASK_CREDIT_CARD_NUMBERS'),'F'),
1187: 'N', p_credit_card,
1188: 'F', RPAD( SUBSTR(p_credit_card,1,4),LENGTH(p_credit_card),'*'),
1189: 'L', LPAD( SUBSTR(p_credit_card,-4),LENGTH(p_credit_card),'*')
1190: )