68: ,p_BUSINESS_GROUP_ID => p_business_group_id
69: ,p_LEGISLATION_CODE => p_legislation_code
70: );
71: exception
72: when hr_api.cannot_find_prog_unit then
73: hr_api.cannot_find_prog_unit_error
74: (p_module_name => 'create_rate_matrix_rate'
75: ,p_hook_type => 'BP'
76: );
69: ,p_LEGISLATION_CODE => p_legislation_code
70: );
71: exception
72: when hr_api.cannot_find_prog_unit then
73: hr_api.cannot_find_prog_unit_error
74: (p_module_name => 'create_rate_matrix_rate'
75: ,p_hook_type => 'BP'
76: );
77: end;
119: ,p_LEGISLATION_CODE => p_legislation_code
120: ,p_object_version_number => l_object_version_number
121: );
122: exception
123: when hr_api.cannot_find_prog_unit then
124: hr_api.cannot_find_prog_unit_error
125: (p_module_name => 'create_rate_matrix_rate'
126: ,p_hook_type => 'AP'
127: );
120: ,p_object_version_number => l_object_version_number
121: );
122: exception
123: when hr_api.cannot_find_prog_unit then
124: hr_api.cannot_find_prog_unit_error
125: (p_module_name => 'create_rate_matrix_rate'
126: ,p_hook_type => 'AP'
127: );
128: end;
129: --
130: -- When in validation only mode raise the Validate_Enabled exception
131: --
132: if p_validate then
133: raise hr_api.validate_enabled;
134: end if;
135: --
136: -- Set all IN OUT and OUT parameters with out values
137: --
141: p_object_version_number := l_object_version_number;
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 70);
144: exception
145: when hr_api.validate_enabled then
146: --
147: -- As the Validate_Enabled exception has been raised
148: -- we must rollback to the savepoint
149: --
189: ,p_EFFECTIVE_START_DATE out nocopy date
190: ,p_EFFECTIVE_END_DATE out nocopy date
191: ,p_RATE_MATRIX_NODE_ID in number
192: ,p_CRITERIA_RATE_DEFN_ID in number
193: ,p_MIN_RATE_VALUE in NUMBER default hr_api.g_number
194: ,p_MAX_RATE_VALUE in NUMBER default hr_api.g_number
195: ,p_MID_RATE_VALUE in NUMBER default hr_api.g_number
196: ,p_RATE_VALUE in NUMBER
197: ,p_BUSINESS_GROUP_ID in NUMBER default hr_api.g_number
190: ,p_EFFECTIVE_END_DATE out nocopy date
191: ,p_RATE_MATRIX_NODE_ID in number
192: ,p_CRITERIA_RATE_DEFN_ID in number
193: ,p_MIN_RATE_VALUE in NUMBER default hr_api.g_number
194: ,p_MAX_RATE_VALUE in NUMBER default hr_api.g_number
195: ,p_MID_RATE_VALUE in NUMBER default hr_api.g_number
196: ,p_RATE_VALUE in NUMBER
197: ,p_BUSINESS_GROUP_ID in NUMBER default hr_api.g_number
198: ,p_LEGISLATION_CODE in VARCHAR2 default hr_api.g_varchar2
191: ,p_RATE_MATRIX_NODE_ID in number
192: ,p_CRITERIA_RATE_DEFN_ID in number
193: ,p_MIN_RATE_VALUE in NUMBER default hr_api.g_number
194: ,p_MAX_RATE_VALUE in NUMBER default hr_api.g_number
195: ,p_MID_RATE_VALUE in NUMBER default hr_api.g_number
196: ,p_RATE_VALUE in NUMBER
197: ,p_BUSINESS_GROUP_ID in NUMBER default hr_api.g_number
198: ,p_LEGISLATION_CODE in VARCHAR2 default hr_api.g_varchar2
199: ,p_object_version_number in out nocopy number
193: ,p_MIN_RATE_VALUE in NUMBER default hr_api.g_number
194: ,p_MAX_RATE_VALUE in NUMBER default hr_api.g_number
195: ,p_MID_RATE_VALUE in NUMBER default hr_api.g_number
196: ,p_RATE_VALUE in NUMBER
197: ,p_BUSINESS_GROUP_ID in NUMBER default hr_api.g_number
198: ,p_LEGISLATION_CODE in VARCHAR2 default hr_api.g_varchar2
199: ,p_object_version_number in out nocopy number
200: )
201: is
194: ,p_MAX_RATE_VALUE in NUMBER default hr_api.g_number
195: ,p_MID_RATE_VALUE in NUMBER default hr_api.g_number
196: ,p_RATE_VALUE in NUMBER
197: ,p_BUSINESS_GROUP_ID in NUMBER default hr_api.g_number
198: ,p_LEGISLATION_CODE in VARCHAR2 default hr_api.g_varchar2
199: ,p_object_version_number in out nocopy number
200: )
201: is
202: --
242: ,p_object_version_number => p_object_version_number
243: );
244:
245: exception
246: when hr_api.cannot_find_prog_unit then
247: hr_api.cannot_find_prog_unit_error
248: (p_module_name => 'update_rate_matrix_rate'
249: ,p_hook_type => 'BP'
250: );
243: );
244:
245: exception
246: when hr_api.cannot_find_prog_unit then
247: hr_api.cannot_find_prog_unit_error
248: (p_module_name => 'update_rate_matrix_rate'
249: ,p_hook_type => 'BP'
250: );
251: end;
296: ,p_LEGISLATION_CODE => p_legislation_code
297: ,p_object_version_number => l_object_version_number
298: );
299: exception
300: when hr_api.cannot_find_prog_unit then
301: hr_api.cannot_find_prog_unit_error
302: (p_module_name => 'update_rate_matrix_rate'
303: ,p_hook_type => 'AP'
304: );
297: ,p_object_version_number => l_object_version_number
298: );
299: exception
300: when hr_api.cannot_find_prog_unit then
301: hr_api.cannot_find_prog_unit_error
302: (p_module_name => 'update_rate_matrix_rate'
303: ,p_hook_type => 'AP'
304: );
305: end;
306: --
307: -- When in validation only mode raise the Validate_Enabled exception
308: --
309: if p_validate then
310: raise hr_api.validate_enabled;
311: end if;
312: --
313: -- Set all IN OUT and OUT parameters with out values
314: --
317: p_effective_end_date := l_effective_end_date;
318: --
319: hr_utility.set_location(' Leaving:'||l_proc, 70);
320: exception
321: when hr_api.validate_enabled then
322: --
323: -- As the Validate_Enabled exception has been raised
324: -- we must rollback to the savepoint
325: --
397: ,p_rate_matrix_rate_ID => p_rate_matrix_rate_ID
398: ,p_object_version_number => p_object_version_number
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_rt_matrix_node_value'
404: ,p_hook_type => 'BP'
405: );
398: ,p_object_version_number => p_object_version_number
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_rt_matrix_node_value'
404: ,p_hook_type => 'BP'
405: );
406: end;
435: ,p_object_version_number => p_object_version_number
436: );
437:
438: exception
439: when hr_api.cannot_find_prog_unit then
440: hr_api.cannot_find_prog_unit_error
441: (p_module_name => 'delete_rt_matrix_node_value'
442: ,p_hook_type => 'AP'
443: );
436: );
437:
438: exception
439: when hr_api.cannot_find_prog_unit then
440: hr_api.cannot_find_prog_unit_error
441: (p_module_name => 'delete_rt_matrix_node_value'
442: ,p_hook_type => 'AP'
443: );
444: end;
445: --
446: -- When in validation only mode raise the Validate_Enabled exception
447: --
448: if p_validate then
449: raise hr_api.validate_enabled;
450: end if;
451: --
452: -- Set all IN OUT and OUT parameters with out values
453: --
453: --
454: --
455: hr_utility.set_location(' Leaving:'||l_proc, 70);
456: exception
457: when hr_api.validate_enabled then
458: --
459: -- As the Validate_Enabled exception has been raised
460: -- we must rollback to the savepoint
461: --