APPS.GHR_WGI_PKG dependencies on FND_DATE

Line 586: || fnd_date.date_to_displaydate (p_effective_date

582: || ' p_position_id : '
583: || TO_CHAR (l_from_position_id
584: )
585: || ' p_effective_date : '
586: || fnd_date.date_to_displaydate (p_effective_date
587: ),
588: p_message_name => NULL,
589: p_log_date => SYSDATE
590: );

Line 651: l_wgi_due_date := fnd_date.canonical_to_date (l_value);

647: p_value => l_value,
648: p_multiple_error_flag => l_multiple_error_flag
649: );
650: IF l_value IS NOT NULL THEN
651: l_wgi_due_date := fnd_date.canonical_to_date (l_value);
652: ELSE
653: l_wgi_due_date := NULL;
654: END IF;
655: -- End Bug 3747024

Line 668: l_wgi_pay_date := fnd_date.canonical_to_date (l_value);

664:
665: --
666: IF l_value IS NOT NULL
667: THEN
668: l_wgi_pay_date := fnd_date.canonical_to_date (l_value);
669: ELSE
670: l_wgi_pay_date := NULL;
671: END IF;
672:

Line 686: || fnd_date.date_to_displaydate (l_wgi_pay_date

682: || ' Assignment ID : '
683: || TO_CHAR (l_assignment_id
684: )
685: || ' WGI Pay Date : '
686: || fnd_date.date_to_displaydate (l_wgi_pay_date
687: )
688: || ' WGI Due Date : '
689: || fnd_date.date_to_displaydate (l_wgi_due_date
690: ),

Line 689: || fnd_date.date_to_displaydate (l_wgi_due_date

685: || ' WGI Pay Date : '
686: || fnd_date.date_to_displaydate (l_wgi_pay_date
687: )
688: || ' WGI Due Date : '
689: || fnd_date.date_to_displaydate (l_wgi_due_date
690: ),
691: p_message_name => NULL,
692: p_log_date => SYSDATE
693: );

Line 868: || fnd_date.date_to_displaydate (l_effective_date

864: || ' Person ID : '
865: || TO_CHAR (l_person_id
866: )
867: || ' p_effective_date : '
868: || fnd_date.date_to_displaydate (l_effective_date
869: )
870: || ' p_first_noa_code : '
871: || l_first_noa_code,
872: p_message_name => NULL,

Line 890: || fnd_date.date_to_displaydate (l_effective_date

886: || ' Person ID : '
887: || TO_CHAR (l_person_id
888: )
889: || ' p_effective_date : '
890: || fnd_date.date_to_displaydate (l_effective_date
891: )
892: || ' p_first_noa_code : '
893: || l_first_noa_code,
894: p_message_name => NULL,

Line 1207: fnd_date.canonical_to_date (l_scd_leave

1203: --
1204: -- populate service comp date
1205: --
1206: l_service_comp_date :=
1207: fnd_date.canonical_to_date (l_scd_leave
1208: );
1209:
1210: IF p_log_flag = 'Y'
1211: THEN

Line 1219: || fnd_date.date_to_displaydate (l_service_comp_date

1215: || ' Person ID : '
1216: || TO_CHAR (l_person_id
1217: )
1218: || ' service_comp_date : '
1219: || fnd_date.date_to_displaydate (l_service_comp_date
1220: ),
1221: p_message_name => NULL,
1222: p_log_date => SYSDATE
1223: );

Line 2970: l_wgi_pay_date := fnd_date.canonical_to_date (l_value);

2966: p_ret_value := NULL;
2967: END;
2968:
2969: IF l_value IS NOT NULL THEN
2970: l_wgi_pay_date := fnd_date.canonical_to_date (l_value);
2971: IF (p_effective_date >= (l_wgi_pay_date - p_frequency)) THEN
2972: p_ret_value := l_value;
2973: END IF;
2974: END IF;