DBA Data[Home] [Help]

APPS.PQH_DE_VLDVER_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |---------------------------< delete_vldtn_vern >--------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE delete_vldtn_vern
12: (p_validate in number default hr_api.g_false_num
13: ,p_wrkplc_vldtn_ver_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_vldtn_vern >--------------------------|
104: -- ----------------------------------------------------------------------------
105: PROCEDURE insert_vldtn_vern
106: (p_validate in number default hr_api.g_false_num
107: ,p_effective_date in date
108: ,p_business_group_id in number
109: ,p_wrkplc_vldtn_id in number
110: ,p_version_number in number default NULL

Line 152: hr_api.constant_to_boolean

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

Line 239: (p_validate in number default hr_api.g_false_num

235: -- ----------------------------------------------------------------------------
236: -- |---------------------------< update_vldtn_vern >--------------------------|
237: -- ----------------------------------------------------------------------------
238: PROCEDURE update_vldtn_vern
239: (p_validate in number default hr_api.g_false_num
240: ,p_effective_date in date
241: ,p_business_group_id in number
242: ,p_wrkplc_vldtn_id in number default hr_api.g_number
243: ,p_version_number in number default hr_api.g_number

Line 242: ,p_wrkplc_vldtn_id in number default hr_api.g_number

238: PROCEDURE update_vldtn_vern
239: (p_validate in number default hr_api.g_false_num
240: ,p_effective_date in date
241: ,p_business_group_id in number
242: ,p_wrkplc_vldtn_id in number default hr_api.g_number
243: ,p_version_number in number default hr_api.g_number
244: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
245: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2

Line 243: ,p_version_number in number default hr_api.g_number

239: (p_validate in number default hr_api.g_false_num
240: ,p_effective_date in date
241: ,p_business_group_id in number
242: ,p_wrkplc_vldtn_id in number default hr_api.g_number
243: ,p_version_number in number default hr_api.g_number
244: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
245: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
247: ,p_job_group_id in number default hr_api.g_number

Line 244: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2

240: ,p_effective_date in date
241: ,p_business_group_id in number
242: ,p_wrkplc_vldtn_id in number default hr_api.g_number
243: ,p_version_number in number default hr_api.g_number
244: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
245: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
247: ,p_job_group_id in number default hr_api.g_number
248: ,p_remuneration_job_id in number default hr_api.g_number

Line 245: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2

241: ,p_business_group_id in number
242: ,p_wrkplc_vldtn_id in number default hr_api.g_number
243: ,p_version_number in number default hr_api.g_number
244: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
245: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
247: ,p_job_group_id in number default hr_api.g_number
248: ,p_remuneration_job_id in number default hr_api.g_number
249: ,p_derived_grade_id in number default hr_api.g_number

Line 246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2

242: ,p_wrkplc_vldtn_id in number default hr_api.g_number
243: ,p_version_number in number default hr_api.g_number
244: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
245: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
247: ,p_job_group_id in number default hr_api.g_number
248: ,p_remuneration_job_id in number default hr_api.g_number
249: ,p_derived_grade_id in number default hr_api.g_number
250: ,p_derived_case_group_id in number default hr_api.g_number

Line 247: ,p_job_group_id in number default hr_api.g_number

243: ,p_version_number in number default hr_api.g_number
244: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
245: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
247: ,p_job_group_id in number default hr_api.g_number
248: ,p_remuneration_job_id in number default hr_api.g_number
249: ,p_derived_grade_id in number default hr_api.g_number
250: ,p_derived_case_group_id in number default hr_api.g_number
251: ,p_derived_subcasgrp_id in number default hr_api.g_number

Line 248: ,p_remuneration_job_id in number default hr_api.g_number

244: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
245: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
247: ,p_job_group_id in number default hr_api.g_number
248: ,p_remuneration_job_id in number default hr_api.g_number
249: ,p_derived_grade_id in number default hr_api.g_number
250: ,p_derived_case_group_id in number default hr_api.g_number
251: ,p_derived_subcasgrp_id in number default hr_api.g_number
252: ,p_user_enterable_grade_id in number default hr_api.g_number

Line 249: ,p_derived_grade_id in number default hr_api.g_number

245: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
247: ,p_job_group_id in number default hr_api.g_number
248: ,p_remuneration_job_id in number default hr_api.g_number
249: ,p_derived_grade_id in number default hr_api.g_number
250: ,p_derived_case_group_id in number default hr_api.g_number
251: ,p_derived_subcasgrp_id in number default hr_api.g_number
252: ,p_user_enterable_grade_id in number default hr_api.g_number
253: ,p_user_enterable_case_group_id in number default hr_api.g_number

Line 250: ,p_derived_case_group_id in number default hr_api.g_number

246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
247: ,p_job_group_id in number default hr_api.g_number
248: ,p_remuneration_job_id in number default hr_api.g_number
249: ,p_derived_grade_id in number default hr_api.g_number
250: ,p_derived_case_group_id in number default hr_api.g_number
251: ,p_derived_subcasgrp_id in number default hr_api.g_number
252: ,p_user_enterable_grade_id in number default hr_api.g_number
253: ,p_user_enterable_case_group_id in number default hr_api.g_number
254: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number

Line 251: ,p_derived_subcasgrp_id in number default hr_api.g_number

247: ,p_job_group_id in number default hr_api.g_number
248: ,p_remuneration_job_id in number default hr_api.g_number
249: ,p_derived_grade_id in number default hr_api.g_number
250: ,p_derived_case_group_id in number default hr_api.g_number
251: ,p_derived_subcasgrp_id in number default hr_api.g_number
252: ,p_user_enterable_grade_id in number default hr_api.g_number
253: ,p_user_enterable_case_group_id in number default hr_api.g_number
254: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number
255: ,p_freeze in varchar2 default hr_api.g_varchar2

Line 252: ,p_user_enterable_grade_id in number default hr_api.g_number

248: ,p_remuneration_job_id in number default hr_api.g_number
249: ,p_derived_grade_id in number default hr_api.g_number
250: ,p_derived_case_group_id in number default hr_api.g_number
251: ,p_derived_subcasgrp_id in number default hr_api.g_number
252: ,p_user_enterable_grade_id in number default hr_api.g_number
253: ,p_user_enterable_case_group_id in number default hr_api.g_number
254: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number
255: ,p_freeze in varchar2 default hr_api.g_varchar2
256: ,p_wrkplc_vldtn_ver_id in number

Line 253: ,p_user_enterable_case_group_id in number default hr_api.g_number

249: ,p_derived_grade_id in number default hr_api.g_number
250: ,p_derived_case_group_id in number default hr_api.g_number
251: ,p_derived_subcasgrp_id in number default hr_api.g_number
252: ,p_user_enterable_grade_id in number default hr_api.g_number
253: ,p_user_enterable_case_group_id in number default hr_api.g_number
254: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number
255: ,p_freeze in varchar2 default hr_api.g_varchar2
256: ,p_wrkplc_vldtn_ver_id in number
257: ,p_object_version_number in out nocopy number

Line 254: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number

250: ,p_derived_case_group_id in number default hr_api.g_number
251: ,p_derived_subcasgrp_id in number default hr_api.g_number
252: ,p_user_enterable_grade_id in number default hr_api.g_number
253: ,p_user_enterable_case_group_id in number default hr_api.g_number
254: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number
255: ,p_freeze in varchar2 default hr_api.g_varchar2
256: ,p_wrkplc_vldtn_ver_id in number
257: ,p_object_version_number in out nocopy number
258: ,p_return_status out nocopy varchar2

Line 255: ,p_freeze in varchar2 default hr_api.g_varchar2

251: ,p_derived_subcasgrp_id in number default hr_api.g_number
252: ,p_user_enterable_grade_id in number default hr_api.g_number
253: ,p_user_enterable_case_group_id in number default hr_api.g_number
254: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number
255: ,p_freeze in varchar2 default hr_api.g_varchar2
256: ,p_wrkplc_vldtn_ver_id in number
257: ,p_object_version_number in out nocopy number
258: ,p_return_status out nocopy varchar2
259: ) is

Line 287: hr_api.constant_to_boolean

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