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,
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
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
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
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,
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,
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,
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,
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,
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,
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,
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,
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 );
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:
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,
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,
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,
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 ,
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:
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,