1 PACKAGE ghr_pdc_api AUTHID CURRENT_USER AS
2 /* $Header: ghpdcapi.pkh 120.2 2005/10/02 01:58:10 aroussel $ */
3 /*#
4 * This package contains the procedures for creating, updating, and deleting
5 * GHR Position Description Classification records.
6 * @rep:scope public
7 * @rep:product per
8 * @rep:displayname Position Description Classification
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |--------------------------------< create_pdc >----------------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API creates the Position Description Classification.
18 *
19 * This API creates the Position Description Classification record in the
20 * GHR_PD_CLASSIFICATIONS table.
21 *
22 * <p><b>Licensing</b><br>
23 * This API is licensed for use with Human Resources.
24 *
25 * <p><b>Prerequisites</b><br>
26 * Position Description ID is passed
27 *
28 * <p><b>Post Success</b><br>
29 * Position Description Classification is created.
30 *
31 * <p><b>Post Failure</b><br>
32 * An application error is raised and processing is terminated
33 * @param p_validate If true, then only validation is performed and the
34 * database remains unchanged. If false, then all validation checks pass and
35 * the database is modified.
36 * @param p_pd_classification_id If p_validate is false, then this uniquely
37 * identifies the Position Description Classification created. If p_validate is
38 * true, then set to null.
39 * @param p_position_description_id {@rep:casecolumn
40 * GHR_POSITION_DESCRIPTIONS.POSITION_DESCRIPTION_ID}
41 * @param p_class_grade_by Class grade by. Valid values are defined by
42 * 'GHR_US_CLASS_GRADE_BY' lookup type.
43 * @param p_official_title Official Title
44 * @param p_pay_plan Pay Plan. Valid values are defined in the table
45 * GHR_PAY_PLANS
46 * @param p_occupational_code Occupational series. Valid values are defined by
47 * 'GHR_US_OCC_SERIES' lookup code.
48 * @param p_grade_level Grade or Level. Valid values are defined by
49 * 'GHR_US_GRADE_OR_LEVEL' lookup type.
50 * @param p_pdc_object_version_number If p_validate is false, then sets the
51 * version number of the created Position Description Classification. If
52 * p_validate is true, then the value is null.
53 * @rep:displayname Create Position Description Classification
54 * @rep:category BUSINESS_ENTITY GHR_POSITION_DESCRIPTION
55 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
56 * @rep:scope public
57 * @rep:lifecycle active
58 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
59 */
60 --
61 -- {End Of Comments}
62 --
63 PROCEDURE create_pdc(
64 p_validate IN BOOLEAN default false,
65 p_pd_classification_id OUT NOCOPY ghr_pd_classifications.pd_classification_id%TYPE,
66 p_position_description_id IN number,
67 p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
68 p_official_title IN ghr_pd_classifications.official_title%TYPE,
69 p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
70 p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
71 p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
72 p_pdc_object_version_number out NOCOPY number);
73 --
74 -- ----------------------------------------------------------------------------
75 -- |--------------------------------< update_pdc >----------------------------|
76 -- ----------------------------------------------------------------------------
77 --
78 -- {Start Of Comments}
79 /*#
80 * This API updates the Position Description Classification.
81 *
82 * This API updates the Position Description Classification record in the
83 * GHR_PD_CLASSIFICATIONS table.
84 *
85 * <p><b>Licensing</b><br>
86 * This API is licensed for use with Human Resources.
87 *
88 * <p><b>Prerequisites</b><br>
89 * Position Description ID is passed
90 *
91 * <p><b>Post Success</b><br>
92 * Position Description Classification is updated.
93 *
94 * <p><b>Post Failure</b><br>
95 * An application error is raised and processing is terminated
96 * @param p_validate If true, then only validation is performed and the
97 * database remains unchanged. If false, then all validation checks pass the
98 * database is modified.
99 * @param p_pd_classification_id Identifies the Position Description
100 * Classification record to modify
101 * @param p_position_description_id {@rep:casecolumn
102 * GHR_POSITION_DESCRIPTIONS.POSITION_DESCRIPTION_ID}
103 * @param p_class_grade_by Class grade by. Valid values are defined by
104 * 'GHR_US_CLASS_GRADE_BY' lookup type.
105 * @param p_official_title Official Title
106 * @param p_pay_plan Pay Plan. Valid values are defined in the table
107 * GHR_PAY_PLANS
108 * @param p_occupational_code Occupational series. Valid values are defined by
109 * 'GHR_US_OCC_SERIES' lookup code.
110 * @param p_grade_level Grade or Level. Valid values are defined by
111 * 'GHR_US_GRADE_OR_LEVEL' lookup type.
112 * @param p_pdc_object_version_number Pass in the current version number of the
113 * Position Description Classification that you are updating. When the API
114 * completes, if p_validate is false, sets the new version number of the
115 * updated Position Description Classification. If p_validate is true, sets the
116 * same value passed in.
117 * @rep:displayname Update Position Description Classification
118 * @rep:category BUSINESS_ENTITY GHR_POSITION_DESCRIPTION
119 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
120 * @rep:scope public
121 * @rep:lifecycle active
122 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
123 */
124 --
125 -- {End Of Comments}
126 --
127 PROCEDURE update_pdc
128 (
129 p_validate IN BOOLEAN default false,
130 p_pd_classification_id IN ghr_pd_classifications.pd_classification_id%TYPE,
131 p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,
132 p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
133 p_official_title IN ghr_pd_classifications.official_title%TYPE,
134 p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
135 p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
136 p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
137 p_pdc_object_version_number in out NOCOPY number);
138 --
139 -- ----------------------------------------------------------------------------
140 -- |--------------------------------< delete_pdc >----------------------------|
141 -- ----------------------------------------------------------------------------
142 --
143 -- {Start Of Comments}
144 /*#
145 * This API deletes the Position Description Classification.
146 *
147 * This API deletes the Position Description Classification record from the
148 * GHR_PD_CLASSIFICATIONS table.
149 *
150 * <p><b>Licensing</b><br>
151 * This API is licensed for use with Human Resources.
152 *
153 * <p><b>Prerequisites</b><br>
154 * Position Description Classification ID is passed.
155 *
156 * <p><b>Post Success</b><br>
157 * Position Description Classification is deleted.
158 *
159 * <p><b>Post Failure</b><br>
160 * An application error is raised and processing is terminated
161 * @param p_validate If true, then only validation is performed and the
162 * database remains unchanged. If false, then all validation checks pass the
163 * database is modified.
164 * @param p_pd_classification_id Identifies the Position Description
165 * Classification record to delete
166 * @param p_pdc_object_version_number Current version number of the Position
167 * Description Classification to be deleted.
168 * @rep:displayname Delete Position Description Classification
169 * @rep:category BUSINESS_ENTITY GHR_POSITION_DESCRIPTION
170 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
171 * @rep:scope public
172 * @rep:lifecycle active
173 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
174 */
175 --
176 -- {End Of Comments}
177 --
178 PROCEDURE delete_pdc
179 ( p_validate IN BOOLEAN default false,
180 p_pd_classification_id IN ghr_pd_classifications.pd_classification_id%TYPE,
181 p_pdc_object_version_number in number);
182
183 end ghr_pdc_api;