DBA Data[Home] [Help]

APPS.BEN_ASSIGNMENT_API dependencies on FND_DATE

Line 724: ,p_aei_information2 => fnd_date.date_to_canonical(p_adjusted_service_date)

720: ,p_information_type => 'BEN_DERIVED'
721: --
722: ,p_aei_information_category => 'BEN_DERIVED'
723: ,p_aei_information1 => p_age
724: ,p_aei_information2 => fnd_date.date_to_canonical(p_adjusted_service_date)
725: ,p_aei_information3 => fnd_date.date_to_canonical(p_original_hire_date)
726: ,p_aei_information4 => l_aei_payroll_changed
727: ,p_aei_information5 => l_origpayroll_id
728: ,p_aei_information6 => p_salary

Line 725: ,p_aei_information3 => fnd_date.date_to_canonical(p_original_hire_date)

721: --
722: ,p_aei_information_category => 'BEN_DERIVED'
723: ,p_aei_information1 => p_age
724: ,p_aei_information2 => fnd_date.date_to_canonical(p_adjusted_service_date)
725: ,p_aei_information3 => fnd_date.date_to_canonical(p_original_hire_date)
726: ,p_aei_information4 => l_aei_payroll_changed
727: ,p_aei_information5 => l_origpayroll_id
728: ,p_aei_information6 => p_salary
729: ,p_aei_information7 => p_original_person_type

Line 730: ,p_aei_information8 => fnd_date.date_to_canonical(p_termination_date)

726: ,p_aei_information4 => l_aei_payroll_changed
727: ,p_aei_information5 => l_origpayroll_id
728: ,p_aei_information6 => p_salary
729: ,p_aei_information7 => p_original_person_type
730: ,p_aei_information8 => fnd_date.date_to_canonical(p_termination_date)
731: ,p_aei_information9 => p_termination_reason
732: ,p_aei_information10 => fnd_date.date_to_canonical(p_leave_of_absence_date)
733: ,p_aei_information11 => p_absence_type
734: ,p_aei_information12 => p_absence_reason

Line 732: ,p_aei_information10 => fnd_date.date_to_canonical(p_leave_of_absence_date)

728: ,p_aei_information6 => p_salary
729: ,p_aei_information7 => p_original_person_type
730: ,p_aei_information8 => fnd_date.date_to_canonical(p_termination_date)
731: ,p_aei_information9 => p_termination_reason
732: ,p_aei_information10 => fnd_date.date_to_canonical(p_leave_of_absence_date)
733: ,p_aei_information11 => p_absence_type
734: ,p_aei_information12 => p_absence_reason
735: ,p_aei_information13 => fnd_date.date_to_canonical(p_date_of_hire)
736: --

Line 735: ,p_aei_information13 => fnd_date.date_to_canonical(p_date_of_hire)

731: ,p_aei_information9 => p_termination_reason
732: ,p_aei_information10 => fnd_date.date_to_canonical(p_leave_of_absence_date)
733: ,p_aei_information11 => p_absence_type
734: ,p_aei_information12 => p_absence_reason
735: ,p_aei_information13 => fnd_date.date_to_canonical(p_date_of_hire)
736: --
737: ,p_assignment_extra_info_id => l_aei_id
738: ,p_object_version_number => l_aei_ovn
739: );

Line 1406: l_char_adjusted_service_date := fnd_date.date_to_canonical(p_adjusted_service_date);

1402: l_char_adjusted_service_date := hr_api.g_varchar2;
1403: --
1404: else
1405: --
1406: l_char_adjusted_service_date := fnd_date.date_to_canonical(p_adjusted_service_date);
1407: --
1408: end if;
1409: --
1410: if p_original_hire_date = hr_api.g_date then

Line 1416: l_char_original_hire_date := fnd_date.date_to_canonical(p_original_hire_date);

1412: l_char_original_hire_date := hr_api.g_varchar2;
1413: --
1414: else
1415: --
1416: l_char_original_hire_date := fnd_date.date_to_canonical(p_original_hire_date);
1417: --
1418: end if;
1419: --
1420: if p_termination_date = hr_api.g_date then

Line 1426: l_char_termination_date := fnd_date.date_to_canonical(p_termination_date);

1422: l_char_termination_date := hr_api.g_varchar2;
1423: --
1424: else
1425: --
1426: l_char_termination_date := fnd_date.date_to_canonical(p_termination_date);
1427: --
1428: end if;
1429: --
1430: if p_leave_of_absence_date = hr_api.g_date then

Line 1436: l_char_leave_of_absence_date := fnd_date.date_to_canonical(p_leave_of_absence_date);

