1 PACKAGE PA_TASK_PUB1 AUTHID DEFINER AS
2 /* $Header: PATSK1PS.pls 120.13.12020000.4 2013/03/28 09:53:26 bpottipa ship $ */
3
4 G_CALL_PJI_ROLLUP VARCHAR2(1); --bug 4075697
5
6 -- API name : Create_Task
7 -- Type : Public procedure
8 -- Pre-reqs : None
9 -- Return Value : N/A
10 -- Prameters
11 -- p_api_version IN NUMBER N Not Null 1.0
12 -- p_init_msg_list IN VARCHAR2 N Not Null FND_API.TRUE
13 -- p_commit IN VARCHAR2 N Not Null FND_API.G_FALSE
14 -- p_validate_only IN VARCHAR2 N Not Null FND_API.G_TRUE
15 -- p_validation_level IN NUMBER N Null FND_API.G_VALID_LEVEL_FULL
16 -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
17 -- p_debug_mode IN VARCHAR2 N Null N
18 -- p_context IN VARCHAR2 N Null TASK
19 -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20 -- p_object_type IN VARCHAR2 N Not Null
21 -- p_project_id IN NUMBER N Not Null
22 -- p_task_number IN VARCHAR2 N Not Null
23 -- p_task_name IN VARCHAR2 N Not Null
24 -- p_task_description IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
25 -- p_location_id IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
26 -- p_country IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
27 -- p_territory_code IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
28 -- p_state_region IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
29 -- p_city IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30 -- p_task_manager_id IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
31 -- p_task_manager_name IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
32 -- p_carrying_out_org_id IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
33 -- p_carrying_out_org_name IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
34 -- p_priority_code IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
35 -- p_TYPE_ID IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
36 -- p_status_code IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
37 -- p_inc_proj_progress_flag IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
38 -- p_pm_product_code IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
39 -- p_pm_task_reference IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
40 -- p_closed_date IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41 -- p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
42 -- p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43 -- p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
44 -- p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
45 -- p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
46 -- p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
47 -- p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48 -- p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49 -- p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50 -- p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51 -- p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
52 -- p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
53 -- p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
54 -- p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55 -- p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
56 -- p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57 --FP M development
58 -- p_structure_type IN VARCHAR2 := 'WORKPLAN',
59 -- p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
60 --End FPM changes
61 -- x_task_id OUT NUMBER N Not Null
62 -- x_return_status OUT VARCHAR2 N Null
63 -- x_msg_count OUT NUMBER N Null
64 -- x_msg_data OUT VARCHAR2 N Null
65 --
66 -- History
67 --
68 -- 23-OCT-01 Majid Ansari -Created
69 --
70 --
71
72 PROCEDURE Create_Task(
73 p_api_version IN NUMBER :=1.0,
74 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
75 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
76 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
77 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
78 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
79 p_debug_mode IN VARCHAR2 :='N',
80 p_context IN VARCHAR2 :='TASK', -- bug#11928067
81 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
82 p_object_type IN VARCHAR2,
83 p_project_id IN NUMBER,
84 p_structure_id IN NUMBER,
85 p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
86 p_task_number IN VARCHAR2,
87 p_task_name IN VARCHAR2,
88 p_ref_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
89 p_peer_or_sub IN VARCHAR2 :='PEER',
90 p_task_description IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
91 p_location_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
92 p_country IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
93 p_territory_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
94 p_state_region IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
95 p_city IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
96 p_task_manager_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
97 p_task_manager_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
98 p_carrying_out_org_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
99 p_carrying_out_org_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
100 p_priority_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
101 p_TYPE_ID IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
102 p_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
103 p_inc_proj_progress_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
104 p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
105 p_pm_task_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
106 p_closed_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
107 p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
108 p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
109 p_link_task_flag IN VARCHAR2 := 'N',
110 p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
111 p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
112 p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
113 p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
114 p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
115 p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
116 p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
117 p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
118 p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
119 p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
120 p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
121 p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
122 p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
123 p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
124 p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
125 p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
126
127 p_address_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
128 p_address1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
129 p_work_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
130 p_service_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
131 p_chargeable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
132 p_billable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
133 p_receive_project_invoice_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
134
135 p_task_weighting_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
136 p_work_item_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
137 p_uom_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
138 p_wq_actual_entry_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
139 p_task_progress_entry_page_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
140 p_task_progress_entry_page IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
141 p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
142 p_phase_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
143 p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
144 -- xxlu added task DFF attributes
145 p_tk_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
146 p_tk_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
147 p_tk_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
148 p_tk_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
149 p_tk_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
150 p_tk_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
151 p_tk_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
152 p_tk_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
153 p_tk_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
154 p_tk_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
155 p_tk_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
156 -- end xxlu changes
157 --FP M development bug 330119
158 p_structure_type IN VARCHAR2 := 'WORKPLAN',
159 p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
160 p_Base_Perc_Comp_Deriv_Code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
161 --End FPM changes bug 330119
162 --bug 13923366
163 p_pm_source_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
164 --bug 13923366
165 x_task_id IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
166 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
167 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
168 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
169 );
170
171 -- API name : Update_Task
172 -- Type : Public procedure
173 -- Pre-reqs : None
174 -- Return Value : N/A
175 -- Prameters
176 -- p_api_version IN NUMBER N Not Null 1.0
177 -- p_init_msg_list IN VARCHAR2 N Not Null FND_API.TRUE
178 -- p_commit IN VARCHAR2 N Not Null FND_API.G_FALSE
179 -- p_validate_only IN VARCHAR2 N Not Null FND_API.G_TRUE
180 -- p_validation_level IN NUMBER N Null FND_API.G_VALID_LEVEL_FULL
181 -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
182 -- p_debug_mode IN VARCHAR2 N Null N
183 -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
184 -- p_task_id IN NUMBER N Not Null
185 -- p_task_number IN VARCHAR2 N Not Null
186 -- p_task_name IN VARCHAR2 N Not Null
187 -- p_task_description IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
188 -- p_location_id IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
189 -- p_country IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
190 -- p_territory_code IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
191 -- p_state_region IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
192 -- p_city IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
193 -- p_task_manager_id IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
194 -- p_task_manager_name IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
195 -- p_carrying_out_org_id IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
196 -- p_carrying_out_org_name IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
197 -- p_priority_code IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
198 -- p_TYPE_ID IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
199 -- p_status_code IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
200 -- p_inc_proj_progress_flag IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
201 -- p_pm_product_code IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
202 -- p_pm_task_reference IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
203 -- p_closed_date IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
204 -- p_transaction_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
205 -- p_transaction_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
206 -- p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
207 -- p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
208 -- p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
209 -- p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
210 -- p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
211 -- p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
212 -- p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
213 -- p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
214 -- p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
215 -- p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
216 -- p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
217 -- p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
218 -- p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
219 -- p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
220 -- p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
221 -- p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
222 -- p_record_version_number IN NUMBER N Not Null
223 -- x_return_status OUT VARCHAR2 N Null
224 -- x_msg_count OUT NUMBER N Null
225 -- x_msg_data OUT VARCHAR2 N Null
226 --
227 -- History
228 --
229 -- 23-OCT-01 Majid Ansari -Created
230 -- 31-JUL-02 H Siu -Added transaction dates
231 --
232 --
233
234 PROCEDURE Update_Task(
235 p_api_version IN NUMBER :=1.0,
236 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
237 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
238 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
239 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
240 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
241 p_debug_mode IN VARCHAR2 :='N',
242 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
243 p_ref_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
244 p_peer_or_sub IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
245 p_task_id IN NUMBER,
246 p_task_number IN VARCHAR2,
247 p_task_name IN VARCHAR2,
248 p_task_description IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
249 p_location_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
250 p_country IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
251 p_territory_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
252 p_state_region IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
253 p_city IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
254 p_task_manager_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
255 p_task_manager_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
256 p_carrying_out_org_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
257 p_carrying_out_org_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
258 p_priority_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
259 p_TYPE_ID IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
260 p_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
261 p_inc_proj_progress_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
262 p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
263 P_PM_SOURCE_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Added for Huawei 15876400
264 p_pm_task_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
265 p_closed_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
266 p_transaction_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
267 p_transaction_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
268 p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
269 p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
270 p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
271 p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
272 p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
273 p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
274 p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
275 p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
276 p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
277 p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
278 p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
279 p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
280 p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
281 p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
282 p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
283 p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
284
285 p_address_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
286 p_address1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
287 p_work_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
288 p_service_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
289 p_chargeable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
290 p_billable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
291 p_receive_project_invoice_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
292
293 p_task_weighting_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
294 p_work_item_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
295 p_uom_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
296 p_wq_actual_entry_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
297 p_task_progress_entry_page_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
298 p_task_progress_entry_page IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
299 p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
300 p_phase_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
301 p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
302
303 p_record_version_number IN NUMBER,
304 -- xxlu added task DFF attributes
305 p_tk_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
306 p_tk_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
307 p_tk_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
308 p_tk_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
309 p_tk_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
310 p_tk_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
311 p_tk_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
312 p_tk_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
313 p_tk_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
314 p_tk_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
315 p_tk_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
316 -- end xxlu changes
317 p_Base_Perc_Comp_Deriv_Code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- This param added for FP_M changes 3305199
318 p_gen_etc_src_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
319 -- Bug#3491609 : Workflow Chanegs FP M
320 p_wf_item_type IN pa_proj_elements.wf_item_type%TYPE :=NULL,
321 p_wf_process IN pa_proj_elements.wf_process%TYPE :=NULL,
322 p_wf_lead_days IN pa_proj_elements.wf_start_lead_days%TYPE :=NULL,
323 p_wf_enabled_flag IN pa_proj_elements.enable_wf_flag%TYPE :=NULL,
324 -- Bug#3491609 : Workflow Chanegs FP M
325 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
326 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
327 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
328 p_shared IN VARCHAR2 := 'X' -- Bug 3451073
329 ,p_dates_check IN VARCHAR2 := 'Y' --bug 8301015
330 );
331
332 -- API name : Create_Task_version
333 -- Type : Public procedure
334 -- Pre-reqs : None
335 -- Return Value : N/A
336 -- Prameters
337 -- p_api_version IN NUMBER N Not Null 1.0
338 -- p_init_msg_list IN VARCHAR2 N Not Null FND_API.TRUE
339 -- p_commit IN VARCHAR2 N Not Null FND_API.G_FALSE
340 -- p_validate_only IN VARCHAR2 N Not Null FND_API.G_TRUE
341 -- p_validation_level IN NUMBER N Null FND_API.G_VALID_LEVEL_FULL
342 -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
343 -- p_debug_mode IN VARCHAR2 N Null N
344 -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
345 -- p_ref_task_version_id IN NUMBER N Not Null
346 -- p_peer_or_sub IN VARCHAR2 N Not Null
347 -- p_task_id IN NUMBER N Not Null
348 -- p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
349 -- p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
350 -- p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
351 -- p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
352 -- p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
353 -- p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
354 -- p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
355 -- p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
356 -- p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
357 -- p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
358 -- p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
359 -- p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
360 -- p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
361 -- p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
362 -- p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
363 -- p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
364 -- x_task_version_id OUT NUMBER N Null
365 -- x_return_status OUT VARCHAR2 N Null
366 -- x_msg_count OUT NUMBER N Null
367 -- x_msg_data OUT VARCHAR2 N Null
368 --
369 -- History
370 --
371 -- 23-OCT-01 Majid Ansari -Created
372 --
373 --
374
375 PROCEDURE Create_Task_Version(
376 p_api_version IN NUMBER :=1.0,
377 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
378 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
379 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
380 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
381 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
382 p_debug_mode IN VARCHAR2 :='N',
383 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
384 p_ref_task_version_id IN NUMBER,
385 p_peer_or_sub IN VARCHAR2,
386 p_task_id IN NUMBER,
387 p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
388 p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
389 p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
390 p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
391 p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
392 p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
393 p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
394 p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
395 p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
396 p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
397 p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
398 p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
399 p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
400 p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
401 p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
402 p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
403
404 p_WEIGHTING_PERCENTAGE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
405 p_TASK_UNPUB_VER_STATUS_CODE IN VARCHAR2 := NULL,
406 --bug 3301192
407 p_financial_task_flag IN VARCHAR2 := 'N',
408 --bug 3301192
409 x_task_version_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
410 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
411 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
412 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
413 );
414
415 -- API name : Update_Task_version
416 -- Type : Public procedure
417 -- Pre-reqs : None
418 -- Return Value : N/A
419 -- Prameters
420 -- p_api_version IN NUMBER N Not Null 1.0
421 -- p_init_msg_list IN VARCHAR2 N Not Null FND_API.TRUE
422 -- p_commit IN VARCHAR2 N Not Null FND_API.G_FALSE
423 -- p_validate_only IN VARCHAR2 N Not Null FND_API.G_TRUE
424 -- p_validation_level IN NUMBER N Null FND_API.G_VALID_LEVEL_FULL
425 -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
426 -- p_debug_mode IN VARCHAR2 N Null N
427 -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
428 -- p_task_version_id IN NUMBER N Null
429 -- p_record_version_number IN NUMBER
430 -- p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
431 -- p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
432 -- p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
433 -- p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
434 -- p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
435 -- p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
436 -- p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
437 -- p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
438 -- p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
439 -- p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
440 -- p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
441 -- p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
442 -- p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
443 -- p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
444 -- p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
445 -- p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
446 -- x_return_status OUT VARCHAR2 N Null
447 -- x_msg_count OUT NUMBER N Null
448 -- x_msg_data OUT VARCHAR2 N Null
449 --
450 -- History
451 --
452 -- 23-OCT-01 Majid Ansari -Created
453 --
454 --
455
456 PROCEDURE Update_Task_Version(
457 p_api_version IN NUMBER :=1.0,
458 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
459 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
460 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
461 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
462 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
463 p_debug_mode IN VARCHAR2 :='N',
464 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
465 p_ref_task_version_id IN NUMBER,
466 p_peer_or_sub IN VARCHAR2,
467 p_task_version_id IN NUMBER,
468 p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
469 p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
470 p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
471 p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
472 p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
473 p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
474 p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
475 p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
476 p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
477 p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
478 p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
479 p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
480 p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
481 p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
482 p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
483 p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
484 p_record_version_number IN NUMBER,
485 p_action IN VARCHAR2 := 'NULL',
486
487 p_WEIGHTING_PERCENTAGE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
488 p_TASK_UNPUB_VER_STATUS_CODE IN VARCHAR2 := NULL,
489
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_version
496 -- Type : Public procedure
497 -- Pre-reqs : None
498 -- Return Value : N/A
499 -- Prameters
500 -- p_api_version IN NUMBER N Not Null 1.0
501 -- p_init_msg_list IN VARCHAR2 N Not Null FND_API.TRUE
502 -- p_commit IN VARCHAR2 N Not Null FND_API.G_FALSE
503 -- p_validate_only IN VARCHAR2 N Not Null FND_API.G_TRUE
504 -- p_validation_level IN NUMBER N Null FND_API.G_VALID_LEVEL_FULL
505 -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
506 -- p_debug_mode IN VARCHAR2 N Null N
507 -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
508 -- p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
509 -- p_task_version_id IN NUMBER N Null
510 -- p_record_version_number IN NUMBER
511 -- x_return_status OUT VARCHAR2 N Null
512 -- x_msg_count OUT NUMBER N Null
513 -- x_msg_data OUT VARCHAR2 N Null
514 --
515 -- History
516 --
517 -- 23-OCT-01 Majid Ansari -Created
518 --
519 --
520
521 PROCEDURE Delete_Task_Version(
522 p_api_version IN NUMBER :=1.0,
523 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
524 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
525 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
526 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
527 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
528 p_debug_mode IN VARCHAR2 :='N',
529 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
530 p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
531 p_task_version_id IN NUMBER,
532 p_record_version_number IN NUMBER,
533 p_called_from_api IN VARCHAR2 := 'ABCD',
534 p_structure_type IN VARCHAR2 := 'WORKPLAN', --bug 3301192
535 p_calling_from IN VARCHAR2 := 'XYZ', -- Bug 6023347
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 -- API name : Create_Schedule_Version
542 -- Type : Public procedure
543 -- Pre-reqs : None
544 -- Return Value : N/A
545 -- Prameters
546 -- p_api_version IN NUMBER N Not Null 1.0
547 -- p_init_msg_list IN VARCHAR2 N Not Null FND_API.TRUE
548 -- p_commit IN VARCHAR2 N Not Null FND_API.G_FALSE
549 -- p_validate_only IN VARCHAR2 N Not Null FND_API.G_TRUE
550 -- p_validation_level IN NUMBER N Null FND_API.G_VALID_LEVEL_FULL
551 -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
552 -- p_debug_mode IN VARCHAR2 N Null N
553 -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
554 -- p_element_version_id IN NUMBER N Not Null
555 -- p_calendar_id IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
556 -- p_calendar_name IN VARCHAR2 N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
557 -- p_scheduled_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
558 -- p_scheduled_end_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
559 -- p_obligation_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
560 -- p_obligation_end_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
561 -- p_actual_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
562 -- p_actual_finish_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
563 -- p_estimate_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
564 -- p_estimate_finish_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
565 -- p_duration IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
566 -- p_early_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
567 -- p_early_end_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
568 -- p_late_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
569 -- p_late_end_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
570 -- p_milestone_flag IN VARCHAR2 N NULL N
571 -- p_critical_flag IN VARCHAR2 N NULL N
572 -- x_pev_schedule_id OUT NUMBER N NULL
573 -- x_return_status OUT VARCHAR2 N Null
574 -- x_msg_count OUT NUMBER N Null
575 -- x_msg_data OUT VARCHAR2 N Null
576 --
577 -- History
578 --
579 -- 23-OCT-01 Majid Ansari -Created
580 -- 16-OCT-02 XXLU - Added DFF parameters.
581 --
582
583 PROCEDURE Create_Schedule_Version(
584 p_api_version IN NUMBER :=1.0,
585 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
586 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
587 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
588 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
589 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
590 p_debug_mode IN VARCHAR2 :='N',
591 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
592 p_element_version_id IN NUMBER,
593 p_calendar_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
594 p_calendar_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
595 p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
596 p_scheduled_end_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
597 p_obligation_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
598 p_obligation_end_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
599 p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
600 p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
601 p_estimate_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
602 p_estimate_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
603 p_duration IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
604 p_early_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
605 p_early_end_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
606 p_late_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
607 p_late_end_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
608 p_milestone_flag IN VARCHAR2 :='N',
609 p_critical_flag IN VARCHAR2 :='N',
610
611 p_WQ_PLANNED_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
612 p_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
613 p_PLANNED_EQUIP_EFFORT IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --bug 3305199
614
615 --bug 3305199 schedule options
616 p_def_sch_tool_tsk_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
617 p_def_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
618 p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
619 p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
620 p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
621 p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
622 p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
623 p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
624 --end bug 3305199
625 p_ext_act_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
626 p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
627 p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
628 p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
629 p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
630 p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
631 p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
632 p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
633 p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
634 p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
635 p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
636 p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
637 p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
638 p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
639 p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
640 p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
641 p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
642 p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
643 p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
644 x_pev_schedule_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
645 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
646 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
647 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
648 );
649
650
651 -- API name : Update_Schedule_Version
652 -- Type : Public procedure
653 -- Pre-reqs : None
654 -- Return Value : N/A
655 -- Prameters
656 -- p_api_version IN NUMBER N Not Null 1.0
657 -- p_init_msg_list IN VARCHAR2 N Not Null FND_API.TRUE
658 -- p_commit IN VARCHAR2 N Not Null FND_API.G_FALSE
659 -- p_validate_only IN VARCHAR2 N Not Null FND_API.G_TRUE
660 -- p_validation_level IN NUMBER N Null FND_API.G_VALID_LEVEL_FULL
661 -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
662 -- p_debug_mode IN VARCHAR2 N Null N
663 -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
664 -- p_element_version_id IN NUMBER N Not Null
665 -- p_calendar_id IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
666 -- p_calendar_name IN VARCHAR2 N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
667 -- p_scheduled_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
668 -- p_scheduled_end_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
669 -- p_obligation_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
670 -- p_obligation_end_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
671 -- p_actual_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
672 -- p_actual_finish_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
673 -- p_estimate_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
674 -- p_estimate_finish_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
675 -- p_duration IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
676 -- p_early_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
677 -- p_early_end_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
678 -- p_late_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
679 -- p_late_end_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
680 -- p_milestone_flag IN VARCHAR2 N NULL N
681 -- p_critical_flag IN VARCHAR2 N NULL N
682 -- x_pev_schedule_id OUT NUMBER N NULL
683 -- x_return_status OUT VARCHAR2 N Null
684 -- x_msg_count OUT NUMBER N Null
685 -- x_msg_data OUT VARCHAR2 N Null
686 --
687 -- History
688 --
689 -- 23-OCT-01 Majid Ansari -Created
690 -- 16-OCT-02 XXLU - Added DFF parameters.
691 --
692
693 PROCEDURE Update_Schedule_Version(
694 p_api_version IN NUMBER :=1.0,
695 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
696 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
697 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
698 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
699 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
700 p_debug_mode IN VARCHAR2 :='N',
701 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
702 p_pev_schedule_id IN NUMBER,
703 p_calendar_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
704 p_calendar_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
705 p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
706 p_scheduled_end_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
707 p_obligation_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
708 p_obligation_end_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
709 p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
710 p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
711 p_estimate_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
712 p_estimate_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
713 p_duration IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
714 p_early_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
715 p_early_end_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
716 p_late_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
717 p_late_end_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
718 p_milestone_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 2791410
719 p_critical_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 2791410
720
721 p_WQ_PLANNED_QUANTITY IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
722 p_PLANNED_EFFORT IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
723 p_PLANNED_EQUIP_EFFORT IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --bug 3305199
724
725 --bug 3305199 schedule options
726 p_def_sch_tool_tsk_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
727 p_def_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
728 p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
729 p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
730 p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
731 p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
732 p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
733 p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
734 --end bug 3305199
735
736 p_record_version_number IN NUMBER,
737 p_ext_act_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
738 p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
739 p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
740 p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
741 p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
742 p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
743 p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
744 p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
745 p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
746 p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
747 p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
748 p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
749 p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
750 p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
751 p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
752 p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
753 p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
754 p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
755 p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
756 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
757 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
758 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
759 );
760
761 -- API name : Copy_Task
762 -- Type : Public procedure
763 -- Pre-reqs : None
764 -- Return Value : N/A
765 -- Prameters
766 -- p_api_version IN NUMBER N Not Null 1.0
767 -- p_init_msg_list IN VARCHAR2 N Not Null FND_API.TRUE
768 -- p_commit IN VARCHAR2 N Not Null FND_API.G_FALSE
769 -- p_validate_only IN VARCHAR2 N Not Null FND_API.G_TRUE
770 -- p_validation_level IN NUMBER N Null FND_API.G_VALID_LEVEL_FULL
771 -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
772 -- p_debug_mode IN VARCHAR2 N Null N
773 -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
774 -- p_src_project_id IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
775 -- p_src_project_name IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
776 -- p_src_structure_id IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
777 -- p_src_structure_name IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
778 -- p_src_structure_version_id IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
779 -- p_src_structure_version_name IN VARCHAR2 N null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
780 -- p_src_task_version_id IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
781 -- p_src_task_name IN VARCHAR2 N null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
782 -- p_dest_structure_id IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
783 -- p_dest_structure_version_id IN NUMBER N NOT Null
784 -- p_dest_task_version_id IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
785 -- p_dest_project_id IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
786 -- p_task_unpub_ver_status_code IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
787 --p_fin_task_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
788 -- p_sharing_enabled IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
789 -- p_versioning_enabled IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
790 -- p_copy_external_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
791 -- p_copy_option IN VARCHAR2 N NOT NULL
792 -- p_peer_or_sub IN VARCHAR2 N Not Null
793 -- x_return_status OUT VARCHAR2 N Null
794 -- x_msg_count OUT NUMBER N Null
795 -- x_msg_data OUT VARCHAR2 N Null
796 --
797 -- History
798 --
799 -- 23-OCT-01 Majid Ansari -Created
800 --
801 --
802
803 PROCEDURE Copy_Task(
804 p_api_version IN NUMBER :=1.0,
805 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
806 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
807 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
808 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
809 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
810 p_debug_mode IN VARCHAR2 :='N',
811 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
812 p_src_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
813 p_src_project_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
814 p_src_structure_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
815 p_src_structure_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
816 p_src_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
817 p_src_structure_version_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
818 p_src_task_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
819 p_src_task_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
820 p_dest_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
821 p_dest_structure_version_id IN NUMBER,
822 p_dest_task_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
823 p_dest_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- 4201927
824 p_task_unpub_ver_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
825 p_fin_task_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
826 p_sharing_enabled IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
827 p_versioning_enabled IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
828 p_copy_external_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
829 p_called_from_api IN VARCHAR2 := 'ABCD',
830 p_copy_option IN VARCHAR2,
831 p_peer_or_sub IN VARCHAR2,
832 p_prefix IN VARCHAR2,
833 -- Added for FP_M changes. Refer to tracking Bug 3305199
834 p_structure_type IN VARCHAR2 :='WORKPLAN',
835 p_cp_dependency_flag IN VARCHAR2 :='N',
836 p_cp_deliverable_asso_flag IN VARCHAR2 :='N',
837 p_cp_tk_assignments_flag IN VARCHAR2 :='N',
838 p_cp_cost_code_flag IN VARCHAR2 :='N', -- bug#16083858
839 p_cp_people_flag IN VARCHAR2 :='N',
840 p_cp_financial_elem_flag IN VARCHAR2 :='N',
841 p_cp_material_items_flag IN VARCHAR2 :='N',
842 p_cp_equipment_flag IN VARCHAR2 :='N',
843 -- End of FP_M changes
844 p_called_from_bulk_api IN VARCHAR2 :='N',
845 p_user_defn_att_flag IN VARCHAR2 :='N', -- Added for 14209636
846 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
847 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
848 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
849 );
850
851 -- API name : Move_Task
852 -- Type : Public procedure
853 -- Pre-reqs : None
854 -- Return Value : N/A
855 -- Prameters
856 -- p_api_version IN NUMBER N Not Null 1.0
857 -- p_init_msg_list IN VARCHAR2 N Not Null FND_API.TRUE
858 -- p_commit IN VARCHAR2 N Not Null FND_API.G_FALSE
859 -- p_validate_only IN VARCHAR2 N Not Null FND_API.G_TRUE
860 -- p_validation_level IN NUMBER N Null FND_API.G_VALID_LEVEL_FULL
861 -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
862 -- p_debug_mode IN VARCHAR2 N Null N
863 -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
864 -- p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
865 -- p_task_version_id IN NUMBER N Not Null
866 -- p_ref_task_version_id IN NUMBER N Not Null
867 -- p_peer_or_sub IN VARCHAR2 N Not Null
868 -- prefix IN VARCHAR2 N Not Null
869 -- p_called_from_bulk_api IN VARCHAR2 N Null 'N'
870 -- x_return_status OUT VARCHAR2 N Null
871 -- x_msg_count OUT NUMBER N Null
872 -- x_msg_data OUT VARCHAR2 N Null
873 --
874 -- History
875 --
876 -- 13-NOV-01 Andrew Lee -Created
877 --
878 --
879
880 PROCEDURE MOVE_TASK_VERSION (
881 p_api_version IN NUMBER := 1.0,
882 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
883 p_commit IN VARCHAR2 := FND_API.G_FALSE,
884 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
885 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
886 p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
887 p_debug_mode IN VARCHAR2 := 'N',
888 p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
889 p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
890 p_task_version_id IN NUMBER,
891 p_ref_task_version_id IN NUMBER,
892 /*4269830 : Performance Enhancements : Start*/
893 p_ref_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
894 p_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
895 p_published_version IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
896 p_shared IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
897 p_sharing_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
898 p_versioned IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
899 p_wp_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
900 p_fin_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
901 p_weighting_basis_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
902 p_check_third_party_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
903 /*4269830 : Performance Enhancements : End */
904 p_peer_or_sub IN VARCHAR2,
905 p_record_version_number IN NUMBER,
906 p_called_from_bulk_api IN VARCHAR2 := 'N',
907 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
908 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
909 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
910 ) ;
911 -- API name : Indent_Task_Version
912 -- Type : Public procedure
913 -- Pre-reqs : None
914 -- Return Value : N/A
915 -- Prameters
916 -- p_api_version IN NUMBER N Not Null 1.0
917 -- p_init_msg_list IN VARCHAR2 N Not Null FND_API.TRUE
918 -- p_commit IN VARCHAR2 N Not Null FND_API.G_FALSE
919 -- p_validate_only IN VARCHAR2 N Not Null FND_API.G_TRUE
920 -- p_validation_level IN NUMBER N Null FND_API.G_VALID_LEVEL_FULL
921 -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
922 -- p_debug_mode IN VARCHAR2 N Null N
923 -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
924 -- p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
925 -- p_task_version_id IN NUMBER N Not Null
926 -- x_return_status OUT VARCHAR2 N Null
927 -- x_msg_count OUT NUMBER N Null
928 -- x_msg_data OUT VARCHAR2 N Null
929 --
930 -- History
931 --
932 -- 23-OCT-01 Andrew Lee -Created
933 --
934 --
935
936 PROCEDURE INDENT_TASK_VERSION (
937 p_api_version IN NUMBER :=1.0,
938 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
939 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
940 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
941 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
942 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
943 p_debug_mode IN VARCHAR2 :='N',
944 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
945 p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
946 p_task_version_id IN NUMBER,
947 p_record_version_number IN NUMBER,
948 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
949 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
950 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
951 ) ;
952
953 -- API name : Outdent_Task_Version
954 -- Type : Public procedure
955 -- Pre-reqs : None
956 -- Return Value : N/A
957 -- Prameters
958 -- p_api_version IN NUMBER N Not Null 1.0
959 -- p_init_msg_list IN VARCHAR2 N Not Null FND_API.TRUE
960 -- p_commit IN VARCHAR2 N Not Null FND_API.G_FALSE
961 -- p_validate_only IN VARCHAR2 N Not Null FND_API.G_TRUE
962 -- p_validation_level IN NUMBER N Null FND_API.G_VALID_LEVEL_FULL
963 -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
964 -- p_debug_mode IN VARCHAR2 N Null N
965 -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
966 -- p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
967 -- p_task_version_id IN NUMBER N Not Null
968 -- x_return_status OUT VARCHAR2 N Null
969 -- x_msg_count OUT NUMBER N Null
970 -- x_msg_data OUT VARCHAR2 N Null
971 --
972 -- History
973 --
974 -- 13-OCT-01 Andrew Lee -Created
975 --
976 --
977
978 PROCEDURE OUTDENT_TASK_VERSION (
979 p_api_version IN NUMBER :=1.0,
980 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
981 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
982 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
983 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
984 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
985 p_debug_mode IN VARCHAR2 :='N',
986 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
987 p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
988 p_task_version_id IN NUMBER,
989 p_record_version_number IN NUMBER,
990 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
991 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
992 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
993 );
994
995
996 -- API name : Create_tasks
997 -- Type : Wrapper Public procedure
998 -- Pre-reqs : None
999 -- Return Value : N/A
1000 -- Prameters
1001 -- p_project_id IN NUMBER
1002 -- p_ref_task_version_id IN NUMBER
1003 -- p_structure_id IN NUMBER
1004 -- p_structure_version_id IN NUMBER
1005 -- p_outline_level IN PA_NUM_1000_NUM
1006 -- p_task_number IN PA_VC_1000_150
1007 -- p_task_name IN PA_VC_1000_2000
1008 -- p_scheduled_start_date IN PA_DATE_1000_DATE
1009 -- p_scheduled_finish_date IN PA_DATE_1000_DATE
1010 -- p_task_manager_id IN PA_NUM_1000_NUM
1011 -- p_task_manager_name IN PA_VC_1000_150
1012 --FP M Development Changes
1013 -- p_planned_effort IN PA_NUM_1000_NUM
1014 -- p_dependencies IN PA_VC_1000_4000
1015 -- p_dependency_ids IN PA_NUM_1000_NUM
1016 -- p_structure_type IN VARCHAR2 :='WORKPLAN'
1017 -- p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1018 -- p_resources IN PA_VC_1000_4000
1019 -- p_resource_ids IN PA_NUM_1000_NUM
1020 -- p_mapped_task IN PA_VC_1000_4000
1021 -- p_mapped_task_id IN PA_NUM_1000_NUM
1022 --End FP M Development Changes
1023 -- x_msg_count OUT NUMBER
1024 -- x_msg_data OUT VARCHAR2
1025 -- x_return_status OUT VARCHAR2
1026 -- x_return_status OUT VARCHAR2 N Null
1027 -- x_msg_count OUT NUMBER N Null
1028 -- x_msg_data OUT VARCHAR2 N Null
1029 --
1030 -- History
1031 --
1032 -- 23-OCT-01 Andrew Lee -Created
1033 --
1034 --
1035
1036 PROCEDURE CREATE_TASKS
1037 ( p_project_id IN NUMBER
1038 ,p_ref_task_version_id IN NUMBER
1039 ,p_structure_id IN NUMBER
1040 ,p_structure_version_id IN NUMBER
1041 ,p_outline_level IN PA_NUM_1000_NUM
1042 ,p_task_number IN PA_VC_1000_150
1043 ,p_task_name IN PA_VC_1000_2000
1044 ,p_scheduled_start_date IN PA_DATE_1000_DATE
1045 ,p_scheduled_finish_date IN PA_DATE_1000_DATE
1046 ,p_task_manager_id IN PA_NUM_1000_NUM
1047 ,p_task_manager_name IN PA_VC_1000_150
1048 ,p_TYPE_ID IN PA_NUM_1000_NUM
1049 --FP M Development Changes bug 330119
1050 ,p_planned_effort IN PA_NUM_1000_NUM
1051 ,p_planned_equip_effort IN PA_NUM_1000_NUM
1052 ,p_dependencies IN PA_VC_1000_4000
1053 ,p_dependency_ids IN PA_NUM_1000_NUM
1054 ,p_structure_type IN VARCHAR2 :='WORKPLAN'
1055 ,p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1056 ,p_use_in_fin_plan IN PA_VC_1000_10
1057 ,p_resources IN PA_VC_1000_4000
1058 ,p_resource_ids IN PA_NUM_1000_NUM
1059 ,p_mapped_task IN PA_VC_1000_4000
1060 ,p_mapped_task_id IN PA_NUM_1000_NUM
1061 --End FP M Development Changes bug 330119
1062 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1063 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1064 ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
1065
1066 -- anlee task weighting
1067 -- API name : Calc_Task_Weights
1068 -- Type : Utility
1069 -- Pre-reqs : None
1070 -- Return Value : N/A
1071 -- Prameters
1072 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1073 -- p_element_versions IN PA_NUM_1000_NUM
1074 -- p_outline_level IN PA_NUM_1000_NUM
1075 -- p_top_peer_count IN NUMBER
1076 -- p_top_sub_count IN NUMBER
1077 -- x_msg_count OUT NUMBER
1078 -- x_msg_data OUT VARCHAR2
1079 -- x_return_status OUT VARCHAR2
1080 --
1081 -- History
1082 --
1083 -- 17-SEP-02 Andrew Lee -Created
1084 --
1085 --
1086
1087 PROCEDURE CALC_TASK_WEIGHTS
1088 ( p_element_versions IN PA_NUM_1000_NUM
1089 ,p_outline_level IN PA_NUM_1000_NUM
1090 ,p_top_sub_count IN NUMBER
1091 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1092 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1093 ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
1094
1095 -- API name : Update_Task_Weighting
1096 -- Type : Public Procedure
1097 -- Pre-reqs : None
1098 -- Return Value : N/A
1099 -- Parameters
1100 -- p_api_version IN NUMBER := 1.0
1101 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1102 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1103 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1104 -- p_validation_level IN VARCHAR2 := 100
1105 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1106 -- p_debug_mode IN VARCHAR2 := 'N'
1107 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1108 -- p_object_relationship_id IN NUMBER
1109 -- p_weighting_percentage IN NUMBER
1110 -- p_record_version_number IN NUMBER
1111 -- x_return_status OUT VARCHAR2
1112 -- x_msg_count OUT NUMBER
1113 -- x_msg_data OUT VARCHAR2
1114 --
1115 -- History
1116 --
1117 -- 20-SEP-02 hyau -Created
1118 --
1119 --
1120 procedure Update_Task_Weighting
1121 (
1122 p_api_version IN NUMBER := 1.0
1123 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1124 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1125 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1126 ,p_validation_level IN VARCHAR2 := 100
1127 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1128 ,p_debug_mode IN VARCHAR2 := 'N'
1129 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1130 ,p_object_relationship_id IN NUMBER
1131 ,p_weighting_percentage IN NUMBER
1132 ,p_record_version_number IN NUMBER
1133 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1134 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1135 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1136 );
1137
1138 -- Amit : Following procedure added for Bug 2838700
1139
1140 PROCEDURE INDENT_TASK_VERSION_BULK (
1141 p_api_version IN NUMBER :=1.0,
1142 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
1143 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1144 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
1145 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1146 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
1147 p_debug_mode IN VARCHAR2 :='N',
1148 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1149 p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1150 p_task_version_id IN NUMBER,
1151 p_project_id IN NUMBER,
1152 p_record_version_number IN NUMBER,
1153 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1154 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1155 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1156 );
1157
1158 -- Amit : Following procedure added for Bug 2838700
1159
1160 PROCEDURE OUTDENT_TASK_VERSION_BULK (
1161 p_api_version IN NUMBER :=1.0,
1162 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
1163 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1164 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
1165 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1166 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
1167 p_debug_mode IN VARCHAR2 :='N',
1168 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1169 p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1170 p_task_version_id IN NUMBER,
1171 p_project_id IN NUMBER,
1172 p_record_version_number IN NUMBER,
1173 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1174 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1175 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1176 );
1177
1178 PROCEDURE DELETE_TASK_VERSION_IN_BULK
1179 (p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1180 ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1181 ,p_structure_version_id IN NUMBER
1182 ,p_structure_type IN VARCHAR2 := 'WORKPLAN' -- 3305199
1183 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1184 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1185 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1186 ) ;
1187
1188 --margaret bug 3024607 add update task association
1189 PROCEDURE Update_Task_Association (
1190 p_api_version IN NUMBER :=1.0,
1191 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
1192 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1193 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
1194 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1195 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
1196 p_debug_mode IN VARCHAR2 :='N',
1197 p_max_msg_count IN NUMBER :=NULL,
1198 p_associated_project_id IN NUMBER := NULL,
1199 p_associated_task_id IN NUMBER := NULL,
1200 p_associated_project_name IN VARCHAR2 :=NULL,
1201 p_associated_task_name IN VARCHAR2 :=NULL,
1202 p_task_id IN NUMBER ,
1203 p_relationship_type IN VARCHAR2 :='A',
1204 p_relationship_id IN NUMBER := NULL,
1205 p_record_version_number IN NUMBER := NULL,
1206 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1207 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1208 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1209 x_relationship_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1210 );
1211
1212
1213
1214 --margaret bug 3024607 delete task association
1215 PROCEDURE Delete_Task_Associations(
1216 p_api_version IN NUMBER :=1.0,
1217 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
1218 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1219 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
1220 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1221 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
1222 p_debug_mode IN VARCHAR2 :='N',
1223 p_max_msg_count IN NUMBER :=NULL,
1224 p_relationship_type IN VARCHAR2 :='A',
1225 p_relationship_id IN NUMBER := NULL,
1226 p_task_id IN NUMBER := NULL,
1227 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1228 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1229 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1230 );
1231
1232 --Delete a single association - relationship_id required
1233 --Only the association specified by relationship_id is deleted if it exists
1234 PROCEDURE Delete_Association(
1235 p_relationship_id IN NUMBER
1236 ,p_record_version_number IN NUMBER :=NULL
1237 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1238 );
1239
1240
1241 --margaret check if task has associations, returns Y/N
1242 FUNCTION has_Associations(
1243 p_task_id IN NUMBER
1244 ,p_relationship_type VARCHAR2 :='A'
1245 )return VARCHAR2;
1246
1247 --margaret check if project is associated to tasks, returns Y/N
1248 FUNCTION proj_has_task_associations(
1249 p_project_id IN NUMBER
1250 ,p_relationship_type IN VARCHAR2 :='A'
1251 )return VARCHAR2;
1252
1253
1254 PROCEDURE Check_Task_Has_Association(
1255 p_task_id IN NUMBER
1256 ,p_relationship_type VARCHAR2 :='A'
1257 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1258 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1259 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1260
1261 );
1262
1263 --Check if project is associated tosks
1264
1265 PROCEDURE Check_Proj_Associated_To_Tasks(
1266 p_project_id IN NUMBER
1267 ,p_relationship_type VARCHAR2 :='A'
1268 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1269 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1270 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1271
1272 );
1273 PROCEDURE Delete_Proj_To_Task_Assoc(
1274 p_api_version IN NUMBER :=1.0,
1275 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
1276 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1277 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
1278 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1279 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
1280 p_debug_mode IN VARCHAR2 :='N',
1281 p_max_msg_count IN NUMBER :=NULL,
1282 p_relationship_type IN VARCHAR2 :='A',
1283 p_relationship_id IN NUMBER := NULL,
1284 p_project_id IN NUMBER := NULL,
1285 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1286 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1287 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1288
1289 );
1290
1291 --This procedure copies associations for tasks from p_project_id_from tasks
1292 -- to p_project_id_to tasks
1293 PROCEDURE Copy_Task_Associations(
1294 p_api_version IN NUMBER :=1.0,
1295 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
1296 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1297 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
1298 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
1299 p_debug_mode IN VARCHAR2 :='N',
1300 p_max_msg_count IN NUMBER := NULL,
1301 p_project_id_to IN NUMBER := NULL,
1302 p_project_id_from IN NUMBER := NULL,
1303 p_relationship_type IN VARCHAR2 :='A',
1304 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1305 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1306 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1307 );
1308
1309
1310 --FPM bug 3301192
1311 --Planning and budget changes.
1312 --This apis is called from CREATE_TASKS api and AMG create_project, update_prohject and add_task apis
1313
1314 PROCEDURE call_add_planning_txns(
1315 p_tasks_ver_ids IN PA_NUM_1000_NUM,
1316 p_planned_effort IN PA_NUM_1000_NUM,
1317 p_project_id IN NUMBER,
1318 p_structure_version_id IN NUMBER,
1319 p_start_date IN PA_DATE_1000_DATE,
1320 p_end_date IN PA_DATE_1000_DATE,
1321 p_pm_product_code IN VARCHAR2 DEFAULT NULL, ---bug 3811243
1322 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1323 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1324 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1325 );
1326
1327
1328
1329 PROCEDURE update_task_det_sch_info(
1330 p_api_version IN NUMBER :=1.0,
1331 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
1332 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1333 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
1334 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
1335 p_debug_mode IN VARCHAR2 :='N',
1336 p_task_ver_id IN NUMBER,
1337 p_project_id IN NUMBER,
1338 p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1339 p_ETC_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1340 p_structure_version_id IN NUMBER,
1341 p_object_type IN VARCHAR2 := 'PA_TASKS',
1342 p_etc_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1343 p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1344 p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1345 p_res_assign_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1346 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1347 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1348 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1349 );
1350
1351 --FP M Bug 4201927
1352 PROCEDURE Copy_Tasks_In_Bulk
1353 (
1354 p_api_version IN NUMBER :=1.0,
1355 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
1356 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1357 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
1358 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1359 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
1360 p_debug_mode IN VARCHAR2 :='N',
1361 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1362 p_src_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1363 p_src_project_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1364 p_src_structure_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1365 p_src_structure_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1366 p_src_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1367 p_src_structure_version_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1368 p_src_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1369 p_src_task_name IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
1370 p_dest_structure_version_id IN NUMBER,
1371 p_dest_task_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1372 p_dest_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1373 p_called_from_api IN VARCHAR2 := 'ABCD',
1374 p_copy_option IN VARCHAR2,
1375 p_peer_or_sub IN VARCHAR2,
1376 p_prefix IN VARCHAR2,
1377 p_structure_type IN VARCHAR2 :='WORKPLAN',
1378 p_cp_dependency_flag IN VARCHAR2 :='N',
1379 p_cp_deliverable_asso_flag IN VARCHAR2 :='N',
1380 p_cp_tk_assignments_flag IN VARCHAR2 :='N',
1381 p_cp_cost_code_flag IN VARCHAR2 :='N', -- bug#16083858
1382 p_cp_people_flag IN VARCHAR2 :='N',
1383 p_cp_financial_elem_flag IN VARCHAR2 :='N',
1384 p_cp_material_items_flag IN VARCHAR2 :='N',
1385 p_cp_equipment_flag IN VARCHAR2 :='N',
1386 p_user_defn_att_flag IN VARCHAR2 :='N', -- Added for 14209636
1387 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1388 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1389 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1390 );
1391
1392 PROCEDURE MOVE_TASK_VERSIONS_IN_BULK
1393 (
1394 p_api_version IN NUMBER := 1.0,
1395 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1396 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1397 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
1398 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1399 p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
1400 p_debug_mode IN VARCHAR2 := 'N',
1401 p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1402 p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1403 p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1404 p_ref_task_version_id IN NUMBER,
1405 p_ref_project_id IN NUMBER, /*4269830*/
1406 p_peer_or_sub IN VARCHAR2,
1407 p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1408 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1409 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1410 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1411 );
1412
1413 -- 4218932 Added below update api for update task page for bulk approach
1414
1415 PROCEDURE Update_Task_All_Info(
1416 p_api_version IN NUMBER :=1.0,
1417 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
1418 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1419 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
1420 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1421 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
1422 p_debug_mode IN VARCHAR2 :='N',
1423 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1424 p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1425 --Begin:5867373:p_task_number_tbl's data-type has been changed to varchar2(100)
1426 p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE(),
1427 --End:5867373:
1428 p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
1429 p_task_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE(),
1430 p_task_manager_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1431 p_task_manager_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
1432 p_carrying_out_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1433 p_carrying_out_org_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
1434 p_priority_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
1435 p_TYPE_ID_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1436 p_status_code_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
1437 p_inc_proj_progress_flag_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE(),
1438 p_transaction_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
1439 p_transaction_finish_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
1440 p_work_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1441 p_service_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
1442 p_work_item_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
1443 p_uom_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
1444 p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1445 -- Update_Schedule_Version
1446 p_scheduled_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
1447 p_scheduled_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
1448 p_pev_schedule_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1449 p_milestone_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE(),
1450 p_critical_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE(),
1451 p_WQ_PLANNED_QUANTITY_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1452 p_early_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
1453 p_early_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
1454 p_late_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
1455 p_late_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
1456 p_constraint_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
1457 p_constraint_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE(),
1458 p_sch_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1459 -- update_task_det_sch_info
1460 p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1461 p_percent_complete_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1462 p_ETC_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1463 p_structure_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1464 p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1465 p_planned_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1466 p_actual_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1467 -- Update_Task_Weighting
1468 p_object_relationship_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1469 p_weighting_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1470 p_obj_rec_ver_num_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1471 p_task_weight_method IN VARCHAR2,
1472 -- common
1473 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1474 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1475 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1476 );
1477
1478 -- 4429929 : Added CANCEL_TASK
1479 PROCEDURE CANCEL_TASK(
1480 p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1481 ,p_api_version IN NUMBER :=1.0
1482 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
1483 ,p_validate_only IN VARCHAR2 :=FND_API.G_FALSE
1484 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1485 ,p_calling_mode IN VARCHAR2 :=null
1486 ,p_task_id IN NUMBER
1487 ,p_task_version_id IN NUMBER
1488 ,p_project_id IN NUMBER
1489 ,p_cancel_status_code IN VARCHAR2
1490 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1491 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1492 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1493 );
1494
1495 -- Bug Fix 5593736.
1496
1497 PROCEDURE INDENT_MULTI_TASK_VERSION
1498 (p_api_version IN NUMBER := 1.0
1499 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1500 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1501 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1502 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1503 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1504 ,p_debug_mode IN VARCHAR2 := 'N'
1505 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1506 ,p_project_id IN NUMBER
1507 ,p_structure_version_id IN NUMBER
1508 ,p_structure_type IN VARCHAR2 :='WORKPLAN'
1509 ,p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1510 ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1511 ,p_display_sequence_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1512 ,x_return_status OUT NOCOPY VARCHAR2
1513 ,x_msg_count OUT NOCOPY NUMBER
1514 ,x_msg_data OUT NOCOPY VARCHAR2);
1515
1516 PROCEDURE OUTDENT_MULTI_TASK_VERSION
1517 (p_api_version IN NUMBER := 1.0
1518 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1519 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1520 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1521 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1522 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1523 ,p_debug_mode IN VARCHAR2 := 'N'
1524 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1525 ,p_project_id IN NUMBER
1526 ,p_structure_version_id IN NUMBER
1527 ,p_structure_type IN VARCHAR2 :='WORKPLAN'
1528 ,p_task_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1529 ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1530 ,p_display_sequence_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1531 ,x_return_status OUT NOCOPY VARCHAR2
1532 ,x_msg_count OUT NOCOPY NUMBER
1533 ,x_msg_data OUT NOCOPY VARCHAR2);
1534
1535 -- Bug 8566495 E&C enhancement
1536 PROCEDURE APPROVE_TASKS_IN_BULK
1537 (p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1538 ,p_parent_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1539 ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE
1540 ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE
1541 ,p_project_id IN NUMBER
1542 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1543 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1544 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1545 );
1546 -- End of Bug Fix 5593736.
1547
1548 END PA_TASK_PUB1;