339: l_object_version_number ben_ext_rslt_dtl.object_version_number%TYPE;
340: --
341: begin
342: --
343: hr_utility.set_location('Entering:'|| l_proc, 10);
344: --
345: -- Issue a savepoint if operating in validation only mode
346: --
347: savepoint create_EXT_RSLT_DTL;
345: -- Issue a savepoint if operating in validation only mode
346: --
347: savepoint create_EXT_RSLT_DTL;
348: --
349: hr_utility.set_location(l_proc, 20);
350: --
351: -- Process Logic
352: --
353: begin
1344: -- End of API User Hook for the after hook of create_EXT_RSLT_DTL
1345: --
1346: end;
1347: --
1348: hr_utility.set_location(l_proc, 60);
1349: --
1350: -- When in validation only mode raise the Validate_Enabled exception
1351: --
1352: if p_validate then
1357: --
1358: p_ext_rslt_dtl_id := l_ext_rslt_dtl_id;
1359: p_object_version_number := l_object_version_number;
1360: --
1361: hr_utility.set_location(' Leaving:'||l_proc, 70);
1362: --
1363: exception
1364: --
1365: when hr_api.validate_enabled then
1374: -- when validation only mode is being used.)
1375: --
1376: p_ext_rslt_dtl_id := null;
1377: p_object_version_number := null;
1378: hr_utility.set_location(' Leaving:'||l_proc, 80);
1379: --
1380: when others then
1381: --
1382: -- A validation or unexpected error has occured
1720: l_object_version_number ben_ext_rslt_dtl.object_version_number%TYPE;
1721: --
1722: begin
1723: --
1724: hr_utility.set_location('Entering:'|| l_proc, 10);
1725: --
1726: -- Issue a savepoint if operating in validation only mode
1727: --
1728: savepoint update_EXT_RSLT_DTL;
1726: -- Issue a savepoint if operating in validation only mode
1727: --
1728: savepoint update_EXT_RSLT_DTL;
1729: --
1730: hr_utility.set_location(l_proc, 20);
1731: --
1732: -- Process Logic
1733: --
1734: l_object_version_number := p_object_version_number;
2729: -- End of API User Hook for the after hook of update_EXT_RSLT_DTL
2730: --
2731: end;
2732: --
2733: hr_utility.set_location(l_proc, 60);
2734: --
2735: -- When in validation only mode raise the Validate_Enabled exception
2736: --
2737: if p_validate then
2741: -- Set all output arguments
2742: --
2743: p_object_version_number := l_object_version_number;
2744: --
2745: hr_utility.set_location(' Leaving:'||l_proc, 70);
2746: --
2747: exception
2748: --
2749: when hr_api.validate_enabled then
2756: -- Only set output warning arguments
2757: -- (Any key or derived arguments must be set to null
2758: -- when validation only mode is being used.)
2759: --
2760: hr_utility.set_location(' Leaving:'||l_proc, 80);
2761: --
2762: when others then
2763: --
2764: -- A validation or unexpected error has occured
2783: l_object_version_number ben_ext_rslt_dtl.object_version_number%TYPE;
2784: --
2785: begin
2786: --
2787: hr_utility.set_location('Entering:'|| l_proc, 10);
2788: --
2789: -- Issue a savepoint if operating in validation only mode
2790: --
2791: savepoint delete_EXT_RSLT_DTL;
2789: -- Issue a savepoint if operating in validation only mode
2790: --
2791: savepoint delete_EXT_RSLT_DTL;
2792: --
2793: hr_utility.set_location(l_proc, 20);
2794: --
2795: -- Process Logic
2796: --
2797: l_object_version_number := p_object_version_number;
2842: -- End of API User Hook for the after hook of delete_EXT_RSLT_DTL
2843: --
2844: end;
2845: --
2846: hr_utility.set_location(l_proc, 60);
2847: --
2848: -- When in validation only mode raise the Validate_Enabled exception
2849: --
2850: if p_validate then
2850: if p_validate then
2851: raise hr_api.validate_enabled;
2852: end if;
2853: --
2854: hr_utility.set_location(' Leaving:'||l_proc, 70);
2855: --
2856: exception
2857: --
2858: when hr_api.validate_enabled then
2892: l_proc varchar2(72) := g_package||'lck';
2893: --
2894: begin
2895: --
2896: hr_utility.set_location('Entering:'|| l_proc, 10);
2897: --
2898: ben_xrd_shd.lck
2899: (
2900: p_ext_rslt_dtl_id => p_ext_rslt_dtl_id
2900: p_ext_rslt_dtl_id => p_ext_rslt_dtl_id
2901: ,p_object_version_number => p_object_version_number
2902: );
2903: --
2904: hr_utility.set_location(' Leaving:'||l_proc, 70);
2905: --
2906: end lck;
2907: --
2908: end ben_EXT_RSLT_DTL_api;