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