APPS.HR_QUEST_FIELDS_API dependencies on HR_API

Line 60: when hr_api.cannot_find_prog_unit then

56: ,p_html_text =>p_html_text
57: ,p_sql_text =>p_sql_text
58: );
59: exception
60: when hr_api.cannot_find_prog_unit then
61: hr_api.cannot_find_prog_unit_error
62: (p_module_name => 'insert_quest_fields'
63: ,p_hook_type => 'BP'
64: );

Line 61: hr_api.cannot_find_prog_unit_error

57: ,p_sql_text =>p_sql_text
58: );
59: exception
60: when hr_api.cannot_find_prog_unit then
61: hr_api.cannot_find_prog_unit_error
62: (p_module_name => 'insert_quest_fields'
63: ,p_hook_type => 'BP'
64: );
65: end;

Line 105: when hr_api.cannot_find_prog_unit then

101: ,p_field_id =>p_field_id
102: ,p_object_version_number =>p_object_version_number
103: );
104: exception
105: when hr_api.cannot_find_prog_unit then
106: hr_api.cannot_find_prog_unit_error
107: (p_module_name => 'insert_quest_fields'
108: ,p_hook_type => 'AP'
109: );

Line 106: hr_api.cannot_find_prog_unit_error

102: ,p_object_version_number =>p_object_version_number
103: );
104: exception
105: when hr_api.cannot_find_prog_unit then
106: hr_api.cannot_find_prog_unit_error
107: (p_module_name => 'insert_quest_fields'
108: ,p_hook_type => 'AP'
109: );
110: end;

Line 115: raise hr_api.validate_enabled;

111: --
112: -- When in validation only mode raise the Validate_Enabled exception
113: --
114: if p_validate then
115: raise hr_api.validate_enabled;
116: end if;
117: --
118: -- Set all IN OUT and OUT parameters with out values
119: --

Line 124: when hr_api.validate_enabled then

120:
121: --
122: hr_utility.set_location(' Leaving:'||l_proc, 70);
123: exception
124: when hr_api.validate_enabled then
125: --
126: -- As the Validate_Enabled exception has been raised
127: -- we must rollback to the savepoint
128: --

Line 166: ,p_questionnaire_template_id in number default hr_api.g_number

162: (p_validate in boolean default false
163: ,p_effective_date in date
164: ,p_field_id in number
165: ,p_object_version_number in out nocopy number
166: ,p_questionnaire_template_id in number default hr_api.g_number
167: ,p_name in varchar2 default hr_api.g_varchar2
168: ,p_type in varchar2 default hr_api.g_varchar2
169: ,p_sql_required_flag in varchar2 default hr_api.g_varchar2
170: ,p_html_text in varchar2 default hr_api.g_varchar2

Line 167: ,p_name in varchar2 default hr_api.g_varchar2

163: ,p_effective_date in date
164: ,p_field_id in number
165: ,p_object_version_number in out nocopy number
166: ,p_questionnaire_template_id in number default hr_api.g_number
167: ,p_name in varchar2 default hr_api.g_varchar2
168: ,p_type in varchar2 default hr_api.g_varchar2
169: ,p_sql_required_flag in varchar2 default hr_api.g_varchar2
170: ,p_html_text in varchar2 default hr_api.g_varchar2
171: ,p_sql_text in varchar2 default hr_api.g_varchar2

Line 168: ,p_type in varchar2 default hr_api.g_varchar2

164: ,p_field_id in number
165: ,p_object_version_number in out nocopy number
166: ,p_questionnaire_template_id in number default hr_api.g_number
167: ,p_name in varchar2 default hr_api.g_varchar2
168: ,p_type in varchar2 default hr_api.g_varchar2
169: ,p_sql_required_flag in varchar2 default hr_api.g_varchar2
170: ,p_html_text in varchar2 default hr_api.g_varchar2
171: ,p_sql_text in varchar2 default hr_api.g_varchar2
172: ) is

Line 169: ,p_sql_required_flag in varchar2 default hr_api.g_varchar2

165: ,p_object_version_number in out nocopy number
166: ,p_questionnaire_template_id in number default hr_api.g_number
167: ,p_name in varchar2 default hr_api.g_varchar2
168: ,p_type in varchar2 default hr_api.g_varchar2
169: ,p_sql_required_flag in varchar2 default hr_api.g_varchar2
170: ,p_html_text in varchar2 default hr_api.g_varchar2
171: ,p_sql_text in varchar2 default hr_api.g_varchar2
172: ) is
173: --

Line 170: ,p_html_text in varchar2 default hr_api.g_varchar2

