DBA Data[Home] [Help]

APPS.PQH_DE_CASE_GROUPS_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< delete_case_groups >--------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE delete_case_groups
12: (p_validate in number default hr_api.g_false_num
13: ,p_case_group_id in number
14: ,p_object_version_number in number
15: ,p_return_status out nocopy varchar2
16: ) is

Line 42: hr_api.constant_to_boolean

38: --
39: -- Convert constant values to their corresponding boolean value
40: --
41: l_validate :=
42: hr_api.constant_to_boolean
43: (p_constant_value => p_validate);
44: --
45: -- Register Surrogate ID or user key values
46: --

Line 106: (p_validate in number default hr_api.g_false_num

102: -- ----------------------------------------------------------------------------
103: -- |--------------------------< insert_case_groups >--------------------------|
104: -- ----------------------------------------------------------------------------
105: PROCEDURE insert_case_groups
106: (p_validate in number default hr_api.g_false_num
107: ,p_effective_date in date
108: ,p_case_group_number in varchar2
109: ,p_description in varchar2
110: ,p_advanced_pay_grade in number

Line 151: hr_api.constant_to_boolean

147: --
148: -- Convert constant values to their corresponding boolean value
149: --
150: l_validate :=
151: hr_api.constant_to_boolean
152: (p_constant_value => p_validate);
153: --
154: -- Register Surrogate ID or user key values
155: --

Line 233: (p_validate in number default hr_api.g_false_num

229: -- ----------------------------------------------------------------------------
230: -- |--------------------------< update_case_groups >--------------------------|
231: -- ----------------------------------------------------------------------------
232: PROCEDURE update_case_groups
233: (p_validate in number default hr_api.g_false_num
234: ,p_effective_date in date
235: ,p_case_group_id in number
236: ,p_object_version_number in out nocopy number
237: ,p_case_group_number in varchar2 default hr_api.g_varchar2

Line 237: ,p_case_group_number in varchar2 default hr_api.g_varchar2

233: (p_validate in number default hr_api.g_false_num
234: ,p_effective_date in date
235: ,p_case_group_id in number
236: ,p_object_version_number in out nocopy number
237: ,p_case_group_number in varchar2 default hr_api.g_varchar2
238: ,p_description in varchar2 default hr_api.g_varchar2
239: ,p_advanced_pay_grade in number default hr_api.g_number
240: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
241: ,p_period_of_prob_advmnt in number default hr_api.g_number

Line 238: ,p_description in varchar2 default hr_api.g_varchar2

234: ,p_effective_date in date
235: ,p_case_group_id in number
236: ,p_object_version_number in out nocopy number
237: ,p_case_group_number in varchar2 default hr_api.g_varchar2
238: ,p_description in varchar2 default hr_api.g_varchar2
239: ,p_advanced_pay_grade in number default hr_api.g_number
240: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
241: ,p_period_of_prob_advmnt in number default hr_api.g_number
242: ,p_period_of_time_advmnt in number default hr_api.g_number

Line 239: ,p_advanced_pay_grade in number default hr_api.g_number

235: ,p_case_group_id in number
236: ,p_object_version_number in out nocopy number
237: ,p_case_group_number in varchar2 default hr_api.g_varchar2
238: ,p_description in varchar2 default hr_api.g_varchar2
239: ,p_advanced_pay_grade in number default hr_api.g_number
240: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
241: ,p_period_of_prob_advmnt in number default hr_api.g_number
242: ,p_period_of_time_advmnt in number default hr_api.g_number
243: ,p_advancement_to in number default hr_api.g_number

Line 240: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2

236: ,p_object_version_number in out nocopy number
237: ,p_case_group_number in varchar2 default hr_api.g_varchar2
238: ,p_description in varchar2 default hr_api.g_varchar2
239: ,p_advanced_pay_grade in number default hr_api.g_number
240: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
241: ,p_period_of_prob_advmnt in number default hr_api.g_number
242: ,p_period_of_time_advmnt in number default hr_api.g_number
243: ,p_advancement_to in number default hr_api.g_number
244: ,p_advancement_additional_pyt in number default hr_api.g_number

Line 241: ,p_period_of_prob_advmnt in number default hr_api.g_number

237: ,p_case_group_number in varchar2 default hr_api.g_varchar2
238: ,p_description in varchar2 default hr_api.g_varchar2
239: ,p_advanced_pay_grade in number default hr_api.g_number
240: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
241: ,p_period_of_prob_advmnt in number default hr_api.g_number
242: ,p_period_of_time_advmnt in number default hr_api.g_number
243: ,p_advancement_to in number default hr_api.g_number
244: ,p_advancement_additional_pyt in number default hr_api.g_number
245: ,p_time_advanced_pay_grade in number default hr_api.g_number

Line 242: ,p_period_of_time_advmnt in number default hr_api.g_number

238: ,p_description in varchar2 default hr_api.g_varchar2
239: ,p_advanced_pay_grade in number default hr_api.g_number
240: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
241: ,p_period_of_prob_advmnt in number default hr_api.g_number
242: ,p_period_of_time_advmnt in number default hr_api.g_number
243: ,p_advancement_to in number default hr_api.g_number
244: ,p_advancement_additional_pyt in number default hr_api.g_number
245: ,p_time_advanced_pay_grade in number default hr_api.g_number
246: ,p_time_advancement_to in number default hr_api.g_number

Line 243: ,p_advancement_to in number default hr_api.g_number

239: ,p_advanced_pay_grade in number default hr_api.g_number
240: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
241: ,p_period_of_prob_advmnt in number default hr_api.g_number
242: ,p_period_of_time_advmnt in number default hr_api.g_number
243: ,p_advancement_to in number default hr_api.g_number
244: ,p_advancement_additional_pyt in number default hr_api.g_number
245: ,p_time_advanced_pay_grade in number default hr_api.g_number
246: ,p_time_advancement_to in number default hr_api.g_number
247: ,p_business_group_id in number default hr_api.g_number

Line 244: ,p_advancement_additional_pyt in number default hr_api.g_number

240: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
241: ,p_period_of_prob_advmnt in number default hr_api.g_number
242: ,p_period_of_time_advmnt in number default hr_api.g_number
243: ,p_advancement_to in number default hr_api.g_number
244: ,p_advancement_additional_pyt in number default hr_api.g_number
245: ,p_time_advanced_pay_grade in number default hr_api.g_number
246: ,p_time_advancement_to in number default hr_api.g_number
247: ,p_business_group_id in number default hr_api.g_number
248: ,p_time_advn_units in varchar2 default hr_api.g_varchar2

Line 245: ,p_time_advanced_pay_grade in number default hr_api.g_number

241: ,p_period_of_prob_advmnt in number default hr_api.g_number
242: ,p_period_of_time_advmnt in number default hr_api.g_number
243: ,p_advancement_to in number default hr_api.g_number
244: ,p_advancement_additional_pyt in number default hr_api.g_number
245: ,p_time_advanced_pay_grade in number default hr_api.g_number
246: ,p_time_advancement_to in number default hr_api.g_number
247: ,p_business_group_id in number default hr_api.g_number
248: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
249: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2

Line 246: ,p_time_advancement_to in number default hr_api.g_number

242: ,p_period_of_time_advmnt in number default hr_api.g_number
243: ,p_advancement_to in number default hr_api.g_number
244: ,p_advancement_additional_pyt in number default hr_api.g_number
245: ,p_time_advanced_pay_grade in number default hr_api.g_number
246: ,p_time_advancement_to in number default hr_api.g_number
247: ,p_business_group_id in number default hr_api.g_number
248: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
249: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
250: ,p_SUB_CSGRP_DESCRIPTION in varchar2 default hr_api.g_varchar2

Line 247: ,p_business_group_id in number default hr_api.g_number

243: ,p_advancement_to in number default hr_api.g_number
244: ,p_advancement_additional_pyt in number default hr_api.g_number
245: ,p_time_advanced_pay_grade in number default hr_api.g_number
246: ,p_time_advancement_to in number default hr_api.g_number
247: ,p_business_group_id in number default hr_api.g_number
248: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
249: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
250: ,p_SUB_CSGRP_DESCRIPTION in varchar2 default hr_api.g_varchar2
251: ,p_return_status out nocopy varchar2

Line 248: ,p_time_advn_units in varchar2 default hr_api.g_varchar2

244: ,p_advancement_additional_pyt in number default hr_api.g_number
245: ,p_time_advanced_pay_grade in number default hr_api.g_number
246: ,p_time_advancement_to in number default hr_api.g_number
247: ,p_business_group_id in number default hr_api.g_number
248: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
249: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
250: ,p_SUB_CSGRP_DESCRIPTION in varchar2 default hr_api.g_varchar2
251: ,p_return_status out nocopy varchar2
252: ) is

Line 249: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2

245: ,p_time_advanced_pay_grade in number default hr_api.g_number
246: ,p_time_advancement_to in number default hr_api.g_number
247: ,p_business_group_id in number default hr_api.g_number
248: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
249: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
250: ,p_SUB_CSGRP_DESCRIPTION in varchar2 default hr_api.g_varchar2
251: ,p_return_status out nocopy varchar2
252: ) is
253: --

Line 250: ,p_SUB_CSGRP_DESCRIPTION in varchar2 default hr_api.g_varchar2

246: ,p_time_advancement_to in number default hr_api.g_number
247: ,p_business_group_id in number default hr_api.g_number
248: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
249: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
250: ,p_SUB_CSGRP_DESCRIPTION in varchar2 default hr_api.g_varchar2
251: ,p_return_status out nocopy varchar2
252: ) is
253: --
254: -- Variables for API Boolean parameters

Line 281: hr_api.constant_to_boolean

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