1 PACKAGE PER_ASSIGNMENTS_V8_PKG AUTHID CURRENT_USER as
2 /* $Header: peasg08t.pkh 120.1 2006/01/23 06:35:05 eumenyio noship $ */
3 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
4 X_Assignment_Id IN OUT NOCOPY NUMBER,
5 X_Effective_Start_Date DATE,
6 X_Effective_End_Date DATE,
7 X_Business_Group_Id NUMBER,
8 X_Job_Id NUMBER,
9 X_Position_Id NUMBER,
10 X_Assignment_Status_Type_Id IN OUT NOCOPY NUMBER,
11 X_Person_Id NUMBER,
12 X_Organization_Id NUMBER,
13 X_Assignment_Sequence IN OUT NOCOPY NUMBER,
14 X_Assignment_Type VARCHAR2,
15 X_Primary_Flag IN OUT NOCOPY VARCHAR2,
16 X_Assignment_Number IN OUT NOCOPY VARCHAR2,
17 X_Comment_Id NUMBER,
18 X_Period_Of_Service_Id NUMBER,
19 X_Default_Code_Comb_Id NUMBER,
20 X_Set_Of_Books_Id NUMBER,
21 X_Location_Id NUMBER,
22 X_Supervisor_Id NUMBER,
23 X_Ass_Attribute_Category VARCHAR2,
24 X_Ass_Attribute1 VARCHAR2,
25 X_Ass_Attribute2 VARCHAR2,
26 X_Ass_Attribute3 VARCHAR2,
27 X_Ass_Attribute4 VARCHAR2,
28 X_Ass_Attribute5 VARCHAR2,
29 X_Ass_Attribute6 VARCHAR2,
30 X_Ass_Attribute7 VARCHAR2,
31 X_Ass_Attribute8 VARCHAR2,
32 X_Ass_Attribute9 VARCHAR2,
33 X_Ass_Attribute10 VARCHAR2,
34 X_Ass_Attribute11 VARCHAR2,
35 X_Ass_Attribute12 VARCHAR2,
36 X_Ass_Attribute13 VARCHAR2,
37 X_Ass_Attribute14 VARCHAR2,
38 X_Ass_Attribute15 VARCHAR2,
39 X_Ass_Attribute16 VARCHAR2,
40 X_Ass_Attribute17 VARCHAR2,
41 X_Ass_Attribute18 VARCHAR2,
42 X_Ass_Attribute19 VARCHAR2,
43 X_Ass_Attribute20 VARCHAR2,
44 X_Ass_Attribute21 VARCHAR2,
45 X_Ass_Attribute22 VARCHAR2,
46 X_Ass_Attribute23 VARCHAR2,
47 X_Ass_Attribute24 VARCHAR2,
48 X_Ass_Attribute25 VARCHAR2,
49 X_Ass_Attribute26 VARCHAR2,
50 X_Ass_Attribute27 VARCHAR2,
51 X_Ass_Attribute28 VARCHAR2,
52 X_Ass_Attribute29 VARCHAR2,
53 X_Ass_Attribute30 VARCHAR2,
54 X_Last_Update_Date DATE,
55 X_Last_Updated_By NUMBER,
56 X_Last_Update_Login NUMBER,
57 X_Created_By NUMBER,
58 X_Creation_Date DATE,
59 X_Title VARCHAR2
60 );
61 --
62 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
63 X_Assignment_Id IN OUT NOCOPY NUMBER,
64 X_Effective_Start_Date DATE,
65 X_Effective_End_Date DATE,
66 X_Business_Group_Id NUMBER,
67 X_Job_Id NUMBER,
68 X_Assignment_Status_Type_Id IN OUT NOCOPY NUMBER,
69 X_Person_Id NUMBER,
70 X_Organization_Id NUMBER,
71 X_Assignment_Sequence IN OUT NOCOPY NUMBER,
72 X_Assignment_Type VARCHAR2,
73 X_Primary_Flag IN OUT NOCOPY VARCHAR2,
74 X_Assignment_Number IN OUT NOCOPY VARCHAR2,
75 X_Comment_Id NUMBER,
76 X_Period_Of_Service_Id NUMBER,
77 X_Default_Code_Comb_Id NUMBER,
78 X_Set_Of_Books_Id NUMBER,
79 X_Location_Id NUMBER,
80 X_Supervisor_Id NUMBER,
81 X_Ass_Attribute_Category VARCHAR2,
82 X_Ass_Attribute1 VARCHAR2,
83 X_Ass_Attribute2 VARCHAR2,
84 X_Ass_Attribute3 VARCHAR2,
85 X_Ass_Attribute4 VARCHAR2,
86 X_Ass_Attribute5 VARCHAR2,
87 X_Ass_Attribute6 VARCHAR2,
88 X_Ass_Attribute7 VARCHAR2,
89 X_Ass_Attribute8 VARCHAR2,
90 X_Ass_Attribute9 VARCHAR2,
91 X_Ass_Attribute10 VARCHAR2,
92 X_Ass_Attribute11 VARCHAR2,
93 X_Ass_Attribute12 VARCHAR2,
94 X_Ass_Attribute13 VARCHAR2,
95 X_Ass_Attribute14 VARCHAR2,
96 X_Ass_Attribute15 VARCHAR2,
97 X_Ass_Attribute16 VARCHAR2,
98 X_Ass_Attribute17 VARCHAR2,
99 X_Ass_Attribute18 VARCHAR2,
100 X_Ass_Attribute19 VARCHAR2,
101 X_Ass_Attribute20 VARCHAR2,
102 X_Ass_Attribute21 VARCHAR2,
103 X_Ass_Attribute22 VARCHAR2,
104 X_Ass_Attribute23 VARCHAR2,
105 X_Ass_Attribute24 VARCHAR2,
106 X_Ass_Attribute25 VARCHAR2,
107 X_Ass_Attribute26 VARCHAR2,
108 X_Ass_Attribute27 VARCHAR2,
109 X_Ass_Attribute28 VARCHAR2,
110 X_Ass_Attribute29 VARCHAR2,
111 X_Ass_Attribute30 VARCHAR2,
112 X_Last_Update_Date DATE,
113 X_Last_Updated_By NUMBER,
114 X_Last_Update_Login NUMBER,
115 X_Created_By NUMBER,
116 X_Creation_Date DATE,
117 X_Title VARCHAR2
118 );
119 --
120 procedure delete_record(p_ROWID Varchar2);
121 --
122 procedure get_enddate_and_defaults(p_effective_start_date IN OUT NOCOPY DATE
123 ,p_job_name IN OUT NOCOPY VARCHAR2
124 ,p_job_id IN OUT NOCOPY NUMBER
125 ,p_position_name IN OUT NOCOPY VARCHAR2
126 ,p_position_id IN OUT NOCOPY NUMBER
127 ,p_organization_name IN OUT NOCOPY VARCHAR2
128 ,p_organization_id IN OUT NOCOPY NUMBER
129 ,p_Assignment_Id IN OUT NOCOPY NUMBER
130 ,p_Effective_End_Date IN OUT NOCOPY DATE
131 ,p_Business_Group_Id IN OUT NOCOPY NUMBER
132 ,p_Assignment_Status_Type_Id IN OUT NOCOPY NUMBER
133 ,p_Person_Id IN OUT NOCOPY NUMBER
134 ,p_Period_of_service_id IN OUT NOCOPY NUMBER
135 ,p_Assignment_Sequence IN OUT NOCOPY NUMBER
136 ,p_Assignment_Type IN OUT NOCOPY VARCHAR2
137 ,p_Primary_Flag IN OUT NOCOPY VARCHAR2
138 ,p_Assignment_Number IN OUT NOCOPY VARCHAR2
139 ,p_Comment_Id IN OUT NOCOPY NUMBER
140 ,p_Set_Of_Books_Id IN OUT NOCOPY NUMBER
141 ,p_Location_code IN OUT NOCOPY VARCHAR2
142 ,p_Location_Id IN OUT NOCOPY NUMBER
143 ,p_Supervisor_name IN OUT NOCOPY VARCHAR2
144 ,p_Supervisor_Id IN OUT NOCOPY NUMBER
145 ,p_Title IN OUT NOCOPY VARCHAR2
146 ,p_Ass_Attribute_Category IN OUT NOCOPY VARCHAR2
147 ,p_Ass_Attribute1 IN OUT NOCOPY VARCHAR2
148 ,p_Ass_Attribute2 IN OUT NOCOPY VARCHAR2
149 ,p_Ass_Attribute3 IN OUT NOCOPY VARCHAR2
150 ,p_Ass_Attribute4 IN OUT NOCOPY VARCHAR2
151 ,p_Ass_Attribute5 IN OUT NOCOPY VARCHAR2
152 ,p_Ass_Attribute6 IN OUT NOCOPY VARCHAR2
153 ,p_Ass_Attribute7 IN OUT NOCOPY VARCHAR2
154 ,p_Ass_Attribute8 IN OUT NOCOPY VARCHAR2
155 ,p_Ass_Attribute9 IN OUT NOCOPY VARCHAR2
156 ,p_Ass_Attribute10 IN OUT NOCOPY VARCHAR2
157 ,p_Ass_Attribute11 IN OUT NOCOPY VARCHAR2
158 ,p_Ass_Attribute12 IN OUT NOCOPY VARCHAR2
159 ,p_Ass_Attribute13 IN OUT NOCOPY VARCHAR2
160 ,p_Ass_Attribute14 IN OUT NOCOPY VARCHAR2
161 ,p_Ass_Attribute15 IN OUT NOCOPY VARCHAR2
162 ,p_Ass_Attribute16 IN OUT NOCOPY VARCHAR2
163 ,p_Ass_Attribute17 IN OUT NOCOPY VARCHAR2
164 ,p_Ass_Attribute18 IN OUT NOCOPY VARCHAR2
165 ,p_Ass_Attribute19 IN OUT NOCOPY VARCHAR2
166 ,p_Ass_Attribute20 IN OUT NOCOPY VARCHAR2
167 ,p_Ass_Attribute21 IN OUT NOCOPY VARCHAR2
168 ,p_Ass_Attribute22 IN OUT NOCOPY VARCHAR2
169 ,p_Ass_Attribute23 IN OUT NOCOPY VARCHAR2
170 ,p_Ass_Attribute24 IN OUT NOCOPY VARCHAR2
171 ,p_Ass_Attribute25 IN OUT NOCOPY VARCHAR2
172 ,p_Ass_Attribute26 IN OUT NOCOPY VARCHAR2
173 ,p_Ass_Attribute27 IN OUT NOCOPY VARCHAR2
174 ,p_Ass_Attribute28 IN OUT NOCOPY VARCHAR2
175 ,p_Ass_Attribute29 IN OUT NOCOPY VARCHAR2
176 ,p_Ass_Attribute30 IN OUT NOCOPY VARCHAR2
177 ,p_warning_message IN OUT NOCOPY VARCHAR2);
178 --
179 procedure get_enddate_and_defaults(p_effective_start_date IN OUT NOCOPY DATE
180 ,p_job_name IN OUT NOCOPY VARCHAR2
181 ,p_job_id IN OUT NOCOPY NUMBER
182 ,p_organization_name IN OUT NOCOPY VARCHAR2
183 ,p_organization_id IN OUT NOCOPY NUMBER
184 ,p_Assignment_Id IN OUT NOCOPY NUMBER
185 ,p_Effective_End_Date IN OUT NOCOPY DATE
186 ,p_Business_Group_Id IN OUT NOCOPY NUMBER
187 ,p_Assignment_Status_Type_Id IN OUT NOCOPY NUMBER
188 ,p_Person_Id IN OUT NOCOPY NUMBER
189 ,p_Period_of_service_id IN OUT NOCOPY NUMBER
190 ,p_Assignment_Sequence IN OUT NOCOPY NUMBER
191 ,p_Assignment_Type IN OUT NOCOPY VARCHAR2
192 ,p_Primary_Flag IN OUT NOCOPY VARCHAR2
193 ,p_Assignment_Number IN OUT NOCOPY VARCHAR2
194 ,p_Comment_Id IN OUT NOCOPY NUMBER
195 ,p_Set_Of_Books_Id IN OUT NOCOPY NUMBER
196 ,p_Location_code IN OUT NOCOPY VARCHAR2
197 ,p_Location_Id IN OUT NOCOPY NUMBER
198 ,p_Supervisor_name IN OUT NOCOPY VARCHAR2
199 ,p_Supervisor_Id IN OUT NOCOPY NUMBER
200 ,p_Title IN OUT NOCOPY VARCHAR2
201 ,p_Ass_Attribute_Category IN OUT NOCOPY VARCHAR2
202 ,p_Ass_Attribute1 IN OUT NOCOPY VARCHAR2
203 ,p_Ass_Attribute2 IN OUT NOCOPY VARCHAR2
204 ,p_Ass_Attribute3 IN OUT NOCOPY VARCHAR2
205 ,p_Ass_Attribute4 IN OUT NOCOPY VARCHAR2
206 ,p_Ass_Attribute5 IN OUT NOCOPY VARCHAR2
207 ,p_Ass_Attribute6 IN OUT NOCOPY VARCHAR2
208 ,p_Ass_Attribute7 IN OUT NOCOPY VARCHAR2
209 ,p_Ass_Attribute8 IN OUT NOCOPY VARCHAR2
210 ,p_Ass_Attribute9 IN OUT NOCOPY VARCHAR2
211 ,p_Ass_Attribute10 IN OUT NOCOPY VARCHAR2
212 ,p_Ass_Attribute11 IN OUT NOCOPY VARCHAR2
213 ,p_Ass_Attribute12 IN OUT NOCOPY VARCHAR2
214 ,p_Ass_Attribute13 IN OUT NOCOPY VARCHAR2
215 ,p_Ass_Attribute14 IN OUT NOCOPY VARCHAR2
216 ,p_Ass_Attribute15 IN OUT NOCOPY VARCHAR2
217 ,p_Ass_Attribute16 IN OUT NOCOPY VARCHAR2
218 ,p_Ass_Attribute17 IN OUT NOCOPY VARCHAR2
219 ,p_Ass_Attribute18 IN OUT NOCOPY VARCHAR2
220 ,p_Ass_Attribute19 IN OUT NOCOPY VARCHAR2
221 ,p_Ass_Attribute20 IN OUT NOCOPY VARCHAR2
222 ,p_Ass_Attribute21 IN OUT NOCOPY VARCHAR2
223 ,p_Ass_Attribute22 IN OUT NOCOPY VARCHAR2
224 ,p_Ass_Attribute23 IN OUT NOCOPY VARCHAR2
225 ,p_Ass_Attribute24 IN OUT NOCOPY VARCHAR2
226 ,p_Ass_Attribute25 IN OUT NOCOPY VARCHAR2
227 ,p_Ass_Attribute26 IN OUT NOCOPY VARCHAR2
228 ,p_Ass_Attribute27 IN OUT NOCOPY VARCHAR2
229 ,p_Ass_Attribute28 IN OUT NOCOPY VARCHAR2
230 ,p_Ass_Attribute29 IN OUT NOCOPY VARCHAR2
231 ,p_Ass_Attribute30 IN OUT NOCOPY VARCHAR2
232 ,p_warning_message IN OUT NOCOPY VARCHAR2);
233 --
234 procedure validate_effective_start(p_effective_start_date DATE
235 ,p_person_id NUMBER
236 ,p_period_of_service_id NUMBER);
237 --
238 END PER_ASSIGNMENTS_V8_PKG;