[Home] [Help]
39: l_workbench_item_code per_ri_workbench_items.workbench_item_code%TYPE;
40: --
41: Begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Issue a savepoint
46: --
47: Savepoint create_workbench_item;
45: -- Issue a savepoint
46: --
47: Savepoint create_workbench_item;
48: --
49: hr_utility.set_location(l_proc, 15);
50: per_wbi_ins.set_base_key_value (p_workbench_item_code => p_workbench_item_code );
51: --
52: -- All date input parameters must be truncated to remove time elements
53: --
61: --
62: l_language_code := p_language_code;
63: hr_api.validate_language_code(p_language_code => l_language_code);
64: --
65: hr_utility.set_location(l_proc, 20);
66:
67: -- Process Logic
68: --
69: -- Insert non-translatable rows into PER_RI_WORKBENCH_ITEMS first
85: ,p_workbench_item_description => p_workbench_item_description
86: ,p_language_code => l_language_code
87: );
88:
89: hr_utility.set_location(l_proc, 60);
90: --
91: -- When in validation only mode raise the Validate_Enabled exception
92: --
93: If p_validate Then
97: -- Set all output arguments
98: --
99: p_object_version_number := l_object_version_number;
100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 70);
102: --
103: Exception
104: --
105: When hr_api.validate_enabled Then
113: -- (Any key or derived arguments must be set to null
114: -- when validation only mode is being used.)
115: --
116: p_object_version_number := Null;
117: hr_utility.set_location(' Leaving:'||l_proc, 80);
118: When Others Then
119: --
120: -- A validation or unexpected error has occurred
121: Rollback To create_workbench_item;
120: -- A validation or unexpected error has occurred
121: Rollback To create_workbench_item;
122: -- Set OUT parameters.
123: p_object_version_number := Null;
124: hr_utility.set_location(' Leaving:'||l_proc, 90);
125: Raise;
126: --
127: End create_workbench_item;
128: -- ----------------------------------------------------------------------------
155: l_temp_ovn number := p_object_version_number;
156: --
157: BEGIN
158: --
159: hr_utility.set_location('Entering:'|| l_proc, 10);
160: --
161: -- Issue a savepoint.
162: --
163: savepoint update_workbench_item;
173: -- passed through.
174: --
175: l_language_code := p_language_code;
176: hr_api.validate_language_code(p_language_code => l_language_code);
177: hr_utility.set_location(l_proc, 20);
178: --
179: --
180: -- Process Logic
181: --
203: );
204:
205: --
206:
207: hr_utility.set_location(l_proc, 60);
208: --
209: -- When in validation only mode raise the Validate_Enabled exception
210: --
211: If p_validate Then
216: -- never reached, so p_object_version_number is passed back unchanged.
217: --
218: p_object_version_number := l_object_version_number;
219: --
220: hr_utility.set_location(' Leaving:'||l_proc, 70);
221: --
222: Exception
223: --
224: When hr_api.validate_enabled Then
232: -- (Any key or derived arguments must be set to null
233: -- when validation only mode is being used.)
234: -- Reset IN OUT parameters.
235: p_object_version_number := l_temp_ovn;
236: hr_utility.set_location(' Leaving:'||l_proc, 80);
237: When Others Then
238: --
239: -- A validation or unexpected error has occurred
240: Rollback To update_workbench_item;
239: -- A validation or unexpected error has occurred
240: Rollback To update_workbench_item;
241: -- Reset IN OUT parameters.
242: p_object_version_number := l_temp_ovn;
243: hr_utility.set_location(' Leaving:'||l_proc, 90);
244: Raise;
245: --
246: --
247: End update_workbench_item;
262: l_proc Varchar2(72) := g_package||'delete_workbench_item';
263: --
264: Begin
265: --
266: hr_utility.set_location('Entering:'|| l_proc, 10);
267: --
268: -- Issue a savepoint
269: --
270: Savepoint delete_workbench_item;
274: -- =============
275: --
276: -- Need to lock main table to maintain the locking ladder order
277: --
278: hr_utility.set_location( l_proc, 30);
279: per_wbi_shd.lck ( p_workbench_item_code => p_workbench_item_code,
280: p_object_version_number => p_object_version_number );
281: --
282: -- Remove all matching translation rows
280: p_object_version_number => p_object_version_number );
281: --
282: -- Remove all matching translation rows
283: --
284: hr_utility.set_location( l_proc, 35);
285:
286: per_wbt_del.del_tl( p_workbench_item_code => p_workbench_item_code );
287: --
288: -- Remove non-translated data row
286: per_wbt_del.del_tl( p_workbench_item_code => p_workbench_item_code );
287: --
288: -- Remove non-translated data row
289: --
290: hr_utility.set_location( l_proc, 40);
291:
292: per_wbi_del.del(p_workbench_item_code => p_workbench_item_code,
293: p_object_version_number => p_object_version_number );
294: --
292: per_wbi_del.del(p_workbench_item_code => p_workbench_item_code,
293: p_object_version_number => p_object_version_number );
294: --
295: --
296: hr_utility.set_location(' Leaving:'||l_proc, 60);
297: --
298: -- When in validation only mode raise the Validate_Enabled exception
299: --
300: If p_validate Then
314: -- Only set output warning arguments
315: -- (Any key or derived arguments must be set to null
316: -- when validation only mode is being used.)
317: --
318: hr_utility.set_location(' Leaving:'||l_proc, 80);
319: When Others Then
320: --
321: -- A validation or unexpected error has occurred
322: Rollback To delete_workbench_item;
319: When Others Then
320: --
321: -- A validation or unexpected error has occurred
322: Rollback To delete_workbench_item;
323: hr_utility.set_location(' Leaving:'||l_proc, 90);
324: Raise;
325: --
326: End delete_workbench_item;
327: