[Home] [Help]
44: l_setup_sub_task_code per_ri_setup_sub_tasks.setup_sub_task_code%TYPE;
45: --
46: Begin
47: --
48: hr_utility.set_location('Entering:'|| l_proc, 10);
49: --
50: -- Issue a savepoint
51: --
52: Savepoint create_setup_sub_task;
50: -- Issue a savepoint
51: --
52: Savepoint create_setup_sub_task;
53: --
54: hr_utility.set_location(l_proc, 15);
55: per_ssb_ins.set_base_key_value (p_setup_sub_task_code => p_setup_sub_task_code );
56: --
57: -- All date input parameters must be truncated to remove time elements
58: --
67: --
68: l_language_code := p_language_code;
69: hr_api.validate_language_code(p_language_code => l_language_code);
70: --
71: hr_utility.set_location(l_proc, 20);
72:
73: -- Process Logic
74: --
75: -- Insert non-translatable rows into PER_RI_SETUP_SUB_TASKS first
97: ,p_setup_sub_task_description => p_setup_sub_task_description
98: ,p_language_code => l_language_code
99: );
100:
101: hr_utility.set_location(l_proc, 60);
102: --
103: -- When in validation only mode raise the Validate_Enabled exception
104: --
105: If p_validate Then
109: -- Set all output arguments
110: --
111: p_object_version_number := l_object_version_number;
112: --
113: hr_utility.set_location(' Leaving:'||l_proc, 70);
114: --
115: Exception
116: --
117: When hr_api.validate_enabled Then
125: -- (Any key or derived arguments must be set to null
126: -- when validation only mode is being used.)
127: --
128: p_object_version_number := Null;
129: hr_utility.set_location(' Leaving:'||l_proc, 80);
130: When Others Then
131: --
132: -- A validation or unexpected error has occurred
133: Rollback To create_setup_sub_task;
132: -- A validation or unexpected error has occurred
133: Rollback To create_setup_sub_task;
134: -- Set OUT parameters.
135: p_object_version_number := Null;
136: hr_utility.set_location(' Leaving:'||l_proc, 90);
137: Raise;
138: --
139: End create_setup_sub_task;
140: -- ----------------------------------------------------------------------------
172: l_temp_ovn number := p_object_version_number;
173: --
174: BEGIN
175: --
176: hr_utility.set_location('Entering:'|| l_proc, 10);
177: --
178: -- Issue a savepoint.
179: --
180: savepoint update_setup_sub_task ;
191: -- passed through.
192: --
193: l_language_code := p_language_code;
194: hr_api.validate_language_code(p_language_code => l_language_code);
195: hr_utility.set_location(l_proc, 20);
196: --
197: --
198: -- Process Logic
199: --
226: );
227:
228: --
229:
230: hr_utility.set_location(l_proc, 60);
231: --
232: -- When in validation only mode raise the Validate_Enabled exception
233: --
234: If p_validate Then
239: -- never reached, so p_object_version_number is passed back unchanged.
240: --
241: p_object_version_number := l_object_version_number;
242: --
243: hr_utility.set_location(' Leaving:'||l_proc, 70);
244: --
245: Exception
246: --
247: When hr_api.validate_enabled Then
255: -- (Any key or derived arguments must be set to null
256: -- when validation only mode is being used.)
257: -- Reset IN OUT parameters.
258: p_object_version_number := l_temp_ovn;
259: hr_utility.set_location(' Leaving:'||l_proc, 80);
260: When Others Then
261: --
262: -- A validation or unexpected error has occurred
263: Rollback To update_setup_sub_task;
262: -- A validation or unexpected error has occurred
263: Rollback To update_setup_sub_task;
264: -- Reset IN OUT parameters.
265: p_object_version_number := l_temp_ovn;
266: hr_utility.set_location(' Leaving:'||l_proc, 90);
267: Raise;
268: --
269: --
270: End update_setup_sub_task;
285: l_proc Varchar2(72) := g_package||'delete_setup_sub_task';
286: --
287: Begin
288: --
289: hr_utility.set_location('Entering:'|| l_proc, 10);
290: --
291: -- Issue a savepoint
292: --
293: Savepoint delete_setup_sub_task;
297: -- =============
298: --
299: -- Need to lock main table to maintain the locking ladder order
300: --
301: hr_utility.set_location( l_proc, 30);
302: per_ssb_shd.lck ( p_setup_sub_task_code => p_setup_sub_task_code,
303: p_object_version_number => p_object_version_number );
304: --
305: -- Remove all matching translation rows
303: p_object_version_number => p_object_version_number );
304: --
305: -- Remove all matching translation rows
306: --
307: hr_utility.set_location( l_proc, 35);
308:
309: per_sst_del.del_tl( p_setup_sub_task_code => p_setup_sub_task_code );
310: --
311: -- Remove non-translated data row
309: per_sst_del.del_tl( p_setup_sub_task_code => p_setup_sub_task_code );
310: --
311: -- Remove non-translated data row
312: --
313: hr_utility.set_location( l_proc, 40);
314:
315: per_ssb_del.del(p_setup_sub_task_code => p_setup_sub_task_code,
316: p_object_version_number => p_object_version_number );
317: --
315: per_ssb_del.del(p_setup_sub_task_code => p_setup_sub_task_code,
316: p_object_version_number => p_object_version_number );
317: --
318: --
319: hr_utility.set_location(' Leaving:'||l_proc, 60);
320: --
321: -- When in validation only mode raise the Validate_Enabled exception
322: --
323: If p_validate Then
337: -- Only set output warning arguments
338: -- (Any key or derived arguments must be set to null
339: -- when validation only mode is being used.)
340: --
341: hr_utility.set_location(' Leaving:'||l_proc, 80);
342: When Others Then
343: --
344: -- A validation or unexpected error has occurred
345: Rollback To delete_setup_sub_task;
342: When Others Then
343: --
344: -- A validation or unexpected error has occurred
345: Rollback To delete_setup_sub_task;
346: hr_utility.set_location(' Leaving:'||l_proc, 90);
347: Raise;
348: --
349: End delete_setup_sub_task;
350: