DBA Data[Home] [Help]

APPS.PQH_FR_STAT_SIT_RULES_API dependencies on HR_API

Line 76: when hr_api.cannot_find_prog_unit then

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

Line 77: hr_api.cannot_find_prog_unit_error

73: );
74:
75: exception
76: when hr_api.cannot_find_prog_unit then
77: hr_api.cannot_find_prog_unit_error
78: (p_module_name => 'CREATE_STAT_SITUATION_RULE'
79: ,p_hook_type => 'BP'
80: );
81: end;

Line 126: when hr_api.cannot_find_prog_unit then

122: ,p_object_version_number => l_object_version_number
123:
124: );
125: exception
126: when hr_api.cannot_find_prog_unit then
127: hr_api.cannot_find_prog_unit_error
128: (p_module_name => 'CREATE_STAT_SITUATION_RULE'
129: ,p_hook_type => 'AP'
130: );

Line 127: hr_api.cannot_find_prog_unit_error

123:
124: );
125: exception
126: when hr_api.cannot_find_prog_unit then
127: hr_api.cannot_find_prog_unit_error
128: (p_module_name => 'CREATE_STAT_SITUATION_RULE'
129: ,p_hook_type => 'AP'
130: );
131: end;

Line 136: raise hr_api.validate_enabled;

132: --
133: -- When in validation only mode raise the Validate_Enabled exception
134: --
135: if p_validate then
136: raise hr_api.validate_enabled;
137: end if;
138: --
139: -- Set all IN OUT and OUT parameters with out values
140: --

Line 151: when hr_api.validate_enabled then

147: --
148: End if;
149:
150: exception
151: when hr_api.validate_enabled then
152: --
153: -- As the Validate_Enabled exception has been raised
154: -- we must rollback to the savepoint
155: --

Line 197: ,p_statutory_situation_id in number default hr_api.g_number

193: (p_validate in boolean default false
194: ,p_effective_date in date default sysdate
195: ,p_stat_situation_rule_id in number
196: ,p_object_version_number in out nocopy number
197: ,p_statutory_situation_id in number default hr_api.g_number
198: ,p_processing_sequence in number default hr_api.g_number
199: ,p_txn_category_attribute_id in number default hr_api.g_number
200: ,p_from_value in varchar2 default hr_api.g_varchar2
201: ,p_to_value in varchar2 default hr_api.g_varchar2

Line 198: ,p_processing_sequence in number default hr_api.g_number

194: ,p_effective_date in date default sysdate
195: ,p_stat_situation_rule_id in number
196: ,p_object_version_number in out nocopy number
197: ,p_statutory_situation_id in number default hr_api.g_number
198: ,p_processing_sequence in number default hr_api.g_number
199: ,p_txn_category_attribute_id in number default hr_api.g_number
200: ,p_from_value in varchar2 default hr_api.g_varchar2
201: ,p_to_value in varchar2 default hr_api.g_varchar2
202: ,p_enabled_flag in varchar2 default hr_api.g_varchar2

Line 199: ,p_txn_category_attribute_id in number default hr_api.g_number

195: ,p_stat_situation_rule_id in number
196: ,p_object_version_number in out nocopy number
197: ,p_statutory_situation_id in number default hr_api.g_number
198: ,p_processing_sequence in number default hr_api.g_number
199: ,p_txn_category_attribute_id in number default hr_api.g_number
200: ,p_from_value in varchar2 default hr_api.g_varchar2
201: ,p_to_value in varchar2 default hr_api.g_varchar2
202: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
203: ,p_required_flag in varchar2 default hr_api.g_varchar2

Line 200: ,p_from_value in varchar2 default hr_api.g_varchar2

196: ,p_object_version_number in out nocopy number
197: ,p_statutory_situation_id in number default hr_api.g_number
198: ,p_processing_sequence in number default hr_api.g_number
199: ,p_txn_category_attribute_id in number default hr_api.g_number
200: ,p_from_value in varchar2 default hr_api.g_varchar2
201: ,p_to_value in varchar2 default hr_api.g_varchar2
202: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
203: ,p_required_flag in varchar2 default hr_api.g_varchar2
204: ,p_exclude_flag in varchar2 default hr_api.g_varchar2

Line 201: ,p_to_value in varchar2 default hr_api.g_varchar2

197: ,p_statutory_situation_id in number default hr_api.g_number
198: ,p_processing_sequence in number default hr_api.g_number
199: ,p_txn_category_attribute_id in number default hr_api.g_number
200: ,p_from_value in varchar2 default hr_api.g_varchar2
201: ,p_to_value in varchar2 default hr_api.g_varchar2
202: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
203: ,p_required_flag in varchar2 default hr_api.g_varchar2
204: ,p_exclude_flag in varchar2 default hr_api.g_varchar2
205: ) is

Line 202: ,p_enabled_flag in varchar2 default hr_api.g_varchar2

198: ,p_processing_sequence in number default hr_api.g_number
199: ,p_txn_category_attribute_id in number default hr_api.g_number
200: ,p_from_value in varchar2 default hr_api.g_varchar2
201: ,p_to_value in varchar2 default hr_api.g_varchar2
202: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
203: ,p_required_flag in varchar2 default hr_api.g_varchar2
204: ,p_exclude_flag in varchar2 default hr_api.g_varchar2
205: ) is
206: --

Line 203: ,p_required_flag in varchar2 default hr_api.g_varchar2

199: ,p_txn_category_attribute_id in number default hr_api.g_number
200: ,p_from_value in varchar2 default hr_api.g_varchar2
201: ,p_to_value in varchar2 default hr_api.g_varchar2
202: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
203: ,p_required_flag in varchar2 default hr_api.g_varchar2
204: ,p_exclude_flag in varchar2 default hr_api.g_varchar2
205: ) is
206: --
207: -- Declare cursors and local variables

Line 204: ,p_exclude_flag in varchar2 default hr_api.g_varchar2

200: ,p_from_value in varchar2 default hr_api.g_varchar2
201: ,p_to_value in varchar2 default hr_api.g_varchar2
202: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
203: ,p_required_flag in varchar2 default hr_api.g_varchar2
204: ,p_exclude_flag in varchar2 default hr_api.g_varchar2
205: ) is
206: --
207: -- Declare cursors and local variables
208: --

Line 259: when hr_api.cannot_find_prog_unit then

255: ,p_object_version_number => p_object_version_number
256:
257: );
258: exception
259: when hr_api.cannot_find_prog_unit then
260: hr_api.cannot_find_prog_unit_error
261: (p_module_name => 'UPDATE_STAT_SITUATION_RULE'
262: ,p_hook_type => 'BP'
263: );

Line 260: hr_api.cannot_find_prog_unit_error

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

Line 302: when hr_api.cannot_find_prog_unit then

298: ,p_object_version_number => p_object_version_number
299:
300: );
301: exception
302: when hr_api.cannot_find_prog_unit then
303: hr_api.cannot_find_prog_unit_error
304: (p_module_name => 'UPDATE_STAT_SITUATION_RULE'
305: ,p_hook_type => 'AP'
306: );

Line 303: hr_api.cannot_find_prog_unit_error

299:
300: );
301: exception
302: when hr_api.cannot_find_prog_unit then
303: hr_api.cannot_find_prog_unit_error
304: (p_module_name => 'UPDATE_STAT_SITUATION_RULE'
305: ,p_hook_type => 'AP'
306: );
307: end;

Line 312: raise hr_api.validate_enabled;

308: --
309: -- When in validation only mode raise the Validate_Enabled exception
310: --
311: if p_validate then
312: raise hr_api.validate_enabled;
313: end if;
314: --
315: -- Set all IN OUT and OUT parameters with out values
316: --

Line 327: when hr_api.validate_enabled then

323: --
324: End if;
325:
326: exception
327: when hr_api.validate_enabled then
328: --
329: -- As the Validate_Enabled exception has been raised
330: -- we must rollback to the savepoint
331: --

Line 402: when hr_api.cannot_find_prog_unit then

398: ,p_object_version_number => p_object_version_number
399: );
400:
401: exception
402: when hr_api.cannot_find_prog_unit then
403: hr_api.cannot_find_prog_unit_error
404: (p_module_name => 'DELETE_STAT_SITUATION_RULE'
405: ,p_hook_type => 'BP'
406: );

Line 403: hr_api.cannot_find_prog_unit_error

399: );
400:
401: exception
402: when hr_api.cannot_find_prog_unit then
403: hr_api.cannot_find_prog_unit_error
404: (p_module_name => 'DELETE_STAT_SITUATION_RULE'
405: ,p_hook_type => 'BP'
406: );
407: end;

Line 430: when hr_api.cannot_find_prog_unit then

426: ( p_stat_situation_rule_id => p_stat_situation_rule_id
427: ,p_object_version_number => p_object_version_number
428: );
429: exception
430: when hr_api.cannot_find_prog_unit then
431: hr_api.cannot_find_prog_unit_error
432: (p_module_name => 'DELETE_STAT_SITUATION_RULE'
433: ,p_hook_type => 'AP'
434: );

Line 431: hr_api.cannot_find_prog_unit_error

427: ,p_object_version_number => p_object_version_number
428: );
429: exception
430: when hr_api.cannot_find_prog_unit then
431: hr_api.cannot_find_prog_unit_error
432: (p_module_name => 'DELETE_STAT_SITUATION_RULE'
433: ,p_hook_type => 'AP'
434: );
435: end;

Line 440: raise hr_api.validate_enabled;

436: --
437: -- When in validation only mode raise the Validate_Enabled exception
438: --
439: if p_validate then
440: raise hr_api.validate_enabled;
441: end if;
442: --
443: -- Set all IN OUT and OUT parameters with out values
444: --

Line 453: when hr_api.validate_enabled then

449: hr_utility.set_location(' Leaving:'||l_proc, 70);
450: --
451: End if;
452: exception
453: when hr_api.validate_enabled then
454: --
455: -- As the Validate_Enabled exception has been raised
456: -- we must rollback to the savepoint
457: --