APPS.PQH_RULE_SETS_API dependencies on HR_API

Line 26: ,p_language_code in varchar2 default hr_api.userenv_lang

22: ,p_rule_level_cd in varchar2
23: ,p_object_version_number out nocopy number
24: ,p_short_name in varchar2
25: ,p_effective_date in date
26: ,p_language_code in varchar2 default hr_api.userenv_lang
27: ,p_rule_applicability in varchar2
28: ,p_rule_category in varchar2
29: ,p_starting_organization_id in number default null
30: ,p_seeded_rule_flag in varchar2 default 'N'

Line 74: when hr_api.cannot_find_prog_unit then

70: ,p_seeded_rule_flag => p_seeded_rule_flag
71: ,p_status => p_status
72: );
73: exception
74: when hr_api.cannot_find_prog_unit then
75: hr_api.cannot_find_prog_unit_error
76: (
77: p_module_name => 'CREATE_RULE_SET'
78: ,p_hook_type => 'BP'

Line 75: hr_api.cannot_find_prog_unit_error

71: ,p_status => p_status
72: );
73: exception
74: when hr_api.cannot_find_prog_unit then
75: hr_api.cannot_find_prog_unit_error
76: (
77: p_module_name => 'CREATE_RULE_SET'
78: ,p_hook_type => 'BP'
79: );

Line 138: when hr_api.cannot_find_prog_unit then

134: ,p_seeded_rule_flag => p_seeded_rule_flag
135: ,p_status => p_status
136: );
137: exception
138: when hr_api.cannot_find_prog_unit then
139: hr_api.cannot_find_prog_unit_error
140: (p_module_name => 'CREATE_RULE_SET'
141: ,p_hook_type => 'AP'
142: );

Line 139: hr_api.cannot_find_prog_unit_error

135: ,p_status => p_status
136: );
137: exception
138: when hr_api.cannot_find_prog_unit then
139: hr_api.cannot_find_prog_unit_error
140: (p_module_name => 'CREATE_RULE_SET'
141: ,p_hook_type => 'AP'
142: );
143: --

Line 153: raise hr_api.validate_enabled;

149: --
150: -- When in validation only mode raise the Validate_Enabled exception
151: --
152: if p_validate then
153: raise hr_api.validate_enabled;
154: end if;
155: --
156: -- Set all output arguments
157: --

Line 165: when hr_api.validate_enabled then

161: hr_utility.set_location(' Leaving:'||l_proc, 70);
162: --
163: exception
164: --
165: when hr_api.validate_enabled then
166: --
167: -- As the Validate_Enabled exception has been raised
168: -- we must rollback to the savepoint
169: --

Line 196: ,p_business_group_id in number default hr_api.g_number

