DBA Data[Home] [Help]

APPS.AMS_WFCMPAPR_PVT dependencies on FND_PROFILE

Line 3140: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', -1),

3136: or (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.MINOR_VERSION >= 2)
3137: or (FND_RELEASE.MAJOR_VERSION > 12)
3138: then
3139: l_camp_start_date_txt := to_char(l_start_dt,
3140: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', -1),
3141: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR',-1),'GREGORIAN') || '''');
3142: l_camp_end_date_txt := to_char(l_end_dt,
3143: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', -1),
3144: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR',-1),'GREGORIAN') || '''');

Line 3141: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR',-1),'GREGORIAN') || '''');

3137: or (FND_RELEASE.MAJOR_VERSION > 12)
3138: then
3139: l_camp_start_date_txt := to_char(l_start_dt,
3140: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', -1),
3141: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR',-1),'GREGORIAN') || '''');
3142: l_camp_end_date_txt := to_char(l_end_dt,
3143: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', -1),
3144: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR',-1),'GREGORIAN') || '''');
3145: else

Line 3143: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', -1),

3139: l_camp_start_date_txt := to_char(l_start_dt,
3140: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', -1),
3141: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR',-1),'GREGORIAN') || '''');
3142: l_camp_end_date_txt := to_char(l_end_dt,
3143: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', -1),
3144: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR',-1),'GREGORIAN') || '''');
3145: else
3146: l_camp_start_date_txt := to_char(l_start_dt);
3147: l_camp_end_date_txt := to_char(l_end_dt);

Line 3144: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR',-1),'GREGORIAN') || '''');

3140: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', -1),
3141: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR',-1),'GREGORIAN') || '''');
3142: l_camp_end_date_txt := to_char(l_end_dt,
3143: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', -1),
3144: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR',-1),'GREGORIAN') || '''');
3145: else
3146: l_camp_start_date_txt := to_char(l_start_dt);
3147: l_camp_end_date_txt := to_char(l_end_dt);
3148: end if;