23: l_proc varchar2(72) := g_package||'derive_PIL_statcd_dates';
24: --
25: begin
26: --
27: hr_utility.set_location('Entering:'|| l_proc, 10);
28: --
29: -- Set OUT parameters
30: --
31: if p_per_in_ler_stat_cd = 'PROCD' then
44: elsif p_per_in_ler_stat_cd = 'CLSD' then
45: p_clsd_dt := p_effective_date;
46: end if;
47: --
48: hr_utility.set_location(' Leaving:'||l_proc, 70);
49: --
50: end derive_PIL_statcd_dates;
51: --
52: --
154: l_clsd_dt date := null;
155: --
156: begin
157: --
158: hr_utility.set_location('Entering:'|| l_proc, 10);
159: --
160: -- Issue a savepoint if operating in validation only mode
161: --
162: savepoint create_Person_Life_Event;
160: -- Issue a savepoint if operating in validation only mode
161: --
162: savepoint create_Person_Life_Event;
163: --
164: hr_utility.set_location(l_proc, 20);
165: --
166: -- Process Logic
167: --
168: begin
387: -- End of API User Hook for the after hook of create_Person_Life_Event
388: --
389: end;
390: --
391: hr_utility.set_location(l_proc, 60);
392: --
393: -- When in validation only mode raise the Validate_Enabled exception
394: --
395: if p_validate then
403: p_procd_dt := l_procd_dt;
404: p_strtd_dt := l_strtd_dt;
405: p_voidd_dt := l_voidd_dt;
406: --
407: hr_utility.set_location(' Leaving:'||l_proc, 70);
408: --
409: exception
410: --
411: when hr_api.validate_enabled then
423: p_object_version_number := null;
424: p_procd_dt := null;
425: p_strtd_dt := null;
426: p_voidd_dt := null;
427: hr_utility.set_location(' Leaving:'||l_proc, 80);
428: --
429: when others then
430: --
431: -- A validation or unexpected error has occured
540: l_clsd_dt date := null;
541: --
542: begin
543: --
544: hr_utility.set_location('Entering:'|| l_proc, 10);
545: --
546: -- Issue a savepoint if operating in validation only mode
547: --
548: savepoint create_Person_Life_Event;
546: -- Issue a savepoint if operating in validation only mode
547: --
548: savepoint create_Person_Life_Event;
549: --
550: hr_utility.set_location(l_proc, 20);
551: --
552: -- Process Logic
553: --
554: begin
961: -- End of API User Hook for the after hook of create_Person_Life_Event
962: --
963: end;
964: --
965: hr_utility.set_location(l_proc, 60);
966: --
967: -- When in validation only mode raise the Validate_Enabled exception
968: --
969: if p_validate then
977: p_procd_dt := l_procd_dt;
978: p_strtd_dt := l_strtd_dt;
979: p_voidd_dt := l_voidd_dt;
980: --
981: hr_utility.set_location(' Leaving:'||l_proc, 70);
982: --
983: exception
984: --
985: when hr_api.validate_enabled then
997: p_object_version_number := null;
998: p_procd_dt := null;
999: p_strtd_dt := null;
1000: p_voidd_dt := null;
1001: hr_utility.set_location(' Leaving:'||l_proc, 80);
1002: --
1003: when others then
1004: --
1005: -- A validation or unexpected error has occured
1087: l_ntfn_dt date := hr_api.g_date;
1088: --
1089: begin
1090: --
1091: hr_utility.set_location('Entering:'|| l_proc, 10);
1092: --
1093: -- Issue a savepoint if operating in validation only mode
1094: --
1095: savepoint update_Person_Life_Event;
1093: -- Issue a savepoint if operating in validation only mode
1094: --
1095: savepoint update_Person_Life_Event;
1096: --
1097: hr_utility.set_location(l_proc, 20);
1098: --
1099: -- Process Logic
1100: --
1101: l_object_version_number := p_object_version_number;
1186: ,p_voidd_dt => l_voidd_dt
1187: ,p_bckt_dt => l_bckt_dt
1188: ,p_clsd_dt => l_clsd_dt);
1189: --
1190: hr_utility.set_location(l_proc, 20);
1191: hr_utility.set_location(l_proc||' l_procd_dt: '||l_procd_dt, 20);
1192: --
1193: ben_pil_upd.upd
1194: (p_per_in_ler_id => p_per_in_ler_id
1187: ,p_bckt_dt => l_bckt_dt
1188: ,p_clsd_dt => l_clsd_dt);
1189: --
1190: hr_utility.set_location(l_proc, 20);
1191: hr_utility.set_location(l_proc||' l_procd_dt: '||l_procd_dt, 20);
1192: --
1193: ben_pil_upd.upd
1194: (p_per_in_ler_id => p_per_in_ler_id
1195: ,p_per_in_ler_stat_cd => p_per_in_ler_stat_cd
1325: -- End of API User Hook for the after hook of update_Person_Life_Event
1326: --
1327: end;
1328: --
1329: hr_utility.set_location(l_proc, 60);
1330: --
1331: -- When in validation only mode raise the Validate_Enabled exception
1332: --
1333: if p_validate then
1340: p_procd_dt := l_procd_dt;
1341: p_strtd_dt := l_strtd_dt;
1342: p_voidd_dt := l_voidd_dt;
1343: --
1344: hr_utility.set_location(' Leaving:'||l_proc, 70);
1345: --
1346: exception
1347: --
1348: when hr_api.validate_enabled then
1355: -- Only set output warning arguments
1356: -- (Any key or derived arguments must be set to null
1357: -- when validation only mode is being used.)
1358: --
1359: hr_utility.set_location(' Leaving:'||l_proc, 80);
1360: --
1361: when others then
1362: --
1363: -- A validation or unexpected error has occured
1388: l_object_version_number ben_per_in_ler.object_version_number%TYPE;
1389: --
1390: begin
1391: --
1392: hr_utility.set_location('Entering:'|| l_proc, 10);
1393: --
1394: -- Issue a savepoint if operating in validation only mode
1395: --
1396: savepoint delete_Person_Life_Event;
1394: -- Issue a savepoint if operating in validation only mode
1395: --
1396: savepoint delete_Person_Life_Event;
1397: --
1398: hr_utility.set_location(l_proc, 20);
1399: --
1400: -- Process Logic
1401: --
1402: l_object_version_number := p_object_version_number;
1448: -- End of API User Hook for the after hook of delete_Person_Life_Event
1449: --
1450: end;
1451: --
1452: hr_utility.set_location(l_proc, 60);
1453: --
1454: -- When in validation only mode raise the Validate_Enabled exception
1455: --
1456: if p_validate then
1456: if p_validate then
1457: raise hr_api.validate_enabled;
1458: end if;
1459: --
1460: hr_utility.set_location(' Leaving:'||l_proc, 70);
1461: --
1462: exception
1463: --
1464: when hr_api.validate_enabled then
1498: l_proc varchar2(72) := g_package||'lck';
1499: --
1500: begin
1501: --
1502: hr_utility.set_location('Entering:'|| l_proc, 10);
1503: --
1504: ben_pil_shd.lck
1505: (p_per_in_ler_id => p_per_in_ler_id
1506: ,p_object_version_number => p_object_version_number);
1504: ben_pil_shd.lck
1505: (p_per_in_ler_id => p_per_in_ler_id
1506: ,p_object_version_number => p_object_version_number);
1507: --
1508: hr_utility.set_location(' Leaving:'||l_proc, 70);
1509: --
1510: end lck;
1511: --
1512: end ben_Person_Life_Event_api;