56: ,p_quest_type_code => p_quest_type_code
57: );
58:
59: exception
60: when hr_api.cannot_find_prog_unit then
61: hr_api.cannot_find_prog_unit_error
62: (p_module_name => 'create_questionnaire'
63: ,p_hook_type => 'BP'
64: );
57: );
58:
59: exception
60: when hr_api.cannot_find_prog_unit then
61: hr_api.cannot_find_prog_unit_error
62: (p_module_name => 'create_questionnaire'
63: ,p_hook_type => 'BP'
64: );
65: end;
99: ,p_object_version_number => p_object_version_number
100: ,p_quest_type_code =>p_quest_type_code
101: );
102: exception
103: when hr_api.cannot_find_prog_unit then
104: hr_api.cannot_find_prog_unit_error
105: (p_module_name => 'create_questionnaire'
106: ,p_hook_type => 'AP'
107: );
100: ,p_quest_type_code =>p_quest_type_code
101: );
102: exception
103: when hr_api.cannot_find_prog_unit then
104: hr_api.cannot_find_prog_unit_error
105: (p_module_name => 'create_questionnaire'
106: ,p_hook_type => 'AP'
107: );
108: end;
109: --
110: -- When in validation only mode raise the Validate_Enabled exception
111: --
112: if p_validate then
113: raise hr_api.validate_enabled;
114: end if;
115: --
116: -- Set all IN OUT and OUT parameters with out values
117: --
118:
119: --
120: hr_utility.set_location(' Leaving:'||l_proc, 70);
121: exception
122: when hr_api.validate_enabled then
123: --
124: -- As the Validate_Enabled exception has been raised
125: -- we must rollback to the savepoint
126: --
158: ,p_questionnaire_template_id in number
159: ,p_object_version_number in out nocopy number
160: ,p_quest_type_code in varchar2
161: ,p_effective_date in date
162: ,p_name in varchar2 default hr_api.g_varchar2
163: ,p_available_flag in varchar2 default hr_api.g_varchar2
164: ,p_business_group_id in number default hr_api.g_number
165: ,p_text in CLOB
166: ) is
159: ,p_object_version_number in out nocopy number
160: ,p_quest_type_code in varchar2
161: ,p_effective_date in date
162: ,p_name in varchar2 default hr_api.g_varchar2
163: ,p_available_flag in varchar2 default hr_api.g_varchar2
164: ,p_business_group_id in number default hr_api.g_number
165: ,p_text in CLOB
166: ) is
167: --
160: ,p_quest_type_code in varchar2
161: ,p_effective_date in date
162: ,p_name in varchar2 default hr_api.g_varchar2
163: ,p_available_flag in varchar2 default hr_api.g_varchar2
164: ,p_business_group_id in number default hr_api.g_number
165: ,p_text in CLOB
166: ) is
167: --
168: -- Declare cursors and local variables
200: ,p_quest_type_code =>p_quest_type_code
201: );
202:
203: exception
204: when hr_api.cannot_find_prog_unit then
205: hr_api.cannot_find_prog_unit_error
206: (p_module_name => 'update_questionnaire'
207: ,p_hook_type => 'BP'
208: );
201: );
202:
203: exception
204: when hr_api.cannot_find_prog_unit then
205: hr_api.cannot_find_prog_unit_error
206: (p_module_name => 'update_questionnaire'
207: ,p_hook_type => 'BP'
208: );
209: end;
243: ,p_quest_type_code =>p_quest_type_code
244: );
245:
246: exception
247: when hr_api.cannot_find_prog_unit then
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'update_questionnaire'
250: ,p_hook_type => 'AP'
251: );
244: );
245:
246: exception
247: when hr_api.cannot_find_prog_unit then
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'update_questionnaire'
250: ,p_hook_type => 'AP'
251: );
252: end;
253: --
254: -- When in validation only mode raise the Validate_Enabled exception
255: --
256: if p_validate then
257: raise hr_api.validate_enabled;
258: end if;
259: --
260: -- Set all IN OUT and OUT parameters with out values
261: --
260: -- Set all IN OUT and OUT parameters with out values
261: --
262: hr_utility.set_location(' Leaving:'||l_proc, 70);
263: exception
264: when hr_api.validate_enabled then
265: --
266: -- As the Validate_Enabled exception has been raised
267: -- we must rollback to the savepoint
268: --
336: p_questionnaire_template_id => p_questionnaire_template_id
337: ,p_object_version_number => p_object_version_number
338: );
339: exception
340: when hr_api.cannot_find_prog_unit then
341: hr_api.cannot_find_prog_unit_error
342: (p_module_name => 'delete_questionnaire'
343: ,p_hook_type => 'BP'
344: );
337: ,p_object_version_number => p_object_version_number
338: );
339: exception
340: when hr_api.cannot_find_prog_unit then
341: hr_api.cannot_find_prog_unit_error
342: (p_module_name => 'delete_questionnaire'
343: ,p_hook_type => 'BP'
344: );
345: end;
397: ,p_object_version_number => p_object_version_number
398: );
399:
400: exception
401: when hr_api.cannot_find_prog_unit then
402: hr_api.cannot_find_prog_unit_error
403: (p_module_name => 'delete_questionnaire'
404: ,p_hook_type => 'AP'
405: );
398: );
399:
400: exception
401: when hr_api.cannot_find_prog_unit then
402: hr_api.cannot_find_prog_unit_error
403: (p_module_name => 'delete_questionnaire'
404: ,p_hook_type => 'AP'
405: );
406: end;
407: --
408: -- When in validation only mode raise the Validate_Enabled exception
409: --
410: if p_validate then
411: raise hr_api.validate_enabled;
412: end if;
413: --
414: -- Set all IN OUT and OUT parameters with out values
415: --
415: --
416: --
417: hr_utility.set_location(' Leaving:'||l_proc, 70);
418: exception
419: when hr_api.validate_enabled then
420: --
421: -- As the Validate_Enabled exception has been raised
422: -- we must rollback to the savepoint
423: --