1 Package hr_job_requirement_api AUTHID CURRENT_USER as
2 /* $Header: pejbrapi.pkh 120.1 2005/10/02 02:17:51 aroussel $ */
3 /*#
4 * This package contains APIs for maintaining job requirement information.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Job Requirement
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |--------------------------< create_job_requirement >----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a requirement information relating to a job.
17 *
18 * The job requirement is a Special Information Type relating to a job.
19 *
20 * <p><b>Licensing</b><br>
21 * This API is licensed for use with Human Resources.
22 *
23 * <p><b>Prerequisites</b><br>
24 * The job must exist. The combination of job and the key flexfield segments
25 * must not have been used already.
26 *
27 * <p><b>Post Success</b><br>
28 * The API will create the job requirement.
29 *
30 * <p><b>Post Failure</b><br>
31 * The API does not create the job requirement and raises an error.
32 * @param p_validate If true, then validation alone will be performed and the
33 * database will remain unchanged. If false and all validation checks pass,
34 * then the database will be modified.
35 * @param p_id_flex_num Identifies the structure of the Personal Analysis Key
36 * Flexfield to use for this job requirement.
37 * @param p_job_id Identifies the job of the assignment
38 * @param p_comments Comment text.
39 * @param p_essential Value 'Y' indicates the requirement is an essential
40 * requirement. Otherwise, must be set to 'N'
41 * @param p_attribute_category This context value determines which flexfield
42 * structure to use with the descriptive flexfield segments.
43 * @param p_attribute1 Descriptive flexfield segment.
44 * @param p_attribute2 Descriptive flexfield segment.
45 * @param p_attribute3 Descriptive flexfield segment.
46 * @param p_attribute4 Descriptive flexfield segment.
47 * @param p_attribute5 Descriptive flexfield segment.
48 * @param p_attribute6 Descriptive flexfield segment.
49 * @param p_attribute7 Descriptive flexfield segment.
50 * @param p_attribute8 Descriptive flexfield segment.
51 * @param p_attribute9 Descriptive flexfield segment.
52 * @param p_attribute10 Descriptive flexfield segment.
53 * @param p_attribute11 Descriptive flexfield segment.
54 * @param p_attribute12 Descriptive flexfield segment.
55 * @param p_attribute13 Descriptive flexfield segment.
56 * @param p_attribute14 Descriptive flexfield segment.
57 * @param p_attribute15 Descriptive flexfield segment.
58 * @param p_attribute16 Descriptive flexfield segment.
59 * @param p_attribute17 Descriptive flexfield segment.
60 * @param p_attribute18 Descriptive flexfield segment.
61 * @param p_attribute19 Descriptive flexfield segment.
62 * @param p_attribute20 Descriptive flexfield segment.
63 * @param p_segment1 Key flexfield segment of Personal Analysis Key Flexfield
64 * @param p_segment2 Key flexfield segment of Personal Analysis Key Flexfield
65 * @param p_segment3 Key flexfield segment of Personal Analysis Key Flexfield
66 * @param p_segment4 Key flexfield segment of Personal Analysis Key Flexfield
67 * @param p_segment5 Key flexfield segment of Personal Analysis Key Flexfield
68 * @param p_segment6 Key flexfield segment of Personal Analysis Key Flexfield
69 * @param p_segment7 Key flexfield segment of Personal Analysis Key Flexfield
70 * @param p_segment8 Key flexfield segment of Personal Analysis Key Flexfield
71 * @param p_segment9 Key flexfield segment of Personal Analysis Key Flexfield
72 * @param p_segment10 Key flexfield segment of Personal Analysis Key Flexfield
73 * @param p_segment11 Key flexfield segment of Personal Analysis Key Flexfield
74 * @param p_segment12 Key flexfield segment of Personal Analysis Key Flexfield
75 * @param p_segment13 Key flexfield segment of Personal Analysis Key Flexfield
76 * @param p_segment14 Key flexfield segment of Personal Analysis Key Flexfield
77 * @param p_segment15 Key flexfield segment of Personal Analysis Key Flexfield
78 * @param p_segment16 Key flexfield segment of Personal Analysis Key Flexfield
79 * @param p_segment17 Key flexfield segment of Personal Analysis Key Flexfield
80 * @param p_segment18 Key flexfield segment of Personal Analysis Key Flexfield
81 * @param p_segment19 Key flexfield segment of Personal Analysis Key Flexfield
82 * @param p_segment20 Key flexfield segment of Personal Analysis Key Flexfield
83 * @param p_segment21 Key flexfield segment of Personal Analysis Key Flexfield
84 * @param p_segment22 Key flexfield segment of Personal Analysis Key Flexfield
85 * @param p_segment23 Key flexfield segment of Personal Analysis Key Flexfield
86 * @param p_segment24 Key flexfield segment of Personal Analysis Key Flexfield
87 * @param p_segment25 Key flexfield segment of Personal Analysis Key Flexfield
88 * @param p_segment26 Key flexfield segment of Personal Analysis Key Flexfield
89 * @param p_segment27 Key flexfield segment of Personal Analysis Key Flexfield
90 * @param p_segment28 Key flexfield segment of Personal Analysis Key Flexfield
91 * @param p_segment29 Key flexfield segment of Personal Analysis Key Flexfield
92 * @param p_segment30 Key flexfield segment of Personal Analysis Key Flexfield
93 * @param p_concat_segments Concatenated segments of Personal Analysis Key
94 * Flexfield
95 * @param p_job_requirement_id If p_validate is false, uniquely identifies the
96 * job requirement created. If p_validate is true, set to null.
97 * @param p_object_version_number If p_validate is false, then set to the
98 * version number of the created job requirement. If p_validate is true, then
99 * the value will be null.
100 * @param p_analysis_criteria_id If p_validate is false, uniquely identifies
101 * the combination of segments of Personal Analysis Key Flexfield recorded for
102 * this job requirement. If p_validate is true, then the value is set to null.
103 * @rep:displayname Create Job Requirement
104 * @rep:category BUSINESS_ENTITY PER_JOB
105 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
106 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
107 * @rep:scope public
108 * @rep:lifecycle active
109 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
110 */
111 --
112 -- {End Of Comments}
113 --
114 procedure create_job_requirement
115 (p_validate in boolean default false
116 ,p_id_flex_num in number
117 ,p_job_id in number
118 ,p_comments in varchar2 default null
119 ,p_essential in varchar2 default 'N'
120 ,p_attribute_category in varchar2 default null
121 ,p_attribute1 in varchar2 default null
122 ,p_attribute2 in varchar2 default null
123 ,p_attribute3 in varchar2 default null
124 ,p_attribute4 in varchar2 default null
125 ,p_attribute5 in varchar2 default null
126 ,p_attribute6 in varchar2 default null
127 ,p_attribute7 in varchar2 default null
128 ,p_attribute8 in varchar2 default null
129 ,p_attribute9 in varchar2 default null
130 ,p_attribute10 in varchar2 default null
131 ,p_attribute11 in varchar2 default null
132 ,p_attribute12 in varchar2 default null
133 ,p_attribute13 in varchar2 default null
134 ,p_attribute14 in varchar2 default null
135 ,p_attribute15 in varchar2 default null
136 ,p_attribute16 in varchar2 default null
137 ,p_attribute17 in varchar2 default null
138 ,p_attribute18 in varchar2 default null
139 ,p_attribute19 in varchar2 default null
140 ,p_attribute20 in varchar2 default null
141 ,p_segment1 in varchar2 default null
142 ,p_segment2 in varchar2 default null
143 ,p_segment3 in varchar2 default null
144 ,p_segment4 in varchar2 default null
145 ,p_segment5 in varchar2 default null
146 ,p_segment6 in varchar2 default null
147 ,p_segment7 in varchar2 default null
148 ,p_segment8 in varchar2 default null
149 ,p_segment9 in varchar2 default null
150 ,p_segment10 in varchar2 default null
151 ,p_segment11 in varchar2 default null
152 ,p_segment12 in varchar2 default null
153 ,p_segment13 in varchar2 default null
154 ,p_segment14 in varchar2 default null
155 ,p_segment15 in varchar2 default null
156 ,p_segment16 in varchar2 default null
157 ,p_segment17 in varchar2 default null
158 ,p_segment18 in varchar2 default null
159 ,p_segment19 in varchar2 default null
160 ,p_segment20 in varchar2 default null
161 ,p_segment21 in varchar2 default null
162 ,p_segment22 in varchar2 default null
163 ,p_segment23 in varchar2 default null
164 ,p_segment24 in varchar2 default null
165 ,p_segment25 in varchar2 default null
166 ,p_segment26 in varchar2 default null
167 ,p_segment27 in varchar2 default null
168 ,p_segment28 in varchar2 default null
169 ,p_segment29 in varchar2 default null
170 ,p_segment30 in varchar2 default null
171 ,p_concat_segments in varchar2 default null
172 ,p_job_requirement_id out nocopy number
173 ,p_object_version_number out nocopy number
174 ,p_analysis_criteria_id in out nocopy number
175 );
176 --
177 --
178 end hr_job_requirement_api;
179 --