25:
26: l_effective_date date;
27: l_proc varchar2(72) := g_package||'create_quest_answer';
28: begin
29: hr_utility.set_location('Entering:'|| l_proc, 10);
30: --
31: -- Issue a savepoint
32: --
33: savepoint create_quest_answer;
105: --
106:
107:
108: --
109: hr_utility.set_location(' Leaving:'||l_proc, 70);
110: exception
111: when hr_api.validate_enabled then
112: --
113: -- As the Validate_Enabled exception has been raised
120: -- when validation only mode is being used.)
121: --
122: p_questionnaire_answer_id:=null;
123:
124: hr_utility.set_location(' Leaving:'||l_proc, 80);
125: when others then
126: --
127: -- A validation or unexpected error has occured
128: --
132: -- OUT parameters, including warnings, to null
133: --
134: p_questionnaire_answer_id:=null;
135:
136: hr_utility.set_location(' Leaving:'||l_proc, 90);
137: raise;
138: end create_quest_answer;
139: --
140: --
159: l_in_out_parameter number;
160: l_effective_date date;
161: l_proc varchar2(72) := g_package||'update_quest_answer';
162: begin
163: hr_utility.set_location('Entering:'|| l_proc, 10);
164: --
165: -- Issue a savepoint
166: --
167: savepoint update_quest_answer;
244: --
245:
246:
247: --
248: hr_utility.set_location(' Leaving:'||l_proc, 70);
249: exception
250: when hr_api.validate_enabled then
251: --
252: -- As the Validate_Enabled exception has been raised
258: -- (Any key or derived arguments must be set to null
259: -- when validation only mode is being used.)
260: --
261:
262: hr_utility.set_location(' Leaving:'||l_proc, 80);
263: when others then
264: --
265: -- A validation or unexpected error has occured
266: --
269: -- Reset IN OUT parameters and set all
270: -- OUT parameters, including warnings, to null
271: --
272:
273: hr_utility.set_location(' Leaving:'||l_proc, 90);
274: raise;
275: end update_quest_answer;
276: --
277: --
296:
297: l_proc varchar2(72) := g_package||'delete_quest_answer';
298:
299: begin
300: hr_utility.set_location('Entering:'|| l_proc, 10);
301: --
302: -- Issue a savepoint
303: --
304: savepoint delete_quest_answer;
379: --
380:
381:
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 70);
384: exception
385: when hr_api.validate_enabled then
386: --
387: -- As the Validate_Enabled exception has been raised
393: -- (Any key or derived arguments must be set to null
394: -- when validation only mode is being used.)
395: --
396:
397: hr_utility.set_location(' Leaving:'||l_proc, 80);
398: when others then
399: --
400: -- A validation or unexpected error has occured
401: --
404: -- Reset IN OUT parameters and set all
405: -- OUT parameters, including warnings, to null
406: --
407:
408: hr_utility.set_location(' Leaving:'||l_proc, 90);
409: raise;
410: end delete_quest_answer;
411: --
412: