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