[Home] [Help]
22: --
23: l_effective_date date;
24: l_proc varchar2(72) := g_package||'create_txn_cat_document';
25: begin
26: hr_utility.set_location('Entering:'|| l_proc, 10);
27: --
28: -- Issue a savepoint
29: --
30: savepoint create_txn_cat_document;
94: -- Set all IN OUT and OUT parameters with out values
95: --
96: p_object_version_number := p_object_version_number;
97: --
98: hr_utility.set_location(' Leaving:'||l_proc, 70);
99: exception
100: when hr_api.validate_enabled then
101: --
102: -- As the Validate_Enabled exception has been raised
108: -- (Any key or derived arguments must be set to null
109: -- when validation only mode is being used.)
110: --
111: p_object_version_number := null;
112: hr_utility.set_location(' Leaving:'||l_proc, 80);
113: when others then
114: --
115: -- A validation or unexpected error has occured
116: --
119: -- Reset IN OUT parameters and set all
120: -- OUT parameters, including warnings, to null
121: --
122: p_object_version_number := null;
123: hr_utility.set_location(' Leaving:'||l_proc, 90);
124: raise;
125: end create_txn_cat_document;
126: --
127: -- ----------------------------------------------------------------------------
142: l_effective_date date;
143: l_proc varchar2(72) := g_package||'update_txn_cat_document';
144: l_object_version_number number;
145: begin
146: hr_utility.set_location('Entering:'|| l_proc, 10);
147: --
148: -- Issue a savepoint
149: --
150: savepoint update_txn_cat_document;
215: -- Set all IN OUT and OUT parameters with out values
216: --
217: p_object_version_number := l_object_version_number;
218: --
219: hr_utility.set_location(' Leaving:'||l_proc, 70);
220: exception
221: when hr_api.validate_enabled then
222: --
223: -- As the Validate_Enabled exception has been raised
229: -- (Any key or derived arguments must be set to null
230: -- when validation only mode is being used.)
231: --
232: p_object_version_number := l_object_version_number;
233: hr_utility.set_location(' Leaving:'||l_proc, 80);
234: when others then
235: --
236: -- A validation or unexpected error has occured
237: --
240: -- Reset IN OUT parameters and set all
241: -- OUT parameters, including warnings, to null
242: --
243: p_object_version_number := l_object_version_number;
244: hr_utility.set_location(' Leaving:'||l_proc, 90);
245: raise;
246: end update_txn_cat_document;
247: --
248: -- ----------------------------------------------------------------------------
259: -- Declare cursors and local variables
260: --
261: l_proc varchar2(72) := g_package||'delete_txn_cat_document';
262: begin
263: hr_utility.set_location('Entering:'|| l_proc, 10);
264: --
265: -- Issue a savepoint
266: --
267: savepoint delete_txn_cat_document;
320: --
321: -- Set all IN OUT and OUT parameters with out values
322: --
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 70);
325: exception
326: when hr_api.validate_enabled then
327: --
328: -- As the Validate_Enabled exception has been raised
333: -- Reset IN OUT parameters and set OUT parameters
334: -- (Any key or derived arguments must be set to null
335: -- when validation only mode is being used.)
336: --
337: hr_utility.set_location(' Leaving:'||l_proc, 80);
338: when others then
339: --
340: -- A validation or unexpected error has occured
341: --
343: --
344: -- Reset IN OUT parameters and set all
345: -- OUT parameters, including warnings, to null
346: --
347: hr_utility.set_location(' Leaving:'||l_proc, 90);
348: raise;
349: end delete_txn_cat_document;
350: --
351: end pqh_txn_cat_documents_api;