DBA Data[Home] [Help]

APPS.FV_WF_BE_APPROVAL dependencies on FND_PROFILE

Line 1163: IF FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', vg_user_id) IS

1159: * * Is modified to use TO_CHAR(datetime) with NLS_CALENDAR
1160: * * parameter.
1161: * * */
1162:
1163: IF FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', vg_user_id) IS
1164: NOT NULL THEN
1165: IF vg_user_id IS NULL OR vg_user_id = '' THEN
1166: vg_user_id:=fnd_global.user_id;
1167: END IF;

Line 1169: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK',

1165: IF vg_user_id IS NULL OR vg_user_id = '' THEN
1166: vg_user_id:=fnd_global.user_id;
1167: END IF;
1168: vl_date_str := nvl(to_char(vl_trx_record.gl_date,
1169: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK',
1170: vg_user_id),
1171: 'NLS_CALENDAR = ''' ||
1172: FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR',
1173: vg_user_id) || ''''),'');

Line 1172: FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR',

1168: vl_date_str := nvl(to_char(vl_trx_record.gl_date,
1169: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK',
1170: vg_user_id),
1171: 'NLS_CALENDAR = ''' ||
1172: FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR',
1173: vg_user_id) || ''''),'');
1174:
1175: IF (disp_type=wf_notification.doc_html) THEN
1176: vl_date_str := '' ||