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