90: ,P_MIN_VALUE
91: ,P_WARNING_OR_ERROR
92: );
93: exception
94: when hr_api.cannot_find_prog_unit then
95: hr_api.cannot_find_prog_unit_error
96: (p_module_name => 'CREATE_INPUT_VALUE'
97: ,p_hook_type => 'BP'
98: );
91: ,P_WARNING_OR_ERROR
92: );
93: exception
94: when hr_api.cannot_find_prog_unit then
95: hr_api.cannot_find_prog_unit_error
96: (p_module_name => 'CREATE_INPUT_VALUE'
97: ,p_hook_type => 'BP'
98: );
99: end;
170: ,P_ASSIGNMENT_ID_WARNING
171: ,P_FORMULA_MESSAGE
172: );
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'CREATE_INPUT_VALUE'
177: ,p_hook_type => 'AP'
178: );
171: ,P_FORMULA_MESSAGE
172: );
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'CREATE_INPUT_VALUE'
177: ,p_hook_type => 'AP'
178: );
179: end;
180: --
181: -- When in validation only mode raise the Validate_Enabled exception
182: --
183: if p_validate then
184: raise hr_api.validate_enabled;
185: end if;
186: --
187: -- Set all output arguments
188: --
191:
192: --
193: hr_utility.set_location(' Leaving:'||l_proc, 70);
194: exception
195: when hr_api.validate_enabled then
196: --
197: -- As the Validate_Enabled exception has been raised
198: -- we must rollback to the savepoint
199: --
232: ,P_EFFECTIVE_DATE IN date
233: ,P_DATETRACK_MODE IN varchar2
234: ,P_INPUT_VALUE_ID IN number
235: ,P_OBJECT_VERSION_NUMBER IN OUT NOCOPY number
236: ,P_NAME IN varchar2 Default hr_api.g_varchar2
237: ,P_UOM IN varchar2 Default hr_api.g_varchar2
238: ,P_LOOKUP_TYPE IN varchar2 Default hr_api.g_varchar2
239: ,P_FORMULA_ID IN number Default hr_api.g_number
240: ,P_VALUE_SET_ID IN number Default hr_api.g_number
233: ,P_DATETRACK_MODE IN varchar2
234: ,P_INPUT_VALUE_ID IN number
235: ,P_OBJECT_VERSION_NUMBER IN OUT NOCOPY number
236: ,P_NAME IN varchar2 Default hr_api.g_varchar2
237: ,P_UOM IN varchar2 Default hr_api.g_varchar2
238: ,P_LOOKUP_TYPE IN varchar2 Default hr_api.g_varchar2
239: ,P_FORMULA_ID IN number Default hr_api.g_number
240: ,P_VALUE_SET_ID IN number Default hr_api.g_number
241: ,P_DISPLAY_SEQUENCE IN number Default hr_api.g_number
234: ,P_INPUT_VALUE_ID IN number
235: ,P_OBJECT_VERSION_NUMBER IN OUT NOCOPY number
236: ,P_NAME IN varchar2 Default hr_api.g_varchar2
237: ,P_UOM IN varchar2 Default hr_api.g_varchar2
238: ,P_LOOKUP_TYPE IN varchar2 Default hr_api.g_varchar2
239: ,P_FORMULA_ID IN number Default hr_api.g_number
240: ,P_VALUE_SET_ID IN number Default hr_api.g_number
241: ,P_DISPLAY_SEQUENCE IN number Default hr_api.g_number
242: ,P_GENERATE_DB_ITEMS_FLAG IN varchar2 Default hr_api.g_varchar2
235: ,P_OBJECT_VERSION_NUMBER IN OUT NOCOPY number
236: ,P_NAME IN varchar2 Default hr_api.g_varchar2
237: ,P_UOM IN varchar2 Default hr_api.g_varchar2
238: ,P_LOOKUP_TYPE IN varchar2 Default hr_api.g_varchar2
239: ,P_FORMULA_ID IN number Default hr_api.g_number
240: ,P_VALUE_SET_ID IN number Default hr_api.g_number
241: ,P_DISPLAY_SEQUENCE IN number Default hr_api.g_number
242: ,P_GENERATE_DB_ITEMS_FLAG IN varchar2 Default hr_api.g_varchar2
243: ,P_HOT_DEFAULT_FLAG IN varchar2 Default hr_api.g_varchar2
236: ,P_NAME IN varchar2 Default hr_api.g_varchar2
237: ,P_UOM IN varchar2 Default hr_api.g_varchar2
238: ,P_LOOKUP_TYPE IN varchar2 Default hr_api.g_varchar2
239: ,P_FORMULA_ID IN number Default hr_api.g_number
240: ,P_VALUE_SET_ID IN number Default hr_api.g_number
241: ,P_DISPLAY_SEQUENCE IN number Default hr_api.g_number
242: ,P_GENERATE_DB_ITEMS_FLAG IN varchar2 Default hr_api.g_varchar2
243: ,P_HOT_DEFAULT_FLAG IN varchar2 Default hr_api.g_varchar2
244: ,P_MANDATORY_FLAG IN varchar2 Default hr_api.g_varchar2
237: ,P_UOM IN varchar2 Default hr_api.g_varchar2
238: ,P_LOOKUP_TYPE IN varchar2 Default hr_api.g_varchar2
239: ,P_FORMULA_ID IN number Default hr_api.g_number
240: ,P_VALUE_SET_ID IN number Default hr_api.g_number
241: ,P_DISPLAY_SEQUENCE IN number Default hr_api.g_number
242: ,P_GENERATE_DB_ITEMS_FLAG IN varchar2 Default hr_api.g_varchar2
243: ,P_HOT_DEFAULT_FLAG IN varchar2 Default hr_api.g_varchar2
244: ,P_MANDATORY_FLAG IN varchar2 Default hr_api.g_varchar2
245: ,P_DEFAULT_VALUE IN varchar2 Default hr_api.g_varchar2
238: ,P_LOOKUP_TYPE IN varchar2 Default hr_api.g_varchar2
239: ,P_FORMULA_ID IN number Default hr_api.g_number
240: ,P_VALUE_SET_ID IN number Default hr_api.g_number
241: ,P_DISPLAY_SEQUENCE IN number Default hr_api.g_number
242: ,P_GENERATE_DB_ITEMS_FLAG IN varchar2 Default hr_api.g_varchar2
243: ,P_HOT_DEFAULT_FLAG IN varchar2 Default hr_api.g_varchar2
244: ,P_MANDATORY_FLAG IN varchar2 Default hr_api.g_varchar2
245: ,P_DEFAULT_VALUE IN varchar2 Default hr_api.g_varchar2
246: ,P_MAX_VALUE IN varchar2 Default hr_api.g_varchar2
239: ,P_FORMULA_ID IN number Default hr_api.g_number
240: ,P_VALUE_SET_ID IN number Default hr_api.g_number
241: ,P_DISPLAY_SEQUENCE IN number Default hr_api.g_number
242: ,P_GENERATE_DB_ITEMS_FLAG IN varchar2 Default hr_api.g_varchar2
243: ,P_HOT_DEFAULT_FLAG IN varchar2 Default hr_api.g_varchar2
244: ,P_MANDATORY_FLAG IN varchar2 Default hr_api.g_varchar2
245: ,P_DEFAULT_VALUE IN varchar2 Default hr_api.g_varchar2
246: ,P_MAX_VALUE IN varchar2 Default hr_api.g_varchar2
247: ,P_MIN_VALUE IN varchar2 Default hr_api.g_varchar2
240: ,P_VALUE_SET_ID IN number Default hr_api.g_number
241: ,P_DISPLAY_SEQUENCE IN number Default hr_api.g_number
242: ,P_GENERATE_DB_ITEMS_FLAG IN varchar2 Default hr_api.g_varchar2
243: ,P_HOT_DEFAULT_FLAG IN varchar2 Default hr_api.g_varchar2
244: ,P_MANDATORY_FLAG IN varchar2 Default hr_api.g_varchar2
245: ,P_DEFAULT_VALUE IN varchar2 Default hr_api.g_varchar2
246: ,P_MAX_VALUE IN varchar2 Default hr_api.g_varchar2
247: ,P_MIN_VALUE IN varchar2 Default hr_api.g_varchar2
248: ,P_WARNING_OR_ERROR IN varchar2 Default hr_api.g_varchar2
241: ,P_DISPLAY_SEQUENCE IN number Default hr_api.g_number
242: ,P_GENERATE_DB_ITEMS_FLAG IN varchar2 Default hr_api.g_varchar2
243: ,P_HOT_DEFAULT_FLAG IN varchar2 Default hr_api.g_varchar2
244: ,P_MANDATORY_FLAG IN varchar2 Default hr_api.g_varchar2
245: ,P_DEFAULT_VALUE IN varchar2 Default hr_api.g_varchar2
246: ,P_MAX_VALUE IN varchar2 Default hr_api.g_varchar2
247: ,P_MIN_VALUE IN varchar2 Default hr_api.g_varchar2
248: ,P_WARNING_OR_ERROR IN varchar2 Default hr_api.g_varchar2
249: ,P_EFFECTIVE_START_DATE OUT NOCOPY date
242: ,P_GENERATE_DB_ITEMS_FLAG IN varchar2 Default hr_api.g_varchar2
243: ,P_HOT_DEFAULT_FLAG IN varchar2 Default hr_api.g_varchar2
244: ,P_MANDATORY_FLAG IN varchar2 Default hr_api.g_varchar2
245: ,P_DEFAULT_VALUE IN varchar2 Default hr_api.g_varchar2
246: ,P_MAX_VALUE IN varchar2 Default hr_api.g_varchar2
247: ,P_MIN_VALUE IN varchar2 Default hr_api.g_varchar2
248: ,P_WARNING_OR_ERROR IN varchar2 Default hr_api.g_varchar2
249: ,P_EFFECTIVE_START_DATE OUT NOCOPY date
250: ,P_EFFECTIVE_END_DATE OUT NOCOPY date
243: ,P_HOT_DEFAULT_FLAG IN varchar2 Default hr_api.g_varchar2
244: ,P_MANDATORY_FLAG IN varchar2 Default hr_api.g_varchar2
245: ,P_DEFAULT_VALUE IN varchar2 Default hr_api.g_varchar2
246: ,P_MAX_VALUE IN varchar2 Default hr_api.g_varchar2
247: ,P_MIN_VALUE IN varchar2 Default hr_api.g_varchar2
248: ,P_WARNING_OR_ERROR IN varchar2 Default hr_api.g_varchar2
249: ,P_EFFECTIVE_START_DATE OUT NOCOPY date
250: ,P_EFFECTIVE_END_DATE OUT NOCOPY date
251: ,P_DEFAULT_VAL_WARNING OUT NOCOPY boolean
244: ,P_MANDATORY_FLAG IN varchar2 Default hr_api.g_varchar2
245: ,P_DEFAULT_VALUE IN varchar2 Default hr_api.g_varchar2
246: ,P_MAX_VALUE IN varchar2 Default hr_api.g_varchar2
247: ,P_MIN_VALUE IN varchar2 Default hr_api.g_varchar2
248: ,P_WARNING_OR_ERROR IN varchar2 Default hr_api.g_varchar2
249: ,P_EFFECTIVE_START_DATE OUT NOCOPY date
250: ,P_EFFECTIVE_END_DATE OUT NOCOPY date
251: ,P_DEFAULT_VAL_WARNING OUT NOCOPY boolean
252: ,P_MIN_MAX_WARNING OUT NOCOPY boolean
302: ,P_MIN_VALUE
303: ,P_WARNING_OR_ERROR
304: );
305: exception
306: when hr_api.cannot_find_prog_unit then
307: hr_api.cannot_find_prog_unit_error
308: (p_module_name => 'UPDATE_INPUT_VALUE'
309: ,p_hook_type => 'BP'
310: );
303: ,P_WARNING_OR_ERROR
304: );
305: exception
306: when hr_api.cannot_find_prog_unit then
307: hr_api.cannot_find_prog_unit_error
308: (p_module_name => 'UPDATE_INPUT_VALUE'
309: ,p_hook_type => 'BP'
310: );
311: end;
385: ,P_ASSIGNMENT_ID_WARNING
386: ,P_FORMULA_MESSAGE
387: );
388: exception
389: when hr_api.cannot_find_prog_unit then
390: hr_api.cannot_find_prog_unit_error
391: (p_module_name => 'UPDATE_INPUT_VALUE'
392: ,p_hook_type => 'AP'
393: );
386: ,P_FORMULA_MESSAGE
387: );
388: exception
389: when hr_api.cannot_find_prog_unit then
390: hr_api.cannot_find_prog_unit_error
391: (p_module_name => 'UPDATE_INPUT_VALUE'
392: ,p_hook_type => 'AP'
393: );
394: end;
395: --
396: -- When in validation only mode raise the Validate_Enabled exception
397: --
398: if p_validate then
399: raise hr_api.validate_enabled;
400: end if;
401: --
402: -- Set all output arguments
403: --
411: p_formula_message := null;
412: --
413: hr_utility.set_location(' Leaving:'||l_proc, 70);
414: exception
415: when hr_api.validate_enabled then
416: --
417: -- As the Validate_Enabled exception has been raised
418: -- we must rollback to the savepoint
419: --
472: ,P_INPUT_VALUE_ID
473: ,P_OBJECT_VERSION_NUMBER
474: );
475: exception
476: when hr_api.cannot_find_prog_unit then
477: hr_api.cannot_find_prog_unit_error
478: (p_module_name => 'DELETE_INPUT_VALUE'
479: ,p_hook_type => 'BP'
480: );
473: ,P_OBJECT_VERSION_NUMBER
474: );
475: exception
476: when hr_api.cannot_find_prog_unit then
477: hr_api.cannot_find_prog_unit_error
478: (p_module_name => 'DELETE_INPUT_VALUE'
479: ,p_hook_type => 'BP'
480: );
481: end;
516: ,P_EFFECTIVE_END_DATE
517: ,p_balance_feeds_warning
518: );
519: exception
520: when hr_api.cannot_find_prog_unit then
521: hr_api.cannot_find_prog_unit_error
522: (p_module_name => 'DELETE_INPUT_VALUE'
523: ,p_hook_type => 'AP'
524: );
517: ,p_balance_feeds_warning
518: );
519: exception
520: when hr_api.cannot_find_prog_unit then
521: hr_api.cannot_find_prog_unit_error
522: (p_module_name => 'DELETE_INPUT_VALUE'
523: ,p_hook_type => 'AP'
524: );
525: end;
526: --
527: -- When in validation only mode raise the Validate_Enabled exception
528: --
529: if p_validate then
530: raise hr_api.validate_enabled;
531: end if;
532: --
533: -- Set all output arguments
534: --
535: p_object_version_number := p_object_version_number;
536: --
537: hr_utility.set_location(' Leaving:'||l_proc, 70);
538: exception
539: when hr_api.validate_enabled then
540: --
541: -- As the Validate_Enabled exception has been raised
542: -- we must rollback to the savepoint
543: --