1 package PA_PROJECT_PVT AUTHID DEFINER as
2 /*$Header: PAPMPRVS.pls 120.2.12020000.3 2013/03/28 00:29:14 skkoppul ship $*/
3
4 -- Required for the Special Task number change handling in
5 -- Update_Project
6
7 TYPE task_number_upd_rec_type IS RECORD
8 (task_index NUMBER ,
9 task_id NUMBER);
10 TYPE task_number_upd_tbl_type IS TABLE OF task_number_upd_rec_type
11 INDEX BY BINARY_INTEGER;
12
13 G_task_num_updated_index_tbl task_number_upd_tbl_type;
14
15 G_index_counter NUMBER := 0;
16 G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
17 --Locking exception
18 ROW_ALREADY_LOCKED EXCEPTION;
19 PRAGMA EXCEPTION_INIT(ROW_ALREADY_LOCKED, -54);
20
21 PROCEDURE add_key_members
22 ( p_return_status OUT NOCOPY VARCHAR2 , --Bug: 4537865
23 p_pa_source_template_id IN NUMBER ,
24 p_project_id IN NUMBER ,
25 p_key_members IN pa_project_pub.project_role_tbl_type );
26
27 PROCEDURE add_class_categories
28 ( p_return_status OUT NOCOPY VARCHAR2 , --Bug: 4537865
29 p_pa_source_template_id IN NUMBER ,
30 p_project_id IN NUMBER ,
31 p_class_categories IN pa_project_pub.class_category_tbl_type );
32
33 PROCEDURE add_task_round_one
34 (p_return_status OUT NOCOPY VARCHAR2 --Bug: 4537865
35 ,p_project_rec IN pa_projects%rowtype
36 ,p_task_rec IN pa_project_pub.task_in_rec_type
37 ,p_project_type_class_code IN pa_project_types.project_type_class_code%type
38 ,p_service_type_code IN pa_project_types.service_type_code%type
39 ,p_task_id OUT NOCOPY NUMBER ); --Bug: 4537865
40
41 PROCEDURE add_task_round_two
42 (p_return_status OUT NOCOPY VARCHAR2 --Bug: 4537865
43 ,p_project_rec IN pa_projects%rowtype
44 ,p_task_id IN NUMBER
45 ,p_task_rec IN pa_project_pub.task_in_rec_type
46 --Project Structures
47 ,p_ref_task_id IN NUMBER
48 ,p_tasks_in IN pa_project_pub.task_in_tbl_type
49 ,p_tasks_out IN pa_project_pub.task_out_tbl_type
50 ,p_task_version_id OUT NOCOPY NUMBER --Bug: 4537865
51 ,p_create_task_structure IN VARCHAR2 := 'Y' --Bug 2931183
52 --Project Structures
53 );
54
55 FUNCTION Fetch_project_id
56 (p_pm_project_reference IN VARCHAR2 )
57 RETURN NUMBER;
58
59 FUNCTION Fetch_task_id
60 (p_pa_project_id IN NUMBER
61 ,p_pm_task_reference IN VARCHAR2 )
62 RETURN NUMBER;
63
64 Procedure Convert_pm_projref_to_id
65 (p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
67 ,p_out_project_id OUT NOCOPY NUMBER --Bug: 4537865
68 ,p_return_status OUT NOCOPY VARCHAR2 ); --Bug: 4537865
69
70 Procedure Convert_pm_taskref_to_id
71 (p_pa_project_id IN NUMBER
72 ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
73 ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
74 ,p_out_task_id OUT NOCOPY NUMBER --Bug: 4537865
75 ,p_return_status OUT NOCOPY VARCHAR2 ); --Bug: 4537865
76
77 Procedure Convert_pm_taskref_to_id_all (
78 p_pa_project_id IN NUMBER,
79 p_structure_type IN VARCHAR2 := 'FINANCIAL',
80 p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
81 p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
82 p_out_task_id OUT NOCOPY NUMBER, --Bug: 4537865
83 p_return_status OUT NOCOPY VARCHAR2 ); --Bug: 4537865
84
85 FUNCTION check_valid_message (p_message IN VARCHAR2)
86 RETURN BOOLEAN ;
87
88 FUNCTION check_valid_org (p_org_id IN NUMBER )
89 RETURN VARCHAR2;
90
91 FUNCTION check_valid_project_status( p_project_status IN VARCHAR2 )
92 RETURN VARCHAR2;
93
94 FUNCTION check_valid_dist_rule (p_project_type IN VARCHAR2,
95 p_dist_rule IN VARCHAR2,
96 p_en_top_task_inv_mth_flag IN VARCHAR2 := 'N' )
97 RETURN VARCHAR2;
98
99 FUNCTION check_valid_employee (p_person_id IN NUMBER )
100 RETURN VARCHAR2;
101
102 FUNCTION check_class_code_valid (p_class_category IN VARCHAR2,
103 p_class_code IN VARCHAR2 )
104 RETURN VARCHAR2;
105
106 PROCEDURE Delete_One_Task
107 (p_task_id IN NUMBER,
108 p_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
109 p_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
110 p_msg_data OUT NOCOPY VARCHAR2 ); --Bug: 4537865
111
112 PROCEDURE Validate_billing_info
113 (p_project_id IN NUMBER, -- Added for Bug: 5643876
114 p_project_class_code IN VARCHAR2,
118 PROCEDURE check_start_end_date
115 p_in_task_rec IN pa_project_pub.task_in_rec_type,
116 p_return_status OUT NOCOPY VARCHAR2 ) ; --Bug: 4537865
117
119 ( p_return_status OUT NOCOPY VARCHAR2 --Bug: 4537865
120 ,p_old_start_date IN DATE
121 ,p_new_start_date IN DATE
122 ,p_old_end_date IN DATE
123 ,p_new_end_date IN DATE
124 ,p_update_start_date_flag OUT NOCOPY VARCHAR2 --Bug: 4537865
125 ,p_update_end_date_flag OUT NOCOPY VARCHAR2 ); --Bug: 4537865
126
127 Procedure check_for_one_manager
128 (p_project_id IN NUMBER,
129 p_person_id IN NUMBER,
130 p_key_members IN pa_project_pub.project_role_tbl_type,
131 p_start_date IN DATE,
132 p_end_date IN DATE,
133 p_return_status OUT NOCOPY VARCHAR2 ); --Bug: 4537865
134
135 Procedure handle_task_number_change
136 (p_project_id IN NUMBER,
137 p_task_id IN NUMBER,
138 p_array_cell_number IN NUMBER,
139 p_in_task_number IN VARCHAR2,
140 p_in_task_tbl IN pa_project_pub.task_in_tbl_type,
141 p_proceed_with_update_flag OUT NOCOPY VARCHAR2, --Bug: 4537865
142 p_return_status OUT NOCOPY VARCHAR2 ) ; --Bug: 4537865
143
144 Procedure check_parent_child_task_dates
145 (p_project_id IN NUMBER,
146 p_return_status OUT NOCOPY VARCHAR2 ); --Bug: 4537865
147
148 Procedure Update_One_Task
149 ( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
150 p_commit IN VARCHAR2 := FND_API.G_FALSE,
151 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152 p_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
153 p_msg_data OUT NOCOPY VARCHAR2, --Bug: 4537865
154 p_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
155 p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
156 p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
157 p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
158 p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
159 p_task_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
160 p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
161 p_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
162 p_long_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
163 p_task_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
164 p_task_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
165 p_task_completion_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
166 p_pm_parent_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
167 p_pa_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
168 p_address_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
169 p_carrying_out_organization_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
170 p_service_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
171 p_task_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
172 p_billable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
173 p_chargeable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
174 p_ready_to_bill_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
175 p_ready_to_distribute_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
176 p_limit_to_txn_controls_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
177 p_labor_bill_rate_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
178 p_labor_std_bill_rate_schdl IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
179 p_labor_schedule_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
180 p_labor_schedule_discount IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
181 p_nl_bill_rate_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
182 p_nl_std_bill_rate_schdl IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
183 p_nl_schedule_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
184 p_nl_schedule_discount IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
185 p_labor_cost_multiplier_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
186 p_cost_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
187 p_rev_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
188 p_inv_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
189 p_cost_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
190 p_rev_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
191 p_inv_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
192 p_labor_sch_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
193 p_nl_sch_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
194 p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
195 p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
196 p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
200 p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
197 p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
198 p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
199 p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
201 p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
202 p_tasks_dff IN VARCHAR2 := 'N', -- bug 13680655
203 p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
204 p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
205 p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
206 p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
207 p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
208 p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
209 p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
210 p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
211 p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
212 p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
213 p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
214 p_allow_cross_charge_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
215 p_project_rate_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
216 p_project_rate_type IN VARCHAR2 :=
217 PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
218 p_cc_process_labor_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
219 p_labor_tp_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
220 p_labor_tp_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
221 p_cc_process_nl_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
222 p_nl_tp_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
223 p_nl_tp_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
224 p_receive_project_invoice_flag IN VARCHAR2 :=
225 PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
226 p_work_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
227 p_emp_bill_rate_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
228 p_job_bill_rate_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
229 --Sakthi MCB
230 p_non_lab_std_bill_rt_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
231 p_taskfunc_cost_rate_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
232 p_taskfunc_cost_rate_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
233 --Sakthi MCB
234 p_labor_disc_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
235 p_non_labor_disc_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
236 --PA L changes -- bug 2872708 --update_task
237 p_retirement_cost_flag VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
238 p_cint_eligible_flag VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
239 p_cint_stop_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
240 --end PA L changes -- bug 2872708
241
242 --(Begin Venkat) FP_M changes ----------------------------------------------
243 p_invoice_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
244 p_customer_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
245 p_gen_etc_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
246 --(End Venkat) FP_M changes ------------------------------------------------
247
248 p_out_pa_task_id OUT NOCOPY NUMBER, --Bug: 4537865
249 p_out_pm_task_reference OUT NOCOPY VARCHAR2 ); --Bug: 4537865
250
251 PROCEDURE delete_task1
252 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
253 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
254 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
255 ,p_msg_count OUT NOCOPY NUMBER --Bug: 4537865
256 ,p_msg_data OUT NOCOPY VARCHAR2 --Bug: 4537865
257 ,p_return_status OUT NOCOPY VARCHAR2 --Bug: 4537865
258 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
259 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
260 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
261 ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
262 ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
263 ,p_cascaded_delete_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
264 ,p_project_id OUT NOCOPY NUMBER --Bug: 4537865
265 ,p_task_id OUT NOCOPY NUMBER --Bug: 4537865
266 ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
267 ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
268 );
269
270 PROCEDURE approve_project1
271 ( p_api_version_number IN NUMBER
272 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
273 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
274 ,p_msg_count OUT NOCOPY NUMBER --Bug: 4537865
275 ,p_msg_data OUT NOCOPY VARCHAR2 --Bug: 4537865
276 ,p_return_status OUT NOCOPY VARCHAR2 --Bug: 4537865
277 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
278 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
279 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
280 );
281
282 PROCEDURE delete_project1
283 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
284 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
285 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
286 ,p_msg_count OUT NOCOPY NUMBER --Bug: 4537865
287 ,p_msg_data OUT NOCOPY VARCHAR2 --Bug: 4537865
288 ,p_return_status OUT NOCOPY VARCHAR2 --Bug: 4537865
289 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
290 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
291 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
292 );
293
294 -- anlee org role changes
295 PROCEDURE add_org_roles
296 ( p_return_status OUT NOCOPY VARCHAR2 , --Bug: 4537865
297 p_pa_source_template_id IN NUMBER ,
298 p_project_id IN NUMBER ,
299 p_org_roles IN pa_project_pub.project_role_tbl_type );
300
301 -- anlee org role changes
302 FUNCTION check_valid_organization (p_party_id IN NUMBER )
303 RETURN VARCHAR2;
304
305 --Project Connect 4.0
306 PROCEDURE get_structure_version(
307 p_project_id IN NUMBER
308 ,p_structure_versions_out OUT NOCOPY PA_PROJECT_PUB.struc_out_tbl_type );
309 --Project Connect 4.0
310
311 /*Added the below two procedures for the bug 2802984*/
312 PROCEDURE Check_Schedule_type
313 (p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
314 p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
315 p_in_labor_sch_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
316 p_in_nl_sch_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
317 p_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
318 p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
319 p_out_labor_sch_type OUT NOCOPY VARCHAR, --Bug: 4537865
320 p_out_nl_labor_sch_type OUT NOCOPY VARCHAR, --Bug: 4537865
321 p_return_status OUT NOCOPY VARCHAR2 --Bug: 4537865
322 );
323
324 PROCEDURE validate_schedule_values
325 (p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
326 p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
327 p_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
328 p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
329 p_lab_db_sch_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
330 p_nl_db_sch_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
331 p_labor_sch_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
332 p_nl_sch_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
333 p_emp_bill_rate_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
334 p_job_bill_rate_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
335 p_labor_schedule_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
336 p_labor_schedule_discount IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
337 p_labor_disc_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
338 p_nl_bill_rate_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
339 p_non_lab_std_bill_rt_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
340 p_nl_schedule_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
341 p_nl_schedule_discount IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
342 p_non_labor_disc_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
343 p_rev_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
344 p_inv_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
345 p_rev_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
346 p_inv_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
347 p_return_status OUT NOCOPY VARCHAR2 --Bug: 4537865
348 );
349
350 PROCEDURE VALIDATE_DATA
351 (p_project_id IN NUMBER ,
352 p_calling_context IN VARCHAR2 ,
353 x_return_status OUT NOCOPY VARCHAR2 ,
354 X_MSG_COUNT OUT NOCOPY NUMBER ,
355 X_MSG_DATA OUT NOCOPY VARCHAR2
356 );
357
358 /* Added for Concurrency issues to get the project level locks while calling the AMG APIs */
359 Procedure CONC_LOCK_PROJECT
360 (p_project_id Number ,
361 p_lock_mode varchar2,
362 x_msg_data OUT NOCOPY VARCHAR2 ,
363 x_return_status OUT NOCOPY VARCHAR2);
364
365 PROCEDURE CONC_RELEASE_LOCK_PROJECT (p_project_id Number);
366
367 Procedure LOG_ROLLUP_EVENT(
368 p_project_id Number ,
369 p_struc_Ver_Id Number,
370 p_lock_mode varchar2 );
371
372 Procedure LOG_TASK_LEVEL_EVENT(
373 p_project_id Number,
374 p_task_id Number,
375 p_structure_version_id Number,
376 p_event_mode varchar2 );
377
378
379
380 end PA_PROJECT_PVT;
[Home] [Help]