1 PACKAGE PA_TASK_PVT1 AS
2 /* $Header: PATSK1VS.pls 120.1 2005/08/19 17:05:16 mwasowic noship $ */
3
4 -- API name : Create_Task
5 -- Type : Public procedure
6 -- Pre-reqs : None
7 -- Return Value : N/A
8 -- Prameters
9 -- p_api_version IN NUMBER N Not Null 1.0
10 -- p_init_msg_list IN VARCHAR2 N Not Null FND_API.TRUE
11 -- p_commit IN VARCHAR2 N Not Null FND_API.G_FALSE
12 -- p_validate_only IN VARCHAR2 N Not Null FND_API.G_TRUE
13 -- p_validation_level IN NUMBER N Null FND_API.G_VALID_LEVEL_FULL
14 -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
15 -- p_debug_mode IN VARCHAR2 N Null N
16 -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17 -- p_object_type IN VARCHAR2 N Not Null
18 -- p_project_id IN NUMBER N Not Null
19 -- p_task_number IN VARCHAR2 N Not Null
20 -- p_task_name IN VARCHAR2 N Not Null
21 -- p_task_description IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
22 -- p_location_id IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
23 -- p_country IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
24 -- p_territory_code IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
25 -- p_state_region IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
26 -- p_city IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
27 -- p_task_manager_id IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
28 -- p_carrying_out_org_id IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
29 -- p_priority_code IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30 -- p_TYPE_ID IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
31 -- p_status_code IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
32 -- p_inc_proj_progress_flag IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
33 -- p_pm_product_code IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
34 -- p_pm_task_reference IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
35 -- p_closed_date IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
36 -- p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
37 -- p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
38 -- p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
39 -- p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
40 -- p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41 -- p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
42 -- p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43 -- p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
44 -- p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
45 -- p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
46 -- p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
47 -- p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48 -- p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49 -- p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50 -- p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51 -- p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
52 -- x_task_id OUT NUMBER N Not Null
53 -- x_return_status OUT VARCHAR2 N Null
54 -- x_msg_count OUT NUMBER N Null
55 -- x_msg_data OUT VARCHAR2 N Null
56 --
57 -- History
58 --
59 -- 23-OCT-01 Majid Ansari -Created
60 --
61 --
62
63 PROCEDURE Create_Task(
64 p_api_version IN NUMBER :=1.0,
65 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
66 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
67 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
68 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
69 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
70 p_debug_mode IN VARCHAR2 :='N',
71 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
72 p_object_type IN VARCHAR2,
73 p_project_id IN NUMBER,
74 p_structure_id IN NUMBER,
75 p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
76 p_task_number IN VARCHAR2,
77 p_task_name IN VARCHAR2,
78 p_ref_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
79 p_peer_or_sub IN VARCHAR2 :='PEER',
80 p_task_description IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
81 p_location_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
82 p_country IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
83 p_territory_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
84 p_state_region IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
85 p_city IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
86 p_task_manager_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
87 p_carrying_out_org_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
88 p_priority_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
89 p_TYPE_ID IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
90 p_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
91 p_inc_proj_progress_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
92 p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
93 p_pm_task_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
94 p_closed_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
95 p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
96 p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
97 p_link_task_flag IN VARCHAR2 := 'N',
98 p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
99 p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
100 p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
101 p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
102 p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
103 p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
104 p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
105 p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
106 p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
107 p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
108 p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
109 p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
110 p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
111 p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
112 p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
113 p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
114 p_address_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
115 p_address1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
116 p_work_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
117 p_service_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
118 p_chargeable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
119 p_billable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
120 p_receive_project_invoice_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
121
122 p_task_weighting_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
123 p_work_item_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
124 p_uom_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
125 p_wq_actual_entry_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
126 p_task_progress_entry_page_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
127 p_task_progress_entry_page IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
128
129 p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
130 p_phase_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
131 p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
132 -- xxlu added task DFF attributes
133 p_tk_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
134 p_tk_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
135 p_tk_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
136 p_tk_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
137 p_tk_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
138 p_tk_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
139 p_tk_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
140 p_tk_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
141 p_tk_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
142 p_tk_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
143 p_tk_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
144 -- end xxlu changes
145 --FP M development bug 330119
146 p_structure_type IN VARCHAR2 := 'WORKPLAN',
147 p_financial_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
148 --End FPM changes bug 330119
149 p_Base_Perc_Comp_Deriv_Code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
150 -- This param added for FP_M changes 3305199
151 -- Bug#3491609 : Workflow Chanegs FP M
152 p_wf_item_type IN pa_proj_elements.wf_item_type%TYPE :=NULL,
153 p_wf_process IN pa_proj_elements.wf_process%TYPE :=NULL,
154 p_wf_lead_days IN pa_proj_elements.wf_start_lead_days%TYPE :=NULL,
155 p_wf_enabled_flag IN pa_proj_elements.enable_wf_flag%TYPE :=NULL,
156 -- Bug#3491609 : Workflow Chanegs FP M
157 x_task_id IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
158 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
159 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
160 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
161 );
162
163 -- API name : Update_Task
164 -- Type : Public procedure
165 -- Pre-reqs : None
166 -- Return Value : N/A
167 -- Prameters
168 -- p_api_version IN NUMBER N Not Null 1.0
169 -- p_init_msg_list IN VARCHAR2 N Not Null FND_API.TRUE
170 -- p_commit IN VARCHAR2 N Not Null FND_API.G_FALSE
171 -- p_validate_only IN VARCHAR2 N Not Null FND_API.G_TRUE
172 -- p_validation_level IN NUMBER N Null FND_API.G_VALID_LEVEL_FULL
173 -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
174 -- p_debug_mode IN VARCHAR2 N Null N
175 -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
176 -- p_task_id IN NUMBER N Not Null
177 -- p_task_number IN VARCHAR2 N Not Null
178 -- p_task_name IN VARCHAR2 N Not Null
179 -- p_task_description IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
180 -- p_location_id IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
181 -- p_country IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
182 -- p_territory_code IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
183 -- p_state_region IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
184 -- p_city IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
185 -- p_task_manager_id IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
186 -- p_carrying_out_org_id IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
187 -- p_priority_code IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
188 -- p_TYPE_ID IN NUMBER N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
189 -- p_status_code IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
190 -- p_inc_proj_progress_flag IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
191 -- p_pm_product_code IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
192 -- p_pm_task_reference IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
193 -- p_closed_date IN VARCHAR2 N Null PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
194 -- p_transaction_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
195 -- p_transaction_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
196 -- p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
197 -- p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
198 -- p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
199 -- p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
200 -- p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
201 -- p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
202 -- p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
203 -- p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
204 -- p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
205 -- p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
206 -- p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
207 -- p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
208 -- p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
209 -- p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
210 -- p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
211 -- p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
212 -- p_record_version_number IN NUMBER N Not Null
213 -- x_return_status OUT VARCHAR2 N Null
214 -- x_msg_count OUT NUMBER N Null
215 -- x_msg_data OUT VARCHAR2 N Null
216 --
217 -- History
218 --
219 -- 23-OCT-01 Majid Ansari -Created
220 -- 31-JUL-02 H Siu -Added transaction dates
221 --
222 --
223
224 PROCEDURE Update_Task(
225 p_api_version IN NUMBER :=1.0,
226 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
227 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
228 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
229 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
230 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
231 p_debug_mode IN VARCHAR2 :='N',
232 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
233 p_ref_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
234 p_peer_or_sub IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
235 p_task_id IN NUMBER,
236 p_task_number IN VARCHAR2,
237 p_task_name IN VARCHAR2,
238 p_task_description IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
239 p_location_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
240 p_country IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
241 p_territory_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
242 p_state_region IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
243 p_city IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
244 p_task_manager_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
245 p_carrying_out_org_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
246 p_priority_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
247 p_TYPE_ID IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
248 p_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
249 p_inc_proj_progress_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
250 p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
251 p_pm_task_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
252 p_closed_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
253 p_transaction_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
254 p_transaction_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
255 p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
256 p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
257 p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
258 p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
259 p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
260 p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
261 p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
262 p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
263 p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
264 p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
265 p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
266 p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
267 p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
268 p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
269 p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
270 p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
271
272 p_address_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
273 p_address1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
274 p_work_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
275 p_service_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
276 p_chargeable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
277 p_billable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
278 p_receive_project_invoice_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
279
280 p_task_weighting_deriv_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
281 p_work_item_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
282 p_uom_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
283 p_wq_actual_entry_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
284 p_task_progress_entry_page_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
285 p_task_progress_entry_page IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
286 p_phase_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
287 p_parent_structure_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
288 p_phase_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
289
290 p_record_version_number IN NUMBER,
291 -- xxlu added task DFF attributes
292 p_tk_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
293 p_tk_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
294 p_tk_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
295 p_tk_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
296 p_tk_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
297 p_tk_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
298 p_tk_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
299 p_tk_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
300 p_tk_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
301 p_tk_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
302 p_tk_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
303 -- end xxlu changes
304 p_Base_Perc_Comp_Deriv_Code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
305 p_gen_etc_src_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
306 -- This param added for FP_M changes 3305199
307 -- Bug#3491609 : Workflow Chanegs FP M
308 p_wf_item_type IN pa_proj_elements.wf_item_type%TYPE :=NULL,
309 p_wf_process IN pa_proj_elements.wf_process%TYPE :=NULL,
310 p_wf_lead_days IN pa_proj_elements.wf_start_lead_days%TYPE :=NULL,
311 p_wf_enabled_flag IN pa_proj_elements.enable_wf_flag%TYPE :=NULL,
312 -- Bug#3491609 : Workflow Chanegs FP M
313 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
314 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
315 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
316 p_shared IN VARCHAR2 := 'X' -- Added for Bug 3451073
317 );
318
319 -- API name : Create_Task_version
320 -- Type : Public procedure
321 -- Pre-reqs : None
322 -- Return Value : N/A
323 -- Prameters
324 -- p_api_version IN NUMBER N Not Null 1.0
325 -- p_init_msg_list IN VARCHAR2 N Not Null FND_API.TRUE
326 -- p_commit IN VARCHAR2 N Not Null FND_API.G_FALSE
327 -- p_validate_only IN VARCHAR2 N Not Null FND_API.G_TRUE
328 -- p_validation_level IN NUMBER N Null FND_API.G_VALID_LEVEL_FULL
329 -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
330 -- p_debug_mode IN VARCHAR2 N Null N
331 -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
332 -- p_ref_task_version_id IN NUMBER N Not Null
333 -- p_peer_or_sub IN VARCHAR2 N Not Null
334 -- p_task_id IN NUMBER N Not Null
335 -- p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
336 -- p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
337 -- p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
338 -- p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
339 -- p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
340 -- p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
341 -- p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
342 -- p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
343 -- p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
344 -- p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
345 -- p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
346 -- p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
347 -- p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
348 -- p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
349 -- p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
350 -- p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
351 -- x_task_version_id OUT NUMBER N Null
352 -- x_return_status OUT VARCHAR2 N Null
353 -- x_msg_count OUT NUMBER N Null
354 -- x_msg_data OUT VARCHAR2 N Null
355 --
356 -- History
357 --
358 -- 23-OCT-01 Majid Ansari -Created
359 --
360 --
361
362 PROCEDURE Create_Task_Version(
363 p_api_version IN NUMBER :=1.0,
364 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
365 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
366 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
367 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
368 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
369 p_debug_mode IN VARCHAR2 :='N',
370 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
371 p_ref_task_version_id IN NUMBER,
372 p_peer_or_sub IN VARCHAR2,
373 p_task_id IN NUMBER,
374 p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
375 p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
376 p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
377 p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
378 p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
379 p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
380 p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
381 p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
382 p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
383 p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
384 p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
385 p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
386 p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
387 p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
388 p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
389 p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
390
391 p_WEIGHTING_PERCENTAGE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
392 p_TASK_UNPUB_VER_STATUS_CODE IN VARCHAR2 := NULL,
393 --bug 3301192
394 p_financial_task_flag IN VARCHAR2 := 'N',
395 --bug 3301192
396 x_task_version_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
397 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
398 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
399 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
400 );
401
402 -- API name : Update_Task_version
403 -- Type : Public procedure
404 -- Pre-reqs : None
405 -- Return Value : N/A
406 -- Prameters
407 -- p_api_version IN NUMBER N Not Null 1.0
408 -- p_init_msg_list IN VARCHAR2 N Not Null FND_API.TRUE
409 -- p_commit IN VARCHAR2 N Not Null FND_API.G_FALSE
410 -- p_validate_only IN VARCHAR2 N Not Null FND_API.G_TRUE
411 -- p_validation_level IN NUMBER N Null FND_API.G_VALID_LEVEL_FULL
412 -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
413 -- p_debug_mode IN VARCHAR2 N Null N
414 -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415 -- p_task_version_id IN NUMBER N Null
416 -- p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
417 -- p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
418 -- p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
419 -- p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
420 -- p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
421 -- p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
422 -- p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
423 -- p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
424 -- p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
425 -- p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
426 -- p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
427 -- p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
428 -- p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
429 -- p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
430 -- p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
431 -- p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
432 -- p_record_version_number IN NUMBER
433 -- x_return_status OUT VARCHAR2 N Null
434 -- x_msg_count OUT NUMBER N Null
435 -- x_msg_data OUT VARCHAR2 N Null
436 --
437 -- History
438 --
439 -- 23-OCT-01 Majid Ansari -Created
440 --
441 --
442
443 PROCEDURE Update_Task_Version(
444 p_api_version IN NUMBER :=1.0,
445 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
446 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
447 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
448 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
449 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
450 p_debug_mode IN VARCHAR2 :='N',
451 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
452 p_ref_task_version_id IN NUMBER,
453 p_peer_or_sub IN VARCHAR2,
454 p_task_version_id IN NUMBER,
455 p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
456 p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
457 p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
458 p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
459 p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
460 p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
461 p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
462 p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
463 p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
464 p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
465 p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
466 p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
467 p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
468 p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
469 p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
470 p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
471 p_record_version_number IN NUMBER,
472 p_action IN VARCHAR2 := 'NULL',
473
474 p_WEIGHTING_PERCENTAGE IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
475 p_TASK_UNPUB_VER_STATUS_CODE IN VARCHAR2 := NULL,
476
477 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
478 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
479 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
480 );
481
482 -- API name : Delete_Task_version
483 -- Type : Public procedure
484 -- Pre-reqs : None
485 -- Return Value : N/A
486 -- Prameters
487 -- p_api_version IN NUMBER N Not Null 1.0
488 -- p_init_msg_list IN VARCHAR2 N Not Null FND_API.TRUE
489 -- p_commit IN VARCHAR2 N Not Null FND_API.G_FALSE
490 -- p_validate_only IN VARCHAR2 N Not Null FND_API.G_TRUE
491 -- p_validation_level IN NUMBER N Null FND_API.G_VALID_LEVEL_FULL
492 -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
493 -- p_debug_mode IN VARCHAR2 N Null N
494 -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
495 -- p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
496 -- p_task_version_id IN NUMBER N Null
497 -- p_record_version_number IN NUMBER
498 -- x_return_status OUT VARCHAR2 N Null
499 -- x_msg_count OUT NUMBER N Null
500 -- x_msg_data OUT VARCHAR2 N Null
501 --
502 -- History
503 --
504 -- 23-OCT-01 Majid Ansari -Created
505 --
506 --
507
508 PROCEDURE Delete_Task_Version(
509 p_api_version IN NUMBER :=1.0,
510 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
511 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
512 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
513 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
514 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
515 p_debug_mode IN VARCHAR2 :='N',
516 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
517 p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
518 p_task_version_id IN NUMBER,
519 p_record_version_number IN NUMBER,
520 p_called_from_api IN VARCHAR2 := 'ABCD',
521 p_structure_type IN VARCHAR2 := 'WORKPLAN', --bug 3301192
522 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
523 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
524 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
525 );
526
527 -- API name : Create_Schedule_Version
528 -- Type : Public procedure
529 -- Pre-reqs : None
530 -- Return Value : N/A
531 -- Prameters
532 -- p_api_version IN NUMBER N Not Null 1.0
533 -- p_init_msg_list IN VARCHAR2 N Not Null FND_API.TRUE
534 -- p_commit IN VARCHAR2 N Not Null FND_API.G_FALSE
535 -- p_validate_only IN VARCHAR2 N Not Null FND_API.G_TRUE
536 -- p_validation_level IN NUMBER N Null FND_API.G_VALID_LEVEL_FULL
537 -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
538 -- p_debug_mode IN VARCHAR2 N Null N
539 -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
540 -- p_element_version_id IN NUMBER N Not Null
541 -- p_calendar_id IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
542 -- p_scheduled_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
543 -- p_scheduled_end_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
544 -- p_obligation_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
545 -- p_obligation_end_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
546 -- p_actual_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
547 -- p_actual_finish_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
548 -- p_estimate_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
549 -- p_estimate_finish_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
550 -- p_duration IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
551 -- p_early_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
552 -- p_early_end_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
553 -- p_late_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
554 -- p_late_end_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
555 -- p_milestone_flag IN VARCHAR2 N NULL N
556 -- p_critical_flag IN VARCHAR2 N NULL N
557 -- x_pev_schedule_id OUT NUMBER N NULL
558 -- x_return_status OUT VARCHAR2 N Null
559 -- x_msg_count OUT NUMBER N Null
560 -- x_msg_data OUT VARCHAR2 N Null
561 --
562 -- History
563 --
564 -- 23-OCT-01 Majid Ansari -Created
565 --
566 --
567
568 PROCEDURE Create_Schedule_Version(
569 p_api_version IN NUMBER :=1.0,
570 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
571 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
572 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
573 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
574 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
575 p_debug_mode IN VARCHAR2 :='N',
576 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
577 p_element_version_id IN NUMBER,
578 p_calendar_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
579 p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
580 p_scheduled_end_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
581 p_obligation_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
582 p_obligation_end_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
583 p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
584 p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
585 p_estimate_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
586 p_estimate_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
587 p_duration IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
588 p_early_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
589 p_early_end_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
590 p_late_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
591 p_late_end_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
592 p_milestone_flag IN VARCHAR2 :='N',
593 p_critical_flag IN VARCHAR2 :='N',
594 p_WQ_PLANNED_QUANTITY IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
595 p_PLANNED_EFFORT IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
596 p_PLANNED_EQUIP_EFFORT IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --bug 3305199
597 p_ext_act_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
598 p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
599 p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
600 p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
601 p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
602 p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
603 p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
604 p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
605 p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
606 p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
607 p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
608 p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
609 p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
610 p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
611 p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
612 p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
613 p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
614 p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
615 p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
616
617 --bug 3305199 schedule options
618 p_def_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
619 p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
620 p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
621 p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
622 p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
623 p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
624 p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
625 --end bug 3305199
626
627 x_pev_schedule_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
628 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
629 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
630 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
631 );
632
633
634 -- API name : Update_Schedule_Version
635 -- Type : Public procedure
636 -- Pre-reqs : None
637 -- Return Value : N/A
638 -- Prameters
639 -- p_api_version IN NUMBER N Not Null 1.0
640 -- p_init_msg_list IN VARCHAR2 N Not Null FND_API.TRUE
641 -- p_commit IN VARCHAR2 N Not Null FND_API.G_FALSE
642 -- p_validate_only IN VARCHAR2 N Not Null FND_API.G_TRUE
643 -- p_validation_level IN NUMBER N Null FND_API.G_VALID_LEVEL_FULL
644 -- p_calling_module IN VARCHAR2 N Null SELF_SERVICE
645 -- p_debug_mode IN VARCHAR2 N Null N
646 -- p_max_msg_count IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
647 -- p_element_version_id IN NUMBER N Not Null
648 -- p_calendar_id IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
649 -- p_scheduled_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
650 -- p_scheduled_end_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
651 -- p_obligation_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
652 -- p_obligation_end_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
653 -- p_actual_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
654 -- p_actual_finish_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
655 -- p_estimate_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
656 -- p_estimate_finish_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
657 -- p_duration IN NUMBER N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
658 -- p_early_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
659 -- p_early_end_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
660 -- p_late_start_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
661 -- p_late_end_date IN DATE N NULL PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
662 -- p_milestone_flag IN VARCHAR2 N NULL N
663 -- p_critical_flag IN VARCHAR2 N NULL N
664 -- x_pev_schedule_id OUT NUMBER N NULL
665 -- x_return_status OUT VARCHAR2 N Null
666 -- x_msg_count OUT NUMBER N Null
667 -- x_msg_data OUT VARCHAR2 N Null
668 --
669 -- History
670 --
671 -- 23-OCT-01 Majid Ansari -Created
672 --
673 --
674
675 PROCEDURE Update_Schedule_Version(
676 p_api_version IN NUMBER :=1.0,
677 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
678 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
679 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
680 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
681 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
682 p_debug_mode IN VARCHAR2 :='N',
683 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
684 p_pev_schedule_id IN NUMBER,
685 p_calendar_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
686 p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
687 p_scheduled_end_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
688 p_obligation_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
689 p_obligation_end_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
690 p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
691 p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
692 p_estimate_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
693 p_estimate_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
694 p_duration IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
695 p_early_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
696 p_early_end_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
697 p_late_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
698 p_late_end_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
699 p_milestone_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 2791410
700 p_critical_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, -- Bug 2791410
701 p_WQ_PLANNED_QUANTITY IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
702 p_PLANNED_EFFORT IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
703 p_PLANNED_EQUIP_EFFORT IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --bug 3305199
704 --bug 3305199 schedule options
705 p_def_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
706 p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
707 p_constraint_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
708 p_free_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
709 p_total_slack IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
710 p_effort_driven_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
711 p_level_assignments_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
712 --end bug 3305199
713 p_record_version_number IN NUMBER,
714 p_ext_act_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
715 p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
716 p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
717 p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
718 p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
719 p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
720 p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
721 p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
722 p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
723 p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
724 p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
725 p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
726 p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
727 p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
728 p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
729 p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
730 p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
731 p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
732 p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
733 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
734 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
735 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
736 );
737
738 PROCEDURE Inherit_task_type_attr(
739 p_api_version IN NUMBER :=1.0,
740 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
741 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
742 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
743 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
744 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
745 p_debug_mode IN VARCHAR2 :='N',
746 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
747 p_task_id IN NUMBER,
748 p_task_version_id IN NUMBER,
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 : Update_Task_Weighting
755 -- Type : Private Procedure
756 -- Pre-reqs : None
757 -- Return Value : N/A
758 -- Parameters
759 -- p_api_version IN NUMBER := 1.0
760 -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
761 -- p_commit IN VARCHAR2 := FND_API.G_FALSE
762 -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
763 -- p_validation_level IN VARCHAR2 := 100
764 -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
765 -- p_debug_mode IN VARCHAR2 := 'N'
766 -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
767 -- p_object_relationship_id IN NUMBER
768 -- p_weighting_percentage IN NUMBER
769 -- p_record_version_number IN NUMBER
770 -- x_return_status OUT VARCHAR2
771 -- x_msg_count OUT NUMBER
772 -- x_msg_data OUT VARCHAR2
773 --
774 -- History
775 --
776 -- 20-SEP-02 hyau -Created
777 --
778 --
779
780 procedure Update_Task_Weighting
781 (
782 p_api_version IN NUMBER := 1.0
783 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
784 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
785 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
786 ,p_validation_level IN VARCHAR2 := 100
787 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
788 ,p_debug_mode IN VARCHAR2 := 'N'
789 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
790 ,p_object_relationship_id IN NUMBER
791 ,p_weighting_percentage IN NUMBER
792 ,p_record_version_number IN NUMBER
793 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
794 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
795 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
796 );
797
798 PROCEDURE RECALC_TASKS_WEIGHTING(
799 p_api_version IN NUMBER := 1.0
800 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
801 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
802 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
803 ,p_validation_level IN VARCHAR2 := 100
804 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
805 ,p_debug_mode IN VARCHAR2 := 'N'
806 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
807 ,p_task_version_id IN NUMBER
808 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
809 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
810 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
811 );
812
813 PROCEDURE update_task_ver_delete_status(
814 p_api_version IN NUMBER := 1.0
815 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
816 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
817 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
818 ,p_validation_level IN VARCHAR2 := 100
819 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
820 ,p_debug_mode IN VARCHAR2 := 'N'
821 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
822 ,p_task_version_id IN NUMBER
823 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
824 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
825 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
826 );
827
828 procedure delete_task_ver_wo_val
829 (
830 p_api_version IN NUMBER :=1.0,
831 p_init_msg_list IN VARCHAR2:=FND_API.G_TRUE,
832 p_commit IN VARCHAR2:=FND_API.G_FALSE,
833 p_validate_only IN VARCHAR2:=FND_API.G_TRUE,
834 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
835 p_calling_module IN VARCHAR2:='SELF_SERVICE',
836 p_debug_mode IN VARCHAR2:='N',
837 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
838 p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
839 p_task_version_id IN NUMBER,
840 p_record_version_number IN NUMBER,
841 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
842 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
843 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
844 );
845
846 procedure UPDATE_WORKING_VER_WEIGHT(
847 p_commit IN VARCHAR2 := FND_API.G_FALSE
848 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
849 ,p_validation_level IN VARCHAR2 := 100
850 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
851 ,p_debug_mode IN VARCHAR2 := 'N'
852 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
853 ,p_task_id IN NUMBER
854 ,p_weighting IN NUMBER
855 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
856 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
857 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
858 );
859
860 procedure set_new_tasks_to_TBD(
861 p_commit IN VARCHAR2 := FND_API.G_FALSE
862 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
863 ,p_validation_level IN VARCHAR2 := 100
864 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
865 ,p_debug_mode IN VARCHAR2 := 'N'
866 ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
867 ,p_project_id IN NUMBER
868 ,p_task_id IN NUMBER
869 ,p_task_status IN VARCHAR2
870 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
871 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
872 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
873 );
874
875 -- Bug 2812855 : Added following procedure to populate actual and estimated dates to all the task versions
876
877 PROCEDURE Update_Dates_To_All_Versions(
878 p_api_version IN NUMBER :=1.0,
879 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
880 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
881 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
882 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
883 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
884 p_debug_mode IN VARCHAR2 :='N',
885 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
886 p_project_id IN NUMBER,
887 p_element_version_id IN NUMBER,
888 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
889 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
890 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
891 );
892
893 END PA_TASK_PVT1;