77: ,p_BUSINESS_GROUP_ID => p_business_group_id
78: ,p_LEGISLATION_CODE => p_legislation_code
79: );
80: exception
81: when hr_api.cannot_find_prog_unit then
82: hr_api.cannot_find_prog_unit_error
83: (p_module_name => 'create_rt_matrix_node_value'
84: ,p_hook_type => 'BP'
85: );
78: ,p_LEGISLATION_CODE => p_legislation_code
79: );
80: exception
81: when hr_api.cannot_find_prog_unit then
82: hr_api.cannot_find_prog_unit_error
83: (p_module_name => 'create_rt_matrix_node_value'
84: ,p_hook_type => 'BP'
85: );
86: end;
140: ,p_LEGISLATION_CODE => p_legislation_code
141: ,p_object_version_number => l_object_version_number
142: );
143: exception
144: when hr_api.cannot_find_prog_unit then
145: hr_api.cannot_find_prog_unit_error
146: (p_module_name => 'create_rt_matrix_node_value'
147: ,p_hook_type => 'AP'
148: );
141: ,p_object_version_number => l_object_version_number
142: );
143: exception
144: when hr_api.cannot_find_prog_unit then
145: hr_api.cannot_find_prog_unit_error
146: (p_module_name => 'create_rt_matrix_node_value'
147: ,p_hook_type => 'AP'
148: );
149: end;
150: --
151: -- When in validation only mode raise the Validate_Enabled exception
152: --
153: if p_validate then
154: raise hr_api.validate_enabled;
155: end if;
156: --
157: -- Set all IN OUT and OUT parameters with out values
158: --
160: p_object_version_number := l_object_version_number;
161: --
162: hr_utility.set_location(' Leaving:'||l_proc, 70);
163: exception
164: when hr_api.validate_enabled then
165: --
166: -- As the Validate_Enabled exception has been raised
167: -- we must rollback to the savepoint
168: --
201: ,p_effective_date in date
202: ,p_NODE_VALUE_ID in number
203: ,p_RATE_MATRIX_NODE_ID in number
204: ,p_SHORT_CODE in varchar2
205: ,p_CHAR_VALUE1 in varchar2 default hr_api.g_varchar2
206: ,p_CHAR_VALUE2 in varchar2 default hr_api.g_varchar2
207: ,p_CHAR_VALUE3 in varchar2 default hr_api.g_varchar2
208: ,p_CHAR_VALUE4 in varchar2 default hr_api.g_varchar2
209: ,p_NUMBER_VALUE1 in number default hr_api.g_number
202: ,p_NODE_VALUE_ID in number
203: ,p_RATE_MATRIX_NODE_ID in number
204: ,p_SHORT_CODE in varchar2
205: ,p_CHAR_VALUE1 in varchar2 default hr_api.g_varchar2
206: ,p_CHAR_VALUE2 in varchar2 default hr_api.g_varchar2
207: ,p_CHAR_VALUE3 in varchar2 default hr_api.g_varchar2
208: ,p_CHAR_VALUE4 in varchar2 default hr_api.g_varchar2
209: ,p_NUMBER_VALUE1 in number default hr_api.g_number
210: ,p_NUMBER_VALUE2 in number default hr_api.g_number
203: ,p_RATE_MATRIX_NODE_ID in number
204: ,p_SHORT_CODE in varchar2
205: ,p_CHAR_VALUE1 in varchar2 default hr_api.g_varchar2
206: ,p_CHAR_VALUE2 in varchar2 default hr_api.g_varchar2
207: ,p_CHAR_VALUE3 in varchar2 default hr_api.g_varchar2
208: ,p_CHAR_VALUE4 in varchar2 default hr_api.g_varchar2
209: ,p_NUMBER_VALUE1 in number default hr_api.g_number
210: ,p_NUMBER_VALUE2 in number default hr_api.g_number
211: ,p_NUMBER_VALUE3 in number default hr_api.g_number
204: ,p_SHORT_CODE in varchar2
205: ,p_CHAR_VALUE1 in varchar2 default hr_api.g_varchar2
206: ,p_CHAR_VALUE2 in varchar2 default hr_api.g_varchar2
207: ,p_CHAR_VALUE3 in varchar2 default hr_api.g_varchar2
208: ,p_CHAR_VALUE4 in varchar2 default hr_api.g_varchar2
209: ,p_NUMBER_VALUE1 in number default hr_api.g_number
210: ,p_NUMBER_VALUE2 in number default hr_api.g_number
211: ,p_NUMBER_VALUE3 in number default hr_api.g_number
212: ,p_NUMBER_VALUE4 in number default hr_api.g_number
205: ,p_CHAR_VALUE1 in varchar2 default hr_api.g_varchar2
206: ,p_CHAR_VALUE2 in varchar2 default hr_api.g_varchar2
207: ,p_CHAR_VALUE3 in varchar2 default hr_api.g_varchar2
208: ,p_CHAR_VALUE4 in varchar2 default hr_api.g_varchar2
209: ,p_NUMBER_VALUE1 in number default hr_api.g_number
210: ,p_NUMBER_VALUE2 in number default hr_api.g_number
211: ,p_NUMBER_VALUE3 in number default hr_api.g_number
212: ,p_NUMBER_VALUE4 in number default hr_api.g_number
213: ,p_DATE_VALUE1 in date default hr_api.g_date
206: ,p_CHAR_VALUE2 in varchar2 default hr_api.g_varchar2
207: ,p_CHAR_VALUE3 in varchar2 default hr_api.g_varchar2
208: ,p_CHAR_VALUE4 in varchar2 default hr_api.g_varchar2
209: ,p_NUMBER_VALUE1 in number default hr_api.g_number
210: ,p_NUMBER_VALUE2 in number default hr_api.g_number
211: ,p_NUMBER_VALUE3 in number default hr_api.g_number
212: ,p_NUMBER_VALUE4 in number default hr_api.g_number
213: ,p_DATE_VALUE1 in date default hr_api.g_date
214: ,p_DATE_VALUE2 in date default hr_api.g_date
207: ,p_CHAR_VALUE3 in varchar2 default hr_api.g_varchar2
208: ,p_CHAR_VALUE4 in varchar2 default hr_api.g_varchar2
209: ,p_NUMBER_VALUE1 in number default hr_api.g_number
210: ,p_NUMBER_VALUE2 in number default hr_api.g_number
211: ,p_NUMBER_VALUE3 in number default hr_api.g_number
212: ,p_NUMBER_VALUE4 in number default hr_api.g_number
213: ,p_DATE_VALUE1 in date default hr_api.g_date
214: ,p_DATE_VALUE2 in date default hr_api.g_date
215: ,p_DATE_VALUE3 in date default hr_api.g_date
208: ,p_CHAR_VALUE4 in varchar2 default hr_api.g_varchar2
209: ,p_NUMBER_VALUE1 in number default hr_api.g_number
210: ,p_NUMBER_VALUE2 in number default hr_api.g_number
211: ,p_NUMBER_VALUE3 in number default hr_api.g_number
212: ,p_NUMBER_VALUE4 in number default hr_api.g_number
213: ,p_DATE_VALUE1 in date default hr_api.g_date
214: ,p_DATE_VALUE2 in date default hr_api.g_date
215: ,p_DATE_VALUE3 in date default hr_api.g_date
216: ,p_DATE_VALUE4 in date default hr_api.g_date
209: ,p_NUMBER_VALUE1 in number default hr_api.g_number
210: ,p_NUMBER_VALUE2 in number default hr_api.g_number
211: ,p_NUMBER_VALUE3 in number default hr_api.g_number
212: ,p_NUMBER_VALUE4 in number default hr_api.g_number
213: ,p_DATE_VALUE1 in date default hr_api.g_date
214: ,p_DATE_VALUE2 in date default hr_api.g_date
215: ,p_DATE_VALUE3 in date default hr_api.g_date
216: ,p_DATE_VALUE4 in date default hr_api.g_date
217: ,p_BUSINESS_GROUP_ID in number default hr_api.g_number
210: ,p_NUMBER_VALUE2 in number default hr_api.g_number
211: ,p_NUMBER_VALUE3 in number default hr_api.g_number
212: ,p_NUMBER_VALUE4 in number default hr_api.g_number
213: ,p_DATE_VALUE1 in date default hr_api.g_date
214: ,p_DATE_VALUE2 in date default hr_api.g_date
215: ,p_DATE_VALUE3 in date default hr_api.g_date
216: ,p_DATE_VALUE4 in date default hr_api.g_date
217: ,p_BUSINESS_GROUP_ID in number default hr_api.g_number
218: ,p_LEGISLATION_CODE in varchar2 default hr_api.g_varchar2
211: ,p_NUMBER_VALUE3 in number default hr_api.g_number
212: ,p_NUMBER_VALUE4 in number default hr_api.g_number
213: ,p_DATE_VALUE1 in date default hr_api.g_date
214: ,p_DATE_VALUE2 in date default hr_api.g_date
215: ,p_DATE_VALUE3 in date default hr_api.g_date
216: ,p_DATE_VALUE4 in date default hr_api.g_date
217: ,p_BUSINESS_GROUP_ID in number default hr_api.g_number
218: ,p_LEGISLATION_CODE in varchar2 default hr_api.g_varchar2
219: ,p_object_version_number in out nocopy number
212: ,p_NUMBER_VALUE4 in number default hr_api.g_number
213: ,p_DATE_VALUE1 in date default hr_api.g_date
214: ,p_DATE_VALUE2 in date default hr_api.g_date
215: ,p_DATE_VALUE3 in date default hr_api.g_date
216: ,p_DATE_VALUE4 in date default hr_api.g_date
217: ,p_BUSINESS_GROUP_ID in number default hr_api.g_number
218: ,p_LEGISLATION_CODE in varchar2 default hr_api.g_varchar2
219: ,p_object_version_number in out nocopy number
220: )
213: ,p_DATE_VALUE1 in date default hr_api.g_date
214: ,p_DATE_VALUE2 in date default hr_api.g_date
215: ,p_DATE_VALUE3 in date default hr_api.g_date
216: ,p_DATE_VALUE4 in date default hr_api.g_date
217: ,p_BUSINESS_GROUP_ID in number default hr_api.g_number
218: ,p_LEGISLATION_CODE in varchar2 default hr_api.g_varchar2
219: ,p_object_version_number in out nocopy number
220: )
221: is
214: ,p_DATE_VALUE2 in date default hr_api.g_date
215: ,p_DATE_VALUE3 in date default hr_api.g_date
216: ,p_DATE_VALUE4 in date default hr_api.g_date
217: ,p_BUSINESS_GROUP_ID in number default hr_api.g_number
218: ,p_LEGISLATION_CODE in varchar2 default hr_api.g_varchar2
219: ,p_object_version_number in out nocopy number
220: )
221: is
222: --
267: ,p_object_version_number => l_object_version_number
268: );
269:
270: exception
271: when hr_api.cannot_find_prog_unit then
272: hr_api.cannot_find_prog_unit_error
273: (p_module_name => 'update_rt_matrix_node_value'
274: ,p_hook_type => 'BP'
275: );
268: );
269:
270: exception
271: when hr_api.cannot_find_prog_unit then
272: hr_api.cannot_find_prog_unit_error
273: (p_module_name => 'update_rt_matrix_node_value'
274: ,p_hook_type => 'BP'
275: );
276: end;
330: ,p_LEGISLATION_CODE => p_legislation_code
331: ,p_object_version_number => l_object_version_number
332: );
333: exception
334: when hr_api.cannot_find_prog_unit then
335: hr_api.cannot_find_prog_unit_error
336: (p_module_name => 'update_rt_matrix_node_value'
337: ,p_hook_type => 'AP'
338: );
331: ,p_object_version_number => l_object_version_number
332: );
333: exception
334: when hr_api.cannot_find_prog_unit then
335: hr_api.cannot_find_prog_unit_error
336: (p_module_name => 'update_rt_matrix_node_value'
337: ,p_hook_type => 'AP'
338: );
339: end;
340: --
341: -- When in validation only mode raise the Validate_Enabled exception
342: --
343: if p_validate then
344: raise hr_api.validate_enabled;
345: end if;
346: --
347: -- Set all IN OUT and OUT parameters with out values
348: --
349: p_object_version_number := l_object_version_number;
350: --
351: hr_utility.set_location(' Leaving:'||l_proc, 70);
352: exception
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: --
418: ,p_object_version_number => p_object_version_number
419: );
420:
421: exception
422: when hr_api.cannot_find_prog_unit then
423: hr_api.cannot_find_prog_unit_error
424: (p_module_name => 'delete_rt_matrix_node_value'
425: ,p_hook_type => 'BP'
426: );
419: );
420:
421: exception
422: when hr_api.cannot_find_prog_unit then
423: hr_api.cannot_find_prog_unit_error
424: (p_module_name => 'delete_rt_matrix_node_value'
425: ,p_hook_type => 'BP'
426: );
427: end;
450: ,p_object_version_number => p_object_version_number
451: );
452:
453: exception
454: when hr_api.cannot_find_prog_unit then
455: hr_api.cannot_find_prog_unit_error
456: (p_module_name => 'delete_rt_matrix_node_value'
457: ,p_hook_type => 'AP'
458: );
451: );
452:
453: exception
454: when hr_api.cannot_find_prog_unit then
455: hr_api.cannot_find_prog_unit_error
456: (p_module_name => 'delete_rt_matrix_node_value'
457: ,p_hook_type => 'AP'
458: );
459: end;
460: --
461: -- When in validation only mode raise the Validate_Enabled exception
462: --
463: if p_validate then
464: raise hr_api.validate_enabled;
465: end if;
466: --
467: -- Set all IN OUT and OUT parameters with out values
468: --
468: --
469: --
470: hr_utility.set_location(' Leaving:'||l_proc, 70);
471: exception
472: when hr_api.validate_enabled then
473: --
474: -- As the Validate_Enabled exception has been raised
475: -- we must rollback to the savepoint
476: --