1432: l_char_leave_of_absence_date := hr_api.g_varchar2;
1433: --
1434: else
1435: --
1436: l_char_leave_of_absence_date := fnd_date.date_to_canonical(p_leave_of_absence_date);
1437: --
1438: end if;
1439: --
1440: if p_date_of_hire = hr_api.g_date then

Line 1446: l_char_date_of_hire := fnd_date.date_to_canonical(p_date_of_hire);

1442: l_char_date_of_hire := hr_api.g_varchar2;
1443: --
1444: else
1445: --
1446: l_char_date_of_hire := fnd_date.date_to_canonical(p_date_of_hire);
1447: --
1448: end if;
1449: --
1450: hr_assignment_extra_info_api.update_assignment_extra_info

Line 1455: ,p_aei_information2 => l_char_adjusted_service_date -- fnd_date.date_to_canonical(p_adjusted_service_date)

1451: (p_assignment_extra_info_id => l_assignment_extra_info_id
1452: ,p_object_version_number => l_assignment_extra_info_ovn
1453: ,p_aei_information_category => 'BEN_DERIVED'
1454: ,p_aei_information1 => l_char_age -- p_age
1455: ,p_aei_information2 => l_char_adjusted_service_date -- fnd_date.date_to_canonical(p_adjusted_service_date)
1456: ,p_aei_information3 => l_char_original_hire_date -- fnd_date.date_to_canonical(p_original_hire_date)
1457: ,p_aei_information4 => l_payroll_changed
1458: ,p_aei_information5 => l_orig_payroll_id
1459: ,p_aei_information6 => p_salary

Line 1456: ,p_aei_information3 => l_char_original_hire_date -- fnd_date.date_to_canonical(p_original_hire_date)

1452: ,p_object_version_number => l_assignment_extra_info_ovn
1453: ,p_aei_information_category => 'BEN_DERIVED'
1454: ,p_aei_information1 => l_char_age -- p_age
1455: ,p_aei_information2 => l_char_adjusted_service_date -- fnd_date.date_to_canonical(p_adjusted_service_date)
1456: ,p_aei_information3 => l_char_original_hire_date -- fnd_date.date_to_canonical(p_original_hire_date)
1457: ,p_aei_information4 => l_payroll_changed
1458: ,p_aei_information5 => l_orig_payroll_id
1459: ,p_aei_information6 => p_salary
1460: ,p_aei_information7 => p_original_person_type

Line 1461: ,p_aei_information8 => l_char_termination_date -- fnd_date.date_to_canonical(p_termination_date)

1457: ,p_aei_information4 => l_payroll_changed
1458: ,p_aei_information5 => l_orig_payroll_id
1459: ,p_aei_information6 => p_salary
1460: ,p_aei_information7 => p_original_person_type
1461: ,p_aei_information8 => l_char_termination_date -- fnd_date.date_to_canonical(p_termination_date)
1462: ,p_aei_information9 => p_termination_reason
1463: ,p_aei_information10 => l_char_leave_of_absence_date -- fnd_date.date_to_canonical(p_leave_of_absence_date)
1464: ,p_aei_information11 => p_absence_type
1465: ,p_aei_information12 => p_absence_reason

Line 1463: ,p_aei_information10 => l_char_leave_of_absence_date -- fnd_date.date_to_canonical(p_leave_of_absence_date)

1459: ,p_aei_information6 => p_salary
1460: ,p_aei_information7 => p_original_person_type
1461: ,p_aei_information8 => l_char_termination_date -- fnd_date.date_to_canonical(p_termination_date)
1462: ,p_aei_information9 => p_termination_reason
1463: ,p_aei_information10 => l_char_leave_of_absence_date -- fnd_date.date_to_canonical(p_leave_of_absence_date)
1464: ,p_aei_information11 => p_absence_type
1465: ,p_aei_information12 => p_absence_reason
1466: ,p_aei_information13 => l_char_date_of_hire -- fnd_date.date_to_canonical(p_date_of_hire)
1467: );

Line 1466: ,p_aei_information13 => l_char_date_of_hire -- fnd_date.date_to_canonical(p_date_of_hire)

1462: ,p_aei_information9 => p_termination_reason
1463: ,p_aei_information10 => l_char_leave_of_absence_date -- fnd_date.date_to_canonical(p_leave_of_absence_date)
1464: ,p_aei_information11 => p_absence_type
1465: ,p_aei_information12 => p_absence_reason
1466: ,p_aei_information13 => l_char_date_of_hire -- fnd_date.date_to_canonical(p_date_of_hire)
1467: );
1468: hr_utility.set_location(l_proc, 70);
1469: --
1470: -- When in validation only mode raise the Validate_Enabled exception