[Home] [Help]
36: l_suspend_enrl c_suspend_enrl%rowtype;
37: --
38: begin
39: --
40: hr_utility.set_location ('Entering '||l_package,10);
41: --
42: -- Check if the enrollment result is already suspended.
43: --
44: open c_suspend_enrl;
60: ,p_datetrack_mode => p_datetrack_mode);
61: --
62: end if;
63: --
64: hr_utility.set_location ('Leaving ' ||l_package,10);
65: --
66: end suspend_rslt;
67: --
68: -- ----------------------------------------------------------------------------
115: l_cmpltd_actn c_cmpltd_actn%rowtype;
116: --
117: begin
118: --
119: hr_utility.set_location ('Entering '||l_package,10);
120: --
121: open c_suspend_enrl;
122: fetch c_suspend_enrl into l_suspend_enrl;
123: close c_suspend_enrl;
154: else
155: NULL; -- Enrollment already unsuspended.
156: end if;
157: --
158: hr_utility.set_location ('Leaving ' ||l_package,10);
159: --
160: end unsuspend_rslt;
161: --
162: -- ----------------------------------------------------------------------------
245: l_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
246: --
247: begin
248: --
249: hr_utility.set_location('Entering:'|| l_proc, 10);
250: --
251: -- Issue a savepoint if operating in validation only mode
252: --
253: savepoint create_PRTT_ENRT_ACTN;
251: -- Issue a savepoint if operating in validation only mode
252: --
253: savepoint create_PRTT_ENRT_ACTN;
254: --
255: hr_utility.set_location(l_proc, 20);
256: --
257: -- Process Logic
258: --
259: begin
426: -- End of API User Hook for the after hook of create_PRTT_ENRT_ACTN
427: --
428: end;
429: --
430: hr_utility.set_location(l_proc, 60);
431: --
432: p_prtt_enrt_actn_id := l_prtt_enrt_actn_id;
433: p_effective_start_date := l_effective_start_date;
434: p_effective_end_date := l_effective_end_date;
503: end if;
504: --
505: -- Set all output arguments
506: --
507: hr_utility.set_location(' Leaving:'||l_proc, 70);
508: --
509: exception
510: --
511: when hr_api.validate_enabled
523: p_prtt_enrt_actn_id := null;
524: p_effective_start_date := null;
525: p_effective_end_date := null;
526: p_object_version_number := null;
527: hr_utility.set_location(' Leaving:'||l_proc, 80);
528: --
529: when others then
530: --
531: -- A validation or unexpected error has occured
623: l_per_in_ler_id number;
624: --
625: begin
626: --
627: hr_utility.set_location('Entering:'|| l_proc, 10);
628: --
629: -- Issue a savepoint if operating in validation only mode
630: --
631: savepoint create_PRTT_ENRT_ACTN;
629: -- Issue a savepoint if operating in validation only mode
630: --
631: savepoint create_PRTT_ENRT_ACTN;
632: --
633: hr_utility.set_location(l_proc, 20);
634: --
635: -- Process Logic
636: --
637: begin
818: -- End of API User Hook for the after hook of create_PRTT_ENRT_ACTN
819: --
820: end;
821: --
822: hr_utility.set_location(l_proc, 60);
823: --
824: p_prtt_enrt_actn_id := l_prtt_enrt_actn_id;
825: p_effective_start_date := l_effective_start_date;
826: p_effective_end_date := l_effective_end_date;
882: end if;
883: --
884: -- Set all output arguments
885: --
886: hr_utility.set_location(' Leaving:'||l_proc, 70);
887: --
888: exception
889: --
890: when hr_api.validate_enabled
902: p_prtt_enrt_actn_id := null;
903: p_effective_start_date := null;
904: p_effective_end_date := null;
905: p_object_version_number := null;
906: hr_utility.set_location(' Leaving:'||l_proc, 80);
907: --
908: when others then
909: --
910: -- A validation or unexpected error has occured
1023: l_pcm_effective_end_date date;
1024: --
1025: begin
1026: --
1027: hr_utility.set_location('Entering:'|| l_proc, 10);
1028: --
1029: -- Issue a savepoint if operating in validation only mode
1030: --
1031: savepoint update_PRTT_ENRT_ACTN;
1029: -- Issue a savepoint if operating in validation only mode
1030: --
1031: savepoint update_PRTT_ENRT_ACTN;
1032: --
1033: hr_utility.set_location(l_proc, 20);
1034: --
1035: -- Get the completed date and effective start date before the update.
1036: --
1037: open c_pea;
1217: -- End of API User Hook for the after hook of update_PRTT_ENRT_ACTN
1218: --
1219: end;
1220: --
1221: hr_utility.set_location(l_proc, 60);
1222: --
1223: -- Set all output arguments
1224: --
1225: p_object_version_number := l_object_version_number;
1326: if p_validate then
1327: raise hr_api.validate_enabled;
1328: end if;
1329: --
1330: hr_utility.set_location(' Leaving:'||l_proc, 70);
1331: --
1332: exception
1333: --
1334: when hr_api.validate_enabled then
1343: -- when validation only mode is being used.)
1344: --
1345: p_effective_start_date := null;
1346: p_effective_end_date := null;
1347: hr_utility.set_location(' Leaving:'||l_proc, 80);
1348: --
1349: when others then
1350: --
1351: -- A validation or unexpected error has occured
1469: l_pcm_effective_end_date date;
1470: --
1471: begin
1472: --
1473: hr_utility.set_location('Entering:'|| l_proc, 10);
1474: --
1475: -- Issue a savepoint if operating in validation only mode
1476: --
1477: savepoint update_PRTT_ENRT_ACTN;
1475: -- Issue a savepoint if operating in validation only mode
1476: --
1477: savepoint update_PRTT_ENRT_ACTN;
1478: --
1479: hr_utility.set_location(l_proc, 20);
1480: --
1481: -- Get the completed date and effective start date before the update.
1482: --
1483: open c_pea;
1677: -- End of API User Hook for the after hook of update_PRTT_ENRT_ACTN
1678: --
1679: end;
1680: --
1681: hr_utility.set_location(l_proc, 60);
1682: --
1683: -- Set all output arguments
1684: --
1685: p_object_version_number := l_object_version_number;
1772: if p_validate then
1773: raise hr_api.validate_enabled;
1774: end if;
1775: --
1776: hr_utility.set_location(' Leaving:'||l_proc, 70);
1777: --
1778: exception
1779: --
1780: when hr_api.validate_enabled then
1789: -- when validation only mode is being used.)
1790: --
1791: p_effective_start_date := null;
1792: p_effective_end_date := null;
1793: hr_utility.set_location(' Leaving:'||l_proc, 80);
1794: --
1795: when others then
1796: --
1797: -- A validation or unexpected error has occured
1890: l_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
1891: --
1892: begin
1893: --
1894: hr_utility.set_location('Entering:'|| l_proc, 10);
1895: --
1896:
1897: -- Issue a savepoint if operating in validation only mode
1898: --
1897: -- Issue a savepoint if operating in validation only mode
1898: --
1899: savepoint delete_PRTT_ENRT_ACTN;
1900: --
1901: hr_utility.set_location(l_proc, 20);
1902: --
1903: -- Process Logic
1904: --
1905: l_object_version_number := p_object_version_number;
2100: --
2101: end if;
2102: --
2103: --Bug 5693086
2104: hr_utility.set_location(l_proc, 60);
2105: --
2106: -- If the calling procedure requests that the enrollment result be unsuspended
2107: -- then unsuspend the enrollment result.
2108: --
2124: if p_validate then
2125: raise hr_api.validate_enabled;
2126: end if;
2127: --
2128: hr_utility.set_location(' Leaving:'||l_proc, 70);
2129: --
2130: exception
2131: --
2132: when hr_api.validate_enabled then
2176: l_validation_end_date date;
2177: --
2178: begin
2179: --
2180: hr_utility.set_location('Entering:'|| l_proc, 10);
2181: --
2182: ben_pea_shd.lck
2183: (
2184: p_prtt_enrt_actn_id => p_prtt_enrt_actn_id
2188: ,p_effective_date => p_effective_date
2189: ,p_datetrack_mode => p_datetrack_mode
2190: );
2191: --
2192: hr_utility.set_location(' Leaving:'||l_proc, 70);
2193: --
2194: end lck;
2195: --
2196: end ben_PRTT_ENRT_ACTN_api;