62: ,p_validation_detail =>p_validation_detail
63: ,p_display_sequence =>p_display_sequence
64: );
65: exception
66: when hr_api.cannot_find_prog_unit then
67: hr_api.cannot_find_prog_unit_error
68: (p_module_name => 'insert_quest_fields'
69: ,p_hook_type => 'BP'
70: );
63: ,p_display_sequence =>p_display_sequence
64: );
65: exception
66: when hr_api.cannot_find_prog_unit then
67: hr_api.cannot_find_prog_unit_error
68: (p_module_name => 'insert_quest_fields'
69: ,p_hook_type => 'BP'
70: );
71: end;
113: ,p_validation_detail => p_validation_detail
114: ,p_display_sequence => p_display_sequence
115: );
116: exception
117: when hr_api.cannot_find_prog_unit then
118: hr_api.cannot_find_prog_unit_error
119: (p_module_name => 'insert_quest_fields'
120: ,p_hook_type => 'AP'
121: );
114: ,p_display_sequence => p_display_sequence
115: );
116: exception
117: when hr_api.cannot_find_prog_unit then
118: hr_api.cannot_find_prog_unit_error
119: (p_module_name => 'insert_quest_fields'
120: ,p_hook_type => 'AP'
121: );
122: end;
123: --
124: -- When in validation only mode raise the Validate_Enabled exception
125: --
126: if p_validate then
127: raise hr_api.validate_enabled;
128: end if;
129: --
130: -- Set all IN OUT and OUT parameters with out values
131: --
132:
133: --
134: hr_utility.set_location(' Leaving:'||l_proc, 70);
135: exception
136: when hr_api.validate_enabled then
137: --
138: -- As the Validate_Enabled exception has been raised
139: -- we must rollback to the savepoint
140: --
174: (p_validate in boolean default false
175: ,p_effective_date in date
176: ,p_field_id in number
177: ,p_object_version_number in out nocopy number
178: ,p_questionnaire_template_id in number default hr_api.g_number
179: ,p_name in varchar2 default hr_api.g_varchar2
180: ,p_type in varchar2 default hr_api.g_varchar2
181: ,p_sql_required_flag in varchar2 default hr_api.g_varchar2
182: ,p_html_text in CLOB default hr_api.g_varchar2
175: ,p_effective_date in date
176: ,p_field_id in number
177: ,p_object_version_number in out nocopy number
178: ,p_questionnaire_template_id in number default hr_api.g_number
179: ,p_name in varchar2 default hr_api.g_varchar2
180: ,p_type in varchar2 default hr_api.g_varchar2
181: ,p_sql_required_flag in varchar2 default hr_api.g_varchar2
182: ,p_html_text in CLOB default hr_api.g_varchar2
183: ,p_sql_text in varchar2 default hr_api.g_varchar2
176: ,p_field_id in number
177: ,p_object_version_number in out nocopy number
178: ,p_questionnaire_template_id in number default hr_api.g_number
179: ,p_name in varchar2 default hr_api.g_varchar2
180: ,p_type in varchar2 default hr_api.g_varchar2
181: ,p_sql_required_flag in varchar2 default hr_api.g_varchar2
182: ,p_html_text in CLOB default hr_api.g_varchar2
183: ,p_sql_text in varchar2 default hr_api.g_varchar2
184: ,p_validation_type in varchar2
177: ,p_object_version_number in out nocopy number
178: ,p_questionnaire_template_id in number default hr_api.g_number
179: ,p_name in varchar2 default hr_api.g_varchar2
180: ,p_type in varchar2 default hr_api.g_varchar2
181: ,p_sql_required_flag in varchar2 default hr_api.g_varchar2
182: ,p_html_text in CLOB default hr_api.g_varchar2
183: ,p_sql_text in varchar2 default hr_api.g_varchar2
184: ,p_validation_type in varchar2
185: ,p_validation_detail in varchar2
178: ,p_questionnaire_template_id in number default hr_api.g_number
179: ,p_name in varchar2 default hr_api.g_varchar2
180: ,p_type in varchar2 default hr_api.g_varchar2
181: ,p_sql_required_flag in varchar2 default hr_api.g_varchar2
182: ,p_html_text in CLOB default hr_api.g_varchar2
183: ,p_sql_text in varchar2 default hr_api.g_varchar2
184: ,p_validation_type in varchar2
185: ,p_validation_detail in varchar2
186: ,p_display_sequence in number
179: ,p_name in varchar2 default hr_api.g_varchar2
180: ,p_type in varchar2 default hr_api.g_varchar2
181: ,p_sql_required_flag in varchar2 default hr_api.g_varchar2
182: ,p_html_text in CLOB default hr_api.g_varchar2
183: ,p_sql_text in varchar2 default hr_api.g_varchar2
184: ,p_validation_type in varchar2
185: ,p_validation_detail in varchar2
186: ,p_display_sequence in number
187: ) is
226: ,p_validation_detail => p_validation_detail
227: ,p_display_sequence => p_display_sequence
228: );
229: exception
230: when hr_api.cannot_find_prog_unit then
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'update_quest_fields'
233: ,p_hook_type => 'BP'
234: );
227: ,p_display_sequence => p_display_sequence
228: );
229: exception
230: when hr_api.cannot_find_prog_unit then
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'update_quest_fields'
233: ,p_hook_type => 'BP'
234: );
235: end;
276: ,p_validation_detail => p_validation_detail
277: ,p_display_sequence => p_display_sequence
278: );
279: exception
280: when hr_api.cannot_find_prog_unit then
281: hr_api.cannot_find_prog_unit_error
282: (p_module_name => 'update_quest_fields'
283: ,p_hook_type => 'AP'
284: );
277: ,p_display_sequence => p_display_sequence
278: );
279: exception
280: when hr_api.cannot_find_prog_unit then
281: hr_api.cannot_find_prog_unit_error
282: (p_module_name => 'update_quest_fields'
283: ,p_hook_type => 'AP'
284: );
285: end;
286: --
287: -- When in validation only mode raise the Validate_Enabled exception
288: --
289: if p_validate then
290: raise hr_api.validate_enabled;
291: end if;
292: --
293: -- Set all IN OUT and OUT parameters with out values
294: --
295:
296: --
297: hr_utility.set_location(' Leaving:'||l_proc, 70);
298: exception
299: when hr_api.validate_enabled then
300: --
301: -- As the Validate_Enabled exception has been raised
302: -- we must rollback to the savepoint
303: --
371: p_field_id => p_field_id
372: ,p_object_version_number => p_object_version_number
373: );
374: exception
375: when hr_api.cannot_find_prog_unit then
376: hr_api.cannot_find_prog_unit_error
377: (p_module_name => 'delete_quest_fields'
378: ,p_hook_type => 'BP'
379: );
372: ,p_object_version_number => p_object_version_number
373: );
374: exception
375: when hr_api.cannot_find_prog_unit then
376: hr_api.cannot_find_prog_unit_error
377: (p_module_name => 'delete_quest_fields'
378: ,p_hook_type => 'BP'
379: );
380: end;
416: p_field_id =>p_field_id
417: ,p_object_version_number =>p_object_version_number
418: );
419: exception
420: when hr_api.cannot_find_prog_unit then
421: hr_api.cannot_find_prog_unit_error
422: (p_module_name => 'delete_quest_fields'
423: ,p_hook_type => 'AP'
424: );
417: ,p_object_version_number =>p_object_version_number
418: );
419: exception
420: when hr_api.cannot_find_prog_unit then
421: hr_api.cannot_find_prog_unit_error
422: (p_module_name => 'delete_quest_fields'
423: ,p_hook_type => 'AP'
424: );
425: end;
426: --
427: -- When in validation only mode raise the Validate_Enabled exception
428: --
429: if p_validate then
430: raise hr_api.validate_enabled;
431: end if;
432: --
433: -- Set all IN OUT and OUT parameters with out values
434: --
435:
436: --
437: hr_utility.set_location(' Leaving:'||l_proc, 70);
438: exception
439: when hr_api.validate_enabled then
440: --
441: -- As the Validate_Enabled exception has been raised
442: -- we must rollback to the savepoint
443: --