1 Package PQH_DE_VLDVER_API as
2 /* $Header: pqverapi.pkh 120.0 2005/05/29 02:53:13 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< <PQH_DE_VLDVER_API> >--------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This API Creates the the Validation Definition for the Workplace Validation Proess
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 --
18 --
19 -- Post Success:
20 --
21 --
22 -- Name Type Description
23 --
24 -- Post Failure:
25 --
26 --
27 -- Access Status:
28 -- Public.
29 --
30 -- {End Of Comments}
31 --
32 procedure Insert_Vldtn_Vern
33 (p_validate in boolean default false
34 ,p_effective_date in date
35 ,p_business_group_id in number
36 ,p_WRKPLC_VLDTN_ID In Number
37 ,P_VERSION_NUMBER In Number Default NULL
38 ,P_REMUNERATION_JOB_DESCRIPTION In VarChar2 Default NULL
39 ,P_TARIFF_CONTRACT_CODE In Varchar2
40 ,P_TARIFF_GROUP_CODE In Varchar2
41 ,P_JOB_GROUP_ID In Number Default NULL
42 ,P_REMUNERATION_JOB_ID In Number Default NULL
43 ,P_DERIVED_GRADE_ID In Number Default NULL
44 ,P_DERIVED_CASE_GROUP_ID In Number Default NULL
45 ,P_DERIVED_SUBCASGRP_ID In Number Default NULL
46 ,P_USER_ENTERABLE_GRADE_ID In Number Default NULL
47 ,P_USER_ENTERABLE_CASE_GROUP_ID In Number Default NULL
48 ,P_USER_ENTERABLE_SUBCASGRP_ID In Number Default NULL
49 ,P_FREEZE In Varchar2 Default NULL
50 ,p_WRKPLC_VLDTN_VER_ID out nocopy Number
51 ,p_object_version_number out nocopy number);
52
53
54 procedure Update_Vldtn_Vern
55 (p_validate in boolean default false
56 ,p_effective_date in date
57 ,p_business_group_id in number
58 ,p_WRKPLC_VLDTN_ID In Number Default hr_api.g_Number
59 ,P_VERSION_NUMBER In Number Default hr_api.g_Number
60 ,P_REMUNERATION_JOB_DESCRIPTION In VarChar2 Default hr_api.g_Varchar2
61 ,P_TARIFF_CONTRACT_CODE In Varchar2 Default hr_api.g_Varchar2
62 ,P_TARIFF_GROUP_CODE In Varchar2 Default hr_api.g_Varchar2
63 ,P_JOB_GROUP_ID In Number Default hr_api.g_Number
64 ,P_REMUNERATION_JOB_ID In Number Default hr_api.g_Number
65 ,P_DERIVED_GRADE_ID In Number Default hr_api.g_Number
66 ,P_DERIVED_CASE_GROUP_ID In Number Default hr_api.g_Number
67 ,P_DERIVED_SUBCASGRP_ID In Number Default hr_api.g_Number
68 ,P_USER_ENTERABLE_GRADE_ID In Number Default hr_api.g_Number
69 ,P_USER_ENTERABLE_CASE_GROUP_ID In Number Default hr_api.g_Number
70 ,P_USER_ENTERABLE_SUBCASGRP_ID In Number Default hr_api.g_Number
71 ,P_FREEZE In Varchar2 Default hr_api.g_Varchar2
72 ,p_WRKPLC_VLDTN_VER_ID In Number
73 ,p_object_version_number in out nocopy number);
74
75 Procedure Delete_Vldtn_Vern
76 (p_validate in boolean default false
77 ,p_WRKPLC_VLDTN_VER_ID In Number
78 ,p_object_version_number In number);
79 --
80 end PQH_DE_VLDVER_API;