[Home] [Help]
36:
37: --
38: Begin
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Issue a savepoint
43: --
44: Savepoint create_configuration;
42: -- Issue a savepoint
43: --
44: Savepoint create_configuration;
45: --
46: hr_utility.set_location(l_proc, 15);
47: per_cnf_ins.set_base_key_value (p_configuration_code => p_configuration_code );
48: --
49: -- All date input parameters must be truncated to remove time elements
50: --
57: --
58: l_language_code := p_language_code;
59: hr_api.validate_language_code(p_language_code => l_language_code);
60: --
61: hr_utility.set_location(l_proc, 20);
62:
63: -- Process Logic
64: --
65: -- Insert non-translatable rows into PER_RI_configurationS first
79: ,p_configuration_description => p_configuration_description
80: ,p_language_code => l_language_code
81: );
82:
83: hr_utility.set_location(l_proc, 60);
84: --
85: -- When in validation only mode raise the Validate_Enabled exception
86: --
87: If p_validate Then
91: -- Set all output arguments
92: --
93: p_object_version_number := l_object_version_number;
94: --
95: hr_utility.set_location(' Leaving:'||l_proc, 70);
96: --
97: Exception
98: --
99: When hr_api.validate_enabled Then
107: -- (Any key or derived arguments must be set to null
108: -- when validation only mode is being used.)
109: --
110: p_object_version_number := Null;
111: hr_utility.set_location(' Leaving:'||l_proc, 80);
112: When Others Then
113: --
114: -- A validation or unexpected error has occurred
115: Rollback To create_configuration;
114: -- A validation or unexpected error has occurred
115: Rollback To create_configuration;
116: -- Set OUT parameters.
117: p_object_version_number := Null;
118: hr_utility.set_location(' Leaving:'||l_proc, 90);
119: Raise;
120: --
121: End create_configuration;
122: -- ----------------------------------------------------------------------------
146: l_temp_ovn number := p_object_version_number;
147: --
148: BEGIN
149: --
150: hr_utility.set_location('Entering:'|| l_proc, 10);
151: --
152: -- Issue a savepoint.
153: --
154: savepoint update_configuration;
164: -- passed through.
165: --
166: l_language_code := p_language_code;
167: hr_api.validate_language_code(p_language_code => l_language_code);
168: hr_utility.set_location(l_proc, 20);
169: --
170: --
171: -- Process Logic
172: --
192: );
193:
194: --
195:
196: hr_utility.set_location(l_proc, 60);
197: --
198: -- When in validation only mode raise the Validate_Enabled exception
199: --
200: If p_validate Then
205: -- never reached, so p_object_version_number is passed back unchanged.
206: --
207: p_object_version_number := l_object_version_number;
208: --
209: hr_utility.set_location(' Leaving:'||l_proc, 70);
210: --
211: Exception
212: --
213: When hr_api.validate_enabled Then
221: -- (Any key or derived arguments must be set to null
222: -- when validation only mode is being used.)
223: -- Reset IN OUT parameters.
224: p_object_version_number := l_temp_ovn;
225: hr_utility.set_location(' Leaving:'||l_proc, 80);
226: When Others Then
227: --
228: -- A validation or unexpected error has occurred
229: Rollback To update_configuration;
228: -- A validation or unexpected error has occurred
229: Rollback To update_configuration;
230: -- Reset IN OUT parameters.
231: p_object_version_number := l_temp_ovn;
232: hr_utility.set_location(' Leaving:'||l_proc, 90);
233: Raise;
234: --
235: --
236: End update_configuration;
251: l_proc Varchar2(72) := g_package||'delete_configuration';
252: --
253: Begin
254: --
255: hr_utility.set_location('Entering:'|| l_proc, 10);
256: --
257: -- Issue a savepoint
258: --
259: Savepoint delete_configuration;
263: -- =============
264: --
265: -- Need to lock main table to maintain the locking ladder order
266: --
267: hr_utility.set_location( l_proc, 30);
268: per_cnf_shd.lck ( p_configuration_code => p_configuration_code,
269: p_object_version_number => p_object_version_number );
270: --
271: -- Remove all matching translation rows
269: p_object_version_number => p_object_version_number );
270: --
271: -- Remove all matching translation rows
272: --
273: hr_utility.set_location( l_proc, 35);
274:
275: per_cnt_del.del_tl( p_configuration_code => p_configuration_code );
276: --
277: -- Remove non-translated data row
275: per_cnt_del.del_tl( p_configuration_code => p_configuration_code );
276: --
277: -- Remove non-translated data row
278: --
279: hr_utility.set_location( l_proc, 40);
280:
281: per_cnf_del.del(p_configuration_code => p_configuration_code,
282: p_object_version_number => p_object_version_number );
283: --
281: per_cnf_del.del(p_configuration_code => p_configuration_code,
282: p_object_version_number => p_object_version_number );
283: --
284: --
285: hr_utility.set_location(' Leaving:'||l_proc, 60);
286: --
287: -- When in validation only mode raise the Validate_Enabled exception
288: --
289: If p_validate Then
303: -- Only set output warning arguments
304: -- (Any key or derived arguments must be set to null
305: -- when validation only mode is being used.)
306: --
307: hr_utility.set_location(' Leaving:'||l_proc, 80);
308: When Others Then
309: --
310: -- A validation or unexpected error has occurred
311: Rollback To delete_configuration;
308: When Others Then
309: --
310: -- A validation or unexpected error has occurred
311: Rollback To delete_configuration;
312: hr_utility.set_location(' Leaving:'||l_proc, 90);
313: Raise;
314: --
315: End delete_configuration;
316: