DBA Data[Home] [Help]

APPS.PQH_DE_LEVEL_CODES_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< delete_level_codes >--------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE delete_level_codes
12: (p_validate in number default hr_api.g_false_num
13: ,p_level_code_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_level_codes >--------------------------|
104: -- ----------------------------------------------------------------------------
105: PROCEDURE insert_level_codes
106: (p_validate in number default hr_api.g_false_num
107: ,p_effective_date in date
108: ,p_level_number_id in number
109: ,p_level_code in varchar2
110: ,p_description in varchar2

Line 141: hr_api.constant_to_boolean

137: --
138: -- Convert constant values to their corresponding boolean value
139: --
140: l_validate :=
141: hr_api.constant_to_boolean
142: (p_constant_value => p_validate);
143: --
144: -- Register Surrogate ID or user key values
145: --

Line 218: (p_validate in number default hr_api.g_false_num

214: -- ----------------------------------------------------------------------------
215: -- |--------------------------< update_level_codes >--------------------------|
216: -- ----------------------------------------------------------------------------
217: PROCEDURE update_level_codes
218: (p_validate in number default hr_api.g_false_num
219: ,p_effective_date in date
220: ,p_level_code_id in number
221: ,p_object_version_number in out nocopy number
222: ,p_level_number_id in number default hr_api.g_number

Line 222: ,p_level_number_id in number default hr_api.g_number

218: (p_validate in number default hr_api.g_false_num
219: ,p_effective_date in date
220: ,p_level_code_id in number
221: ,p_object_version_number in out nocopy number
222: ,p_level_number_id in number default hr_api.g_number
223: ,p_level_code in varchar2 default hr_api.g_varchar2
224: ,p_description in varchar2 default hr_api.g_varchar2
225: ,p_gradual_value_number in number default hr_api.g_number
226: ,p_return_status out nocopy varchar2

Line 223: ,p_level_code in varchar2 default hr_api.g_varchar2

219: ,p_effective_date in date
220: ,p_level_code_id in number
221: ,p_object_version_number in out nocopy number
222: ,p_level_number_id in number default hr_api.g_number
223: ,p_level_code in varchar2 default hr_api.g_varchar2
224: ,p_description in varchar2 default hr_api.g_varchar2
225: ,p_gradual_value_number in number default hr_api.g_number
226: ,p_return_status out nocopy varchar2
227: ) is

Line 224: ,p_description in varchar2 default hr_api.g_varchar2

220: ,p_level_code_id in number
221: ,p_object_version_number in out nocopy number
222: ,p_level_number_id in number default hr_api.g_number
223: ,p_level_code in varchar2 default hr_api.g_varchar2
224: ,p_description in varchar2 default hr_api.g_varchar2
225: ,p_gradual_value_number in number default hr_api.g_number
226: ,p_return_status out nocopy varchar2
227: ) is
228: --

Line 225: ,p_gradual_value_number in number default hr_api.g_number

221: ,p_object_version_number in out nocopy number
222: ,p_level_number_id in number default hr_api.g_number
223: ,p_level_code in varchar2 default hr_api.g_varchar2
224: ,p_description in varchar2 default hr_api.g_varchar2
225: ,p_gradual_value_number in number default hr_api.g_number
226: ,p_return_status out nocopy varchar2
227: ) is
228: --
229: -- Variables for API Boolean parameters

Line 255: hr_api.constant_to_boolean

251: --
252: -- Convert constant values to their corresponding boolean value
253: --
254: l_validate :=
255: hr_api.constant_to_boolean
256: (p_constant_value => p_validate);
257: --
258: -- Register Surrogate ID or user key values
259: --