DBA Data[Home] [Help]

APPS.PA_TASK_ASSIGNMENTS_PUB dependencies on PA_NUM_1000_NUM

Line 272: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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)

Line 273: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(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)

Line 275: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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)

Line 276: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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)

Line 278: ,p_pa_task_assignment_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)

Line 280: ,p_resource_list_member_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)

Line 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

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)

Line 284: ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

Line 285: ,p_planned_total_raw_cost 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)

Line 286: ,p_planned_total_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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)

Line 289: ,p_scheduled_delay 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)

Line 323: ,up_raw_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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)

Line 324: ,up_burd_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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)

Line 325: ,up_billable_work_percent IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

Line 327: ,up_mfg_cost_type_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

Line 372: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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)

Line 373: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(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)

Line 375: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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)

Line 376: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(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)

Line 378: ,p_pa_task_assignment_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

Line 380: ,p_resource_list_member_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

Line 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

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)

Line 388: ,p_txn_quantity IN PA_num_1000_num := PA_num_1000_num(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

Line 389: ,p_txn_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

Line 390: ,p_txn_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

Line 723: ,p_task_asgmt_index IN pa_num_1000_num := pa_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

Line 725: ,p_pa_task_assignment_id OUT NOCOPY pa_num_1000_num

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

Line 727: ,p_pa_task_id OUT NOCOPY pa_num_1000_num

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

Line 729: ,p_resource_list_member_id OUT NOCOPY pa_num_1000_num

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:

Line 730: ,p_cbs_element_id OUT NOCOPY pa_num_1000_num -- Added for CBS 16598322

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: /*#