166: ,p_questionnaire_template_id in number default hr_api.g_number
167: ,p_name in varchar2 default hr_api.g_varchar2
168: ,p_type in varchar2 default hr_api.g_varchar2
169: ,p_sql_required_flag in varchar2 default hr_api.g_varchar2
170: ,p_html_text in varchar2 default hr_api.g_varchar2
171: ,p_sql_text in varchar2 default hr_api.g_varchar2
172: ) is
173: --
174: -- Declare cursors and local variables

Line 171: ,p_sql_text in varchar2 default hr_api.g_varchar2

167: ,p_name in varchar2 default hr_api.g_varchar2
168: ,p_type in varchar2 default hr_api.g_varchar2
169: ,p_sql_required_flag in varchar2 default hr_api.g_varchar2
170: ,p_html_text in varchar2 default hr_api.g_varchar2
171: ,p_sql_text in varchar2 default hr_api.g_varchar2
172: ) is
173: --
174: -- Declare cursors and local variables
175: --

Line 212: when hr_api.cannot_find_prog_unit then

208: ,p_html_text => p_html_text
209: ,p_sql_text => p_sql_text
210: );
211: exception
212: when hr_api.cannot_find_prog_unit then
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'update_quest_fields'
215: ,p_hook_type => 'BP'
216: );

Line 213: hr_api.cannot_find_prog_unit_error

209: ,p_sql_text => p_sql_text
210: );
211: exception
212: when hr_api.cannot_find_prog_unit then
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'update_quest_fields'
215: ,p_hook_type => 'BP'
216: );
217: end;

Line 251: when hr_api.cannot_find_prog_unit then

247: ,p_html_text => p_html_text
248: ,p_sql_text => p_sql_text
249: );
250: exception
251: when hr_api.cannot_find_prog_unit then
252: hr_api.cannot_find_prog_unit_error
253: (p_module_name => 'update_quest_fields'
254: ,p_hook_type => 'AP'
255: );

Line 252: hr_api.cannot_find_prog_unit_error

248: ,p_sql_text => p_sql_text
249: );
250: exception
251: when hr_api.cannot_find_prog_unit then
252: hr_api.cannot_find_prog_unit_error
253: (p_module_name => 'update_quest_fields'
254: ,p_hook_type => 'AP'
255: );
256: end;

Line 261: raise hr_api.validate_enabled;

257: --
258: -- When in validation only mode raise the Validate_Enabled exception
259: --
260: if p_validate then
261: raise hr_api.validate_enabled;
262: end if;
263: --
264: -- Set all IN OUT and OUT parameters with out values
265: --

Line 270: when hr_api.validate_enabled then

266:
267: --
268: hr_utility.set_location(' Leaving:'||l_proc, 70);
269: exception
270: when hr_api.validate_enabled then
271: --
272: -- As the Validate_Enabled exception has been raised
273: -- we must rollback to the savepoint
274: --

Line 346: when hr_api.cannot_find_prog_unit then

342: p_field_id => p_field_id
343: ,p_object_version_number => p_object_version_number
344: );
345: exception
346: when hr_api.cannot_find_prog_unit then
347: hr_api.cannot_find_prog_unit_error
348: (p_module_name => 'delete_quest_fields'
349: ,p_hook_type => 'BP'
350: );

Line 347: hr_api.cannot_find_prog_unit_error

343: ,p_object_version_number => p_object_version_number
344: );
345: exception
346: when hr_api.cannot_find_prog_unit then
347: hr_api.cannot_find_prog_unit_error
348: (p_module_name => 'delete_quest_fields'
349: ,p_hook_type => 'BP'
350: );
351: end;

Line 391: when hr_api.cannot_find_prog_unit then

387: p_field_id =>p_field_id
388: ,p_object_version_number =>p_object_version_number
389: );
390: exception
391: when hr_api.cannot_find_prog_unit then
392: hr_api.cannot_find_prog_unit_error
393: (p_module_name => 'delete_quest_fields'
394: ,p_hook_type => 'AP'
395: );

Line 392: hr_api.cannot_find_prog_unit_error

388: ,p_object_version_number =>p_object_version_number
389: );
390: exception
391: when hr_api.cannot_find_prog_unit then
392: hr_api.cannot_find_prog_unit_error
393: (p_module_name => 'delete_quest_fields'
394: ,p_hook_type => 'AP'
395: );
396: end;

Line 401: raise hr_api.validate_enabled;

397: --
398: -- When in validation only mode raise the Validate_Enabled exception
399: --
400: if p_validate then
401: raise hr_api.validate_enabled;
402: end if;
403: --
404: -- Set all IN OUT and OUT parameters with out values
405: --

Line 410: when hr_api.validate_enabled then

406:
407: --
408: hr_utility.set_location(' Leaving:'||l_proc, 70);
409: exception
410: when hr_api.validate_enabled then
411: --
412: -- As the Validate_Enabled exception has been raised
413: -- we must rollback to the savepoint
414: --