192: -- ----------------------------------------------------------------------------
193: --
194: procedure update_RULE_SET
195: (p_validate in boolean default false
196: ,p_business_group_id in number default hr_api.g_number
197: ,p_rule_set_id in number
198: ,p_rule_set_name in varchar2 default hr_api.g_varchar2
199: ,p_description in varchar2 default hr_api.g_varchar2
200: ,p_organization_structure_id in number default hr_api.g_number

Line 198: ,p_rule_set_name in varchar2 default hr_api.g_varchar2

194: procedure update_RULE_SET
195: (p_validate in boolean default false
196: ,p_business_group_id in number default hr_api.g_number
197: ,p_rule_set_id in number
198: ,p_rule_set_name in varchar2 default hr_api.g_varchar2
199: ,p_description in varchar2 default hr_api.g_varchar2
200: ,p_organization_structure_id in number default hr_api.g_number
201: ,p_organization_id in number default hr_api.g_number
202: ,p_referenced_rule_set_id in number default hr_api.g_number

Line 199: ,p_description in varchar2 default hr_api.g_varchar2

195: (p_validate in boolean default false
196: ,p_business_group_id in number default hr_api.g_number
197: ,p_rule_set_id in number
198: ,p_rule_set_name in varchar2 default hr_api.g_varchar2
199: ,p_description in varchar2 default hr_api.g_varchar2
200: ,p_organization_structure_id in number default hr_api.g_number
201: ,p_organization_id in number default hr_api.g_number
202: ,p_referenced_rule_set_id in number default hr_api.g_number
203: ,p_rule_level_cd in varchar2 default hr_api.g_varchar2

Line 200: ,p_organization_structure_id in number default hr_api.g_number

196: ,p_business_group_id in number default hr_api.g_number
197: ,p_rule_set_id in number
198: ,p_rule_set_name in varchar2 default hr_api.g_varchar2
199: ,p_description in varchar2 default hr_api.g_varchar2
200: ,p_organization_structure_id in number default hr_api.g_number
201: ,p_organization_id in number default hr_api.g_number
202: ,p_referenced_rule_set_id in number default hr_api.g_number
203: ,p_rule_level_cd in varchar2 default hr_api.g_varchar2
204: ,p_object_version_number in out nocopy number

Line 201: ,p_organization_id in number default hr_api.g_number

197: ,p_rule_set_id in number
198: ,p_rule_set_name in varchar2 default hr_api.g_varchar2
199: ,p_description in varchar2 default hr_api.g_varchar2
200: ,p_organization_structure_id in number default hr_api.g_number
201: ,p_organization_id in number default hr_api.g_number
202: ,p_referenced_rule_set_id in number default hr_api.g_number
203: ,p_rule_level_cd in varchar2 default hr_api.g_varchar2
204: ,p_object_version_number in out nocopy number
205: ,p_short_name in varchar2 default hr_api.g_varchar2

Line 202: ,p_referenced_rule_set_id in number default hr_api.g_number

198: ,p_rule_set_name in varchar2 default hr_api.g_varchar2
199: ,p_description in varchar2 default hr_api.g_varchar2
200: ,p_organization_structure_id in number default hr_api.g_number
201: ,p_organization_id in number default hr_api.g_number
202: ,p_referenced_rule_set_id in number default hr_api.g_number
203: ,p_rule_level_cd in varchar2 default hr_api.g_varchar2
204: ,p_object_version_number in out nocopy number
205: ,p_short_name in varchar2 default hr_api.g_varchar2
206: ,p_effective_date in date

Line 203: ,p_rule_level_cd in varchar2 default hr_api.g_varchar2

199: ,p_description in varchar2 default hr_api.g_varchar2
200: ,p_organization_structure_id in number default hr_api.g_number
201: ,p_organization_id in number default hr_api.g_number
202: ,p_referenced_rule_set_id in number default hr_api.g_number
203: ,p_rule_level_cd in varchar2 default hr_api.g_varchar2
204: ,p_object_version_number in out nocopy number
205: ,p_short_name in varchar2 default hr_api.g_varchar2
206: ,p_effective_date in date
207: ,p_language_code in varchar2 default hr_api.userenv_lang

Line 205: ,p_short_name in varchar2 default hr_api.g_varchar2

201: ,p_organization_id in number default hr_api.g_number
202: ,p_referenced_rule_set_id in number default hr_api.g_number
203: ,p_rule_level_cd in varchar2 default hr_api.g_varchar2
204: ,p_object_version_number in out nocopy number
205: ,p_short_name in varchar2 default hr_api.g_varchar2
206: ,p_effective_date in date
207: ,p_language_code in varchar2 default hr_api.userenv_lang
208: ,p_rule_applicability in varchar2 default hr_api.g_varchar2
209: ,p_rule_category in varchar2 default hr_api.g_varchar2

Line 207: ,p_language_code in varchar2 default hr_api.userenv_lang

203: ,p_rule_level_cd in varchar2 default hr_api.g_varchar2
204: ,p_object_version_number in out nocopy number
205: ,p_short_name in varchar2 default hr_api.g_varchar2
206: ,p_effective_date in date
207: ,p_language_code in varchar2 default hr_api.userenv_lang
208: ,p_rule_applicability in varchar2 default hr_api.g_varchar2
209: ,p_rule_category in varchar2 default hr_api.g_varchar2
210: ,p_starting_organization_id in number default hr_api.g_number
211: ,p_seeded_rule_flag in varchar2 default hr_api.g_varchar2

Line 208: ,p_rule_applicability in varchar2 default hr_api.g_varchar2

204: ,p_object_version_number in out nocopy number
205: ,p_short_name in varchar2 default hr_api.g_varchar2
206: ,p_effective_date in date
207: ,p_language_code in varchar2 default hr_api.userenv_lang
208: ,p_rule_applicability in varchar2 default hr_api.g_varchar2
209: ,p_rule_category in varchar2 default hr_api.g_varchar2
210: ,p_starting_organization_id in number default hr_api.g_number
211: ,p_seeded_rule_flag in varchar2 default hr_api.g_varchar2
212: ,p_status in varchar2 default hr_api.g_varchar2

Line 209: ,p_rule_category in varchar2 default hr_api.g_varchar2

205: ,p_short_name in varchar2 default hr_api.g_varchar2
206: ,p_effective_date in date
207: ,p_language_code in varchar2 default hr_api.userenv_lang
208: ,p_rule_applicability in varchar2 default hr_api.g_varchar2
209: ,p_rule_category in varchar2 default hr_api.g_varchar2
210: ,p_starting_organization_id in number default hr_api.g_number
211: ,p_seeded_rule_flag in varchar2 default hr_api.g_varchar2
212: ,p_status in varchar2 default hr_api.g_varchar2
213: ) is

Line 210: ,p_starting_organization_id in number default hr_api.g_number

206: ,p_effective_date in date
207: ,p_language_code in varchar2 default hr_api.userenv_lang
208: ,p_rule_applicability in varchar2 default hr_api.g_varchar2
209: ,p_rule_category in varchar2 default hr_api.g_varchar2
210: ,p_starting_organization_id in number default hr_api.g_number
211: ,p_seeded_rule_flag in varchar2 default hr_api.g_varchar2
212: ,p_status in varchar2 default hr_api.g_varchar2
213: ) is
214: --

Line 211: ,p_seeded_rule_flag in varchar2 default hr_api.g_varchar2

207: ,p_language_code in varchar2 default hr_api.userenv_lang
208: ,p_rule_applicability in varchar2 default hr_api.g_varchar2
209: ,p_rule_category in varchar2 default hr_api.g_varchar2
210: ,p_starting_organization_id in number default hr_api.g_number
211: ,p_seeded_rule_flag in varchar2 default hr_api.g_varchar2
212: ,p_status in varchar2 default hr_api.g_varchar2
213: ) is
214: --
215: -- Declare cursors and local variables

