[Home] [Help]
126: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
127: --
128: begin
129: --
130: hr_utility.set_location('Entering:'|| l_proc, 10);
131: --
132: -- Issue a savepoint if operating in validation only mode
133: --
134: savepoint create_Eligible_Person;
132: -- Issue a savepoint if operating in validation only mode
133: --
134: savepoint create_Eligible_Person;
135: --
136: hr_utility.set_location(l_proc, 20);
137: --
138: -- Process Logic
139: --
140: begin
478: -- End of API User Hook for the after hook of create_Eligible_Person
479: --
480: end;
481: --
482: hr_utility.set_location(l_proc, 60);
483: --
484: -- When in validation only mode raise the Validate_Enabled exception
485: --
486: if p_validate then
493: p_effective_start_date := l_effective_start_date;
494: p_effective_end_date := l_effective_end_date;
495: p_object_version_number := l_object_version_number;
496: --
497: hr_utility.set_location(' Leaving:'||l_proc, 70);
498: --
499: exception
500: --
501: when hr_api.validate_enabled then
512: p_elig_per_id := null;
513: p_effective_start_date := null;
514: p_effective_end_date := null;
515: p_object_version_number := null;
516: hr_utility.set_location(' Leaving:'||l_proc, 80);
517: --
518: when others then
519: --
520: -- A validation or unexpected error has occured
660: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
661: --
662: begin
663: --
664: hr_utility.set_location('Entering:'|| l_proc, 10);
665: --
666: -- Issue a savepoint if operating in validation only mode
667: --
668: savepoint create_perf_Eligible_Person;
803: ben_pep_shd.g_api_dml := true; -- Set the api dml status
804: --
805: -- Insert the row into: ben_elig_per_f
806: --
807: hr_utility.set_location('Insert: '||l_proc, 5);
808: insert into ben_elig_per_f
809: (
810: elig_per_id,
811: effective_start_date,
1016: l_last_update_date,
1017: l_last_updated_by,
1018: l_last_update_login
1019: ) RETURNING elig_per_id into l_elig_per_id;
1020: hr_utility.set_location('Dn Insert: '||l_proc, 5);
1021: --
1022: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
1023: --
1024: -- When in validation only mode raise the Validate_Enabled exception
1033: p_effective_start_date := l_effective_start_date;
1034: p_effective_end_date := l_effective_end_date;
1035: p_object_version_number := l_object_version_number;
1036: --
1037: hr_utility.set_location(' Leaving:'||l_proc, 70);
1038: --
1039: exception
1040: --
1041: when hr_api.validate_enabled then
1052: p_elig_per_id := null;
1053: p_effective_start_date := null;
1054: p_effective_end_date := null;
1055: p_object_version_number := null;
1056: hr_utility.set_location(' Leaving:'||l_proc, 80);
1057: --
1058: when others then
1059: --
1060: -- A validation or unexpected error has occured
1186: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
1187: --
1188: begin
1189: --
1190: hr_utility.set_location('Entering:'|| l_proc, 10);
1191: --
1192: -- Issue a savepoint if operating in validation only mode
1193: --
1194: savepoint update_Eligible_Person;
1192: -- Issue a savepoint if operating in validation only mode
1193: --
1194: savepoint update_Eligible_Person;
1195: --
1196: hr_utility.set_location(l_proc, 20);
1197: --
1198: -- Process Logic
1199: --
1200: l_object_version_number := p_object_version_number;
1543: -- End of API User Hook for the after hook of update_Eligible_Person
1544: --
1545: end;
1546: --
1547: hr_utility.set_location(l_proc, 60);
1548: --
1549: -- When in validation only mode raise the Validate_Enabled exception
1550: --
1551: if p_validate then
1557: p_object_version_number := l_object_version_number;
1558: p_effective_start_date := l_effective_start_date;
1559: p_effective_end_date := l_effective_end_date;
1560: --
1561: hr_utility.set_location(' Leaving:'||l_proc, 70);
1562: --
1563: exception
1564: --
1565: when hr_api.validate_enabled then
1572: -- Only set output warning arguments
1573: -- (Any key or derived arguments must be set to null
1574: -- when validation only mode is being used.)
1575: --
1576: hr_utility.set_location(' Leaving:'||l_proc, 80);
1577: --
1578: when others then
1579: --
1580: -- A validation or unexpected error has occured
1607: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
1608: --
1609: begin
1610: --
1611: hr_utility.set_location('Entering:'|| l_proc, 10);
1612: --
1613: -- Issue a savepoint if operating in validation only mode
1614: --
1615: savepoint delete_Eligible_Person;
1613: -- Issue a savepoint if operating in validation only mode
1614: --
1615: savepoint delete_Eligible_Person;
1616: --
1617: hr_utility.set_location(l_proc, 20);
1618: --
1619: -- Process Logic
1620: --
1621: l_object_version_number := p_object_version_number;
1674: -- End of API User Hook for the after hook of delete_Eligible_Person
1675: --
1676: end;
1677: --
1678: hr_utility.set_location(l_proc, 60);
1679: --
1680: -- When in validation only mode raise the Validate_Enabled exception
1681: --
1682: if p_validate then
1682: if p_validate then
1683: raise hr_api.validate_enabled;
1684: end if;
1685: --
1686: hr_utility.set_location(' Leaving:'||l_proc, 70);
1687: --
1688: exception
1689: --
1690: when hr_api.validate_enabled then
1734: l_validation_end_date date;
1735: --
1736: begin
1737: --
1738: hr_utility.set_location('Entering:'|| l_proc, 10);
1739: --
1740: ben_pep_shd.lck
1741: (p_elig_per_id => p_elig_per_id
1742: ,p_validation_start_date => l_validation_start_date
1744: ,p_object_version_number => p_object_version_number
1745: ,p_effective_date => p_effective_date
1746: ,p_datetrack_mode => p_datetrack_mode);
1747: --
1748: hr_utility.set_location(' Leaving:'||l_proc, 70);
1749: --
1750: end lck;
1751: --
1752: end ben_Eligible_Person_api;