1 PACKAGE PA_TASK_ASSIGNMENTS_PUB AUTHID CURRENT_USER AS
2 -- $Header: PATAPUBS.pls 120.6.12020000.2 2013/04/04 07:31:28 djambhek ship $
3 /*#
4 * This package contains the public APIs for project task resource information.
5 * @rep:scope public
6 * @rep:product PA
7 * @rep:lifecycle active
8 * @rep:displayname Task Assignments API
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY PA_TASK_RESOURCE
11 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
12 */
13
14 TYPE assignment_in_rec_type IS RECORD
15 ( -- All parameters listed initially are used in creation and updation
16 --Either project reference or id is required
17 pm_project_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
18 ,pa_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19 --Structure version id is required currently
20 ,pa_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21 --Task reference or id is required
22 ,pm_task_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23 ,pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24 ,pa_task_element_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
25 -- Task Asgmt. Reference is required for creation. Asgmt. Id or reference required for determination of updation.
26 -- Task Assignment Reference can be created but not updated.
27 ,pm_task_asgmt_reference VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
28 ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
29 ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30 -- Planning resource list member id required for creation
31 ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
32 -- CBS element Id is mandatory for CBS enabled projects 16598322
33 ,cbs_element_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
34 ,cost_code VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
35 ,start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
36 ,end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
37 ,planned_quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
38 ,planned_total_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
39 ,planned_total_bur_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40 ,currency_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41 --This attribute is added for Bug 3948128: TA Delay CR by DHI
42 ,scheduled_delay NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
43 --Following are flexfield parameters
44 ,attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
45 ,attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
46 ,attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
47 ,attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48 ,attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49 ,attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50 ,attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51 ,attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
52 ,attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
53 ,attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
54 ,attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55 ,attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
56 ,attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57 ,attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
58 ,attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59 ,attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
60 ,attribute16 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
61 ,attribute17 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
62 ,attribute18 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
63 ,attribute19 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
64 ,attribute20 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
65 ,attribute21 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
66 ,attribute22 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
67 ,attribute23 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68 ,attribute24 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
69 ,attribute25 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70 ,attribute26 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
71 ,attribute27 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
72 ,attribute28 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
73 ,attribute29 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
74 ,attribute30 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
75 -- Following parameters used for update process only..........
76 --=============================================================
77 ,description VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
78 ,use_task_schedule_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
79 --Rate Overrides.
80 ,raw_cost_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
81 ,burd_cost_rate_override NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
82 ,billable_work_percent NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
83 --Mfg cost type is converted to id if mfg cost type id is not provided
84 ,mfg_cost_type VARCHAR2(10) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
85 ,mfg_cost_type_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
86 -- Above parameters for update only..........
87 --===============================================================
88 --Pass in p_context of 'D' for explicit deletion
89 --Pass in p_context of 'F' for implicit deletion based on task assignments not passed on tasks.
90 ,p_context VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
91 ,spread_curve_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug#8646853
92 ,spread_curve_name varchar2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --Bug#8646853
93 ,fixed_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE --Bug#8646853
94 );
95
96
97
98 TYPE assignment_out_rec_type IS RECORD
99 ( pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
100 ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
101 ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
102 ,cbs_element_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Added for 16598322
103 ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
104 ,return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
105 );
106
107
108
109 TYPE assignment_in_tbl_type IS TABLE OF assignment_in_rec_type
110 INDEX BY BINARY_INTEGER;
111
112 TYPE assignment_out_tbl_type IS TABLE OF assignment_out_rec_type
113 INDEX BY BINARY_INTEGER;
114
115
116 TYPE ta_del_rec_type IS RECORD
117 ( pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
118 pa_task_elem_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
119 del_ta_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
120 );
121
122 TYPE assignment_del_tbl_type IS TABLE OF ta_del_rec_type
123 INDEX BY BINARY_INTEGER;
124
125 TYPE task_asgmt_del_type IS RECORD
126 ( pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
127 start_del_index NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
128 end_del_index NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
129 del_flag VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
130 );
131 TYPE task_asgmt_del_tbl_type IS TABLE OF task_asgmt_del_type
132 INDEX BY BINARY_INTEGER;
133
134
135 TYPE assignment_periods_type IS RECORD
136 ( -- All parameters are used after a task assignment is created for periodic data creation/updation.
137 pm_product_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --SAME
138 --Either project reference or id is required
139 ,pm_project_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
140 ,pa_project_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
141 --Structure version id is required currently
142 ,pa_structure_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
143 --Task reference or id is required
144 ,pm_task_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
145 ,pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
146 ,pa_task_element_version_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
147 -- Task Asgmt. Reference is required for creation. Asgmt. Id or reference required for updation.
148 ,pm_task_asgmt_reference VARCHAR2(25) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
149 ,pa_task_assignment_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
150 ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
151 -- Planning resource list member id required for creation
152 ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
153 -- CBS element Id is mandatory for CBS enabled projects 16598322
154 ,cbs_element_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
155 ,cost_code VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
156 --Name of the period if available
157 ,period_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
158 --Start date of the period
159 ,start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
160 --End date of the period
161 ,end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
162 ,quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
163 ,txn_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
164 ,txn_burdened_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
165 ,txn_currency_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
166
167 );
168
169
170 TYPE assignment_periods_tbl_type IS TABLE OF assignment_periods_type
171 INDEX BY BINARY_INTEGER;
172
173 --Temporary table below will be reinitialized at the end of every load cycle.
174 g_asgmts_periods_tbl assignment_periods_tbl_type;
175 g_asgmts_periods_out_tbl assignment_out_tbl_type;
176 g_asgmts_periods_tbl_count NUMBER;
177
178 empty_asgmts_periods_tbl assignment_periods_tbl_type;
179
180 --All type contained in paxdty01.sql , paxdty03.sql
181
182
183 -- global plsql tables of assignment records
184 g_task_asgmts_in_tbl assignment_in_tbl_type;
185 g_task_asgmts_out_tbl assignment_out_tbl_type;
186
187 g_task_asgmts_tbl_count NUMBER;
188
189 empty_task_asgmts_in_tbl assignment_in_tbl_type;
190 empty_task_asgmts_out_tbl assignment_out_tbl_type;
191
192 /*#
193 * This API is used to load project task resources to a global PL/SQL table.
194 * @param p_commit API standard (default = F): indicates if the transaction will be committed
195 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
196 * @param p_api_version_number API standard: version number
197 * @param p_pm_project_reference Reference code that uniquely identifies the project in the external system
198 * @param p_pa_project_id Identifier of the project in the Oracle Projects
199 * @param p_pa_structure_version_id Identifier of the structure version in Oracle Projects
200 * @param p_pm_task_reference External task reference
201 * @param p_pa_task_id Identifier of the task in the Oracle Projects
202 * @param p_pa_task_element_version_id Identifier of the task version in the Oracle Projects
203 * @param p_pm_task_asgmt_reference External task resource reference
204 * @param p_pa_task_assignment_id Identifier of the task resource in Oracle Projects
205 * @param p_resource_alias Planning resource alias
206 * @param p_resource_list_member_id Identifier of the planning resource
207 * @param p_start_date Start date of the task resource assignment
208 * @param p_end_date End date of the task resource assignment
209 * @param p_planned_quantity Planned effort or quantity
210 * @param p_planned_total_raw_cost Planned row cost
211 * @param p_planned_total_bur_cost Planned burdened cost
212 * @param p_currency_code Currency code
213 * @param p_scheduled_delay Task Resource scheduled delay
214 * @param p_attribute_category Descriptive flexfield category
215 * @param p_attribute1 Descriptive flexfield attribute
216 * @param p_attribute2 Descriptive flexfield attribute
217 * @param p_attribute3 Descriptive flexfield attribute
218 * @param p_attribute4 Descriptive flexfield attribute
219 * @param p_attribute5 Descriptive flexfield attribute
220 * @param p_attribute6 Descriptive flexfield attribute
221 * @param p_attribute7 Descriptive flexfield attribute
222 * @param p_attribute8 Descriptive flexfield attribute
223 * @param p_attribute9 Descriptive flexfield attribute
224 * @param p_attribute10 Descriptive flexfield attribute
225 * @param p_attribute11 Descriptive flexfield attribute
226 * @param p_attribute12 Descriptive flexfield attribute
227 * @param p_attribute13 Descriptive flexfield attribute
228 * @param p_attribute14 Descriptive flexfield attribute
229 * @param p_attribute15 Descriptive flexfield attribute
230 * @param p_attribute16 Descriptive flexfield attribute
231 * @param p_attribute17 Descriptive flexfield attribute
232 * @param p_attribute18 Descriptive flexfield attribute
233 * @param p_attribute19 Descriptive flexfield attribute
234 * @param p_attribute20 Descriptive flexfield attribute
235 * @param p_attribute21 Descriptive flexfield attribute
236 * @param p_attribute22 Descriptive flexfield attribute
237 * @param p_attribute23 Descriptive flexfield attribute
238 * @param p_attribute24 Descriptive flexfield attribute
239 * @param p_attribute25 Descriptive flexfield attribute
240 * @param p_attribute26 Descriptive flexfield attribute
241 * @param p_attribute27 Descriptive flexfield attribute
242 * @param p_attribute28 Descriptive flexfield attribute
243 * @param p_attribute29 Descriptive flexfield attribute
244 * @param p_attribute30 Descriptive flexfield attribute
245 * @param up_description Description of the assignment (used only in update mode)
246 * @param up_use_task_schedule_flag Flag indicating whether the assignment dates and the task scheduled dates are the same (used only in update mode)
247 * @param up_raw_cost_rate_override Override raw cost rate (used only in update mode)
248 * @param up_burd_cost_rate_override Override burdened cost rate (used only in update mode)
249 * @param up_billable_work_percent Billable percent (used only in update mode)
250 * @param up_mfg_cost_type Manufacturing cost type (used only in update mode)
251 * @param up_mfg_cost_type_id Identifier of the manufacturing cost type (used only in update mode)
252 * @param p_context_flag Flag indicating whether the task assignments that are not passed on the tasks will be deleted
253 * @rep:paraminfo {@rep:precision 1}
254 * @param x_msg_count API standard: number of error messages
255 * @rep:paraminfo {@rep:required}
256 * @param x_msg_data API standard: error message
257 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
258 * @param x_return_status API standard Return of the API success / failure / unexpected error
259 * @rep:paraminfo {@rep:precision 1} {@rep:required}
260 * @rep:scope public
261 * @rep:lifecycle active
262 * @rep:displayname Load Project Task Resources
263 * @rep:compatibility S
264 */
265 -- All parameters mentioned as p_ are for both create and update
266 -- All parameters mentioned as up_ are meant for updation.
267 PROCEDURE Load_Task_Assignments
268 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
269 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
270 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
271 ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
272 ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
273 ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
274 ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
275 ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
276 ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
277 ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
278 ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
279 ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
280 ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
281 ,p_cbs_element_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) -- Added for CBS :16598322
282 ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
283 ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
284 ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
285 ,p_planned_total_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
286 ,p_planned_total_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
287 ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
288 --This parameter is added for Bug 3948128: TA Delay CR by DHI
289 ,p_scheduled_delay IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
290 ,p_attribute_category IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
291 ,p_attribute1 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
292 ,p_attribute2 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
293 ,p_attribute3 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
294 ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
295 ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
296 ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
297 ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
298 ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
299 ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
300 ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
301 ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
302 ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
303 ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
304 ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
305 ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
306 ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
307 ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
308 ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
309 ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
310 ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
311 ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
312 ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
313 ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
314 ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
315 ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
316 ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
317 ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
318 ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
319 ,p_attribute29 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
320 ,p_attribute30 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
321 ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
322 ,up_use_task_schedule_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
323 ,up_raw_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
324 ,up_burd_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
325 ,up_billable_work_percent IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
326 ,up_mfg_cost_type IN PA_VC_1000_10 := PA_VC_1000_10(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
327 ,up_mfg_cost_type_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
328 ,p_context_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
329 ,x_msg_count OUT NOCOPY NUMBER
330 ,x_msg_data OUT NOCOPY VARCHAR2
331 ,x_return_status OUT NOCOPY VARCHAR2
332 ) ;
333
334 /*#
335 * This API is used to load periodic data of project task resources to a global PL/SQL table.
336 * @param p_commit API standard (default = F): indicates if the transaction will be committed
337 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
338 * @param p_api_version_number API standard: version number
339 * @param p_pm_project_reference Reference code that uniquely identifies the project in the external system
340 * @param p_pa_project_id Identifier of the project in the Oracle Projects
341 * @param p_pa_structure_version_id Identifier of the structure version in Oracle Projects
342 * @param p_pm_task_reference External task reference
343 * @param p_pa_task_id Identifier of the task in the Oracle Projects
344 * @param p_pa_task_element_version_id Identifier of the task version in the Oracle Projects
345 * @param p_pm_task_asgmt_reference External task resource reference
346 * @param p_pa_task_assignment_id Identifier of the task resource in Oracle Projects
347 * @param p_resource_alias Planning resource alias
348 * @param p_resource_list_member_id Identifier of the planning resource
349 * @param p_period_name Name of the period
350 * @param p_start_date Start date of the period
351 * @param p_end_date End date of the period
352 * @param p_txn_quantity Planned effort or quantity for the period
353 * @param p_txn_raw_cost Planned raw cost for the period
354 * @param p_txn_bur_cost Planned burdened cost for the period
355 * @param p_currency_code Currency code
356 * @param x_msg_count API standard: number of error messages
357 * @rep:paraminfo {@rep:required}
358 * @param x_msg_data API standard: error message
359 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
360 * @param x_return_status API standard Return of the API success / failure / unexpected error
361 * @rep:paraminfo {@rep:precision 1} {@rep:required}
362 * @rep:scope public
363 * @rep:lifecycle active
364 * @rep:displayname Load Periodic Data of Project Task Resources
365 * @rep:compatibility S
366 */
367 PROCEDURE Load_Task_Asgmt_Periods
368 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
369 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
370 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
371 ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
372 ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
373 ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
374 ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
375 ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
376 ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
377 ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
378 ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
379 ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
380 ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
381 ,p_cbs_element_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) -- Added for CBS :16598322
382 --Name of the period if available
383 ,p_period_name IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
384 --Start date of the period
385 ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
386 --End date of the period
387 ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
388 ,p_txn_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
389 ,p_txn_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
390 ,p_txn_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
391 ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
392 ,x_msg_count OUT NOCOPY NUMBER
393 ,x_msg_data OUT NOCOPY VARCHAR2
394 ,x_return_status OUT NOCOPY VARCHAR2
395 );
396
397 /*#
398 * This API is used to create project task resources using the data stored in the global tables.
399 * @param p_api_version_number API standard: version number
400 * @param p_commit API standard (default = F): indicates if the transaction will be committed
401 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
402 * @param p_pm_product_code Identifier of the external system from which the project was imported
403 * @rep:paraminfo {@rep:precision 25}
404 * @param p_pm_project_reference Reference code that uniquely identifies the project in the external system
405 * @param p_pa_project_id Identifier of the project in the Oracle Projects
406 * @param p_pa_structure_version_id Identifier of the structure version in Oracle Projects
407 * @param x_msg_count API standard: number of error messages
408 * @rep:paraminfo {@rep:required}
409 * @param x_msg_data API standard: error message
410 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
411 * @param x_return_status API standard Return of the API success / failure / unexpected error
412 * @rep:paraminfo {@rep:precision 1} {@rep:required}
413 * @rep:scope public
414 * @rep:lifecycle active
415 * @rep:displayname Execute Create Project Task Resources
416 * @rep:compatibility S
417 */
418 PROCEDURE Execute_Create_Task_Asgmts
419 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
420 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
421 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
422 -- Product Code is a required parameter
423 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
424 --Either project reference or project id is required
425 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
426 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
427 --Structure version id is required
428 ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
429 ,x_msg_count OUT NOCOPY NUMBER
430 ,x_msg_data OUT NOCOPY VARCHAR2
431 ,x_return_status OUT NOCOPY VARCHAR2
432 );
433
434 /*#
435 * This API is used to update project task resources using the data stored in the global tables.
436 * @param p_api_version_number API standard: version number
437 * @param p_commit API standard (default = F): indicates if the transaction will be committed
438 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
439 * @param p_pm_product_code Identifier of the external system from which the project was imported
440 * @rep:paraminfo {@rep:precision 25}
441 * @param p_pm_project_reference Reference code that uniquely identifies the project in the external system
442 * @param p_pa_project_id Identifier of the project in the Oracle Projects
443 * @param p_pa_structure_version_id Identifier of the structure version in Oracle Projects
444 * @param x_msg_count API standard: number of error messages
445 * @rep:paraminfo {@rep:required}
446 * @param x_msg_data API standard: error message
447 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
448 * @param x_return_status API standard Return of the API success / failure / unexpected error
449 * @rep:paraminfo {@rep:precision 1} {@rep:required}
450 * @rep:scope public
451 * @rep:lifecycle active
452 * @rep:displayname Execute Update Project Task Resources
453 * @rep:compatibility S
454 */
455 PROCEDURE Execute_Update_Task_Asgmts
456 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
457 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
458 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
459 -- Product Code is a required parameter
460 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
461 --Either project reference or project id is required
462 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
463 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
464 --Structure version id is required
465 ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
466 ,x_msg_count OUT NOCOPY NUMBER
467 ,x_msg_data OUT NOCOPY VARCHAR2
468 ,x_return_status OUT NOCOPY VARCHAR2
469 );
470
471 /*#
472 * This API is used to create project task resources using a table of task resource records.
473 * @param p_commit API standard (default = F): indicates if the transaction will be committed
474 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
475 * @param p_api_version_number API standard: version number
476 * @param p_pm_product_code Identifier of the external system from which the project was imported
477 * @rep:paraminfo {@rep:precision 25}
478 * @param p_pm_project_reference Reference code that uniquely identifies the project in the external system
479 * @param p_pa_project_id Identifier of the project in the Oracle Projects
480 * @param p_pa_structure_version_id Identifier of the structure version in Oracle Projects
481 * Oracle Projects
482 * @param p_task_assignments_in Input table of task resource detail records
483 * @rep:paraminfo {@rep:required}
484 * @param p_task_assignments_out Output table of task resource detail records
485 * @rep:paraminfo {@rep:required}
486 * @param x_msg_count API standard: number of error messages
487 * @rep:paraminfo {@rep:required}
488 * @param x_msg_data API standard: error message
489 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
490 * @param x_return_status API standard Return of the API success / failure / unexpected error
491 * @rep:paraminfo {@rep:precision 1} {@rep:required}
492 * @rep:scope public
493 * @rep:lifecycle active
494 * @rep:displayname Create Project Task Resources
495 * @rep:compatibility S
496 */
497 PROCEDURE Create_Task_Assignments
498 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
499 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
500 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
501 -- Product Code is a required parameter
502 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
503 --Either project reference or project id is required
504 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
505 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
506 --Structure version id is required
507 ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
508 ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
509 ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
510 ,x_msg_count OUT NOCOPY NUMBER
511 ,x_msg_data OUT NOCOPY VARCHAR2
512 ,x_return_status OUT NOCOPY VARCHAR2
513 );
514
515
516 /*#
517 * This API is used to create project task resources and periodic data using a table of task resource records
518 * and a table of periodic data.
519 * @param p_commit API standard (default = F): indicates if the transaction will be committed
520 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
521 * @param p_api_version_number API standard: version number
522 * @param p_pm_product_code Identifier of the external system from which the project was imported
523 * @rep:paraminfo {@rep:precision 25}
524 * @param p_pm_project_reference Reference code that uniquely identifies the project in the external system
525 * @param p_pa_project_id Identifier of the project in the Oracle Projects
526 * @param p_pa_structure_version_id Identifier of the structure version in Oracle Projects
527 * @param p_task_assignments_in Input table of task resource detail records
528 * @rep:paraminfo {@rep:required}
529 * @param p_task_assignments_out Output table of task resource detail records
530 * @rep:paraminfo {@rep:required}
531 * @param p_task_assignment_periods_in Input table of task resource periodic data detail records
532 * @rep:paraminfo {@rep:required}
533 * @param p_task_assignment_periods_out Output table of task resource periodic data detail records
534 * @rep:paraminfo {@rep:required}
535 * @param x_msg_count API standard: number of error messages
536 * @rep:paraminfo {@rep:required}
537 * @param x_msg_data API standard: error message
538 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
539 * @param x_return_status API standard Return of the API success / failure / unexpected error
540 * @rep:paraminfo {@rep:precision 1} {@rep:required}
541 * @rep:scope public
542 * @rep:lifecycle active
543 * @rep:displayname Create Project Task Resource and Periodic Data
544 * @rep:compatibility S
545 */
546 PROCEDURE Create_Task_Assignment_Periods
547 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
548 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
549 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
550 -- Product Code is a required parameter
551 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
552 --Either project reference or project id is required
553 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
554 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
555 --Structure version id is required
556 ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
557 ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
558 ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
559 ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
560 ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE
561 ,x_msg_count OUT NOCOPY NUMBER
562 ,x_msg_data OUT NOCOPY VARCHAR2
563 ,x_return_status OUT NOCOPY VARCHAR2
564 );
565
566 /*#
567 * This API is used to update project task resources using a table of task resource records.
568 * @param p_commit API standard (default = F): indicates if the transaction will be committed
569 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
570 * @param p_api_version_number API standard: version number
571 * @param p_pm_product_code Identifier of the external system from which the project was imported
572 * @rep:paraminfo {@rep:precision 25}
573 * @param p_pm_project_reference Reference code that uniquely identifies the project in the external system
574 * @param p_pa_project_id Identifier of the project in the Oracle Projects
575 * @param p_pa_structure_version_id Identifier of the structure version in Oracle Projects
576 * @param p_task_assignments_in Input table of task resource detail records
577 * @rep:paraminfo {@rep:required}
578 * @param p_task_assignments_out Output table of task resource detail records
579 * @rep:paraminfo {@rep:required}
580 * @param x_msg_count API standard: number of error messages
581 * @rep:paraminfo {@rep:required}
582 * @param x_msg_data API standard: error message
583 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
584 * @param x_return_status API standard Return of the API success / failure / unexpected error
585 * @rep:paraminfo {@rep:precision 1} {@rep:required}
586 * @rep:scope public
587 * @rep:lifecycle active
588 * @rep:displayname Update Project Task Resources
589 * @rep:compatibility S
590 */
591 PROCEDURE Update_Task_Assignments
592 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
593 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
594 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
595 -- Product Code is a required parameter
596 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
597 --Either project reference or project id is required
598 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
599 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
600 --Structure version id is required
601 ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
602 ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
603 ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
604 ,x_msg_count OUT NOCOPY NUMBER
605 ,x_msg_data OUT NOCOPY VARCHAR2
606 ,x_return_status OUT NOCOPY VARCHAR2
607 );
608
609 /*#
610 * This API is used to delete project task resources using a table of task resource records.
611 * @param p_commit API standard (default = F): indicates if the transaction will be committed
612 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
613 * @param p_api_version_number API standard: version number
614 * @param p_pm_project_reference Reference code that uniquely identifies the project in the external system
615 * @param p_pa_project_id Identifier of the project in the Oracle Projects
616 * @param p_pa_structure_version_id Identifier of the structure version in Oracle Projects
617 * @param p_task_assignments_in Input table of task resource detail records
618 * @rep:paraminfo {@rep:required}
619 * @param x_msg_count API standard: number of error messages
620 * @rep:paraminfo {@rep:required}
621 * @param x_msg_data API standard: error message
622 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
623 * @param x_return_status API standard Return of the API success / failure / unexpected error
624 * @rep:paraminfo {@rep:precision 1} {@rep:required}
625 * @rep:scope public
626 * @rep:lifecycle active
627 * @rep:displayname Delete Project Task Resources
628 * @rep:compatibility S
629 */
630 PROCEDURE Delete_Task_Assignments
631 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
632 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
633 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
634 --Either project reference or project id is required
635 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
636 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
637 --Structure version id is required
638 ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
639 --Pass in list of task assignment id's or references as information at a minimum
640 ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
641 ,x_msg_count OUT NOCOPY NUMBER
642 ,x_msg_data OUT NOCOPY VARCHAR2
643 ,x_return_status OUT NOCOPY VARCHAR2
644 );
645
646 /*#
647 * This API is used to update project task resources and periodic data using a table of task resource records
648 * and a table of periodic data.
649 * @param p_commit API standard (default = F): indicates if the transaction will be committed
650 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
651 * @param p_api_version_number API standard: version number
652 * @param p_pm_product_code Identifier of the external system from which the project was imported
653 * @rep:paraminfo {@rep:precision 25}
654 * @param p_pm_project_reference Reference code that uniquely identifies the project in the external system
655 * @param p_pa_project_id Identifier of the project in the Oracle Projects
656 * @param p_pa_structure_version_id Identifier of the structure version in Oracle Projects
657 * @param p_task_assignments_in Input table of task resource detail records
658 * @rep:paraminfo {@rep:required}
659 * @param p_task_assignments_out Output table of task resource detail records
660 * @rep:paraminfo {@rep:required}
661 * @param p_task_assignment_periods_in Input table of task resource periodic data detail records
662 * @rep:paraminfo {@rep:required}
663 * @param p_task_assignment_periods_out Output table of task resource periodic data detail records
664 * @rep:paraminfo {@rep:required}
665 * @param x_msg_count API standard: number of error messages
666 * @rep:paraminfo {@rep:required}
667 * @param x_msg_data API standard: error message
668 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
669 * @param x_return_status API standard Return of the API success / failure / unexpected error
670 * @rep:paraminfo {@rep:precision 1} {@rep:required}
671 * @rep:scope public
672 * @rep:lifecycle active
673 * @rep:displayname Update Project Task Resource and Periodic Data
674 * @rep:compatibility S
675 */
676 PROCEDURE Update_Task_Assignment_Periods
677 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
678 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
679 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
680 -- Product Code is a required parameter
681 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
682 --Either project reference or project id is required
683 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
684 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
685 --Structure version id is required
686 ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
687 ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
688 ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
689 ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
690 ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE
691 ,x_msg_count OUT NOCOPY NUMBER
692 ,x_msg_data OUT NOCOPY VARCHAR2
693 ,x_return_status OUT NOCOPY VARCHAR2
694 );
695
696 /*#
697 * This API is used to fetch output parameters related to project task resources.
698 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
699 * @param p_api_version_number API standard: version number
700 * @param p_task_asgmt_index Index of task resources to be retrieved
701 * @param p_pm_task_asgmt_reference External task resource reference
702 * @rep:paraminfo {@rep:required}
703 * @param p_pa_task_assignment_id Identifier of the task resource in Oracle Projects
704 * @rep:paraminfo {@rep:required}
705 * @param p_pm_task_reference External task reference
706 * @rep:paraminfo {@rep:required}
707 * @param p_pa_task_id Identifier of the task in Oracle Projects
708 * @rep:paraminfo {@rep:required}
709 * @param p_resource_alias Alias of the planning resource
710 * @rep:paraminfo {@rep:required}
711 * @param p_resource_list_member_id Identifier of the planning resource
712 * @rep:paraminfo {@rep:required}
713 * @param x_return_status API standard Return of the API success / failure / unexpected error
714 * @rep:paraminfo {@rep:precision 1} {@rep:required}
715 * @rep:scope public
716 * @rep:lifecycle active
717 * @rep:displayname Fetch Project Task Resources
718 * @rep:compatibility S
719 */
720 PROCEDURE Fetch_Task_Assignments
721 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
722 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
723 ,p_task_asgmt_index IN pa_num_1000_num := pa_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
724 ,p_pm_task_asgmt_reference OUT NOCOPY pa_vc_1000_30
725 ,p_pa_task_assignment_id OUT NOCOPY pa_num_1000_num
726 ,p_pm_task_reference OUT NOCOPY pa_vc_1000_30
727 ,p_pa_task_id OUT NOCOPY pa_num_1000_num
728 ,p_resource_alias OUT NOCOPY pa_vc_1000_80
729 ,p_resource_list_member_id OUT NOCOPY pa_num_1000_num
730 ,p_cbs_element_id OUT NOCOPY pa_num_1000_num -- Added for CBS 16598322
731 ,x_return_status OUT NOCOPY VARCHAR2
732 );
733
734 /*#
735 * This API is used to convert project task resource reference of external system to a task resource identifier of
736 * Oracle Projects.
737 * @param p_pm_product_code Identifier of the external system from which the project was imported
738 * @rep:paraminfo {@rep:required}
739 * @param p_pa_project_id Identifier of the project in the Oracle Projects
740 * @rep:paraminfo {@rep:required}
741 * @param p_pa_structure_version_id Identifier of the structure version in Oracle Projects
742 * @rep:paraminfo {@rep:required}
743 * @param p_pa_task_id Identifier of the task in the Oracle Projects
744 * @rep:paraminfo {@rep:required}
745 * @param p_pa_task_elem_ver_id Identifier of the task version in the Oracle Projects
746 * @rep:paraminfo {@rep:required}
747 * @param p_pm_task_asgmt_reference External task resource reference
748 * @param p_pa_task_assignment_id Identifier of the task resource in Oracle Projects
749 * @param p_resource_alias Alias of the planning resource
750 * @param p_resource_list_member_id Identifier of the planning resource
751 * @param p_add_error_msg_flag API standard Flag to add error messages
752 * @param p_published_version_flag Published Version Flag
753 * @param x_pa_task_assignment_id Identifier of the task resource in Oracle Projects
754 * @rep:paraminfo {@rep:required}
755 * @param x_return_status API standard Return of the API success / failure / unexpected error
756 * @rep:paraminfo {@rep:precision 1} {@rep:required}
757 * @rep:scope public
758 * @rep:lifecycle active
759 * @rep:displayname Convert Project Task Resource Reference to Id
760 * @rep:compatibility S
761 */
762 PROCEDURE Convert_PM_TARef_To_ID
763 ( p_pm_product_code IN VARCHAR2
764 ,p_pa_project_id IN NUMBER
765 ,p_pa_structure_version_id IN NUMBER
766 ,p_pa_task_id IN NUMBER
767 ,p_pa_task_elem_ver_id IN NUMBER
768 ,p_pm_task_asgmt_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
769 ,p_pa_task_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
770 ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
771 ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
772 ,p_cbs_element_id IN NUMBER := null -- Added for CBS 16598322
773 -- Bug 3937017 Added a new parameter p_add_error_msg_flag
774 ,p_add_error_msg_flag IN VARCHAR2 DEFAULT 'Y'
775 -- Bug 3872176 Added a new parameter p_published_version_flag
776 ,p_published_version_flag IN VARCHAR2 DEFAULT 'N'
777 ,x_pa_task_assignment_id OUT NOCOPY NUMBER
778 ,x_return_status OUT NOCOPY VARCHAR2
779 ) ;
780
781
782 /*#
783 * This API procedure is used to initialize the project task resources global tables prior to
784 * Load-Execute-Fetch cycle.
785 * @rep:scope public
786 * @rep:lifecycle active
787 * @rep:displayname Initialize Project Task Resources
788 * @rep:compatibility S
789 */
790 PROCEDURE Init_Task_Assignments;
791
792
793 end PA_TASK_ASSIGNMENTS_PUB;