1 PACKAGE PA_CREATE_RESOURCE AUTHID CURRENT_USER AS
2 /* $Header: PACRRESS.pls 120.6 2012/01/06 07:36:10 djambhek ship $*/
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.LOGIN_ID;
10
11 PROCEDURE Create_Resource_group
12 (p_resource_list_id IN NUMBER,
13 p_resource_group IN VARCHAR2,
14 p_resource_name IN VARCHAR2,
15 p_alias IN VARCHAR2,
16 p_sort_order IN NUMBER,
17 p_display_flag IN VARCHAR2,
18 p_enabled_flag IN VARCHAR2,
19 p_track_as_labor_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
20 p_resource_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
21 p_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
22 p_err_code OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
23 p_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
24 p_err_stack IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
25
26 PROCEDURE Create_Resource_List
27 (p_resource_list_name IN VARCHAR2,
28 p_description IN VARCHAR2,
29 p_public_flag IN VARCHAR2 DEFAULT 'Y',
30 p_group_resource_type IN VARCHAR2,
31 p_start_date IN DATE DEFAULT SYSDATE,
32 p_end_date IN DATE DEFAULT NULL,
33 p_business_group_id IN NUMBER DEFAULT NULL,
34 p_job_group_id IN NUMBER, -- Added for bug 2486405.
35 p_job_group_name IN VARCHAR2 DEFAULT NULL,
36 p_use_for_wp_flag IN VARCHAR2 DEFAULT NULL,
37 p_control_flag IN VARCHAR2 DEFAULT NULL,
38 p_migration_code IN VARCHAR2 DEFAULT NULL,
39 p_record_version_number IN NUMBER DEFAULT NULL,
40 p_res_class_flag IN VARCHAR2 DEFAULT 'Y', --Added for CBS::13535688
41 p_def_expenditure_type IN VARCHAR2 DEFAULT NULL, --Added for CBS::13535688 & 13546557
42 p_resource_list_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
43 p_err_code OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
44 p_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
45 p_err_stack IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
46
47 PROCEDURE Update_Resource_List
48 (p_resource_list_name IN VARCHAR2 DEFAULT NULL,
49 p_description IN VARCHAR2 DEFAULT NULL,
50 p_start_date IN DATE DEFAULT NULL,
51 p_end_date IN DATE DEFAULT NULL,
52 p_job_group_id IN OUT NOCOPY NUMBER,
53 p_job_group_name IN VARCHAR2 DEFAULT NULL,
54 p_use_for_wp_flag IN VARCHAR2 DEFAULT NULL,
55 p_control_flag IN VARCHAR2 DEFAULT NULL,
56 p_migration_code IN VARCHAR2 DEFAULT NULL,
57 p_record_version_number IN OUT NOCOPY NUMBER,
58 p_resource_list_id IN NUMBER,
59 p_res_class_flag IN VARCHAR2 DEFAULT 'Y', --Added for CBS::13535688
60 p_def_format_creation IN VARCHAR2 DEFAULT 'N', --Added for CBS::13535688
61 p_def_expenditure_type IN VARCHAR2 DEFAULT NULL, --Added for CBS::13535688 & 13546557
62 x_msg_count OUT NOCOPY NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_data OUT NOCOPY VARCHAR2);
65
66 PROCEDURE Create_Resource_txn_Attribute
67 ( p_resource_id IN NUMBER,
68 p_resource_type_Code IN VARCHAR2,
69 p_person_id IN NUMBER,
70 p_job_id IN NUMBER,
71 p_proj_organization_id IN NUMBER,
72 p_vendor_id IN NUMBER,
73 p_expenditure_type IN VARCHAR2,
74 p_event_type IN VARCHAR2,
75 p_expenditure_category IN VARCHAR2,
76 p_revenue_category_code IN VARCHAR2,
77 p_non_labor_resource IN VARCHAR2,
78 p_system_linkage IN VARCHAR2,
79 p_project_role_id IN NUMBER DEFAULT NULL,
80 p_resource_txn_attribute_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
81 p_err_code OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
82 p_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
83 p_err_stack IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
84
85 PROCEDURE Create_Resource_list_member
86 (p_resource_list_id IN NUMBER,
87 p_resource_name IN VARCHAR2,
88 p_resource_type_Code IN VARCHAR2,
89 p_alias IN VARCHAR2,
90 p_sort_order IN NUMBER,
91 p_display_flag IN VARCHAR2,
92 p_enabled_flag IN VARCHAR2,
93 p_person_id IN NUMBER,
94 p_job_id IN NUMBER,
95 p_proj_organization_id IN NUMBER,
96 p_vendor_id IN NUMBER,
97 p_expenditure_type IN VARCHAR2,
98 p_event_type IN VARCHAR2,
99 p_expenditure_category IN VARCHAR2,
100 p_revenue_category_code IN VARCHAR2,
101 p_non_labor_resource IN VARCHAR2,
102 p_system_linkage IN VARCHAR2,
103 p_project_role_id IN NUMBER DEFAULT NULL,
104 p_job_group_id IN NUMBER DEFAULT NULL, --- Added for Bug 2486405.
105 p_parent_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
106 p_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
107 p_track_as_labor_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
108 p_err_code OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
109 p_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
110 p_err_stack IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
111
112 PROCEDURE Create_Resource (p_resource_name IN VARCHAR2,
113 p_resource_type_Code IN VARCHAR2,
114 p_description IN VARCHAR2,
115 p_unit_of_measure IN VARCHAR2,
116 p_rollup_quantity_flag IN VARCHAR2,
117 p_track_as_labor_flag IN VARCHAR2,
118 p_start_date IN DATE,
119 p_end_date IN DATE,
120 p_person_id IN NUMBER,
121 p_job_id IN NUMBER,
122 p_proj_organization_id IN NUMBER,
123 p_vendor_id IN NUMBER,
124 p_expenditure_type IN VARCHAR2,
125 p_event_type IN VARCHAR2,
126 p_expenditure_category IN VARCHAR2,
127 p_revenue_category_code IN VARCHAR2,
128 p_non_labor_resource IN VARCHAR2,
129 p_system_linkage IN VARCHAR2,
130 p_project_role_id IN NUMBER DEFAULT NULL,
131 p_resource_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
132 p_err_code OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
133 p_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
134 p_err_stack IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
135
136 PROCEDURE Add_Resouce_List_Member
137 (p_resource_list_id IN NUMBER,
138 p_resource_name IN VARCHAR2,
139 p_resource_type_Code IN VARCHAR2,
140 p_alias IN VARCHAR2,
141 p_sort_order IN NUMBER,
142 p_display_flag IN VARCHAR2,
143 p_enabled_flag IN VARCHAR2,
144 p_person_id IN NUMBER,
145 p_job_id IN NUMBER,
146 p_proj_organization_id IN NUMBER,
147 p_vendor_id IN NUMBER,
148 p_expenditure_type IN VARCHAR2,
149 p_event_type IN VARCHAR2,
150 p_expenditure_category IN VARCHAR2,
151 p_revenue_category_code IN VARCHAR2,
152 p_non_labor_resource IN VARCHAR2,
153 p_system_linkage IN VARCHAR2,
154 p_parent_member_id IN NUMBER,
155 p_project_role_id IN NUMBER DEFAULT NULL,
156 p_track_as_labor_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
157 p_resource_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
158 p_resource_list_member_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
159 p_err_code OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
160 p_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
161 p_err_stack IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
162
163 PROCEDURE Create_Default_Res_List ( X_business_group_id IN NUMBER
164 , X_err_code OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
165 , X_err_stage IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
166 , X_err_stack IN OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
167
168 PROCEDURE Delete_Plan_Res_List (p_resource_list_id IN NUMBER,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2);
172
173 /*************************************************************
174 * Function : Check_pl_alias_unique
175 * Description : The purpose of this function is to determine
176 * the uniqueness of the resource alias if it is not null.
177 * Further details are specified in the Body.
178 *************************************************************/
179
180 FUNCTION Check_pl_alias_unique(
181 p_resource_list_id IN VARCHAR2,
182 p_resource_alias IN VARCHAR2,
183 p_resource_list_member_id IN VARCHAR2)
184 RETURN VARCHAR2;
185
186 PROCEDURE Add_language;
187
188 /*******************************************************
189 * Procedure : Create_Proj_Resource_List
190 * Description : This procedure is used to create resource
191 * list members, whenever we create a project
192 * specific resource list(ie when a resource
193 * list is associated to a project).
194 * We are copying the resource members
195 * from the existing members for the same
196 * resource list.
197 ******************************************************/
198 PROCEDURE Create_Proj_Resource_List
199 (p_resource_list_id IN VARCHAR2,
200 p_project_id IN NUMBER,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_error_msg_data OUT NOCOPY Varchar2,
203 x_msg_count OUT NOCOPY Number);
204
205
206
207 /* Procedure to create a resource list and copy all its elements from the selected parent resource list id*/
208 /* Added by smullapp */
209
210 PROCEDURE COPY_RESOURCE_LIST(
211 P_Commit IN Varchar2 Default Fnd_Api.G_False,
212 P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
213 P_API_Version_Number IN Number,
214 p_parent_resource_list_id IN PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE,
215 p_name IN PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
216 p_description IN PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
217 p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,
218 p_END_DATE_ACTIVE IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,
219 p_JOB_GROUP_ID IN PA_RESOURCE_LISTS_ALL_BG.JOB_GROUP_ID%TYPE,
220 p_CONTROL_FLAG IN PA_RESOURCE_LISTS_ALL_BG.CONTROL_FLAG%TYPE,
221 p_USE_FOR_WP_FLAG IN PA_RESOURCE_LISTS_ALL_BG.USE_FOR_WP_FLAG%TYPE,
222 p_Enable_Resource_Classes IN VARCHAR2 DEFAULT 'Y', -- Added for CBS Bug13535688
223 x_return_status OUT NOCOPY Varchar2,
224 x_msg_data OUT NOCOPY Varchar2,
225 x_msg_count OUT NOCOPY NUMBER
226 );
227
228
229 /******************************************************
230 * Procedure : Copy_Resource_Lists
231 * Description : This API is used to copy all the
232 * Resource list members for the resource_list_id's
233 * associated to the source project -->
234 * into the destination project.
235 * Further details in the body.
236 * **************************************************/
237 PROCEDURE Copy_Resource_Lists
238 (p_source_project_id IN Number,
239 p_destination_project_id IN Number,
240 x_return_status OUT NOCOPY Varchar2);
241
242
243 /******************************************************
244 * Procedure : TRANSLATE_ROW
245 * Description : This API is used to tranlslate all
246 * translatable colmuns os pa_resource_lits_tl
247 * table. This is called from the lct file.
248 * **************************************************/
249 procedure TRANSLATE_ROW(
250 P_RESOURCE_LIST_ID in NUMBER ,
251 P_OWNER in VARCHAR2 ,
252 P_NAME in VARCHAR2 ,
253 P_DESCRIPTION in VARCHAR2
254 );
255
256 /******************************************************
257 * Procedure : LOAD_ROW
258 * Description : This API is used to update or insert rows
259 * into table pa_resource_lists_bg and
260 * pa_resource_lits_tl table. This procedure
261 * is called from the lct file.
262 * **************************************************/
263 procedure LOAD_ROW(
264 P_RESOURCE_LIST_ID in NUMBER,
265 P_NAME in VARCHAR2,
266 P_DESCRIPTION in VARCHAR2,
267 P_PUBLIC_FLAG in VARCHAR2,
268 P_GROUP_RESOURCE_TYPE_ID in NUMBER,
269 P_START_DATE_ACTIVE in DATE,
270 P_END_DATE_ACTIVE in DATE,
271 P_UNCATEGORIZED_FLAG in VARCHAR2,
272 P_BUSINESS_GROUP_ID in NUMBER,
273 P_JOB_GROUP_ID in NUMBER,
274 P_RESOURCE_LIST_TYPE in VARCHAR2,
275 P_OWNER in VARCHAR2
276 );
277
278 END PA_CREATE_RESOURCE;