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
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,
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
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);