[Home] [Help]
29: l_job_group_id PER_JOB_GROUPS.JOB_GROUP_ID%TYPE;
30: l_object_version_number PER_JOB_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
31: --
32: begin
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: savepoint CREATE_JOB_GROUP;
36: --
37: -- Truncate the time portion from all IN date parameters
103: --
104: p_job_group_id := l_job_group_id;
105: p_object_version_number := l_object_version_number;
106: --
107: hr_utility.set_location(' Leaving:'||l_proc, 70);
108: exception
109: when hr_api.validate_enabled then
110: --
111: -- As the Validate_Enabled exception has been raised
119: --
120: p_job_group_id := null;
121: p_object_version_number := null;
122: --
123: hr_utility.set_location(' Leaving:'||l_proc, 80);
124: when others then
125: --
126: -- A validation or unexpected error has occured
127: --
131: --
132: p_job_group_id := null;
133: p_object_version_number := null;
134: --
135: hr_utility.set_location(' Leaving:'||l_proc, 90);
136: raise;
137: end CREATE_JOB_GROUP;
138: --
139: -- ----------------------------------------------------------------------------
161: l_object_version_number PER_JOB_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
162: l_ovn PER_JOB_GROUPS.OBJECT_VERSION_NUMBER%TYPE := p_object_version_number;
163: --
164: begin
165: hr_utility.set_location('Entering:'|| l_proc, 10);
166: --
167: savepoint UPDATE_JOB_GROUP;
168: --
169: -- Store initial value for OVN in out parameter.
240: -- Set all output arguments
241: --
242: p_object_version_number := l_object_version_number;
243: --
244: hr_utility.set_location(' Leaving:'||l_proc, 70);
245: exception
246: when hr_api.validate_enabled then
247: --
248: -- As the Validate_Enabled exception has been raised
253: -- Only set output warning arguments
254: -- (Any key or derived arguments must be set to null
255: -- when validation only mode is being used.)
256: --
257: hr_utility.set_location(' Leaving:'||l_proc, 80);
258: when others then
259: --
260: -- A validation or unexpected error has occured
261: --
264: -- set in out parameters and set out parameters
265: --
266: p_object_version_number := l_ovn;
267: --
268: hr_utility.set_location(' Leaving:'||l_proc, 90);
269: raise;
270: end UPDATE_JOB_GROUP;
271: --
272: -- ----------------------------------------------------------------------------
283: --
284: l_proc varchar2(72) := g_package||'DELETE_JOB_GROUP';
285: --
286: begin
287: hr_utility.set_location('Entering:'|| l_proc, 10);
288: --
289: savepoint DELETE_JOB_GROUP;
290: --
291: -- Call Before Process User Hook
326: if p_validate then
327: raise hr_api.validate_enabled;
328: end if;
329: --
330: hr_utility.set_location(' Leaving:'||l_proc, 70);
331: exception
332: when hr_api.validate_enabled then
333: --
334: -- As the Validate_Enabled exception has been raised
335: -- we must rollback to the savepoint
336: --
337: rollback to DELETE_JOB_GROUP;
338: --
339: hr_utility.set_location(' Leaving:'||l_proc, 80);
340: when others then
341: --
342: rollback to DELETE_JOB_GROUP;
343: --
340: when others then
341: --
342: rollback to DELETE_JOB_GROUP;
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 90);
345: --
346: raise;
347: --
348: end DELETE_JOB_GROUP;