APPS.GHR_WF_PKG dependencies on FND_DATE

Line 968: l_line2 := fnd_date.date_to_displaydate(l_effective_date) || ' / ASAP';

964: end if;
965: p_line1 := l_line1;
966: -- Second line of message
967: IF l_proposed_effective_date is null then
968: l_line2 := fnd_date.date_to_displaydate(l_effective_date) || ' / ASAP';
969: ELSE
970: l_line2 := fnd_date.date_to_displaydate(l_effective_date) || ' / '|| fnd_date.date_to_displaydate(l_proposed_effective_date);
971: END IF;
972: p_line2 := l_line2;

Line 970: l_line2 := fnd_date.date_to_displaydate(l_effective_date) || ' / '|| fnd_date.date_to_displaydate(l_proposed_effective_date);

966: -- Second line of message
967: IF l_proposed_effective_date is null then
968: l_line2 := fnd_date.date_to_displaydate(l_effective_date) || ' / ASAP';
969: ELSE
970: l_line2 := fnd_date.date_to_displaydate(l_effective_date) || ' / '|| fnd_date.date_to_displaydate(l_proposed_effective_date);
971: END IF;
972: p_line2 := l_line2;
973: -- Third line of message
974: l_line3 := l_status;

Line 981: l_line5 := fnd_date.date_to_displaydate(sysdate) || ' / ' || fnd_date.date_to_displaydate(l_creation_date);

977: l_line4 := l_routing_group_name || ' - ' || l_description;
978: p_line4 := l_line4;
979: -- 5th line of message
980: if l_date_notification_sent Is Null then
981: l_line5 := fnd_date.date_to_displaydate(sysdate) || ' / ' || fnd_date.date_to_displaydate(l_creation_date);
982: else
983: l_line5 := fnd_date.date_to_displaydate(sysdate) || ' / ' || fnd_date.date_to_displaydate(l_date_notification_sent);
984: end if;
985: p_line5 := l_line5;

Line 983: l_line5 := fnd_date.date_to_displaydate(sysdate) || ' / ' || fnd_date.date_to_displaydate(l_date_notification_sent);

979: -- 5th line of message
980: if l_date_notification_sent Is Null then
981: l_line5 := fnd_date.date_to_displaydate(sysdate) || ' / ' || fnd_date.date_to_displaydate(l_creation_date);
982: else
983: l_line5 := fnd_date.date_to_displaydate(sysdate) || ' / ' || fnd_date.date_to_displaydate(l_date_notification_sent);
984: end if;
985: p_line5 := l_line5;
986: -- 6th of message
987: if l_to_organization_name Is Not Null then