[Home] [Help]
42: l_setup_task_code per_ri_setup_tasks.setup_task_code%TYPE;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'|| l_proc, 10);
47: --
48: -- Issue a savepoint
49: --
50: Savepoint create_setup_task;
48: -- Issue a savepoint
49: --
50: Savepoint create_setup_task;
51: --
52: hr_utility.set_location(l_proc, 15);
53: per_stb_ins.set_base_key_value (p_setup_task_code => p_setup_task_code );
54: --
55: -- All date input parameters must be truncated to remove time elements
56: --
65: --
66: l_language_code := p_language_code;
67: hr_api.validate_language_code(p_language_code => l_language_code);
68: --
69: hr_utility.set_location(l_proc, 20);
70:
71: -- Process Logic
72: --
73: -- Insert non-translatable rows into PER_RI_SETUP_TASKS first
90: ,p_setup_task_name =>p_setup_task_name
91: ,p_setup_task_description =>p_setup_task_description
92: ,p_language_code =>l_language_code
93: );
94: hr_utility.set_location(l_proc, 60);
95: --
96: -- When in validation only mode raise the Validate_Enabled exception
97: --
98: If p_validate Then
102: -- Set all output arguments
103: --
104: p_object_version_number := l_object_version_number;
105: --
106: hr_utility.set_location(' Leaving:'||l_proc, 70);
107: --
108: Exception
109: --
110: When hr_api.validate_enabled Then
118: -- (Any key or derived arguments must be set to null
119: -- when validation only mode is being used.)
120: --
121: p_object_version_number := Null;
122: hr_utility.set_location(' Leaving:'||l_proc, 80);
123: When Others Then
124: --
125: -- A validation or unexpected error has occurred
126: Rollback To create_setup_task;
125: -- A validation or unexpected error has occurred
126: Rollback To create_setup_task;
127: -- Set OUT parameters.
128: p_object_version_number := Null;
129: hr_utility.set_location(' Leaving:'||l_proc, 90);
130: Raise;
131: --
132: End create_setup_task;
133: -- ----------------------------------------------------------------------------
163: l_temp_ovn number := p_object_version_number;
164: --
165: BEGIN
166: --
167: hr_utility.set_location('Entering:'|| l_proc, 10);
168: --
169: -- Issue a savepoint.
170: --
171: savepoint update_setup_task;
182: -- passed through.
183: --
184: l_language_code := p_language_code;
185: hr_api.validate_language_code(p_language_code => l_language_code);
186: hr_utility.set_location(l_proc, 20);
187: --
188: --
189: -- Process Logic
190: --
215: );
216:
217: --
218:
219: hr_utility.set_location(l_proc, 60);
220: --
221: -- When in validation only mode raise the Validate_Enabled exception
222: --
223: If p_validate Then
228: -- never reached, so p_object_version_number is passed back unchanged.
229: --
230: p_object_version_number := l_object_version_number;
231: --
232: hr_utility.set_location(' Leaving:'||l_proc, 70);
233: --
234: Exception
235: --
236: When hr_api.validate_enabled Then
244: -- (Any key or derived arguments must be set to null
245: -- when validation only mode is being used.)
246: -- Reset IN OUT parameters.
247: p_object_version_number := l_temp_ovn;
248: hr_utility.set_location(' Leaving:'||l_proc, 80);
249: When Others Then
250: --
251: -- A validation or unexpected error has occurred
252: Rollback To update_setup_task;
251: -- A validation or unexpected error has occurred
252: Rollback To update_setup_task;
253: -- Reset IN OUT parameters.
254: p_object_version_number := l_temp_ovn;
255: hr_utility.set_location(' Leaving:'||l_proc, 90);
256: Raise;
257: --
258: --
259: End update_setup_task;
275: l_proc Varchar2(72) := g_package||'delete_setup_task';
276: --
277: Begin
278: --
279: hr_utility.set_location('Entering:'|| l_proc, 10);
280: --
281: -- Issue a savepoint
282: --
283: Savepoint delete_setup_task;
287: -- =============
288: --
289: -- Need to lock main table to maintain the locking ladder order
290: --
291: hr_utility.set_location( l_proc, 30);
292: per_stb_shd.lck ( p_setup_task_code => p_setup_task_code,
293: p_object_version_number => p_object_version_number );
294: --
295: -- Remove all matching translation rows
293: p_object_version_number => p_object_version_number );
294: --
295: -- Remove all matching translation rows
296: --
297: hr_utility.set_location( l_proc, 35);
298:
299: per_stl_del.del_tl( p_setup_task_code => p_setup_task_code );
300: --
301: -- Remove non-translated data row
299: per_stl_del.del_tl( p_setup_task_code => p_setup_task_code );
300: --
301: -- Remove non-translated data row
302: --
303: hr_utility.set_location( l_proc, 40);
304:
305: per_stb_del.del(p_setup_task_code => p_setup_task_code,
306: p_object_version_number => p_object_version_number );
307: --
305: per_stb_del.del(p_setup_task_code => p_setup_task_code,
306: p_object_version_number => p_object_version_number );
307: --
308: --
309: hr_utility.set_location(' Leaving:'||l_proc, 60);
310: --
311: -- When in validation only mode raise the Validate_Enabled exception
312: --
313: If p_validate Then
327: -- Only set output warning arguments
328: -- (Any key or derived arguments must be set to null
329: -- when validation only mode is being used.)
330: --
331: hr_utility.set_location(' Leaving:'||l_proc, 80);
332: When Others Then
333: --
334: -- A validation or unexpected error has occurred
335: Rollback To delete_setup_task;
332: When Others Then
333: --
334: -- A validation or unexpected error has occurred
335: Rollback To delete_setup_task;
336: hr_utility.set_location(' Leaving:'||l_proc, 90);
337: Raise;
338: --
339: End delete_setup_task;
340: