1 PACKAGE Pa_Res_List_Members_Pkg AS
2 /* $Header: PAPRESTS.pls 120.0 2005/05/30 20:02:52 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 * Procedure : Insert_Row
13 * Description : This procedure is used to take in parameters
14 * passed from the
15 * pa_planning_resource_pub.create_planning_resource
16 * procedure and insert into the pa_resource_list_members
17 * table.
18 ****************************************************/
19 PROCEDURE Insert_Row
20 ( p_resource_list_member_id IN
21 pa_resource_list_members.resource_list_member_id%TYPE,
22 p_resource_list_id IN pa_resource_list_members.resource_list_id%TYPE,
23 p_resource_id IN pa_resource_list_members.resource_id%TYPE,
24 p_resource_alias IN pa_resource_list_members.alias%TYPE,
25 p_person_id IN pa_resource_list_members.person_id%TYPE,
26 p_job_id IN pa_resource_list_members.job_id%TYPE ,
27 p_organization_id IN pa_resource_list_members.organization_id%TYPE ,
28 p_vendor_id IN pa_resource_list_members.vendor_id%TYPE ,
29 p_expenditure_type IN pa_resource_list_members.expenditure_type%TYPE ,
30 p_event_type IN pa_resource_list_members.event_type%TYPE ,
31 p_non_labor_resource IN pa_resource_list_members.non_labor_resource%TYPE ,
32 p_expenditure_category IN
33 pa_resource_list_members.expenditure_category%TYPE,
34 p_revenue_category IN pa_resource_list_members.revenue_category%TYPE ,
35 p_role_id IN
36 pa_resource_list_members.project_role_id%TYPE ,
37 p_resource_class_id IN pa_resource_list_members.resource_class_id%TYPE ,
38 p_res_class_code IN pa_resource_list_members.resource_class_code%TYPE,
39 p_res_format_id IN NUMBER ,
40 p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE ,
41 p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE ,
42 p_mfc_cost_type_id IN pa_resource_list_members.mfc_cost_type_id%TYPE ,
43 p_res_class_flag IN pa_resource_list_members.resource_class_flag%TYPE ,
44 p_fc_res_type_code IN pa_resource_list_members.fc_res_type_code%TYPE ,
45 p_inventory_item_id IN pa_resource_list_members.inventory_item_id%TYPE ,
46 p_item_category_id IN pa_resource_list_members.item_category_id%TYPE,
47 p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
48 p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
49 p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
50 p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
51 p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
52 p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
53 p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
54 p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
55 p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
56 p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
57 p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
58 p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
59 p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
60 p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
61 p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
62 p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
63 p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
64 p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
65 p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
66 p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
67 p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
68 p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
69 p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
70 p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
71 p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
72 p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
73 p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
74 p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
75 p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
76 p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
77 p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
78 p_person_type_code IN pa_resource_list_members.person_type_code%TYPE,
79 p_bom_resource_id IN pa_resource_list_members.bom_resource_id%TYPE,
80 p_team_role IN pa_resource_list_members.team_role%TYPE,
81 p_incur_by_res_flag IN
82 pa_resource_list_members.incurred_by_res_flag%TYPE,
83 p_incur_by_res_class_code IN
84 pa_resource_list_members.incur_by_res_class_code%TYPE,
85 p_incur_by_role_id IN pa_resource_list_members.incur_by_role_id%TYPE,
86 p_object_type IN pa_resource_list_members.object_type%TYPE,
87 p_object_id IN pa_resource_list_members.object_id%TYPE,
88 p_wp_eligible_flag IN pa_resource_list_members.wp_eligible_flag%TYPE,
89 p_unit_of_measure IN pa_resource_list_members.unit_of_measure%TYPE,
90 x_msg_count IN OUT NOCOPY NUMBER,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_error_msg_data OUT NOCOPY VARCHAR2 ) ;
93
94 /******************************************************
95 * Procedure : Update_Row
96 * Description : This procedure is used to take in parameters
97 * passed from the
98 * pa_planning_resource_pub.update_planning_resource
99 * procedure and update the pa_resource_list_members
100 * table.
101 ****************************************************/
102 PROCEDURE UPDATE_ROW
103 (p_alias IN VARCHAR2,
104 p_enabled_flag IN VARCHAR2,
105 p_resource_list_member_id IN
106 pa_resource_list_members.resource_list_member_id%TYPE,
107 p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE,
108 p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE,
109 p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,
110 p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
111 p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
112 p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
113 p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
114 p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
115 p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
116 p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
117 p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
118 p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
119 p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
120 p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
121 p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
122 p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
123 p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
124 p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
125 p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
126 p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
127 p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
128 p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
129 p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
130 p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
131 p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
132 p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
133 p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
134 p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
135 p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
136 p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
137 p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
138 p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
139 p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
140 p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
141 p_record_version_number IN
142 pa_resource_list_members.RECORD_VERSION_NUMBER%TYPE,
143 x_msg_count IN OUT NOCOPY NUMBER,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_error_msg_data OUT NOCOPY VARCHAR2 )
146 ;
147
148 /******************************************************
149 * Procedure : Delete_Row
150 * Description : This procedure is used to take in parameters
151 * passed from the
152 * pa_planning_resource_pub.update_planning_resource
153 * procedure and update the pa_resource_list_members
154 * table.
155 ****************************************************/
156 PROCEDURE DELETE_ROW
157 (p_resource_list_member_id IN VARCHAR2,
158 p_exist_res_list IN VARCHAR2,
159 x_msg_count IN OUT NOCOPY VARCHAR2,
160 x_return_status OUT NOCOPY VARCHAR2);
161
162 END Pa_Res_List_Members_Pkg;