11: -- ----------------------------------------------------------------------------
12: -- |----------------------< create_stat_situation_rule >----------------------|
13: -- ----------------------------------------------------------------------------
14: PROCEDURE create_stat_situation_rule
15: (p_validate in number default hr_api.g_false_num
16: ,p_effective_date in date default null
17: ,p_statutory_situation_id in number
18: ,p_processing_sequence in number
19: ,p_txn_category_attribute_id in number
57: --
58: -- Convert constant values to their corresponding boolean value
59: --
60: l_validate :=
61: hr_api.constant_to_boolean
62: (p_constant_value => p_validate);
63: --
64: -- Register Surrogate ID or user key values
65: --
161: -- ----------------------------------------------------------------------------
162: -- |----------------------< delete_stat_situation_rule >----------------------|
163: -- ----------------------------------------------------------------------------
164: PROCEDURE delete_stat_situation_rule
165: (p_validate in number default hr_api.g_false_num
166: ,p_stat_situation_rule_id in number
167: ,p_object_version_number in number
168: ,p_return_status out nocopy varchar2
169: ) is
197: --
198: -- Convert constant values to their corresponding boolean value
199: --
200: l_validate :=
201: hr_api.constant_to_boolean
202: (p_constant_value => p_validate);
203: --
204: -- Register Surrogate ID or user key values
205: --
284: -- ----------------------------------------------------------------------------
285: -- |----------------------< update_stat_situation_rule >----------------------|
286: -- ----------------------------------------------------------------------------
287: PROCEDURE update_stat_situation_rule
288: (p_validate in number default hr_api.g_false_num
289: ,p_effective_date in date default hr_api.g_date
290: ,p_stat_situation_rule_id in number
291: ,p_object_version_number in out nocopy number
292: ,p_statutory_situation_id in number default hr_api.g_number
285: -- |----------------------< update_stat_situation_rule >----------------------|
286: -- ----------------------------------------------------------------------------
287: PROCEDURE update_stat_situation_rule
288: (p_validate in number default hr_api.g_false_num
289: ,p_effective_date in date default hr_api.g_date
290: ,p_stat_situation_rule_id in number
291: ,p_object_version_number in out nocopy number
292: ,p_statutory_situation_id in number default hr_api.g_number
293: ,p_processing_sequence in number default hr_api.g_number
288: (p_validate in number default hr_api.g_false_num
289: ,p_effective_date in date default hr_api.g_date
290: ,p_stat_situation_rule_id in number
291: ,p_object_version_number in out nocopy number
292: ,p_statutory_situation_id in number default hr_api.g_number
293: ,p_processing_sequence in number default hr_api.g_number
294: ,p_txn_category_attribute_id in number default hr_api.g_number
295: ,p_from_value in varchar2 default hr_api.g_varchar2
296: ,p_to_value in varchar2 default hr_api.g_varchar2
289: ,p_effective_date in date default hr_api.g_date
290: ,p_stat_situation_rule_id in number
291: ,p_object_version_number in out nocopy number
292: ,p_statutory_situation_id in number default hr_api.g_number
293: ,p_processing_sequence in number default hr_api.g_number
294: ,p_txn_category_attribute_id in number default hr_api.g_number
295: ,p_from_value in varchar2 default hr_api.g_varchar2
296: ,p_to_value in varchar2 default hr_api.g_varchar2
297: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
290: ,p_stat_situation_rule_id in number
291: ,p_object_version_number in out nocopy number
292: ,p_statutory_situation_id in number default hr_api.g_number
293: ,p_processing_sequence in number default hr_api.g_number
294: ,p_txn_category_attribute_id in number default hr_api.g_number
295: ,p_from_value in varchar2 default hr_api.g_varchar2
296: ,p_to_value in varchar2 default hr_api.g_varchar2
297: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
298: ,p_required_flag in varchar2 default hr_api.g_varchar2
291: ,p_object_version_number in out nocopy number
292: ,p_statutory_situation_id in number default hr_api.g_number
293: ,p_processing_sequence in number default hr_api.g_number
294: ,p_txn_category_attribute_id in number default hr_api.g_number
295: ,p_from_value in varchar2 default hr_api.g_varchar2
296: ,p_to_value in varchar2 default hr_api.g_varchar2
297: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
298: ,p_required_flag in varchar2 default hr_api.g_varchar2
299: ,p_exclude_flag in varchar2 default hr_api.g_varchar2
292: ,p_statutory_situation_id in number default hr_api.g_number
293: ,p_processing_sequence in number default hr_api.g_number
294: ,p_txn_category_attribute_id in number default hr_api.g_number
295: ,p_from_value in varchar2 default hr_api.g_varchar2
296: ,p_to_value in varchar2 default hr_api.g_varchar2
297: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
298: ,p_required_flag in varchar2 default hr_api.g_varchar2
299: ,p_exclude_flag in varchar2 default hr_api.g_varchar2
300: ,p_return_status out nocopy varchar2
293: ,p_processing_sequence in number default hr_api.g_number
294: ,p_txn_category_attribute_id in number default hr_api.g_number
295: ,p_from_value in varchar2 default hr_api.g_varchar2
296: ,p_to_value in varchar2 default hr_api.g_varchar2
297: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
298: ,p_required_flag in varchar2 default hr_api.g_varchar2
299: ,p_exclude_flag in varchar2 default hr_api.g_varchar2
300: ,p_return_status out nocopy varchar2
301: ) is
294: ,p_txn_category_attribute_id in number default hr_api.g_number
295: ,p_from_value in varchar2 default hr_api.g_varchar2
296: ,p_to_value in varchar2 default hr_api.g_varchar2
297: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
298: ,p_required_flag in varchar2 default hr_api.g_varchar2
299: ,p_exclude_flag in varchar2 default hr_api.g_varchar2
300: ,p_return_status out nocopy varchar2
301: ) is
302: --
295: ,p_from_value in varchar2 default hr_api.g_varchar2
296: ,p_to_value in varchar2 default hr_api.g_varchar2
297: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
298: ,p_required_flag in varchar2 default hr_api.g_varchar2
299: ,p_exclude_flag in varchar2 default hr_api.g_varchar2
300: ,p_return_status out nocopy varchar2
301: ) is
302: --
303: -- Variables for API Boolean parameters
331: --
332: -- Convert constant values to their corresponding boolean value
333: --
334: l_validate :=
335: hr_api.constant_to_boolean
336: (p_constant_value => p_validate);
337: --
338: -- Register Surrogate ID or user key values
339: --