DBA Data[Home] [Help]

APPS.HR_APPLICANT_INTERNAL dependencies on HR_API

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

824: if g_debug then
825: hr_utility.set_location(l_proc,65);
826: end if;
827: --
828: if l_ptu_rec.effective_end_date <> hr_api.g_eot then
829: hr_per_type_usage_internal.maintain_person_type_usage
830: (p_effective_date => l_new_effective_date
831: ,p_person_id => p_person_id
832: ,p_person_type_id => l_ptu_person_type_id

Line 833: ,p_datetrack_update_mode => hr_api.g_update_override

829: hr_per_type_usage_internal.maintain_person_type_usage
830: (p_effective_date => l_new_effective_date
831: ,p_person_id => p_person_id
832: ,p_person_type_id => l_ptu_person_type_id
833: ,p_datetrack_update_mode => hr_api.g_update_override
834: );
835: else
836: hr_per_type_usage_internal.maintain_person_type_usage
837: (p_effective_date => l_new_effective_date

Line 840: ,p_datetrack_update_mode => hr_api.g_update

836: hr_per_type_usage_internal.maintain_person_type_usage
837: (p_effective_date => l_new_effective_date
838: ,p_person_id => p_person_id
839: ,p_person_type_id => l_ptu_person_type_id
840: ,p_datetrack_update_mode => hr_api.g_update
841: );
842: end if;
843: --
844: end if;

Line 1208: ,p_datetrack_delete_mode => hr_api.g_future_change

1204: hr_per_type_usage_internal.maintain_person_type_usage
1205: (p_effective_date => l_start_date
1206: ,p_person_id => p_person_id
1207: ,p_person_type_id => l_first_person_type_id
1208: ,p_datetrack_delete_mode => hr_api.g_future_change
1209: );
1210: exit;
1211: else
1212: l_start_date := l_ptu_rec.effective_start_date;

Line 1244: ,p_datetrack_delete_mode => hr_api.g_future_change

1240: hr_per_type_usage_internal.maintain_person_type_usage -- 3962781
1241: (p_effective_date => l_start_date
1242: ,p_person_id => p_person_id
1243: ,p_person_type_id => l_current_person_type
1244: ,p_datetrack_delete_mode => hr_api.g_future_change
1245: );
1246: --
1247: exit;
1248: else

Line 1270: ,p_datetrack_delete_mode => hr_api.g_future_change

1266: hr_per_type_usage_internal.maintain_person_type_usage -- 3962781
1267: (p_effective_date => l_new_effective_date -1
1268: ,p_person_id => p_person_id
1269: ,p_person_type_id => l_ptu_rec.person_type_id --l_new_person_type_id
1270: ,p_datetrack_delete_mode => hr_api.g_future_change
1271: );
1272: hr_per_type_usage_internal.maintain_person_type_usage
1273: (p_effective_date => l_new_effective_date
1274: ,p_person_id => p_person_id

Line 1276: ,p_datetrack_update_mode => hr_api.g_update

1272: hr_per_type_usage_internal.maintain_person_type_usage
1273: (p_effective_date => l_new_effective_date
1274: ,p_person_id => p_person_id
1275: ,p_person_type_id => l_new_person_type_id
1276: ,p_datetrack_update_mode => hr_api.g_update
1277: );
1278: else
1279: if g_debug then
1280: hr_utility.set_location(l_proc,75);

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

1279: if g_debug then
1280: hr_utility.set_location(l_proc,75);
1281: end if;
1282: close csr_ptu_details;
1283: if l_ptu_rec.effective_end_date <> hr_api.g_eot then
1284: hr_per_type_usage_internal.maintain_person_type_usage
1285: (p_effective_date => l_new_effective_date
1286: ,p_person_id => p_person_id
1287: ,p_person_type_id => l_new_person_type_id

Line 1288: ,p_datetrack_update_mode => hr_api.g_update_override

1284: hr_per_type_usage_internal.maintain_person_type_usage
1285: (p_effective_date => l_new_effective_date
1286: ,p_person_id => p_person_id
1287: ,p_person_type_id => l_new_person_type_id
1288: ,p_datetrack_update_mode => hr_api.g_update_override
1289: );
1290: else
1291: hr_per_type_usage_internal.maintain_person_type_usage
1292: (p_effective_date => l_new_effective_date

Line 1295: ,p_datetrack_update_mode => hr_api.g_update

1291: hr_per_type_usage_internal.maintain_person_type_usage
1292: (p_effective_date => l_new_effective_date
1293: ,p_person_id => p_person_id
1294: ,p_person_type_id => l_new_person_type_id
1295: ,p_datetrack_update_mode => hr_api.g_update
1296: );
1297: end if;
1298: end if;
1299: --

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

1615: if g_debug then
1616: hr_utility.set_location(l_proc,65);
1617: end if;
1618: --
1619: if l_ptu_rec.effective_end_date <> hr_api.g_eot then
1620: hr_per_type_usage_internal.maintain_person_type_usage
1621: (p_effective_date => p_ex_apl_effective_date
1622: ,p_person_id => p_person_id
1623: ,p_person_type_id => l_ptu_person_type_id -- EX_APL record

Line 1624: ,p_datetrack_update_mode => hr_api.g_update_change_insert

1620: hr_per_type_usage_internal.maintain_person_type_usage
1621: (p_effective_date => p_ex_apl_effective_date
1622: ,p_person_id => p_person_id
1623: ,p_person_type_id => l_ptu_person_type_id -- EX_APL record
1624: ,p_datetrack_update_mode => hr_api.g_update_change_insert
1625: );
1626: else
1627: hr_per_type_usage_internal.maintain_person_type_usage
1628: (p_effective_date => p_ex_apl_effective_date

Line 1631: ,p_datetrack_update_mode => hr_api.g_update

1627: hr_per_type_usage_internal.maintain_person_type_usage
1628: (p_effective_date => p_ex_apl_effective_date
1629: ,p_person_id => p_person_id
1630: ,p_person_type_id => l_ptu_person_type_id -- EX_APL record
1631: ,p_datetrack_update_mode => hr_api.g_update
1632: );
1633: hr_per_type_usage_internal.maintain_person_type_usage
1634: (p_effective_date => p_apl_effective_date
1635: ,p_person_id => p_person_id

Line 1637: ,p_datetrack_update_mode => hr_api.g_update

1633: hr_per_type_usage_internal.maintain_person_type_usage
1634: (p_effective_date => p_apl_effective_date
1635: ,p_person_id => p_person_id
1636: ,p_person_type_id => l_ptu_rec.person_type_id -- APL record
1637: ,p_datetrack_update_mode => hr_api.g_update
1638: );
1639: end if;
1640: --
1641: end if;

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

1703: select application_id, date_received, object_version_number
1704: from per_applications
1705: where person_id = cp_person_id
1706: and date_received <= cp_effective_date
1707: and nvl(date_end,hr_api.g_eot) >= cp_effective_date;
1708:
1709: cursor csr_apl_yesterday(cp_person_id number, cp_effective_date date) is
1710: select application_id, date_received, object_version_number
1711: from per_applications

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

1964: select application_id
1965: from per_applications
1966: where person_id = p_person_id
1967: and date_received < p_effective_date
1968: and nvl(date_end,hr_api.g_eot) >= p_effective_date;
1969:
1970: cursor csr_apl_yesterday is
1971: select application_id
1972: from per_applications

Line 2207: hr_api.mandatory_arg_error

2203: -- Validation Logic
2204: --
2205: -- Ensure that the mandatory parameter, p_person_id is not null
2206: --
2207: hr_api.mandatory_arg_error
2208: (p_api_name => l_proc
2209: ,p_argument => 'person id'
2210: ,p_argument_value => p_person_id);
2211: --