eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TASK_ASSIGNMENTS_PUB dependencies on PA_NUM_1000_NUM

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

11: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
12: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
13: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
14: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
15: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
16: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
17: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
18: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
19: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 16: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

12: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
13: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
14: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
15: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
16: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
17: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
18: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
19: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
20: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

14: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
15: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
16: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
17: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
18: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
19: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
20: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
21: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
22: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

15: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
16: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
17: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
18: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
19: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
20: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
21: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
22: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
23: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 21: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

17: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
18: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
19: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
20: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
21: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
22: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
23: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
24: ,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
25: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

Line 23: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

19: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
20: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
21: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
22: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
23: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
24: ,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
25: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
26: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
27: ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 24: ,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

20: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
21: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
22: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
23: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
24: ,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
25: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
26: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
27: ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
28: ,p_planned_total_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

23: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
24: ,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
25: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
26: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
27: ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
28: ,p_planned_total_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
29: ,p_planned_total_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
30: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
31: --This parameter is added for Bug 3948128: TA Delay CR by DHI

Line 28: ,p_planned_total_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

24: ,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
25: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
26: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
27: ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
28: ,p_planned_total_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
29: ,p_planned_total_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
30: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
31: --This parameter is added for Bug 3948128: TA Delay CR by DHI
32: ,p_scheduled_delay IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

25: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
26: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
27: ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
28: ,p_planned_total_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
29: ,p_planned_total_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
30: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
31: --This parameter is added for Bug 3948128: TA Delay CR by DHI
32: ,p_scheduled_delay IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
33: ,p_attribute_category IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 32: ,p_scheduled_delay IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

28: ,p_planned_total_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
29: ,p_planned_total_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
30: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
31: --This parameter is added for Bug 3948128: TA Delay CR by DHI
32: ,p_scheduled_delay IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
33: ,p_attribute_category IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
34: ,p_attribute1 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
35: ,p_attribute2 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
36: ,p_attribute3 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

62: ,p_attribute29 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
63: ,p_attribute30 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
64: ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
65: ,up_use_task_schedule_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
66: ,up_raw_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
67: ,up_burd_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
68: ,up_billable_work_percent IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
69: ,up_mfg_cost_type IN PA_VC_1000_10 := PA_VC_1000_10(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
70: ,up_mfg_cost_type_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

63: ,p_attribute30 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
64: ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
65: ,up_use_task_schedule_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
66: ,up_raw_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
67: ,up_burd_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
68: ,up_billable_work_percent IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
69: ,up_mfg_cost_type IN PA_VC_1000_10 := PA_VC_1000_10(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
70: ,up_mfg_cost_type_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
71: ,p_context_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

64: ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
65: ,up_use_task_schedule_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
66: ,up_raw_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
67: ,up_burd_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
68: ,up_billable_work_percent IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
69: ,up_mfg_cost_type IN PA_VC_1000_10 := PA_VC_1000_10(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
70: ,up_mfg_cost_type_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
71: ,p_context_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
72: ,x_msg_count OUT NOCOPY NUMBER

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

66: ,up_raw_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
67: ,up_burd_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
68: ,up_billable_work_percent IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
69: ,up_mfg_cost_type IN PA_VC_1000_10 := PA_VC_1000_10(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
70: ,up_mfg_cost_type_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
71: ,p_context_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
72: ,x_msg_count OUT NOCOPY NUMBER
73: ,x_msg_data OUT NOCOPY VARCHAR2
74: ,x_return_status OUT NOCOPY VARCHAR2

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

603: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
604: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
605: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
606: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
607: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
608: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
609: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
610: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
611: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 608: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

604: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
605: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
606: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
607: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
608: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
609: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
610: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
611: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
612: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

606: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
607: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
608: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
609: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
610: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
611: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
612: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
613: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
614: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

607: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
608: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
609: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
610: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
611: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
612: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
613: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
614: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
615: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 613: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

609: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
610: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
611: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
612: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
613: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
614: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
615: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
616: ,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
617: --Name of the period if available

Line 615: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

611: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
612: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
613: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
614: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
615: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
616: ,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
617: --Name of the period if available
618: ,p_period_name IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
619: --Start date of the period

Line 616: ,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

612: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
613: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
614: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
615: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
616: ,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
617: --Name of the period if available
618: ,p_period_name IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
619: --Start date of the period
620: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

Line 623: ,p_txn_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

619: --Start date of the period
620: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
621: --End date of the period
622: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
623: ,p_txn_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
624: ,p_txn_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
625: ,p_txn_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
626: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
627: ,x_msg_count OUT NOCOPY NUMBER

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

620: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
621: --End date of the period
622: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
623: ,p_txn_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
624: ,p_txn_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
625: ,p_txn_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
626: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
627: ,x_msg_count OUT NOCOPY NUMBER
628: ,x_msg_data OUT NOCOPY VARCHAR2

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

621: --End date of the period
622: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
623: ,p_txn_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
624: ,p_txn_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
625: ,p_txn_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
626: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
627: ,x_msg_count OUT NOCOPY NUMBER
628: ,x_msg_data OUT NOCOPY VARCHAR2
629: ,x_return_status OUT NOCOPY VARCHAR2

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

6765:
6766: PROCEDURE Fetch_Task_Assignments
6767: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6768: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
6769: ,p_task_asgmt_index IN pa_num_1000_num := pa_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
6770: ,p_pm_task_asgmt_reference OUT NOCOPY pa_vc_1000_30
6771: ,p_pa_task_assignment_id OUT NOCOPY pa_num_1000_num
6772: ,p_pm_task_reference OUT NOCOPY pa_vc_1000_30
6773: ,p_pa_task_id OUT NOCOPY pa_num_1000_num

Line 6771: ,p_pa_task_assignment_id OUT NOCOPY pa_num_1000_num

6767: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6768: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
6769: ,p_task_asgmt_index IN pa_num_1000_num := pa_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
6770: ,p_pm_task_asgmt_reference OUT NOCOPY pa_vc_1000_30
6771: ,p_pa_task_assignment_id OUT NOCOPY pa_num_1000_num
6772: ,p_pm_task_reference OUT NOCOPY pa_vc_1000_30
6773: ,p_pa_task_id OUT NOCOPY pa_num_1000_num
6774: ,p_resource_alias OUT NOCOPY pa_vc_1000_80
6775: ,p_resource_list_member_id OUT NOCOPY pa_num_1000_num

Line 6773: ,p_pa_task_id OUT NOCOPY pa_num_1000_num

6769: ,p_task_asgmt_index IN pa_num_1000_num := pa_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
6770: ,p_pm_task_asgmt_reference OUT NOCOPY pa_vc_1000_30
6771: ,p_pa_task_assignment_id OUT NOCOPY pa_num_1000_num
6772: ,p_pm_task_reference OUT NOCOPY pa_vc_1000_30
6773: ,p_pa_task_id OUT NOCOPY pa_num_1000_num
6774: ,p_resource_alias OUT NOCOPY pa_vc_1000_80
6775: ,p_resource_list_member_id OUT NOCOPY pa_num_1000_num
6776: ,p_cbs_element_id OUT NOCOPY pa_num_1000_num -- Added for CBS 16598322
6777: ,x_return_status OUT NOCOPY VARCHAR2

Line 6775: ,p_resource_list_member_id OUT NOCOPY pa_num_1000_num

6771: ,p_pa_task_assignment_id OUT NOCOPY pa_num_1000_num
6772: ,p_pm_task_reference OUT NOCOPY pa_vc_1000_30
6773: ,p_pa_task_id OUT NOCOPY pa_num_1000_num
6774: ,p_resource_alias OUT NOCOPY pa_vc_1000_80
6775: ,p_resource_list_member_id OUT NOCOPY pa_num_1000_num
6776: ,p_cbs_element_id OUT NOCOPY pa_num_1000_num -- Added for CBS 16598322
6777: ,x_return_status OUT NOCOPY VARCHAR2
6778: ) IS
6779: l_api_name CONSTANT VARCHAR2(30) := 'fetch_task_assignments';

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

6772: ,p_pm_task_reference OUT NOCOPY pa_vc_1000_30
6773: ,p_pa_task_id OUT NOCOPY pa_num_1000_num
6774: ,p_resource_alias OUT NOCOPY pa_vc_1000_80
6775: ,p_resource_list_member_id OUT NOCOPY pa_num_1000_num
6776: ,p_cbs_element_id OUT NOCOPY pa_num_1000_num -- Added for CBS 16598322
6777: ,x_return_status OUT NOCOPY VARCHAR2
6778: ) IS
6779: l_api_name CONSTANT VARCHAR2(30) := 'fetch_task_assignments';
6780: l_index NUMBER;

Line 6796: p_pa_task_assignment_id := pa_num_1000_num();

6792:
6793: --dbms_output.put_line('Entering Fetch Task Assignments');
6794:
6795: p_pm_task_asgmt_reference := pa_vc_1000_30();
6796: p_pa_task_assignment_id := pa_num_1000_num();
6797: p_pm_task_reference := pa_vc_1000_30();
6798: p_pa_task_id := pa_num_1000_num();
6799: p_resource_alias := pa_vc_1000_80();
6800: p_resource_list_member_id := pa_num_1000_num();

Line 6798: p_pa_task_id := pa_num_1000_num();

6794:
6795: p_pm_task_asgmt_reference := pa_vc_1000_30();
6796: p_pa_task_assignment_id := pa_num_1000_num();
6797: p_pm_task_reference := pa_vc_1000_30();
6798: p_pa_task_id := pa_num_1000_num();
6799: p_resource_alias := pa_vc_1000_80();
6800: p_resource_list_member_id := pa_num_1000_num();
6801: p_cbs_element_id :=pa_num_1000_num(); --added for the bug 16924151
6802:

Line 6800: p_resource_list_member_id := pa_num_1000_num();

6796: p_pa_task_assignment_id := pa_num_1000_num();
6797: p_pm_task_reference := pa_vc_1000_30();
6798: p_pa_task_id := pa_num_1000_num();
6799: p_resource_alias := pa_vc_1000_80();
6800: p_resource_list_member_id := pa_num_1000_num();
6801: p_cbs_element_id :=pa_num_1000_num(); --added for the bug 16924151
6802:
6803: p_pm_task_asgmt_reference.extend(p_task_asgmt_index.COUNT);
6804: p_pa_task_assignment_id.extend(p_task_asgmt_index.COUNT);

Line 6801: p_cbs_element_id :=pa_num_1000_num(); --added for the bug 16924151

6797: p_pm_task_reference := pa_vc_1000_30();
6798: p_pa_task_id := pa_num_1000_num();
6799: p_resource_alias := pa_vc_1000_80();
6800: p_resource_list_member_id := pa_num_1000_num();
6801: p_cbs_element_id :=pa_num_1000_num(); --added for the bug 16924151
6802:
6803: p_pm_task_asgmt_reference.extend(p_task_asgmt_index.COUNT);
6804: p_pa_task_assignment_id.extend(p_task_asgmt_index.COUNT);
6805: p_pm_task_reference.extend(p_task_asgmt_index.COUNT);