[Home] [Help]
PACKAGE: APPS.PA_PLANNING_RESOURCE_PUB
Source
1 PACKAGE Pa_Planning_Resource_Pub AUTHID CURRENT_USER AS
2 /* $Header: PAPRESPS.pls 120.0 2005/06/03 13:48:17 appldev noship $*/
3
4 -- Standard who
5 g_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
6 g_last_update_date DATE := SYSDATE;
7 g_creation_date DATE := SYSDATE;
8 g_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
9 -- g_last_update_login NUMBER(15) := FND_GLOBAL.LOG_ID;
10
11 /**************************************************************
12 * Record Structure Declaration
13 * Record : PLANNING_RESOURCE_IN_REC
14 * ***********************************************************/
15 TYPE Planning_Resource_In_Rec IS RECORD
16 (
17 p_resource_list_member_id NUMBER DEFAULT NULL,
18 p_resource_alias VARCHAR2(80) DEFAULT NULL,
19 p_person_id NUMBER DEFAULT NULL,
20 p_person_name VARCHAR2(240) DEFAULT NULL,
21 p_job_id NUMBER DEFAULT NULL,
22 p_job_name VARCHAR2(240) DEFAULT NULL,
23 p_organization_id NUMBER DEFAULT NULL,
24 p_organization_name VARCHAR2(240) DEFAULT NULL,
25 p_vendor_id NUMBER DEFAULT NULL,
26 -- 3592496
27 p_vendor_name VARCHAR2(240) DEFAULT NULL,
28 p_fin_category_name VARCHAR2(30) DEFAULT NULL,
29 p_non_labor_resource VARCHAR2(30) DEFAULT NULL,
30 p_project_role_id NUMBER DEFAULT NULL,
31 p_project_role_name VARCHAR2(80) DEFAULT NULL,
32 p_resource_class_id NUMBER DEFAULT NULL,
33 p_resource_class_code VARCHAR2(30) DEFAULT NULL,
34 p_res_format_id NUMBER ,
35 p_spread_curve_id NUMBER DEFAULT NULL,
36 p_etc_method_code VARCHAR2(30) DEFAULT NULL,
37 p_mfc_cost_type_id NUMBER DEFAULT NULL,
38 p_copy_from_rl_flag VARCHAR2(1) DEFAULT NULL,
39 p_resource_class_flag VARCHAR2(1) DEFAULT NULL,
40 p_fc_res_type_code VARCHAR2(30) DEFAULT NULL,
41 p_inventory_item_id NUMBER DEFAULT NULL,
42 p_inventory_item_name VARCHAR2(80) DEFAULT NULL,
43 p_item_category_id NUMBER DEFAULT NULL,
44 p_item_category_name VARCHAR2(150) DEFAULT NULL,
45 p_migration_code VARCHAR2(150) DEFAULT 'N',
46 p_attribute_category VARCHAR2(150) DEFAULT NULL,
47 p_attribute1 VARCHAR2(150) DEFAULT NULL,
48 p_attribute2 VARCHAR2(150) DEFAULT NULL,
49 p_attribute3 VARCHAR2(150) DEFAULT NULL,
50 p_attribute4 VARCHAR2(150) DEFAULT NULL,
51 p_attribute5 VARCHAR2(150) DEFAULT NULL,
52 p_attribute6 VARCHAR2(150) DEFAULT NULL,
53 p_attribute7 VARCHAR2(150) DEFAULT NULL,
54 p_attribute8 VARCHAR2(150) DEFAULT NULL,
55 p_attribute9 VARCHAR2(150) DEFAULT NULL,
56 p_attribute10 VARCHAR2(150) DEFAULT NULL,
57 p_attribute11 VARCHAR2(150) DEFAULT NULL,
58 p_attribute12 VARCHAR2(150) DEFAULT NULL,
59 p_attribute13 VARCHAR2(150) DEFAULT NULL,
60 p_attribute14 VARCHAR2(150) DEFAULT NULL,
61 p_attribute15 VARCHAR2(150) DEFAULT NULL,
62 p_attribute16 VARCHAR2(150) DEFAULT NULL,
63 p_attribute17 VARCHAR2(150) DEFAULT NULL,
64 p_attribute18 VARCHAR2(150) DEFAULT NULL,
65 p_attribute19 VARCHAR2(150) DEFAULT NULL,
66 p_attribute20 VARCHAR2(150) DEFAULT NULL,
67 p_attribute21 VARCHAR2(150) DEFAULT NULL,
68 p_attribute22 VARCHAR2(150) DEFAULT NULL,
69 p_attribute23 VARCHAR2(150) DEFAULT NULL,
70 p_attribute24 VARCHAR2(150) DEFAULT NULL,
71 p_attribute25 VARCHAR2(150) DEFAULT NULL,
72 p_attribute26 VARCHAR2(150) DEFAULT NULL,
73 p_attribute27 VARCHAR2(150) DEFAULT NULL,
74 p_attribute28 VARCHAR2(150) DEFAULT NULL,
75 p_attribute29 VARCHAR2(150) DEFAULT NULL,
76 p_attribute30 VARCHAR2(150) DEFAULT NULL,
77 p_person_type_code VARCHAR2(30) DEFAULT NULL,
78 p_bom_resource_id NUMBER DEFAULT NULL,
79 p_bom_resource_name VARCHAR2(30) DEFAULT NULL,
80 p_team_role VARCHAR2(80) DEFAULT NULL,
81 p_incur_by_res_code VARCHAR2(30) DEFAULT NULL,
82 p_incur_by_res_type VARCHAR2(30) DEFAULT NULL,
83 p_record_version_number NUMBER,
84 p_project_id NUMBER
85 );
86
87
88 /**************************************************************
89 * Record Structure Declaration
90 * Record : PLANNING_RESOURCE_OUT_REC
91 * ***********************************************************/
92 TYPE Planning_Resource_Out_Rec IS RECORD
93 (
94 x_resource_list_member_id NUMBER DEFAULT NULL,
95 x_record_version_number NUMBER DEFAULT NULL);
96
97 /*************************************************************
98 * Table of records
99 * Table : PLANNING_RESOURCE_IN_TBL
100 ************************************************************/
101 TYPE Planning_Resource_In_Tbl IS TABLE OF Planning_Resource_In_Rec
102 INDEX BY BINARY_INTEGER;
103
104
105 /*************************************************************
106 * Table of records
107 * Table : PLANNING_RESOURCE_OUT_TBL
108 ************************************************************/
109 TYPE Planning_Resource_Out_Tbl IS TABLE OF Planning_Resource_Out_Rec
110 INDEX BY BINARY_INTEGER;
111
112 /**************************************************************
113 * Procedure : Create_Planning_Resource
114 * Description : The purpose of this procedure is to Validate
115 * and create a new planning resource for a
116 * resource list.
117 * Further details specified in the Body.
118 ****************************************************************/
119 PROCEDURE Create_Planning_Resource(
120 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
121 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
122 p_resource_list_id IN VARCHAR2,
123 P_planning_resource_in_tbl IN Planning_Resource_In_Tbl,
124 X_planning_resource_out_tbl OUT NOCOPY Planning_Resource_Out_Tbl,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_error_msg_data OUT NOCOPY VARCHAR2 );
128
129 /**************************************************************
130 * Procedure : Create_Planning_Resource
131 * Description : The purpose of this procedure is to Validate
132 * and create a new planning resource for a
133 * resource list.
134 * Further details specified in the Body.
135 ****************************************************************/
136 PROCEDURE Create_Planning_Resource(
137 p_resource_list_id IN VARCHAR2,
138 p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
139 p_resource_alias IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
140 p_person_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
141 -- Bug 3593613
142 p_person_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
143 p_job_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
144 -- Bug 3593613
145 p_job_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
146 p_organization_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
147 -- Bug 3593613
148 p_organization_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
149 p_vendor_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
150 --Bug 3592496
151 p_vendor_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT NULL,
152 p_fin_category_name IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
153 p_non_labor_resource IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
154 p_project_role_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
155 -- Bug 3593613
156 p_project_role_name IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
157 p_resource_class_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
158 p_resource_class_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
159 p_res_format_id IN SYSTEM.PA_NUM_TBL_TYPE ,
160 p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
161 p_etc_method_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
162 p_mfc_cost_type_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
163 p_copy_from_rl_flag IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT NULL,
164 p_resource_class_flag IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT NULL,
165 p_fc_res_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
166 p_inventory_item_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
167 -- Bug 3593613
168 p_inventory_item_name IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
169 p_item_category_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
170 p_item_category_name IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
171 p_migration_code IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE ,
172 p_attribute_category IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
173 p_attribute1 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
174 p_attribute2 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
175 p_attribute3 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
176 p_attribute4 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
177 p_attribute5 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
178 p_attribute6 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
179 p_attribute7 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
180 p_attribute8 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
181 p_attribute9 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
182 p_attribute10 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
183 p_attribute11 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
184 p_attribute12 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
185 p_attribute13 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
186 p_attribute14 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
187 p_attribute15 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
188 p_attribute16 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
189 p_attribute17 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
190 p_attribute18 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
191 p_attribute19 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
192 p_attribute20 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
193 p_attribute21 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
194 p_attribute22 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
195 p_attribute23 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
196 p_attribute24 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
197 p_attribute25 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
198 p_attribute26 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
199 p_attribute27 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
200 p_attribute28 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
201 p_attribute29 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
202 p_attribute30 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
203 p_person_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
204 p_bom_resource_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
205 p_bom_resource_name IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
206 p_team_role IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
207 --p_named_role IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
208 p_incur_by_res_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
209 p_incur_by_res_type IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
210 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
211 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
212 p_project_id IN NUMBER DEFAULT NULL,
213 x_resource_list_member_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
214 x_record_version_number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
215 x_return_status OUT NOCOPY VARCHAR2 ,
216 x_msg_count OUT NOCOPY NUMBER ,
217 x_error_msg_data OUT NOCOPY VARCHAR2 );
218
219 /***************************************************
220 * Procedure : Update_Planning_Resource
221 * Description : The purpose of this procedure is to
222 * Validate and update attributes on an existing
223 * planning resource for a resource list.
224 * Further details in the Body.
225 ***************************************************/
226 PROCEDURE Update_Planning_Resource
227 (p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
228 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229 p_resource_list_id IN NUMBER,
230 p_enabled_flag IN VARCHAR2,
231 P_planning_resource_in_tbl IN Planning_Resource_In_Tbl,
232 X_planning_resource_out_tbl OUT NOCOPY Planning_Resource_Out_Tbl,
233 x_return_status OUT NOCOPY VARCHAR2,
234 x_msg_count OUT NOCOPY NUMBER,
235 x_error_msg_data OUT NOCOPY VARCHAR2 );
236
237 PROCEDURE Update_Planning_Resource(
238 p_resource_list_id IN NUMBER,
239 p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE,
240 p_enabled_flag IN VARCHAR2,
241 p_resource_alias IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE ,
242 p_spread_curve_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
243 p_etc_method_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
244 p_mfc_cost_type_id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
245 p_attribute_category IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
246 p_attribute1 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
247 p_attribute2 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
248 p_attribute3 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
249 p_attribute4 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
250 p_attribute5 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
251 p_attribute6 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
252 p_attribute7 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
253 p_attribute8 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
254 p_attribute9 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
255 p_attribute10 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
256 p_attribute11 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
257 p_attribute12 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
258 p_attribute13 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
259 p_attribute14 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
260 p_attribute15 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
261 p_attribute16 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
262 p_attribute17 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
263 p_attribute18 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
264 p_attribute19 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
265 p_attribute20 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
266 p_attribute21 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
267 p_attribute22 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
268 p_attribute23 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
269 p_attribute24 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
270 p_attribute25 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
271 p_attribute26 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
272 p_attribute27 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
273 p_attribute28 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
274 p_attribute29 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
275 p_attribute30 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
276 p_record_version_number IN SYSTEM.PA_NUM_TBL_TYPE ,
277 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
278 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
279 x_record_version_number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
280 x_return_status OUT NOCOPY VARCHAR2 ,
281 x_msg_count OUT NOCOPY NUMBER ,
282 x_error_msg_data OUT NOCOPY VARCHAR2 );
283
284
285 /*************************************************
286 * Procedure : Delete_Planning_Resource
287 * Description : The purpose of this procedure is to
288 * delete a planning resource if it is not
289 * being used, else disable it.
290 * Further details in the Body.
291 ***************************************************/
292 PROCEDURE Delete_Planning_Resource(
293 p_resource_list_member_id IN SYSTEM.PA_NUM_TBL_TYPE ,
294 p_commit IN VARCHAR2,
295 p_init_msg_list IN VARCHAR2,
296 x_return_status OUT NOCOPY VARCHAR2,
297 x_msg_count OUT NOCOPY NUMBER,
298 x_error_msg_data OUT NOCOPY VARCHAR2);
299
300
301 END Pa_Planning_Resource_Pub;