DBA Data[Home] [Help]

APPS.OKE_K_APPROVAL_WF2 dependencies on FND_PROFILE

Line 236: || to_char(hrec.Action_Date,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),'NLS_CALENDAR = '''

232: OR (FND_RELEASE.MAJOR_VERSION > 12)
233: )
234: THEN
235: l_action_date_text := ''
236: || to_char(hrec.Action_Date,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),'NLS_CALENDAR = '''
237: || nvl ( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id) , 'GREGORIAN' ) || '''')
238: || '
';
239:
240: ELSE

Line 237: || nvl ( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id) , 'GREGORIAN' ) || '''')

233: )
234: THEN
235: l_action_date_text := ''
236: || to_char(hrec.Action_Date,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),'NLS_CALENDAR = '''
237: || nvl ( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id) , 'GREGORIAN' ) || '''')
238: || '
';
239:
240: ELSE
241: l_action_date_text := fnd_date.date_to_displaydate(hrec.Action_Date,2);