DBA Data[Home] [Help]

APPS.HR_APPLICANT_INTERNAL dependencies on HR_API

Line 861: if l_ptu_rec.effective_end_date <> hr_api.g_eot then

857: if g_debug then
858: hr_utility.set_location(l_proc,65);
859: end if;
860: --
861: if l_ptu_rec.effective_end_date <> hr_api.g_eot then
862: hr_per_type_usage_internal.maintain_person_type_usage
863: (p_effective_date => l_new_effective_date
864: ,p_person_id => p_person_id
865: ,p_person_type_id => l_ptu_person_type_id

Line 866: ,p_datetrack_update_mode => hr_api.g_update_override

862: hr_per_type_usage_internal.maintain_person_type_usage
863: (p_effective_date => l_new_effective_date
864: ,p_person_id => p_person_id
865: ,p_person_type_id => l_ptu_person_type_id
866: ,p_datetrack_update_mode => hr_api.g_update_override
867: );
868: else
869: hr_per_type_usage_internal.maintain_person_type_usage
870: (p_effective_date => l_new_effective_date

Line 873: ,p_datetrack_update_mode => hr_api.g_update

869: hr_per_type_usage_internal.maintain_person_type_usage
870: (p_effective_date => l_new_effective_date
871: ,p_person_id => p_person_id
872: ,p_person_type_id => l_ptu_person_type_id
873: ,p_datetrack_update_mode => hr_api.g_update
874: );
875: end if;
876: -- ER FPT
877: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then

Line 886: l_datetrack_mode := hr_api.g_correction;

882:
883: open chk_ptu_exists(apl_rec.date_received);
884: fetch chk_ptu_exists into l_exists;
885: if chk_ptu_exists%found then
886: l_datetrack_mode := hr_api.g_correction;
887: else
888: l_datetrack_mode := hr_api.g_update;
889: end if;
890: close chk_ptu_exists;

Line 888: l_datetrack_mode := hr_api.g_update;

884: fetch chk_ptu_exists into l_exists;
885: if chk_ptu_exists%found then
886: l_datetrack_mode := hr_api.g_correction;
887: else
888: l_datetrack_mode := hr_api.g_update;
889: end if;
890: close chk_ptu_exists;
891:
892: hr_per_type_usage_internal.maintain_person_type_usage

Line 1368: ,p_datetrack_delete_mode => hr_api.g_future_change

1364: hr_per_type_usage_internal.maintain_person_type_usage
1365: (p_effective_date => l_start_date
1366: ,p_person_id => p_person_id
1367: ,p_person_type_id => l_first_person_type_id
1368: ,p_datetrack_delete_mode => hr_api.g_future_change
1369: );
1370: exit;
1371: else
1372: l_start_date := l_ptu_rec.effective_start_date;

Line 1404: ,p_datetrack_delete_mode => hr_api.g_future_change

1400: hr_per_type_usage_internal.maintain_person_type_usage -- 3962781
1401: (p_effective_date => l_start_date
1402: ,p_person_id => p_person_id
1403: ,p_person_type_id => l_current_person_type
1404: ,p_datetrack_delete_mode => hr_api.g_future_change
1405: );
1406: --
1407: exit;
1408: else

Line 1430: ,p_datetrack_delete_mode => hr_api.g_future_change

1426: hr_per_type_usage_internal.maintain_person_type_usage -- 3962781
1427: (p_effective_date => l_new_effective_date -1
1428: ,p_person_id => p_person_id
1429: ,p_person_type_id => l_ptu_rec.person_type_id --l_new_person_type_id
1430: ,p_datetrack_delete_mode => hr_api.g_future_change
1431: );
1432: hr_per_type_usage_internal.maintain_person_type_usage
1433: (p_effective_date => l_new_effective_date
1434: ,p_person_id => p_person_id

Line 1436: ,p_datetrack_update_mode => hr_api.g_update

1432: hr_per_type_usage_internal.maintain_person_type_usage
1433: (p_effective_date => l_new_effective_date
1434: ,p_person_id => p_person_id
1435: ,p_person_type_id => l_new_person_type_id
1436: ,p_datetrack_update_mode => hr_api.g_update
1437: );
1438: else
1439: if g_debug then
1440: hr_utility.set_location(l_proc,75);

Line 1443: if l_ptu_rec.effective_end_date <> hr_api.g_eot then

1439: if g_debug then
1440: hr_utility.set_location(l_proc,75);
1441: end if;
1442: close csr_ptu_details;
1443: if l_ptu_rec.effective_end_date <> hr_api.g_eot then
1444: hr_per_type_usage_internal.maintain_person_type_usage
1445: (p_effective_date => l_new_effective_date
1446: ,p_person_id => p_person_id
1447: ,p_person_type_id => l_new_person_type_id

Line 1448: ,p_datetrack_update_mode => hr_api.g_update_override

1444: hr_per_type_usage_internal.maintain_person_type_usage
1445: (p_effective_date => l_new_effective_date
1446: ,p_person_id => p_person_id
1447: ,p_person_type_id => l_new_person_type_id
1448: ,p_datetrack_update_mode => hr_api.g_update_override
1449: );
1450: else
1451: hr_per_type_usage_internal.maintain_person_type_usage
1452: (p_effective_date => l_new_effective_date

Line 1455: ,p_datetrack_update_mode => hr_api.g_update

1451: hr_per_type_usage_internal.maintain_person_type_usage
1452: (p_effective_date => l_new_effective_date
1453: ,p_person_id => p_person_id
1454: ,p_person_type_id => l_new_person_type_id
1455: ,p_datetrack_update_mode => hr_api.g_update
1456: );
1457: end if;
1458: end if;
1459: --

Line 1779: if l_ptu_rec.effective_end_date <> hr_api.g_eot then

1775: if g_debug then
1776: hr_utility.set_location(l_proc,65);
1777: end if;
1778: --
1779: if l_ptu_rec.effective_end_date <> hr_api.g_eot then
1780: hr_per_type_usage_internal.maintain_person_type_usage
1781: (p_effective_date => p_ex_apl_effective_date
1782: ,p_person_id => p_person_id
1783: ,p_person_type_id => l_ptu_person_type_id -- EX_APL record

Line 1784: ,p_datetrack_update_mode => hr_api.g_update_change_insert

1780: hr_per_type_usage_internal.maintain_person_type_usage
1781: (p_effective_date => p_ex_apl_effective_date
1782: ,p_person_id => p_person_id
1783: ,p_person_type_id => l_ptu_person_type_id -- EX_APL record
1784: ,p_datetrack_update_mode => hr_api.g_update_change_insert
1785: );
1786: else
1787: hr_per_type_usage_internal.maintain_person_type_usage
1788: (p_effective_date => p_ex_apl_effective_date

Line 1791: ,p_datetrack_update_mode => hr_api.g_update

1787: hr_per_type_usage_internal.maintain_person_type_usage
1788: (p_effective_date => p_ex_apl_effective_date
1789: ,p_person_id => p_person_id
1790: ,p_person_type_id => l_ptu_person_type_id -- EX_APL record
1791: ,p_datetrack_update_mode => hr_api.g_update
1792: );
1793: hr_per_type_usage_internal.maintain_person_type_usage
1794: (p_effective_date => p_apl_effective_date
1795: ,p_person_id => p_person_id

Line 1797: ,p_datetrack_update_mode => hr_api.g_update

1793: hr_per_type_usage_internal.maintain_person_type_usage
1794: (p_effective_date => p_apl_effective_date
1795: ,p_person_id => p_person_id
1796: ,p_person_type_id => l_ptu_rec.person_type_id -- APL record
1797: ,p_datetrack_update_mode => hr_api.g_update
1798: );
1799: end if;
1800: --
1801: end if;

Line 1867: and nvl(date_end,hr_api.g_eot) >= cp_effective_date;

1863: select application_id, date_received, object_version_number
1864: from per_applications
1865: where person_id = cp_person_id
1866: and date_received <= cp_effective_date
1867: and nvl(date_end,hr_api.g_eot) >= cp_effective_date;
1868:
1869: cursor csr_apl_yesterday(cp_person_id number, cp_effective_date date) is
1870: select application_id, date_received, object_version_number
1871: from per_applications

Line 2178: and nvl(date_end,hr_api.g_eot) >= p_effective_date;

2174: select application_id
2175: from per_applications
2176: where person_id = p_person_id
2177: and date_received < p_effective_date
2178: and nvl(date_end,hr_api.g_eot) >= p_effective_date;
2179:
2180: cursor csr_apl_yesterday is
2181: select application_id
2182: from per_applications

Line 2424: hr_api.mandatory_arg_error

2420: -- Validation Logic
2421: --
2422: -- Ensure that the mandatory parameter, p_person_id is not null
2423: --
2424: hr_api.mandatory_arg_error
2425: (p_api_name => l_proc
2426: ,p_argument => 'person id'
2427: ,p_argument_value => p_person_id);
2428: --