DBA Data[Home] [Help]

APPS.FND_CONC dependencies on FND_PROFILE

Line 231: l_user_calendar := nvl(fnd_profile.value('FND_FORMS_USER_CALENDAR'), 'GREGORIAN');

227:
228: begin
229:
230: -- 7712376 gregorian to nongregorian changes
231: l_user_calendar := nvl(fnd_profile.value('FND_FORMS_USER_CALENDAR'), 'GREGORIAN');
232: if (l_user_calendar = 'GREGORIAN') then
233: l_start_date_conv := date_text(P_ACTUAL_START_DATE);
234: l_updat_date_conv := date_text(P_LAST_UPDATE_DATE);
235: else

Line 348: l_user_calendar := nvl(fnd_profile.value('FND_FORMS_USER_CALENDAR'), 'GREGORIAN');

344: l_updat_date_conv varchar2(80);
345:
346: begin
347: -- 7712376 gregorian to nongregorian changes
348: l_user_calendar := nvl(fnd_profile.value('FND_FORMS_USER_CALENDAR'), 'GREGORIAN');
349: if (l_user_calendar = 'GREGORIAN') then
350: l_updat_date_conv := date_text(P_LAST_UPDATE_DATE);
351: else
352: l_updat_date_conv := to_char(P_LAST_UPDATE_DATE, date_fmt_nongreg,

Line 438: l_user_calendar := nvl(fnd_profile.value('FND_FORMS_USER_CALENDAR'), 'GREGORIAN');

434: l_updat_date_conv varchar2(80);
435:
436: begin
437: -- 7712376 gregorian to nongregorian changes
438: l_user_calendar := nvl(fnd_profile.value('FND_FORMS_USER_CALENDAR'), 'GREGORIAN');
439: if (l_user_calendar = 'GREGORIAN') then
440: l_reqstart_date_conv := date_text(P_REQUESTED_START_DATE);
441: l_updat_date_conv := date_text(P_LAST_UPDATE_DATE);
442: else

Line 571: l_user_calendar := nvl(fnd_profile.value('FND_FORMS_USER_CALENDAR'), 'GREGORIAN');

567:
568: begin
569:
570: -- 7712376 gregorian to nongregorian changes
571: l_user_calendar := nvl(fnd_profile.value('FND_FORMS_USER_CALENDAR'), 'GREGORIAN');
572: if (l_user_calendar = 'GREGORIAN') then
573: l_start_date_conv := date_text(P_ACTUAL_START_DATE);
574: l_cmplt_date_conv := date_text(P_ACTUAL_COMPLETION_DATE);
575: l_updat_date_conv := date_text(P_LAST_UPDATE_DATE);