APPS.GHR_WGI_PKG dependencies on FND_DATE

Line 584: || fnd_date.date_to_displaydate (p_effective_date

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

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

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

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

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

Line 684: || fnd_date.date_to_displaydate (l_wgi_pay_date

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

Line 687: || fnd_date.date_to_displaydate (l_wgi_due_date

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

Line 866: || fnd_date.date_to_displaydate (l_effective_date

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

Line 888: || fnd_date.date_to_displaydate (l_effective_date

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

Line 1205: fnd_date.canonical_to_date (l_scd_leave

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

Line 1217: || fnd_date.date_to_displaydate (l_service_comp_date

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

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

2962: p_ret_value := NULL;
2963: END;
2964:
2965: IF l_value IS NOT NULL THEN
2966: l_wgi_pay_date := fnd_date.canonical_to_date (l_value);
2967: IF (p_effective_date >= (l_wgi_pay_date - p_frequency)) THEN
2968: p_ret_value := l_value;
2969: END IF;
2970: END IF;