DBA Data[Home] [Help]

APPS.PQH_RULE_SETS_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |----------------------------< create_rule_set >---------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_rule_set
12: (p_validate in number default hr_api.g_false_num
13: ,p_business_group_id in number default null
14: ,p_rule_set_id out nocopy number
15: ,p_rule_set_name in varchar2
16: ,p_description in varchar2

Line 24: ,p_language_code in varchar2 default hr_api.userenv_lang

20: ,p_rule_level_cd in varchar2 default null
21: ,p_object_version_number out nocopy number
22: ,p_short_name in varchar2
23: ,p_effective_date in date
24: ,p_language_code in varchar2 default hr_api.userenv_lang
25: ,p_rule_applicability in varchar2
26: ,p_rule_category in varchar2
27: ,p_starting_organization_id in number default null
28: ,p_seeded_rule_flag in varchar2 default 'N'

Line 57: hr_api.constant_to_boolean

53: --
54: -- Convert constant values to their corresponding boolean value
55: --
56: l_validate :=
57: hr_api.constant_to_boolean
58: (p_constant_value => p_validate);
59: --
60: -- Register Surrogate ID or user key values
61: --

Line 140: (p_validate in number default hr_api.g_false_num

136: -- ----------------------------------------------------------------------------
137: -- |----------------------------< delete_rule_set >---------------------------|
138: -- ----------------------------------------------------------------------------
139: PROCEDURE delete_rule_set
140: (p_validate in number default hr_api.g_false_num
141: ,p_rule_set_id in number
142: ,p_object_version_number in number
143: ,p_effective_date in date
144: ,p_return_status out nocopy varchar2

Line 171: hr_api.constant_to_boolean

167: --
168: -- Convert constant values to their corresponding boolean value
169: --
170: l_validate :=
171: hr_api.constant_to_boolean
172: (p_constant_value => p_validate);
173: --
174: -- Register Surrogate ID or user key values
175: --

Line 236: (p_validate in number default hr_api.g_false_num

232: -- ----------------------------------------------------------------------------
233: -- |----------------------------< update_rule_set >---------------------------|
234: -- ----------------------------------------------------------------------------
235: PROCEDURE update_rule_set
236: (p_validate in number default hr_api.g_false_num
237: ,p_business_group_id in number default hr_api.g_number
238: ,p_rule_set_id in number
239: ,p_rule_set_name in varchar2 default hr_api.g_varchar2
240: ,p_description in varchar2 default hr_api.g_varchar2

Line 237: ,p_business_group_id in number default hr_api.g_number

233: -- |----------------------------< update_rule_set >---------------------------|
234: -- ----------------------------------------------------------------------------
235: PROCEDURE update_rule_set
236: (p_validate in number default hr_api.g_false_num
237: ,p_business_group_id in number default hr_api.g_number
238: ,p_rule_set_id in number
239: ,p_rule_set_name in varchar2 default hr_api.g_varchar2
240: ,p_description in varchar2 default hr_api.g_varchar2
241: ,p_organization_structure_id in number default hr_api.g_number

Line 239: ,p_rule_set_name in varchar2 default hr_api.g_varchar2

235: PROCEDURE update_rule_set
236: (p_validate in number default hr_api.g_false_num
237: ,p_business_group_id in number default hr_api.g_number
238: ,p_rule_set_id in number
239: ,p_rule_set_name in varchar2 default hr_api.g_varchar2
240: ,p_description in varchar2 default hr_api.g_varchar2
241: ,p_organization_structure_id in number default hr_api.g_number
242: ,p_organization_id in number default hr_api.g_number
243: ,p_referenced_rule_set_id in number default hr_api.g_number

Line 240: ,p_description in varchar2 default hr_api.g_varchar2

236: (p_validate in number default hr_api.g_false_num
237: ,p_business_group_id in number default hr_api.g_number
238: ,p_rule_set_id in number
239: ,p_rule_set_name in varchar2 default hr_api.g_varchar2
240: ,p_description in varchar2 default hr_api.g_varchar2
241: ,p_organization_structure_id in number default hr_api.g_number
242: ,p_organization_id in number default hr_api.g_number
243: ,p_referenced_rule_set_id in number default hr_api.g_number
244: ,p_rule_level_cd in varchar2 default hr_api.g_varchar2

Line 241: ,p_organization_structure_id in number default hr_api.g_number

237: ,p_business_group_id in number default hr_api.g_number
238: ,p_rule_set_id in number
239: ,p_rule_set_name in varchar2 default hr_api.g_varchar2
240: ,p_description in varchar2 default hr_api.g_varchar2
241: ,p_organization_structure_id in number default hr_api.g_number
242: ,p_organization_id in number default hr_api.g_number
243: ,p_referenced_rule_set_id in number default hr_api.g_number
244: ,p_rule_level_cd in varchar2 default hr_api.g_varchar2
245: ,p_object_version_number in out nocopy number

Line 242: ,p_organization_id in number default hr_api.g_number

238: ,p_rule_set_id in number
239: ,p_rule_set_name in varchar2 default hr_api.g_varchar2
240: ,p_description in varchar2 default hr_api.g_varchar2
241: ,p_organization_structure_id in number default hr_api.g_number
242: ,p_organization_id in number default hr_api.g_number
243: ,p_referenced_rule_set_id in number default hr_api.g_number
244: ,p_rule_level_cd in varchar2 default hr_api.g_varchar2
245: ,p_object_version_number in out nocopy number
246: ,p_short_name in varchar2 default hr_api.g_varchar2

Line 243: ,p_referenced_rule_set_id in number default hr_api.g_number

239: ,p_rule_set_name in varchar2 default hr_api.g_varchar2
240: ,p_description in varchar2 default hr_api.g_varchar2
241: ,p_organization_structure_id in number default hr_api.g_number
242: ,p_organization_id in number default hr_api.g_number
243: ,p_referenced_rule_set_id in number default hr_api.g_number
244: ,p_rule_level_cd in varchar2 default hr_api.g_varchar2
245: ,p_object_version_number in out nocopy number
246: ,p_short_name in varchar2 default hr_api.g_varchar2
247: ,p_effective_date in date

Line 244: ,p_rule_level_cd in varchar2 default hr_api.g_varchar2

240: ,p_description in varchar2 default hr_api.g_varchar2
241: ,p_organization_structure_id in number default hr_api.g_number
242: ,p_organization_id in number default hr_api.g_number
243: ,p_referenced_rule_set_id in number default hr_api.g_number
244: ,p_rule_level_cd in varchar2 default hr_api.g_varchar2
245: ,p_object_version_number in out nocopy number
246: ,p_short_name in varchar2 default hr_api.g_varchar2
247: ,p_effective_date in date
248: ,p_language_code in varchar2 default hr_api.userenv_lang

Line 246: ,p_short_name in varchar2 default hr_api.g_varchar2

242: ,p_organization_id in number default hr_api.g_number
243: ,p_referenced_rule_set_id in number default hr_api.g_number
244: ,p_rule_level_cd in varchar2 default hr_api.g_varchar2
245: ,p_object_version_number in out nocopy number
246: ,p_short_name in varchar2 default hr_api.g_varchar2
247: ,p_effective_date in date
248: ,p_language_code in varchar2 default hr_api.userenv_lang
249: ,p_rule_applicability in varchar2 default hr_api.g_varchar2
250: ,p_rule_category in varchar2 default hr_api.g_varchar2

Line 248: ,p_language_code in varchar2 default hr_api.userenv_lang

244: ,p_rule_level_cd in varchar2 default hr_api.g_varchar2
245: ,p_object_version_number in out nocopy number
246: ,p_short_name in varchar2 default hr_api.g_varchar2
247: ,p_effective_date in date
248: ,p_language_code in varchar2 default hr_api.userenv_lang
249: ,p_rule_applicability in varchar2 default hr_api.g_varchar2
250: ,p_rule_category in varchar2 default hr_api.g_varchar2
251: ,p_starting_organization_id in number default hr_api.g_number
252: ,p_seeded_rule_flag in varchar2 default hr_api.g_varchar2

Line 249: ,p_rule_applicability in varchar2 default hr_api.g_varchar2

245: ,p_object_version_number in out nocopy number
246: ,p_short_name in varchar2 default hr_api.g_varchar2
247: ,p_effective_date in date
248: ,p_language_code in varchar2 default hr_api.userenv_lang
249: ,p_rule_applicability in varchar2 default hr_api.g_varchar2
250: ,p_rule_category in varchar2 default hr_api.g_varchar2
251: ,p_starting_organization_id in number default hr_api.g_number
252: ,p_seeded_rule_flag in varchar2 default hr_api.g_varchar2
253: ,p_status in varchar2 default hr_api.g_varchar2

Line 250: ,p_rule_category in varchar2 default hr_api.g_varchar2

246: ,p_short_name in varchar2 default hr_api.g_varchar2
247: ,p_effective_date in date
248: ,p_language_code in varchar2 default hr_api.userenv_lang
249: ,p_rule_applicability in varchar2 default hr_api.g_varchar2
250: ,p_rule_category in varchar2 default hr_api.g_varchar2
251: ,p_starting_organization_id in number default hr_api.g_number
252: ,p_seeded_rule_flag in varchar2 default hr_api.g_varchar2
253: ,p_status in varchar2 default hr_api.g_varchar2
254: ,p_return_status out nocopy varchar2

Line 251: ,p_starting_organization_id in number default hr_api.g_number

247: ,p_effective_date in date
248: ,p_language_code in varchar2 default hr_api.userenv_lang
249: ,p_rule_applicability in varchar2 default hr_api.g_varchar2
250: ,p_rule_category in varchar2 default hr_api.g_varchar2
251: ,p_starting_organization_id in number default hr_api.g_number
252: ,p_seeded_rule_flag in varchar2 default hr_api.g_varchar2
253: ,p_status in varchar2 default hr_api.g_varchar2
254: ,p_return_status out nocopy varchar2
255: ) is

Line 252: ,p_seeded_rule_flag in varchar2 default hr_api.g_varchar2

248: ,p_language_code in varchar2 default hr_api.userenv_lang
249: ,p_rule_applicability in varchar2 default hr_api.g_varchar2
250: ,p_rule_category in varchar2 default hr_api.g_varchar2
251: ,p_starting_organization_id in number default hr_api.g_number
252: ,p_seeded_rule_flag in varchar2 default hr_api.g_varchar2
253: ,p_status in varchar2 default hr_api.g_varchar2
254: ,p_return_status out nocopy varchar2
255: ) is
256: --

Line 253: ,p_status in varchar2 default hr_api.g_varchar2

249: ,p_rule_applicability in varchar2 default hr_api.g_varchar2
250: ,p_rule_category in varchar2 default hr_api.g_varchar2
251: ,p_starting_organization_id in number default hr_api.g_number
252: ,p_seeded_rule_flag in varchar2 default hr_api.g_varchar2
253: ,p_status in varchar2 default hr_api.g_varchar2
254: ,p_return_status out nocopy varchar2
255: ) is
256: --
257: -- Variables for API Boolean parameters

Line 283: hr_api.constant_to_boolean

279: --
280: -- Convert constant values to their corresponding boolean value
281: --
282: l_validate :=
283: hr_api.constant_to_boolean
284: (p_constant_value => p_validate);
285: --
286: -- Register Surrogate ID or user key values
287: --