1 package PA_TASKS_MAINT_PUB AUTHID CURRENT_USER as
2 /*$Header: PATSKSPS.pls 120.2 2007/02/06 10:10:20 dthakker ship $*/
3
4 -- API name : CREATE_TASK
5 -- Type : Public Procedure
6 -- Pre-reqs : None
7 -- Return Value : N/A
8 -- Parameters
9 -- p_api_version IN NUMBER := 1.0
10 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
11 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
12 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
13 -- p_validation_level IN VARCHAR2 := 100
14 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
15 -- p_debug_mode IN VARCHAR2 := 'N'
16 -- p_project_id IN NUMBER
17 -- p_reference_task_id IN NUMBER
18 -- p_reference_task_name IN VARCHAR2
19 -- p_peer_or_sub IN VARCHAR2
20 -- p_task_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
21 -- p_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
22 -- p_long_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23 -- p_task_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
24 -- p_task_manager_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
25 -- p_task_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
26 -- p_carrying_out_org_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
27 -- p_carrying_out_organization_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
28 -- p_task_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
29 -- p_priority_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30 -- p_work_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
31 -- p_service_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
32 -- p_milestone_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
33 -- p_critical_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
34 -- p_chargeable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
35 -- p_billable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
36 -- p_receive_project_invoice_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
37 -- p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
38 -- p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
39 -- p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
40 -- p_estimated_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
41 -- p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
42 -- p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
43 -- p_task_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
44 -- p_task_completion_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
45 -- p_baseline_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
46 -- p_baseline_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
47 -- p_obligation_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
48 -- p_obligation_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
49 -- p_estimate_to_complete_work IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
50 -- p_baseline_work IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
51 -- p_scheduled_work IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
52 -- p_actual_work_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
53 -- p_work_unit IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
54 -- p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55 -- p_job_bill_rate_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
56 -- p_emp_bill_rate_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
57 -- p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
58 -- p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59 -- p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
60 -- p_pm_parent_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
61 -- p_pa_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
62 -- p_address_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
63 -- p_ready_to_bill_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
64 -- p_ready_to_distribute_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
65 -- p_limit_to_txn_controls_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66 -- p_labor_bill_rate_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
67 -- p_labor_std_bill_rate_schdl IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68 -- p_labor_schedule_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
69 -- p_labor_schedule_discount IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
70 -- p_nl_bill_rate_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
71 -- p_nl_std_bill_rate_schdl IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
72 -- p_nl_schedule_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
73 -- p_nl_schedule_discount IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
74 -- p_labor_cost_multiplier_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
75 -- p_cost_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
76 -- p_rev_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
77 -- p_inv_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
78 -- p_cost_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
79 -- p_rev_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
80 -- p_inv_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
81 -- p_labor_sch_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
82 -- p_nl_sch_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
83 -- p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
84 -- p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
85 -- p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
86 -- p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
87 -- p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
88 -- p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
89 -- p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
90 -- p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
91 -- p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
92 -- p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
93 -- p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
94 -- p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
95 -- p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
96 -- p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
97 -- p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
98 -- p_allow_cross_charge_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
99 -- p_project_rate_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
100 -- p_project_rate_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
101 -- p_cc_process_labor_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
102 -- p_labor_tp_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
103 -- p_labor_tp_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
104 -- p_cc_process_nl_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
105 -- p_nl_tp_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
106 -- p_nl_tp_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
107 -- p_inc_proj_progress_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
108 -- p_taskfunc_cost_rate_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
109 -- p_taskfunc_cost_rate_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
110 -- p_non_lab_std_bill_rt_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
111 -- p_wbs_record_version_number IN NUMBER
112 -- p_labor_disc_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
113 -- p_non_labor_disc_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
114 -- p_task_id OUT NUMBER
115 -- x_return_status OUT VARCHAR2
116 -- x_msg_count OUT NUMBER
117 -- x_msg_data OUT VARCHAR2
118 --
119 -- History
120 --
121 -- 25-JUN-01 HSIU -Created
122 --
123 --
124 procedure CREATE_TASK
125 (
126 p_api_version IN NUMBER := 1.0
127 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
128 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
129 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
130 ,p_validation_level IN VARCHAR2 := 100
131 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
132 ,p_debug_mode IN VARCHAR2 := 'N'
133
134 ,p_project_id IN NUMBER
135 ,p_reference_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
136 ,p_reference_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
137 ,p_peer_or_sub IN VARCHAR2
138 ,p_task_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
139 ,p_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
140 ,p_long_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
141 ,p_task_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
142 ,p_task_manager_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
143 ,p_task_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
144 ,p_carrying_out_org_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
145 ,p_carrying_out_organization_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
146 ,p_task_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
147 ,p_priority_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
148 ,p_work_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
149 ,p_service_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
150 ,p_milestone_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
151 ,p_critical_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
152 ,p_chargeable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
153 ,p_billable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
154 ,p_receive_project_invoice_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
155 ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
156 ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
157 ,p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
158 ,p_estimated_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
159 ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
160 ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
161 ,p_task_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
162 ,p_task_completion_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
163 ,p_baseline_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
164 ,p_baseline_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
165
166 ,p_obligation_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
167 ,p_obligation_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
168 ,p_estimate_to_complete_work IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
169 ,p_baseline_work IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
170 ,p_scheduled_work IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
171 ,p_actual_work_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
172 ,p_work_unit IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
173 ,p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
174
175 ,p_job_bill_rate_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
176 ,p_emp_bill_rate_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
177 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
178 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
179 ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
180 ,p_pm_parent_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
181 ,p_pa_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
182 ,p_address_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
183 ,p_ready_to_bill_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
184 ,p_ready_to_distribute_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
185 ,p_limit_to_txn_controls_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
186 ,p_labor_bill_rate_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
187 ,p_labor_std_bill_rate_schdl IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
188 ,p_labor_schedule_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
189 ,p_labor_schedule_discount IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
190 ,p_nl_bill_rate_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
191 ,p_nl_std_bill_rate_schdl IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
192 ,p_nl_schedule_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
193 ,p_nl_schedule_discount IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
194 ,p_labor_cost_multiplier_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
195 ,p_cost_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
196 ,p_rev_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
197 ,p_inv_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
201 ,p_labor_sch_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
198 ,p_cost_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
199 ,p_rev_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
200 ,p_inv_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
202 ,p_nl_sch_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
203 ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
204 ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
205 ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
206 ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
207 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
208 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
209 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
210 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
211 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
212 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
213 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
214 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
215 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
216 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
217 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
218 ,p_allow_cross_charge_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
219 ,p_project_rate_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
220 ,p_project_rate_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
221 ,p_cc_process_labor_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
222 ,p_labor_tp_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
223 ,p_labor_tp_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
224 ,p_cc_process_nl_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
225 ,p_nl_tp_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
226 ,p_nl_tp_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
227 ,p_inc_proj_progress_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
228 ,p_taskfunc_cost_rate_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
229 ,p_taskfunc_cost_rate_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
230 ,p_non_lab_std_bill_rt_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
231 ,p_wbs_record_version_number IN NUMBER
232 ,p_labor_disc_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
233 ,p_non_labor_disc_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
234 --PA L Capital Project Changes 2872708
235 ,p_retirement_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
236 ,p_cint_eligible_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
237 ,p_cint_stop_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
238 --End PA L Capital Project Changes 2872708
239
240 ,p_task_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
241
242 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
243 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
244 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
245 );
246
247
248 -- API name : UPDATE_TASK
249 -- Type : Public Procedure
250 -- Pre-reqs : None
251 -- Return Value : N/A
252 -- Parameters
253 -- p_api_version IN NUMBER := 1.0
254 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
255 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
256 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
257 -- p_validation_level IN VARCHAR2 := 100
258 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
259 -- p_debug_mode IN VARCHAR2 := 'N'
260 -- p_project_id IN NUMBER
261 -- p_task_id IN NUMBER
262 -- p_task_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
263 -- p_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
264 -- p_long_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
265 -- p_task_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
266 -- p_task_manager_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
267 -- p_task_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
268 -- p_carrying_out_org_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
269 -- p_carrying_out_organization_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
270 -- p_task_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
271 -- p_priority_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
272 -- p_work_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
276 -- p_chargeable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
273 -- p_service_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
274 -- p_milestone_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
275 -- p_critical_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
277 -- p_billable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
278 -- p_receive_project_invoice_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
279 -- p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
280 -- p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
281 -- p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
282 -- p_estimated_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
283 -- p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
284 -- p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
285 -- p_task_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
286 -- p_task_completion_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
287 -- p_baseline_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
288 -- p_baseline_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
289 -- p_obligation_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
290 -- p_obligation_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
291 -- p_estimate_to_complete_work IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
292 -- p_baseline_work IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
293 -- p_scheduled_work IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
294 -- p_actual_work_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
295 -- p_work_unit IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
296 -- p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
297 -- p_job_bill_rate_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
298 -- p_emp_bill_rate_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
299 -- p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
300 -- p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
301 -- p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
302 -- p_pm_parent_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
303 -- p_top_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
304 -- p_wbs_level IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
305 -- p_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
306 -- p_address_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
307 -- p_ready_to_bill_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
308 -- p_ready_to_distribute_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
309 -- p_limit_to_txn_controls_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
310 -- p_labor_bill_rate_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
311 -- p_labor_std_bill_rate_schdl IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
312 -- p_labor_schedule_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
313 -- p_labor_schedule_discount IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
314 -- p_nl_bill_rate_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
315 -- p_nl_std_bill_rate_schdl IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
316 -- p_nl_schedule_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
317 -- p_nl_schedule_discount IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
318 -- p_labor_cost_multiplier_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
319 -- p_cost_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
320 -- p_rev_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
321 -- p_inv_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
322 -- p_cost_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
323 -- p_rev_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
324 -- p_inv_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
325 -- p_labor_sch_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
326 -- p_nl_sch_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
327 -- p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
328 -- p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
329 -- p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
330 -- p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
331 -- p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
332 -- p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
333 -- p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
334 -- p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
335 -- p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
336 -- p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
340 -- p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
337 -- p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
338 -- p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
339 -- p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
341 -- p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
342 -- p_allow_cross_charge_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
343 -- p_project_rate_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
344 -- p_project_rate_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
345 -- p_cc_process_labor_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
346 -- p_labor_tp_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
347 -- p_labor_tp_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
348 -- p_cc_process_nl_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
349 -- p_nl_tp_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
350 -- p_nl_tp_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
351 -- p_inc_proj_progress_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
352 -- p_taskfunc_cost_rate_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
353 -- p_taskfunc_cost_rate_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
354 -- p_non_lab_std_bill_rt_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
355 -- p_record_version_number IN NUMBER
356 -- p_wbs_record_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
357 -- p_comments IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
358 -- p_labor_disc_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
359 -- p_non_labor_disc_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
360 -- x_return_status OUT VARCHAR2
361 -- x_msg_count OUT NUMBER
362 -- x_msg_data OUT VARCHAR2
363 --
364 -- History
365 --
366 -- 25-JUN-01 HSIU -Created
367 --
368 --
369
370 procedure UPDATE_TASK
371 (
372 p_api_version IN NUMBER := 1.0
373 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
374 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
375 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
376 ,p_validation_level IN VARCHAR2 := 100
377 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
378 ,p_debug_mode IN VARCHAR2 := 'N'
379
380 ,p_project_id IN NUMBER
381 ,p_task_id IN NUMBER
382 ,p_task_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
383 ,p_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
384 ,p_long_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
385 ,p_task_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
386 ,p_task_manager_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
387 ,p_task_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
388 ,p_carrying_out_org_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
389 ,p_carrying_out_organization_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
390 ,p_task_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
391 ,p_priority_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
392 ,p_work_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
393 ,p_service_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
394 ,p_milestone_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
395 ,p_critical_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
396 ,p_chargeable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
397 ,p_billable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
398 ,p_receive_project_invoice_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
399 ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
400 ,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
401 ,p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
402 ,p_estimated_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
403 ,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
404 ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
405 ,p_task_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
406 ,p_task_completion_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
407 ,p_baseline_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
408 ,p_baseline_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
409
410 ,p_obligation_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
411 ,p_obligation_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
412 ,p_estimate_to_complete_work IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
413 ,p_baseline_work IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
417 ,p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
414 ,p_scheduled_work IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415 ,p_actual_work_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
416 ,p_work_unit IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
418
419 ,p_job_bill_rate_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
420 ,p_emp_bill_rate_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
421 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
422 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
423 ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
424 ,p_pm_parent_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
425 ,p_top_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
426 ,p_wbs_level IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
427 ,p_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
428 ,p_address_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
429 ,p_ready_to_bill_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430 ,p_ready_to_distribute_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
431 ,p_limit_to_txn_controls_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
432 ,p_labor_bill_rate_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
433 ,p_labor_std_bill_rate_schdl IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
434 ,p_labor_schedule_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
435 ,p_labor_schedule_discount IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
436 ,p_nl_bill_rate_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
437 ,p_nl_std_bill_rate_schdl IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
438 ,p_nl_schedule_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
439 ,p_nl_schedule_discount IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
440 ,p_labor_cost_multiplier_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
441 ,p_cost_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
442 ,p_rev_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
443 ,p_inv_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
444 ,p_cost_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
445 ,p_rev_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
446 ,p_inv_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
447 ,p_labor_sch_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
448 ,p_nl_sch_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
449 ,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
450 ,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
451 ,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
452 ,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
453 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
454 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
455 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
456 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
458 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
460 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
461 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
462 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
463 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
464 ,p_allow_cross_charge_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
465 ,p_project_rate_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
466 ,p_project_rate_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
467 ,p_cc_process_labor_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
468 ,p_labor_tp_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
469 ,p_labor_tp_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
470 ,p_cc_process_nl_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
471 ,p_nl_tp_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
472 ,p_nl_tp_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
473 ,p_inc_proj_progress_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
474 ,p_taskfunc_cost_rate_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
475 ,p_taskfunc_cost_rate_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
476 ,p_non_lab_std_bill_rt_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
477 ,p_record_version_number IN NUMBER
478 ,p_wbs_record_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
482 --PA L Capital Project Changes 2872708
479 ,p_comments IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
480 ,p_labor_disc_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
481 ,p_non_labor_disc_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
483 ,p_retirement_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
484 ,p_cint_eligible_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
485 ,p_cint_stop_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
486 --End PA L Capital Project Changes 2872708
487 ,p_gen_etc_src_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
488 ,p_update_subtasks_end_dt IN VARCHAR2 := 'Y' --bug 4241863
489 ,p_dates_check IN VARCHAR2 := 'Y' --bug 5665772
490 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
491 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
492 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
493 );
494
495 -- API name : DELETE_TASK
496 -- Type : Public Procedure
497 -- Pre-reqs : None
498 -- Return Value : N/A
499 -- Parameters
500 -- p_api_version IN NUMBER := 1.0
501 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
502 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
503 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
504 -- p_validation_level IN VARCHAR2 := 100
505 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
506 -- p_debug_mode IN VARCHAR2 := 'N'
507 -- p_project_id IN NUMBER
508 -- p_task_id IN NUMBER
509 -- p_record_version_number IN NUMBER
510 -- p_wbs_record_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
511
512 -- x_return_status OUT VARCHAR2
513 -- x_msg_count OUT NUMBER
514 -- x_msg_data OUT VARCHAR2
515 --
516 -- History
517 --
518 -- 25-JUN-01 HSIU -Created
519 --
520 --
521 procedure DELETE_TASK
522 (
523 p_api_version IN NUMBER := 1.0
524 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
525 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
526 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
527 ,p_validation_level IN VARCHAR2 := 100
528 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
529 ,p_debug_mode IN VARCHAR2 := 'N'
530 ,p_project_id IN NUMBER
531 ,p_task_id IN NUMBER
532 ,p_record_version_number IN NUMBER
533 ,p_wbs_record_version_number IN NUMBER
534 ,p_called_from_api IN VARCHAR2 := 'ABCD'
535 ,p_bulk_flag IN VARCHAR2 := 'N' -- 4201927
536 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
537 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
538 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
539 );
540
541
542 -- API name : Edit_Task_Structure
543 -- Type : Public Procedure
544 -- Pre-reqs : None
545 -- Return Value : N/A
546 -- Parameters
547 -- p_api_version IN NUMBER := 1.0
548 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
549 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
550 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
551 -- p_validation_level IN VARCHAR2 := 100
552 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
553 -- p_debug_mode IN VARCHAR2 := 'N'
554 -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
555 -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
556 -- p_task_id IN NUMBER := FND_API.G_MISS_NUM
557 -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
558 -- p_edit_mode IN VARCHAR2 REQUIRED
559 -- p_record_version_number IN NUMBER
560 -- p_wbs_record_version_number IN NUMBER
561 -- x_return_status OUT VARCHAR2
562 -- x_msg_count OUT NUMBER
563 -- x_msg_data OUT VARCHAR2
564 --
565 -- History
566 --
567 -- 25-JUN-01 Majid Ansari -Created
568 --
569 --
570
571 PROCEDURE Edit_Task_Structure(
572 p_api_version IN NUMBER := 1.0
573 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
574 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
575 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
576 ,p_validation_level IN VARCHAR2 := 100
577 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
578 ,p_debug_mode IN VARCHAR2 := 'N'
579 ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
580 ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
581 ,p_task_id IN NUMBER := FND_API.G_MISS_NUM
582 ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
586 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
583 ,p_edit_mode IN VARCHAR2
584 ,p_record_version_number IN NUMBER
585 ,p_wbs_record_version_number IN NUMBER
587 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
588 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
589
590
591 -- API name : Move_Task
592 -- Type : Public Procedure
593 -- Pre-reqs : None
594 -- Return Value : N/A
595 -- Prameters
596 -- p_api_version IN NUMBER := 1.0
597 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
598 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
599 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
600 -- p_validation_level IN VARCHAR2 := 100
601 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
602 -- p_debug_mode IN VARCHAR2 := 'N'
603 -- p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
604 -- p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
605 -- p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
606 -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
607 -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
608 -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
609 -- p_task_id IN NUMBER := FND_API.G_MISS_NUM
610 -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
611 -- p_peer_or_sub IN VARCHAR2
612 -- p_record_version_number IN NUMBER
613 -- p_wbs_record_version_number IN NUMBER
614
615 -- x_return_status OUT VARCHAR2
616 -- x_msg_count OUT NUMBER
617 -- x_msg_data OUT VARCHAR2
618 --
619 -- History
620 --
621 -- 25-JUN-01 Majid Ansari -Created
622 --
623 --
624
625 PROCEDURE Move_Task(
626 p_api_version IN NUMBER := 1.0
627 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
628 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
629 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
630 ,p_validation_level IN VARCHAR2 := 100
631 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
632 ,p_debug_mode IN VARCHAR2 := 'N'
633 ,p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
634 ,p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
635 ,p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
636 ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
637 ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
638 ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
639 ,p_task_id IN NUMBER := FND_API.G_MISS_NUM
640 ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
641 ,p_peer_or_sub IN VARCHAR2
642 ,p_record_version_number IN NUMBER
643 ,p_wbs_record_version_number IN NUMBER
644 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
645 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
646 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
647
648
649 -- API name : Copy_Task
650 -- Type : Public Procedure
651 -- Pre-reqs : None
652 -- Return Value : N/A
653 -- Prameters
654 -- p_api_version IN NUMBER := 1.0
655 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
656 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
657 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
658 -- p_validation_level IN VARCHAR2 := 100
659 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
660 -- p_debug_mode IN VARCHAR2 := 'N'
661 -- p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
662 -- p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
663 -- p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
664 -- p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
665 -- p_project_id IN NUMBER := FND_API.G_MISS_NUM
666 -- p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
667 -- p_task_id IN NUMBER := FND_API.G_MISS_NUM
668 -- p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
669 -- p_peer_or_sub IN VARCHAR2 REQUIRED
670 -- p_copy_node_flag IN VARCHAR2 REQUIRED
671 -- p_task_prefix IN VARCHAR2 REQUIRED
672 -- p_wbs_record_version_number IN NUMBER
673
674 -- x_return_status OUT VARCHAR2
675 -- x_msg_count OUT NUMBER
676 -- x_msg_data OUT VARCHAR2
677 --
678 -- History
679 --
680 -- 25-JUN-01 Majid Ansari -Created
681 --
682 --
683
684 PROCEDURE Copy_Task(
685 p_api_version IN NUMBER := 1.0
686 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
687 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
688 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
692 ,p_reference_project_id IN NUMBER := FND_API.G_MISS_NUM
689 ,p_validation_level IN VARCHAR2 := 100
690 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
691 ,p_debug_mode IN VARCHAR2 := 'N'
693 ,p_reference_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
694 ,p_reference_task_id IN NUMBER := FND_API.G_MISS_NUM
695 ,p_reference_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
696 ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
697 ,p_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
698 ,p_task_id IN NUMBER := FND_API.G_MISS_NUM
699 ,p_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
700 ,p_peer_or_sub IN VARCHAR2
701 ,p_copy_node_flag IN VARCHAR2
702 ,p_task_prefix IN VARCHAR2
703 ,p_wbs_record_version_number IN NUMBER
704 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
705 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
706 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
707
708 --Begin add by rtarway for FP.M development
709 TYPE task_version_id_table_type IS TABLE OF PA_PROJ_ELEMENT_VERSIONS.element_version_id%TYPE INDEX BY BINARY_INTEGER;
710
711 PROCEDURE SET_FINANCIAL_FLAG_WRAPPER
712 (
713 p_api_version IN NUMBER := 1.0
714 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
715 , p_commit IN VARCHAR2 := FND_API.G_FALSE
716 , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
717 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
718 , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
719 , p_debug_mode IN VARCHAR2 := 'N'
720 , p_task_version_id IN NUMBER
721 , p_checked_flag IN VARCHAR2
722 , p_record_version_number IN NUMBER
723 , p_project_id IN NUMBER
724 , p_published_version_exists IN VARCHAR2
725 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
726 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
727 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
728 );
729
730
731 --TYPE fin_tasks_temp_record_type IS RECORD ( PA_PREVIEW_FIN_TASKS_TEMP_ROW PA_PREVIEW_FIN_TASKS_TEMP%ROWTYPE );
732
733 TYPE fin_tasks_temp_record_type IS RECORD
734 (
735 PROJECT_ID pa_proj_element_versions.project_id%type
736 , ELEMENT_VERSION_ID pa_proj_element_versions.element_version_id%type
737 , PARENT_STRUCTURE_VERSION_ID pa_proj_element_versions.parent_structure_version_id%type
738 , PARENT_ELEMENT_VERSION_ID pa_object_relationships.object_id_from1%type
739 , CHILD_ELEMENT_FLAG VARCHAR2(1)
740 , TASK_NAME pa_proj_elements.name%type
741 , TASK_NUMBER pa_proj_elements.element_number%type
742 , OBJECT_TYPE pa_proj_element_versions.object_type%type
743 , DISPLAY_SEQUENCE pa_proj_element_versions.display_sequence%type
744 , WBS_NUMBER pa_proj_element_versions.wbs_number%type
745 , PROJ_ELEMENT_ID pa_proj_element_versions.proj_element_id%type
746 , FINANCIAL_TASK_FLAG pa_proj_element_versions.financial_task_flag%type
747 );
748
749 TYPE project_id_table_type IS TABLE OF pa_proj_element_versions.project_id%type INDEX BY BINARY_INTEGER;
750 TYPE ELEMENT_VERSION_ID_table_type IS TABLE OF pa_proj_element_versions.element_version_id%type INDEX BY BINARY_INTEGER;
751 TYPE PRNT_STRUCT_VER_ID_table_type IS TABLE OF pa_proj_element_versions.parent_structure_version_id%type INDEX BY BINARY_INTEGER;
752 TYPE PRNT_ELEM_VER_ID_table_type IS TABLE OF pa_object_relationships.object_id_from1%type INDEX BY BINARY_INTEGER;
753 TYPE CHILD_ELEMENT_FLAG_table_type IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
754 TYPE TASK_NAME_table_type IS TABLE OF pa_proj_elements.name%type INDEX BY BINARY_INTEGER;
755 TYPE TASK_NUMBER_table_type IS TABLE OF pa_proj_elements.element_number%type INDEX BY BINARY_INTEGER;
756 TYPE OBJECT_TYPE_table_type IS TABLE OF pa_proj_element_versions.object_type%type INDEX BY BINARY_INTEGER;
757 TYPE DISPLAY_SEQUENCE_table_type IS TABLE OF pa_proj_element_versions.display_sequence%type INDEX BY BINARY_INTEGER;
758 TYPE WBS_NUMBER_table_type IS TABLE OF pa_proj_element_versions.wbs_number%type INDEX BY BINARY_INTEGER;
759 TYPE PROJ_ELEMENT_ID_table_type IS TABLE OF pa_proj_element_versions.proj_element_id%type INDEX BY BINARY_INTEGER;
760 TYPE FINANCIAL_TASK_FLAG_table_type IS TABLE OF pa_proj_element_versions.financial_task_flag%type INDEX BY BINARY_INTEGER;
761
762 --TYPE fin_tasks_temp_table_type IS TABLE OF fin_tasks_temp_record_type INDEX BY BINARY_INTEGER;
763
764 PROCEDURE POPULATE_TEMP_TABLE
765 (
766 p_api_version IN NUMBER := 1.0
767 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
768 , p_commit IN VARCHAR2 := FND_API.G_FALSE
769 , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
770 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
771 , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
772 , p_debug_mode IN VARCHAR2 := 'N'
773 , p_task_version_id_array IN SYSTEM.PA_NUM_TBL_TYPE := NULL
774 , p_structure_version_id IN NUMBER
775 , p_project_id IN NUMBER
776 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
777 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
778 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
779 );
780 PROCEDURE SYNC_UP_WP_TASKS_WITH_FIN
781 (
782 p_api_version IN NUMBER := 1.0
783 , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
784 , p_commit IN VARCHAR2 := FND_API.G_FALSE
785 , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
786 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
787 , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
788 , p_debug_mode IN VARCHAR2 := 'N'
789 , p_patask_record_version_number IN NUMBER := FND_API.G_MISS_NUM
790 , p_parent_task_version_id IN NUMBER := FND_API.G_MISS_NUM
791 , p_project_id IN NUMBER
792 , p_syncup_all_tasks IN VARCHAR2 := 'N'
793 , p_task_version_id IN NUMBER := FND_API.G_MISS_NUM
794 , p_structure_version_id IN NUMBER := FND_API.G_MISS_NUM
795 , p_check_for_transactions IN VARCHAR2 := 'N'
796 , p_checked_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
797 , p_mode IN VARCHAR2 := 'SINGLE'
798 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
799 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
800 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
801 );
802
803 --End add by rtarway for FP.M development
804 end PA_TASKS_MAINT_PUB;