APPS.BEN_ASSIGNMENT_API dependencies on FND_DATE

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

745: ,p_information_type => 'BEN_DERIVED'
746: --
747: ,p_aei_information_category => 'BEN_DERIVED'
748: ,p_aei_information1 => p_age
749: ,p_aei_information2 => fnd_date.date_to_canonical(p_adjusted_service_date)
750: ,p_aei_information3 => fnd_date.date_to_canonical(p_original_hire_date)
751: ,p_aei_information4 => l_aei_payroll_changed
752: ,p_aei_information5 => l_origpayroll_id
753: ,p_aei_information6 => p_salary

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

746: --
747: ,p_aei_information_category => 'BEN_DERIVED'
748: ,p_aei_information1 => p_age
749: ,p_aei_information2 => fnd_date.date_to_canonical(p_adjusted_service_date)
750: ,p_aei_information3 => fnd_date.date_to_canonical(p_original_hire_date)
751: ,p_aei_information4 => l_aei_payroll_changed
752: ,p_aei_information5 => l_origpayroll_id
753: ,p_aei_information6 => p_salary
754: ,p_aei_information7 => p_original_person_type

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

751: ,p_aei_information4 => l_aei_payroll_changed
752: ,p_aei_information5 => l_origpayroll_id
753: ,p_aei_information6 => p_salary
754: ,p_aei_information7 => p_original_person_type
755: ,p_aei_information8 => fnd_date.date_to_canonical(p_termination_date)
756: ,p_aei_information9 => p_termination_reason
757: ,p_aei_information10 => fnd_date.date_to_canonical(p_leave_of_absence_date)
758: ,p_aei_information11 => p_absence_type
759: ,p_aei_information12 => p_absence_reason

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

753: ,p_aei_information6 => p_salary
754: ,p_aei_information7 => p_original_person_type
755: ,p_aei_information8 => fnd_date.date_to_canonical(p_termination_date)
756: ,p_aei_information9 => p_termination_reason
757: ,p_aei_information10 => fnd_date.date_to_canonical(p_leave_of_absence_date)
758: ,p_aei_information11 => p_absence_type
759: ,p_aei_information12 => p_absence_reason
760: ,p_aei_information13 => fnd_date.date_to_canonical(p_date_of_hire)
761: ,p_aei_information14 => nvl(p_original_person_type_id,l_org_ptyp_id) -- Bug:7562768, store the person_type_id in addition to system_person_type

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

756: ,p_aei_information9 => p_termination_reason
757: ,p_aei_information10 => fnd_date.date_to_canonical(p_leave_of_absence_date)
758: ,p_aei_information11 => p_absence_type
759: ,p_aei_information12 => p_absence_reason
760: ,p_aei_information13 => fnd_date.date_to_canonical(p_date_of_hire)
761: ,p_aei_information14 => nvl(p_original_person_type_id,l_org_ptyp_id) -- Bug:7562768, store the person_type_id in addition to system_person_type
762: --
763: ,p_assignment_extra_info_id => l_aei_id
764: ,p_object_version_number => l_aei_ovn

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

1429: l_char_adjusted_service_date := hr_api.g_varchar2;
1430: --
1431: else
1432: --
1433: l_char_adjusted_service_date := fnd_date.date_to_canonical(p_adjusted_service_date);
1434: --
1435: end if;
1436: --
1437: if p_original_hire_date = hr_api.g_date then

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

1439: l_char_original_hire_date := hr_api.g_varchar2;
1440: --
1441: else
1442: --
1443: l_char_original_hire_date := fnd_date.date_to_canonical(p_original_hire_date);
1444: --
1445: end if;
1446: --
1447: if p_termination_date = hr_api.g_date then

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

1449: l_char_termination_date := hr_api.g_varchar2;
1450: --
1451: else
1452: --
1453: l_char_termination_date := fnd_date.date_to_canonical(p_termination_date);
1454: --
1455: end if;
1456: --
1457: if p_leave_of_absence_date = hr_api.g_date then

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

