31: where account_id = p_account_id;
32:
33: begin
34:
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: -- Derive necessary parameters
38: --
39: open csr_business_group_id;
42: --
43: -- Issue a savepoint
44: --
45: savepoint create_wci_rate;
46: hr_utility.set_location(l_proc, 20);
47: --
48: -- Truncate the time portion from all IN date parameters
49: --
50: -- Call Before Process User Hook
65: (p_module_name => 'create_wci_rate'
66: ,p_hook_type => 'BP'
67: );
68: end;
69: hr_utility.set_location(l_proc, 30);
70: --
71: -- Validation in addition to Row Handlers
72: --
73: hr_utility.set_location(l_proc, 40);
69: hr_utility.set_location(l_proc, 30);
70: --
71: -- Validation in addition to Row Handlers
72: --
73: hr_utility.set_location(l_proc, 40);
74: --
75: -- Process Logic
76: --
77: -- Call the row handler
86: ,p_comments => p_comments
87: ,p_object_version_number => p_object_version_number
88: );
89:
90: hr_utility.set_location(l_proc, 50);
91: --
92: -- Call After Process User Hook
93: --
94: begin
108: (p_module_name => 'create_wci_rate'
109: ,p_hook_type => 'AP'
110: );
111: end;
112: hr_utility.set_location(l_proc, 60);
113: --
114: -- When in validation only mode raise the Validate_Enabled exception
115: --
116: if p_validate then
118: end if;
119: --
120: -- Set all output arguments
121: --
122: hr_utility.set_location(' Leaving:'||l_proc, 70);
123:
124: exception
125:
126: when hr_api.validate_enabled then
135: -- when validation only mode is being used.)
136: --
137: p_rate_id := null;
138: p_object_version_number := null;
139: hr_utility.set_location(' Leaving:'||l_proc, 80);
140: when others then
141: --
142: -- A validation or unexpected error has occured
143: --
148: --
149: p_rate_id := null;
150: p_object_version_number := null;
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 90);
153: raise;
154: end create_wci_rate;
155: --
156: -- ----------------------------------------------------------------------------
180: where rate_id = p_rate_id;
181:
182: begin
183:
184: hr_utility.set_location('Entering:'|| l_proc, 10);
185: --
186: -- Store in out parameters
187: --
188: l_object_version_number := p_object_version_number;
189: --
190: -- Issue a savepoint
191: --
192: savepoint update_wci_rate;
193: hr_utility.set_location(l_proc, 20);
194: --
195: -- Truncate the time portion from all IN date parameters
196: --
197: -- Derive necessary parameters
219: (p_module_name => 'update_wci_rate'
220: ,p_hook_type => 'BP'
221: );
222: end;
223: hr_utility.set_location(l_proc, 30);
224: --
225: -- Validation in addition to Row Handlers
226: --
227: hr_utility.set_location(l_proc, 40);
223: hr_utility.set_location(l_proc, 30);
224: --
225: -- Validation in addition to Row Handlers
226: --
227: hr_utility.set_location(l_proc, 40);
228: --
229: -- Process Logic
230: --
231: -- Call the row handler
238: ,p_description => p_description
239: ,p_comments => p_comments
240: );
241:
242: hr_utility.set_location(l_proc, 50);
243: --
244: -- Call After Process User Hook
245: --
246: begin
260: (p_module_name => 'update_wci_rate'
261: ,p_hook_type => 'AP'
262: );
263: end;
264: hr_utility.set_location(l_proc, 60);
265: --
266: -- When in validation only mode raise the Validate_Enabled exception
267: --
268: if p_validate then
272: -- Set all output arguments
273: --
274: p_object_version_number := l_object_version_number;
275: --
276: hr_utility.set_location(' Leaving:'||l_proc, 70);
277:
278: exception
279:
280: when hr_api.validate_enabled then
288: -- (Any key or derived arguments must be set to null
289: -- when validation only mode is being used.)
290: --
291: p_object_version_number := l_object_version_number;
292: hr_utility.set_location(' Leaving:'||l_proc, 80);
293: when others then
294: --
295: -- A validation or unexpected error has occured
296: --
300: -- Reset all OUT/IN OUT parameters
301: --
302: p_object_version_number := l_object_version_number;
303: --
304: hr_utility.set_location(' Leaving:'||l_proc, 90);
305: raise;
306: end update_wci_rate;
307: --
308: -- ----------------------------------------------------------------------------
327: where rate_id = p_rate_id;
328:
329: begin
330:
331: hr_utility.set_location('Entering:'|| l_proc, 10);
332: --
333: -- Issue a savepoint
334: --
335: savepoint delete_wci_rate;
332: --
333: -- Issue a savepoint
334: --
335: savepoint delete_wci_rate;
336: hr_utility.set_location(l_proc, 20);
337: --
338: -- Truncate the time portion from all IN date parameters
339: --
340: -- Derive necessary parameters
358: (p_module_name => 'delete_wci_rate'
359: ,p_hook_type => 'BP'
360: );
361: end;
362: hr_utility.set_location(l_proc, 30);
363: --
364: -- Validation in addition to Row Handlers
365: --
366: hr_utility.set_location(l_proc, 40);
362: hr_utility.set_location(l_proc, 30);
363: --
364: -- Validation in addition to Row Handlers
365: --
366: hr_utility.set_location(l_proc, 40);
367: --
368: -- Process Logic
369: --
370: -- Call the row handler
373: (p_rate_id => p_rate_id
374: ,p_object_version_number => p_object_version_number
375: );
376:
377: hr_utility.set_location(l_proc, 50);
378: --
379: -- Call After Process User Hook
380: --
381: begin
390: (p_module_name => 'delete_wci_rate'
391: ,p_hook_type => 'AP'
392: );
393: end;
394: hr_utility.set_location(l_proc, 60);
395: --
396: -- When in validation only mode raise the Validate_Enabled exception
397: --
398: if p_validate then
400: end if;
401: --
402: -- Set all output arguments
403: --
404: hr_utility.set_location(' Leaving:'||l_proc, 70);
405:
406: exception
407:
408: when hr_api.validate_enabled then
415: -- Only set output warning arguments
416: -- (Any key or derived arguments must be set to null
417: -- when validation only mode is being used.)
418: --
419: hr_utility.set_location(' Leaving:'||l_proc, 80);
420: when others then
421: --
422: -- A validation or unexpected error has occured
423: --
421: --
422: -- A validation or unexpected error has occured
423: --
424: rollback to delete_wci_rate;
425: hr_utility.set_location(' Leaving:'||l_proc, 90);
426: raise;
427:
428: end delete_wci_rate;
429: --