DBA Data[Home] [Help]

APPS.OTA_LO_UTILITY dependencies on FND_DATE

Line 2431: l_lo_status := l_lo_status || ' ' || fnd_date.date_to_displaydate(l_lo_completion_date_tz,2);

2427:
2428: If ( (l_lo_lesson_status = 'C' or l_lo_lesson_status = 'P')
2429: and l_lo_completed_date is not null ) Then
2430: -- l_lo_status := l_lo_status || ' ' || l_lo_completed_date_tz; Modified for iCal Bug 12696284
2431: l_lo_status := l_lo_status || ' ' || fnd_date.date_to_displaydate(l_lo_completion_date_tz,2);
2432: End If;
2433:
2434: --if this is part of active cert prd, return status as "Not Applicable"
2435: if p_active_cert_flag = 'Y' then

Line 4365: l_lo_status := l_lo_status || ' ' || fnd_date.date_to_displaydate(l_lo_completion_date_tz,2);

4361:
4362: If ( (l_lo_lesson_status = 'C' or l_lo_lesson_status = 'P')
4363: and l_lo_completed_date is not null ) Then
4364: -- l_lo_status := l_lo_status || ' ' || l_lo_completed_date_tz; Modified for iCal Bug 12696284
4365: l_lo_status := l_lo_status || ' ' || fnd_date.date_to_displaydate(l_lo_completion_date_tz,2);
4366: End If;
4367:
4368: fnd_message.set_token ('LO_NAME', l_lo_name);
4369: fnd_message.set_token ('STATUS', l_lo_status);