1459: l_char_leave_of_absence_date := hr_api.g_varchar2;
1460: --
1461: else
1462: --
1463: l_char_leave_of_absence_date := fnd_date.date_to_canonical(p_leave_of_absence_date);
1464: --
1465: end if;
1466: --
1467: if p_date_of_hire = hr_api.g_date then

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

1469: l_char_date_of_hire := hr_api.g_varchar2;
1470: --
1471: else
1472: --
1473: l_char_date_of_hire := fnd_date.date_to_canonical(p_date_of_hire);
1474: --
1475: end if;
1476: --
1477: hr_assignment_extra_info_api.update_assignment_extra_info

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

1478: (p_assignment_extra_info_id => l_assignment_extra_info_id
1479: ,p_object_version_number => l_assignment_extra_info_ovn
1480: ,p_aei_information_category => 'BEN_DERIVED'
1481: ,p_aei_information1 => l_char_age -- p_age
1482: ,p_aei_information2 => l_char_adjusted_service_date -- fnd_date.date_to_canonical(p_adjusted_service_date)
1483: ,p_aei_information3 => l_char_original_hire_date -- fnd_date.date_to_canonical(p_original_hire_date)
1484: ,p_aei_information4 => l_payroll_changed
1485: ,p_aei_information5 => l_orig_payroll_id
1486: ,p_aei_information6 => p_salary

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

1479: ,p_object_version_number => l_assignment_extra_info_ovn
1480: ,p_aei_information_category => 'BEN_DERIVED'
1481: ,p_aei_information1 => l_char_age -- p_age
1482: ,p_aei_information2 => l_char_adjusted_service_date -- fnd_date.date_to_canonical(p_adjusted_service_date)
1483: ,p_aei_information3 => l_char_original_hire_date -- fnd_date.date_to_canonical(p_original_hire_date)
1484: ,p_aei_information4 => l_payroll_changed
1485: ,p_aei_information5 => l_orig_payroll_id
1486: ,p_aei_information6 => p_salary
1487: ,p_aei_information7 => p_original_person_type

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

1484: ,p_aei_information4 => l_payroll_changed
1485: ,p_aei_information5 => l_orig_payroll_id
1486: ,p_aei_information6 => p_salary
1487: ,p_aei_information7 => p_original_person_type
1488: ,p_aei_information8 => l_char_termination_date -- fnd_date.date_to_canonical(p_termination_date)
1489: ,p_aei_information9 => p_termination_reason
1490: ,p_aei_information10 => l_char_leave_of_absence_date -- fnd_date.date_to_canonical(p_leave_of_absence_date)
1491: ,p_aei_information11 => p_absence_type
1492: ,p_aei_information12 => p_absence_reason

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

1486: ,p_aei_information6 => p_salary
1487: ,p_aei_information7 => p_original_person_type
1488: ,p_aei_information8 => l_char_termination_date -- fnd_date.date_to_canonical(p_termination_date)
1489: ,p_aei_information9 => p_termination_reason
1490: ,p_aei_information10 => l_char_leave_of_absence_date -- fnd_date.date_to_canonical(p_leave_of_absence_date)
1491: ,p_aei_information11 => p_absence_type
1492: ,p_aei_information12 => p_absence_reason
1493: ,p_aei_information13 => l_char_date_of_hire -- fnd_date.date_to_canonical(p_date_of_hire)
1494: ,p_aei_information14 => p_original_person_type_id -- Bug:7562768, store the person_type_id in addition to system_person_type

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

1489: ,p_aei_information9 => p_termination_reason
1490: ,p_aei_information10 => l_char_leave_of_absence_date -- fnd_date.date_to_canonical(p_leave_of_absence_date)
1491: ,p_aei_information11 => p_absence_type
1492: ,p_aei_information12 => p_absence_reason
1493: ,p_aei_information13 => l_char_date_of_hire -- fnd_date.date_to_canonical(p_date_of_hire)
1494: ,p_aei_information14 => p_original_person_type_id -- Bug:7562768, store the person_type_id in addition to system_person_type
1495: );
1496: hr_utility.set_location(l_proc, 70);
1497: --