[Home] [Help]
41: l_workbench_item_code per_ri_view_reports.workbench_item_code%TYPE;
42: --
43: Begin
44: --
45: hr_utility.set_location('Entering:'|| l_proc, 10);
46: --
47: -- Issue a savepoint
48: --
49: Savepoint create_view_report;
47: -- Issue a savepoint
48: --
49: Savepoint create_view_report;
50: --
51: hr_utility.set_location(l_proc, 15);
52: per_rvr_ins.set_base_key_value (p_workbench_view_report_code => p_workbench_view_report_code );
53: --
54: -- All date input parameters must be truncated to remove time elements
55: --
63: --
64: l_language_code := p_language_code;
65: hr_api.validate_language_code(p_language_code => l_language_code);
66: --
67: hr_utility.set_location(l_proc, 20);
68:
69: -- Process Logic
70: --
71: -- Insert non-translatable rows into PER_RI_VIEW_REPORTS first
90: ,p_wb_view_report_description =>p_wb_view_report_description
91: ,p_language_code =>p_language_code
92: ) ;
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_view_report;
125: -- A validation or unexpected error has occurred
126: Rollback To create_view_report;
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_view_report;
133: -- ----------------------------------------------------------------------------
162: l_temp_ovn number := p_object_version_number;
163: --
164: BEGIN
165: --
166: hr_utility.set_location('Entering:'|| l_proc, 10);
167: --
168: -- Issue a savepoint.
169: --
170: savepoint update_view_report;
180: -- passed through.
181: --
182: l_language_code := p_language_code;
183: hr_api.validate_language_code(p_language_code => l_language_code);
184: hr_utility.set_location(l_proc, 20);
185: --
186: --
187: -- Process Logic
188: --
212: ) ;
213:
214: --
215:
216: hr_utility.set_location(l_proc, 60);
217: --
218: -- When in validation only mode raise the Validate_Enabled exception
219: --
220: If p_validate Then
225: -- never reached, so p_object_version_number is passed back unchanged.
226: --
227: p_object_version_number := l_object_version_number;
228: --
229: hr_utility.set_location(' Leaving:'||l_proc, 70);
230: --
231: Exception
232: --
233: When hr_api.validate_enabled Then
241: -- (Any key or derived arguments must be set to null
242: -- when validation only mode is being used.)
243: -- Reset IN OUT parameters.
244: p_object_version_number := l_temp_ovn;
245: hr_utility.set_location(' Leaving:'||l_proc, 80);
246: When Others Then
247: --
248: -- A validation or unexpected error has occurred
249: Rollback To update_view_report;
248: -- A validation or unexpected error has occurred
249: Rollback To update_view_report;
250: -- Reset IN OUT parameters.
251: p_object_version_number := l_temp_ovn;
252: hr_utility.set_location(' Leaving:'||l_proc, 90);
253: Raise;
254: --
255: --
256: End update_view_report;
271: l_proc Varchar2(72) := g_package||'delete_view_report';
272: --
273: Begin
274: --
275: hr_utility.set_location('Entering:'|| l_proc, 10);
276: --
277: -- Issue a savepoint
278: --
279: Savepoint delete_view_report;
283: -- =============
284: --
285: -- Need to lock main table to maintain the locking ladder order
286: --
287: hr_utility.set_location( l_proc, 30);
288: per_rvr_shd.lck ( p_workbench_view_report_code => p_workbench_view_report_code,
289: p_object_version_number => p_object_version_number );
290: --
291: -- Remove all matching translation rows
289: p_object_version_number => p_object_version_number );
290: --
291: -- Remove all matching translation rows
292: --
293: hr_utility.set_location( l_proc, 35);
294:
295: per_rvt_del.del_tl( p_workbench_view_report_code => p_workbench_view_report_code );
296: --
297: -- Remove non-translated data row
295: per_rvt_del.del_tl( p_workbench_view_report_code => p_workbench_view_report_code );
296: --
297: -- Remove non-translated data row
298: --
299: hr_utility.set_location( l_proc, 40);
300:
301: per_rvr_del.del(p_workbench_view_report_code => p_workbench_view_report_code,
302: p_object_version_number => p_object_version_number );
303: --
301: per_rvr_del.del(p_workbench_view_report_code => p_workbench_view_report_code,
302: p_object_version_number => p_object_version_number );
303: --
304: --
305: hr_utility.set_location(' Leaving:'||l_proc, 60);
306: --
307: -- When in validation only mode raise the Validate_Enabled exception
308: --
309: If p_validate Then
323: -- Only set output warning arguments
324: -- (Any key or derived arguments must be set to null
325: -- when validation only mode is being used.)
326: --
327: hr_utility.set_location(' Leaving:'||l_proc, 80);
328: When Others Then
329: --
330: -- A validation or unexpected error has occurred
331: Rollback To delete_view_report;
328: When Others Then
329: --
330: -- A validation or unexpected error has occurred
331: Rollback To delete_view_report;
332: hr_utility.set_location(' Leaving:'||l_proc, 90);
333: Raise;
334: --
335: End delete_view_report;
336: