DBA Data[Home] [Help]

APPS.PQH_FR_STAT_SIT_RULES_SWI dependencies on HR_API

Line 15: (p_validate in number default hr_api.g_false_num

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

Line 61: hr_api.constant_to_boolean

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: --

Line 165: (p_validate in number default hr_api.g_false_num

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

Line 201: hr_api.constant_to_boolean

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: --

Line 288: (p_validate in number default hr_api.g_false_num

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

Line 289: ,p_effective_date in date default hr_api.g_date

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

Line 292: ,p_statutory_situation_id 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

Line 293: ,p_processing_sequence in number default hr_api.g_number

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

Line 294: ,p_txn_category_attribute_id in number default hr_api.g_number

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

Line 295: ,p_from_value 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

Line 296: ,p_to_value 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

Line 297: ,p_enabled_flag in varchar2 default hr_api.g_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

Line 298: ,p_required_flag in varchar2 default hr_api.g_varchar2

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: --

Line 299: ,p_exclude_flag in varchar2 default hr_api.g_varchar2

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

Line 335: hr_api.constant_to_boolean

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: --