Line 212: ,p_status in varchar2 default hr_api.g_varchar2

208: ,p_rule_applicability in varchar2 default hr_api.g_varchar2
209: ,p_rule_category in varchar2 default hr_api.g_varchar2
210: ,p_starting_organization_id in number default hr_api.g_number
211: ,p_seeded_rule_flag in varchar2 default hr_api.g_varchar2
212: ,p_status in varchar2 default hr_api.g_varchar2
213: ) is
214: --
215: -- Declare cursors and local variables
216: --

Line 260: when hr_api.cannot_find_prog_unit then

256: ,p_seeded_rule_flag => p_seeded_rule_flag
257: ,p_status => p_status
258: );
259: exception
260: when hr_api.cannot_find_prog_unit then
261: hr_api.cannot_find_prog_unit_error
262: (p_module_name => 'UPDATE_RULE_SET'
263: ,p_hook_type => 'BP'
264: );

Line 261: hr_api.cannot_find_prog_unit_error

257: ,p_status => p_status
258: );
259: exception
260: when hr_api.cannot_find_prog_unit then
261: hr_api.cannot_find_prog_unit_error
262: (p_module_name => 'UPDATE_RULE_SET'
263: ,p_hook_type => 'BP'
264: );
265: --

Line 323: when hr_api.cannot_find_prog_unit then

319: ,p_seeded_rule_flag => p_seeded_rule_flag
320: ,p_status => p_status
321: );
322: exception
323: when hr_api.cannot_find_prog_unit then
324: hr_api.cannot_find_prog_unit_error
325: (p_module_name => 'UPDATE_RULE_SET'
326: ,p_hook_type => 'AP'
327: );

Line 324: hr_api.cannot_find_prog_unit_error

320: ,p_status => p_status
321: );
322: exception
323: when hr_api.cannot_find_prog_unit then
324: hr_api.cannot_find_prog_unit_error
325: (p_module_name => 'UPDATE_RULE_SET'
326: ,p_hook_type => 'AP'
327: );
328: --

Line 338: raise hr_api.validate_enabled;

334: --
335: -- When in validation only mode raise the Validate_Enabled exception
336: --
337: if p_validate then
338: raise hr_api.validate_enabled;
339: end if;
340: --
341: -- Set all output arguments
342: --

Line 353: when hr_api.validate_enabled then

349: hr_utility.set_location(' Leaving:'||l_proc, 70);
350: --
351: exception
352: --
353: when hr_api.validate_enabled then
354: --
355: -- As the Validate_Enabled exception has been raised
356: -- we must rollback to the savepoint
357: --

Line 423: when hr_api.cannot_find_prog_unit then

419: ,p_object_version_number => p_object_version_number
420: ,p_effective_date => trunc(p_effective_date)
421: );
422: exception
423: when hr_api.cannot_find_prog_unit then
424: hr_api.cannot_find_prog_unit_error
425: (p_module_name => 'DELETE_RULE_SET'
426: ,p_hook_type => 'BP'
427: );

Line 424: hr_api.cannot_find_prog_unit_error

420: ,p_effective_date => trunc(p_effective_date)
421: );
422: exception
423: when hr_api.cannot_find_prog_unit then
424: hr_api.cannot_find_prog_unit_error
425: (p_module_name => 'DELETE_RULE_SET'
426: ,p_hook_type => 'BP'
427: );
428: --

Line 471: when hr_api.cannot_find_prog_unit then

467: ,p_object_version_number => l_object_version_number
468: ,p_effective_date => trunc(p_effective_date)
469: );
470: exception
471: when hr_api.cannot_find_prog_unit then
472: hr_api.cannot_find_prog_unit_error
473: (p_module_name => 'DELETE_RULE_SET'
474: ,p_hook_type => 'AP'
475: );

Line 472: hr_api.cannot_find_prog_unit_error

468: ,p_effective_date => trunc(p_effective_date)
469: );
470: exception
471: when hr_api.cannot_find_prog_unit then
472: hr_api.cannot_find_prog_unit_error
473: (p_module_name => 'DELETE_RULE_SET'
474: ,p_hook_type => 'AP'
475: );
476: --

Line 486: raise hr_api.validate_enabled;

482: --
483: -- When in validation only mode raise the Validate_Enabled exception
484: --
485: if p_validate then
486: raise hr_api.validate_enabled;
487: end if;
488: --
489: hr_utility.set_location(' Leaving:'||l_proc, 70);
490: --

Line 493: when hr_api.validate_enabled then

489: hr_utility.set_location(' Leaving:'||l_proc, 70);
490: --
491: exception
492: --
493: when hr_api.validate_enabled then
494: --
495: -- As the Validate_Enabled exception has been raised
496: -- we must rollback to the savepoint
497: --