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