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_INTERFACE_UTILS_PUB

Line 11: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

7: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
8: li_curr_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9:
10: PROCEDURE Load_Task_Assignments
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)

Line 14: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

10: PROCEDURE Load_Task_Assignments
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)

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 17: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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)
21: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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 20: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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)
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

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 22: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(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)
26: ,p_end_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 25: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

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)
29: ,p_planned_total_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 26: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

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)
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)

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 30: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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)
34: ,p_attribute1 IN PA_VC_1000_150 := PA_VC_1000_150(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 33: ,p_attribute_category IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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)
37: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 34: ,p_attribute1 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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)
37: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
38: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 35: ,p_attribute2 IN PA_VC_1000_150 := PA_VC_1000_150(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)
37: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
38: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
39: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 36: ,p_attribute3 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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)
37: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
38: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
39: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
40: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 37: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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)
37: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
38: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
39: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
40: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
41: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 38: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(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)
37: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
38: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
39: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
40: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
41: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
42: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 39: ,p_attribute6 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)
37: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
38: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
39: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
40: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
41: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
42: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
43: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 40: ,p_attribute7 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)
37: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
38: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
39: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
40: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
41: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
42: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
43: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
44: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 41: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

37: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
38: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
39: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
40: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
41: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
42: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
43: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
44: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
45: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 42: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

38: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
39: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
40: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
41: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
42: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
43: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
44: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
45: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
46: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 43: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

39: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
40: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
41: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
42: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
43: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
44: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
45: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
46: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
47: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 44: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

40: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
41: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
42: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
43: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
44: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
45: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
46: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
47: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
48: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 45: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

41: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
42: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
43: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
44: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
45: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
46: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
47: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
48: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
49: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 46: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

42: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
43: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
44: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
45: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
46: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
47: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
48: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
49: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
50: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 47: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

43: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
44: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
45: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
46: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
47: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
48: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
49: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
50: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
51: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 48: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

44: ,p_attribute11 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
45: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
46: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
47: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
48: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
49: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
50: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
51: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
52: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 49: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

45: ,p_attribute12 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
46: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
47: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
48: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
49: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
50: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
51: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
52: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
53: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 50: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

46: ,p_attribute13 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
47: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
48: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
49: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
50: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
51: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
52: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
53: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
54: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 51: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

47: ,p_attribute14 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
48: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
49: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
50: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
51: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
52: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
53: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
54: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
55: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 52: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

48: ,p_attribute15 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
49: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
50: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
51: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
52: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
53: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
54: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
55: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
56: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 53: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

49: ,p_attribute16 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
50: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
51: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
52: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
53: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
54: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
55: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
56: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
57: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 54: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

50: ,p_attribute17 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
51: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
52: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
53: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
54: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
55: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
56: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
57: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
58: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 55: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

51: ,p_attribute18 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
52: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
53: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
54: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
55: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
56: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
57: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
58: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
59: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 56: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

52: ,p_attribute19 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
53: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
54: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
55: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
56: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
57: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
58: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
59: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
60: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 57: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

53: ,p_attribute20 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
54: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
55: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
56: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
57: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
58: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
59: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
60: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
61: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 58: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

54: ,p_attribute21 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
55: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
56: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
57: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
58: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
59: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
60: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
61: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
62: ,p_attribute29 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 59: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

55: ,p_attribute22 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
56: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
57: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
58: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
59: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
60: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
61: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
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)

Line 60: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

56: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
57: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
58: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
59: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
60: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
61: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
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)

Line 61: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

57: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
58: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
59: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
60: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
61: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
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)

Line 62: ,p_attribute29 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

58: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
59: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
60: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
61: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
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)

Line 63: ,p_attribute30 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

59: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
60: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
61: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
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)

Line 64: ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

60: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
61: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
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)

Line 65: ,up_use_task_schedule_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

61: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
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)

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 69: ,up_mfg_cost_type IN PA_VC_1000_10 := PA_VC_1000_10(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
73: ,x_msg_data OUT NOCOPY VARCHAR2

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 71: ,p_context_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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
75: ) IS

Line 133: (p_pa_task_assignment_id(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

129:
130: if p_pa_task_assignment_id.exists(i) and p_pm_task_asgmt_reference.exists(i) then
131:
132: if (p_pa_task_assignment_id(i) is null and p_pm_task_asgmt_reference(i) is null) OR
133: (p_pa_task_assignment_id(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134: and p_pm_task_asgmt_reference(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) then
135:
136: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
137: pa_debug.g_err_stage:='Returning from Load TA as index loaded at :' || i ;

Line 134: and p_pm_task_asgmt_reference(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) then

130: if p_pa_task_assignment_id.exists(i) and p_pm_task_asgmt_reference.exists(i) then
131:
132: if (p_pa_task_assignment_id(i) is null and p_pm_task_asgmt_reference(i) is null) OR
133: (p_pa_task_assignment_id(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134: and p_pm_task_asgmt_reference(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) then
135:
136: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
137: pa_debug.g_err_stage:='Returning from Load TA as index loaded at :' || i ;
138: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 147: (p_pa_task_assignment_id(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then

143: end if;
144: elsif p_pa_task_assignment_id.exists(i) then
145:
146: if (p_pa_task_assignment_id(i) is null) OR
147: (p_pa_task_assignment_id(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
148: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
149: pa_debug.g_err_stage:='Returning from Load TA as index loaded at :' || i ;
150: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
151: END IF;

Line 158: (p_pm_task_asgmt_reference(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) then

154: elsif p_pm_task_asgmt_reference.exists(i) then
155:
156:
157: if (p_pm_task_asgmt_reference(i) is null) OR
158: (p_pm_task_asgmt_reference(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) then
159: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
160: pa_debug.g_err_stage:='Returning from Load TA as index loaded at :' || i ;
161: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
162: END IF;

Line 189: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pm_project_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

185:
186: IF p_pm_project_reference.exists(i) THEN
187: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pm_project_reference := p_pm_project_reference(i);
188: ELSE
189: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pm_project_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
190: END IF;
191:
192:
193: IF p_pa_project_id.exists(i) THEN

Line 196: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pa_project_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

192:
193: IF p_pa_project_id.exists(i) THEN
194: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pa_project_id := p_pa_project_id(i);
195: ELSE
196: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pa_project_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
197: END IF;
198:
199: IF p_pa_structure_version_id.exists(i) THEN
200: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pa_structure_version_id := p_pa_structure_version_id(i);

Line 202: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pa_structure_version_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

198:
199: IF p_pa_structure_version_id.exists(i) THEN
200: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pa_structure_version_id := p_pa_structure_version_id(i);
201: ELSE
202: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pa_structure_version_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
203: END IF;
204:
205: IF p_pm_task_reference.exists(i) THEN
206: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pm_task_reference := p_pm_task_reference(i);

Line 212: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pm_task_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

208: pa_debug.g_err_stage:='In Load task asgmts. p_pm_task_reference(' || i || '):' || p_pm_task_reference(i) ;
209: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
210: END IF;
211: ELSE
212: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pm_task_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
213: END IF;
214:
215: IF p_pa_task_id.exists(i) THEN
216: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pa_task_id := p_pa_task_id(i);

Line 222: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pa_task_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

218: pa_debug.g_err_stage:='In Load task asgmts. p_pa_task_id(' || i || '):' || p_pa_task_id(i);
219: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
220: END IF;
221: ELSE
222: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pa_task_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
223: END IF;
224:
225: IF p_pa_task_element_version_id.exists(i) THEN
226: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pa_task_element_version_id := p_pa_task_element_version_id(i);

Line 232: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pa_task_element_version_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

228: pa_debug.g_err_stage:='In Load task asgmts. p_pa_task_element_version_id(' || i || '):' || p_pa_task_element_version_id(i);
229: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
230: END IF;
231: ELSE
232: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pa_task_element_version_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
233: END IF;
234:
235: IF p_pa_task_assignment_id.exists(i) THEN
236: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pa_task_assignment_id := p_pa_task_assignment_id(i);

Line 242: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pa_task_assignment_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

238: pa_debug.g_err_stage:='In Load task asgmts. p_pa_task_assignment_id(' || i || '):' || p_pa_task_assignment_id(i);
239: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
240: END IF;
241: ELSE
242: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pa_task_assignment_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
243: END IF;
244:
245: IF p_pm_task_asgmt_reference.exists(i) THEN
246: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pm_task_asgmt_reference := p_pm_task_asgmt_reference(i);

Line 252: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pm_task_asgmt_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

248: pa_debug.g_err_stage:='In Load task asgmts. p_pm_task_asgmt_reference(' || i || '):' || p_pm_task_asgmt_reference(i);
249: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
250: END IF;
251: ELSE
252: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).pm_task_asgmt_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
253: END IF;
254:
255: IF p_resource_alias.exists(i) THEN
256: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).resource_alias := p_resource_alias(i);

Line 258: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).resource_alias := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

254:
255: IF p_resource_alias.exists(i) THEN
256: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).resource_alias := p_resource_alias(i);
257: ELSE
258: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).resource_alias := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
259: END IF;
260:
261: IF p_resource_list_member_id.exists(i) THEN
262: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).resource_list_member_id := p_resource_list_member_id(i);

Line 264: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).resource_list_member_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

260:
261: IF p_resource_list_member_id.exists(i) THEN
262: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).resource_list_member_id := p_resource_list_member_id(i);
263: ELSE
264: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).resource_list_member_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
265: END IF;
266:
267: -- Added for CBS 16598322
268: IF p_cbs_element_id.exists(i) THEN

Line 271: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).cbs_element_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

267: -- Added for CBS 16598322
268: IF p_cbs_element_id.exists(i) THEN
269: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).cbs_element_id := p_cbs_element_id(i);
270: ELSE
271: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).cbs_element_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
272: END IF;
273:
274: IF p_start_date.exists(i) THEN
275: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).start_date := p_start_date(i);

Line 277: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).start_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;

273:
274: IF p_start_date.exists(i) THEN
275: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).start_date := p_start_date(i);
276: ELSE
277: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).start_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
278: END IF;
279:
280: IF p_end_date.exists(i) THEN
281: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).end_date := p_end_date(i);

Line 283: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).end_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;

279:
280: IF p_end_date.exists(i) THEN
281: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).end_date := p_end_date(i);
282: ELSE
283: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).end_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
284: END IF;
285:
286: IF p_planned_quantity.exists(i) THEN
287: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 293: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_quantity := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

289: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
290: END IF;
291: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_quantity := p_planned_quantity(i);
292: ELSE
293: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_quantity := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
294: END IF;
295:
296: IF p_planned_total_raw_cost.exists(i) THEN
297: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_total_raw_cost := p_planned_total_raw_cost(i);

Line 299: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_total_raw_cost := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

295:
296: IF p_planned_total_raw_cost.exists(i) THEN
297: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_total_raw_cost := p_planned_total_raw_cost(i);
298: ELSE
299: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_total_raw_cost := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
300: END IF;
301:
302: IF p_planned_total_bur_cost.exists(i) THEN
303: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_total_bur_cost := p_planned_total_bur_cost(i);

Line 305: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_total_bur_cost := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

301:
302: IF p_planned_total_bur_cost.exists(i) THEN
303: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_total_bur_cost := p_planned_total_bur_cost(i);
304: ELSE
305: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_total_bur_cost := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
306: END IF;
307:
308: IF p_currency_code.exists(i) THEN
309: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).currency_code := p_currency_code(i);

Line 311: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).currency_code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

307:
308: IF p_currency_code.exists(i) THEN
309: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).currency_code := p_currency_code(i);
310: ELSE
311: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).currency_code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
312: END IF;
313:
314: --This parameter is added for Bug 3948128: TA Delay CR by DHI
315: IF p_scheduled_delay.exists(i) THEN

Line 318: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).scheduled_delay := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

314: --This parameter is added for Bug 3948128: TA Delay CR by DHI
315: IF p_scheduled_delay.exists(i) THEN
316: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).scheduled_delay := p_scheduled_delay(i);
317: ELSE
318: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).scheduled_delay := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
319: END IF;
320:
321: IF p_attribute_category.exists(i) THEN
322: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute_category := p_attribute_category(i);

Line 324: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute_category := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

320:
321: IF p_attribute_category.exists(i) THEN
322: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute_category := p_attribute_category(i);
323: ELSE
324: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute_category := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
325: END IF;
326:
327: IF p_attribute1.exists(i) THEN
328: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute1 := p_attribute1(i);

Line 330: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute1 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

326:
327: IF p_attribute1.exists(i) THEN
328: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute1 := p_attribute1(i);
329: ELSE
330: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute1 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
331: END IF;
332:
333: IF p_attribute2.exists(i) THEN
334: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute2 := p_attribute2(i);

Line 336: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

332:
333: IF p_attribute2.exists(i) THEN
334: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute2 := p_attribute2(i);
335: ELSE
336: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
337: END IF;
338:
339: IF p_attribute3.exists(i) THEN
340: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute3 := p_attribute3(i);

Line 342: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute3 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

338:
339: IF p_attribute3.exists(i) THEN
340: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute3 := p_attribute3(i);
341: ELSE
342: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute3 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
343: END IF;
344:
345: IF p_attribute4.exists(i) THEN
346: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute4 := p_attribute4(i);

Line 348: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute4 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

344:
345: IF p_attribute4.exists(i) THEN
346: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute4 := p_attribute4(i);
347: ELSE
348: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute4 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
349: END IF;
350:
351: IF p_attribute5.exists(i) THEN
352: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute5 := p_attribute5(i);

Line 354: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute5 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

350:
351: IF p_attribute5.exists(i) THEN
352: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute5 := p_attribute5(i);
353: ELSE
354: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute5 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
355: END IF;
356:
357: IF p_attribute6.exists(i) THEN
358: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute6 := p_attribute6(i);

Line 360: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute6 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

356:
357: IF p_attribute6.exists(i) THEN
358: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute6 := p_attribute6(i);
359: ELSE
360: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute6 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
361: END IF;
362:
363: IF p_attribute7.exists(i) THEN
364: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute7 := p_attribute7(i);

Line 366: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute7 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

362:
363: IF p_attribute7.exists(i) THEN
364: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute7 := p_attribute7(i);
365: ELSE
366: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute7 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
367: END IF;
368:
369: IF p_attribute8.exists(i) THEN
370: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute8 := p_attribute8(i);

Line 372: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute8 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

368:
369: IF p_attribute8.exists(i) THEN
370: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute8 := p_attribute8(i);
371: ELSE
372: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute8 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
373: END IF;
374:
375: IF p_attribute9.exists(i) THEN
376: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute9 := p_attribute9(i);

Line 378: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute9 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

374:
375: IF p_attribute9.exists(i) THEN
376: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute9 := p_attribute9(i);
377: ELSE
378: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute9 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
379: END IF;
380:
381: IF p_attribute10.exists(i) THEN
382: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute10 := p_attribute10(i);

Line 384: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute10 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

380:
381: IF p_attribute10.exists(i) THEN
382: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute10 := p_attribute10(i);
383: ELSE
384: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute10 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
385: END IF;
386:
387: IF p_attribute11.exists(i) THEN
388: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute11 := p_attribute11(i);

Line 390: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute11 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

386:
387: IF p_attribute11.exists(i) THEN
388: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute11 := p_attribute11(i);
389: ELSE
390: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute11 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
391: END IF;
392: IF p_attribute12.exists(i) THEN
393: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute12 := p_attribute12(i);
394: ELSE

Line 395: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute12 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

391: END IF;
392: IF p_attribute12.exists(i) THEN
393: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute12 := p_attribute12(i);
394: ELSE
395: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute12 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
396: END IF;
397: IF p_attribute13.exists(i) THEN
398: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute13 := p_attribute13(i);
399: ELSE

Line 400: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute13 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

396: END IF;
397: IF p_attribute13.exists(i) THEN
398: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute13 := p_attribute13(i);
399: ELSE
400: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute13 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
401: END IF;
402: IF p_attribute14.exists(i) THEN
403: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute14 := p_attribute14(i);
404: ELSE

Line 405: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute14 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

401: END IF;
402: IF p_attribute14.exists(i) THEN
403: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute14 := p_attribute14(i);
404: ELSE
405: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute14 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
406: END IF;
407: IF p_attribute15.exists(i) THEN
408: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute15 := p_attribute15(i);
409: ELSE

Line 410: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute15 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

406: END IF;
407: IF p_attribute15.exists(i) THEN
408: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute15 := p_attribute15(i);
409: ELSE
410: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute15 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
411: END IF;
412: IF p_attribute16.exists(i) THEN
413: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute16 := p_attribute16(i);
414: ELSE

Line 415: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute16 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

411: END IF;
412: IF p_attribute16.exists(i) THEN
413: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute16 := p_attribute16(i);
414: ELSE
415: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute16 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
416: END IF;
417: IF p_attribute17.exists(i) THEN
418: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute17 := p_attribute17(i);
419: ELSE

Line 420: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute17 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

416: END IF;
417: IF p_attribute17.exists(i) THEN
418: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute17 := p_attribute17(i);
419: ELSE
420: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute17 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
421: END IF;
422: IF p_attribute18.exists(i) THEN
423: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute18 := p_attribute18(i);
424: ELSE

Line 425: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute18 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

421: END IF;
422: IF p_attribute18.exists(i) THEN
423: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute18 := p_attribute18(i);
424: ELSE
425: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute18 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
426: END IF;
427: IF p_attribute19.exists(i) THEN
428: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute19 := p_attribute19(i);
429: ELSE

Line 430: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute19 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

426: END IF;
427: IF p_attribute19.exists(i) THEN
428: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute19 := p_attribute19(i);
429: ELSE
430: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute19 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
431: END IF;
432: IF p_attribute20.exists(i) THEN
433: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute20 := p_attribute20(i);
434: ELSE

Line 435: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute20 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

431: END IF;
432: IF p_attribute20.exists(i) THEN
433: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute20 := p_attribute20(i);
434: ELSE
435: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute20 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
436: END IF;
437: IF p_attribute21.exists(i) THEN
438: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute21 := p_attribute21(i);
439: ELSE

Line 440: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute21 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

436: END IF;
437: IF p_attribute21.exists(i) THEN
438: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute21 := p_attribute21(i);
439: ELSE
440: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute21 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
441: END IF;
442: IF p_attribute22.exists(i) THEN
443: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute22 := p_attribute22(i);
444: ELSE

Line 445: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute22 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

441: END IF;
442: IF p_attribute22.exists(i) THEN
443: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute22 := p_attribute22(i);
444: ELSE
445: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute22 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
446: END IF;
447: IF p_attribute23.exists(i) THEN
448: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute23 := p_attribute23(i);
449: ELSE

Line 450: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute23 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

446: END IF;
447: IF p_attribute23.exists(i) THEN
448: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute23 := p_attribute23(i);
449: ELSE
450: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute23 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
451: END IF;
452: IF p_attribute24.exists(i) THEN
453: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute24 := p_attribute24(i);
454: ELSE

Line 455: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute24 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

451: END IF;
452: IF p_attribute24.exists(i) THEN
453: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute24 := p_attribute24(i);
454: ELSE
455: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute24 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
456: END IF;
457: IF p_attribute25.exists(i) THEN
458: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute25 := p_attribute25(i);
459: ELSE

Line 460: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute25 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

456: END IF;
457: IF p_attribute25.exists(i) THEN
458: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute25 := p_attribute25(i);
459: ELSE
460: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute25 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
461: END IF;
462: IF p_attribute26.exists(i) THEN
463: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute26 := p_attribute26(i);
464: ELSE

Line 465: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute26 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

461: END IF;
462: IF p_attribute26.exists(i) THEN
463: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute26 := p_attribute26(i);
464: ELSE
465: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute26 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
466: END IF;
467: IF p_attribute27.exists(i) THEN
468: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute27 := p_attribute27(i);
469: ELSE

Line 470: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute27 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

466: END IF;
467: IF p_attribute27.exists(i) THEN
468: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute27 := p_attribute27(i);
469: ELSE
470: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute27 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
471: END IF;
472: IF p_attribute28.exists(i) THEN
473: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute28 := p_attribute28(i);
474: ELSE

Line 475: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute28 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

471: END IF;
472: IF p_attribute28.exists(i) THEN
473: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute28 := p_attribute28(i);
474: ELSE
475: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute28 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
476: END IF;
477: IF p_attribute29.exists(i) THEN
478: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute29 := p_attribute29(i);
479: ELSE

Line 480: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute29 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

476: END IF;
477: IF p_attribute29.exists(i) THEN
478: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute29 := p_attribute29(i);
479: ELSE
480: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute29 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
481: END IF;
482: IF p_attribute30.exists(i) THEN
483: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute30 := p_attribute30(i);
484: ELSE

Line 485: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute30 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

481: END IF;
482: IF p_attribute30.exists(i) THEN
483: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute30 := p_attribute30(i);
484: ELSE
485: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute30 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
486: END IF;
487: IF up_description.exists(i) THEN
488: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).description := up_description(i);
489: ELSE

Line 490: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).description := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

486: END IF;
487: IF up_description.exists(i) THEN
488: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).description := up_description(i);
489: ELSE
490: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).description := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
491: END IF;
492:
493: IF up_use_task_schedule_flag.exists(i) THEN
494: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).use_task_schedule_flag := up_use_task_schedule_flag(i);

Line 496: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).use_task_schedule_flag := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

492:
493: IF up_use_task_schedule_flag.exists(i) THEN
494: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).use_task_schedule_flag := up_use_task_schedule_flag(i);
495: ELSE
496: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).use_task_schedule_flag := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
497: END IF;
498:
499: IF up_raw_cost_rate_override.exists(i) THEN
500: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).raw_cost_rate_override := up_raw_cost_rate_override(i);

Line 502: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).raw_cost_rate_override := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

498:
499: IF up_raw_cost_rate_override.exists(i) THEN
500: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).raw_cost_rate_override := up_raw_cost_rate_override(i);
501: ELSE
502: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).raw_cost_rate_override := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
503: END IF;
504: IF up_burd_cost_rate_override.exists(i) THEN
505: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).burd_cost_rate_override := up_burd_cost_rate_override(i);
506: ELSE

Line 507: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).burd_cost_rate_override := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

503: END IF;
504: IF up_burd_cost_rate_override.exists(i) THEN
505: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).burd_cost_rate_override := up_burd_cost_rate_override(i);
506: ELSE
507: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).burd_cost_rate_override := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
508: END IF;
509: IF up_mfg_cost_type.exists(i) THEN
510: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).mfg_cost_type := up_mfg_cost_type(i);
511: ELSE

Line 512: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).mfg_cost_type := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

508: END IF;
509: IF up_mfg_cost_type.exists(i) THEN
510: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).mfg_cost_type := up_mfg_cost_type(i);
511: ELSE
512: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).mfg_cost_type := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
513: END IF;
514: IF up_mfg_cost_type_id.exists(i) THEN
515: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).mfg_cost_type_id := up_mfg_cost_type_id(i);
516: ELSE

Line 517: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).mfg_cost_type_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

513: END IF;
514: IF up_mfg_cost_type_id.exists(i) THEN
515: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).mfg_cost_type_id := up_mfg_cost_type_id(i);
516: ELSE
517: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).mfg_cost_type_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
518: END IF;
519: IF up_billable_work_percent.exists(i) THEN
520: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).billable_work_percent := up_billable_work_percent(i);
521: ELSE

Line 522: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).billable_work_percent := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

518: END IF;
519: IF up_billable_work_percent.exists(i) THEN
520: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).billable_work_percent := up_billable_work_percent(i);
521: ELSE
522: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).billable_work_percent := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
523: END IF;
524: IF p_context_flag.exists(i) THEN
525: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).p_context := p_context_flag(i);
526: ELSE

Line 527: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).p_context := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

523: END IF;
524: IF p_context_flag.exists(i) THEN
525: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).p_context := p_context_flag(i);
526: ELSE
527: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).p_context := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
528: END IF;
529:
530:
531: END LOOP;

Line 603: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

599: END LOAD_TASK_ASSIGNMENTS;
600:
601:
602: PROCEDURE Load_Task_Asgmt_Periods
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)

Line 606: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

602: PROCEDURE Load_Task_Asgmt_Periods
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)

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 609: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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)
613: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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 612: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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)
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

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 614: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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
618: ,p_period_name IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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 618: ,p_period_name IN PA_VC_1000_30 := PA_VC_1000_30(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)
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)

Line 620: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

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)
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)

Line 622: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

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)
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)

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 626: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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
630: ) IS

Line 739: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_project_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

735:
736: IF p_pm_project_reference.exists(i) THEN
737: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_project_reference := p_pm_project_reference(i);
738: ELSE
739: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_project_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
740: END IF;
741:
742: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
743: pa_debug.g_err_stage:='g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_project_reference:' || g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_project_reference;

Line 749: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_project_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

745: END IF;
746: IF p_pa_project_id.exists(i) THEN
747: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_project_id := p_pa_project_id(i);
748: ELSE
749: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_project_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
750: END IF;
751: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
752: pa_debug.g_err_stage:='g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_project_id:' || g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_project_id;
753: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 759: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_structure_version_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

755:
756: IF p_pa_structure_version_id.exists(i) THEN
757: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_structure_version_id := p_pa_structure_version_id(i);
758: ELSE
759: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_structure_version_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
760: END IF;
761: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
762: pa_debug.g_err_stage:='g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_structure_version_id:' || g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_structure_version_id;
763: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 769: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_task_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

765:
766: IF p_pm_task_reference.exists(i) THEN
767: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_task_reference := p_pm_task_reference(i);
768: ELSE
769: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_task_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
770: END IF;
771: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
772: pa_debug.g_err_stage:='g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_task_reference:' || g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_task_reference;
773: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 779: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

775:
776: IF p_pa_task_id.exists(i) THEN
777: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_id := p_pa_task_id(i);
778: ELSE
779: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
780: END IF;
781: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
782: pa_debug.g_err_stage:='g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_id:' || g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_id;
783: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 793: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_element_version_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

789: pa_debug.g_err_stage:='In Load task asgmts periods. p_pa_task_element_version_id(' || i || '):' || p_pa_task_element_version_id(i) ;
790: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
791: END IF;
792: ELSE
793: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_element_version_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
794: END IF;
795:
796: IF p_pa_task_assignment_id.exists(i) THEN
797: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_assignment_id := p_pa_task_assignment_id(i);

Line 799: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_assignment_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

795:
796: IF p_pa_task_assignment_id.exists(i) THEN
797: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_assignment_id := p_pa_task_assignment_id(i);
798: ELSE
799: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_assignment_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
800: END IF;
801: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
802: pa_debug.g_err_stage:='g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_assignment_id:' || g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_assignment_id;
803: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 809: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_task_asgmt_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

805:
806: IF p_pm_task_asgmt_reference.exists(i) THEN
807: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_task_asgmt_reference := p_pm_task_asgmt_reference(i);
808: ELSE
809: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_task_asgmt_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
810: END IF;
811: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
812: pa_debug.g_err_stage:='g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_task_asgmt_reference :' || g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_task_asgmt_reference ;
813: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 819: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).resource_alias := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

815:
816: IF p_resource_alias.exists(i) THEN
817: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).resource_alias := p_resource_alias(i);
818: ELSE
819: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).resource_alias := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
820: END IF;
821: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
822: pa_debug.g_err_stage:='g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).resource_alias :' || g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).resource_alias ;
823: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 829: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).resource_list_member_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

825:
826: IF p_resource_list_member_id.exists(i) THEN
827: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).resource_list_member_id := p_resource_list_member_id(i);
828: ELSE
829: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).resource_list_member_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
830: END IF;
831:
832: -- Added for CBS 16598322
833: IF p_cbs_element_id.exists(i) THEN

Line 836: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).cbs_element_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

832: -- Added for CBS 16598322
833: IF p_cbs_element_id.exists(i) THEN
834: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).cbs_element_id := p_cbs_element_id(i);
835: ELSE
836: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).cbs_element_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
837: END IF;
838:
839: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
840: pa_debug.g_err_stage:='g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).resource_list_member_id :' || g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).resource_list_member_id ;

Line 846: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).start_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;

842: END IF;
843: IF p_start_date.exists(i) THEN
844: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).start_date := p_start_date(i);
845: ELSE
846: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).start_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
847: END IF;
848: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
849: pa_debug.g_err_stage:='g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).start_date :' || g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).start_date ;
850: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 856: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).end_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;

852:
853: IF p_end_date.exists(i) THEN
854: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).end_date := p_end_date(i);
855: ELSE
856: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).end_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
857: END IF;
858: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
859: pa_debug.g_err_stage:='g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).end_date :' || g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).end_date ;
860: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 866: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).period_name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

862:
863: IF p_period_name.exists(i) THEN
864: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).period_name := p_period_name(i);
865: ELSE
866: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).period_name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
867: END IF;
868: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
869: pa_debug.g_err_stage:='g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).period_name :' || g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).period_name ;
870: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 876: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).quantity := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

872:
873: IF p_txn_quantity.exists(i) THEN
874: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).quantity := p_txn_quantity(i);
875: ELSE
876: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).quantity := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
877: END IF;
878: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
879: pa_debug.g_err_stage:='g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).quantity :' || g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).quantity ;
880: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 886: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_raw_cost := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

882:
883: IF p_txn_raw_cost.exists(i) THEN
884: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_raw_cost := p_txn_raw_cost(i);
885: ELSE
886: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_raw_cost := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
887: END IF;
888: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
889: pa_debug.g_err_stage:='g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_raw_cost :' || g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_raw_cost ;
890: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 895: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_burdened_cost := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

891: END IF;
892: IF p_txn_bur_cost.exists(i) THEN
893: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_burdened_cost := p_txn_bur_cost(i);
894: ELSE
895: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_burdened_cost := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
896: END IF;
897: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
898: pa_debug.g_err_stage:='g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_burdened_cost :' || g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_burdened_cost ;
899: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 904: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_currency_code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

900: END IF;
901: IF p_currency_code.exists(i) THEN
902: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_currency_code := p_currency_code(i);
903: ELSE
904: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_currency_code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
905: END IF;
906: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
907: pa_debug.g_err_stage:='g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_currency_code :' || g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_currency_code ;
908: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 988: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

984: -- 01-APR-2004
985: --
986:
987: PROCEDURE Execute_Create_Task_Asgmts
988: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
989: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
990: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
991: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
992: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 991: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

987: PROCEDURE Execute_Create_Task_Asgmts
988: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
989: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
990: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
991: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
992: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
993: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
994: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
995: ,x_msg_count OUT NOCOPY NUMBER

Line 992: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

988: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
989: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
990: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
991: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
992: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
993: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
994: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
995: ,x_msg_count OUT NOCOPY NUMBER
996: ,x_msg_data OUT NOCOPY VARCHAR2

Line 993: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

989: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
990: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
991: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
992: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
993: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
994: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
995: ,x_msg_count OUT NOCOPY NUMBER
996: ,x_msg_data OUT NOCOPY VARCHAR2
997: ,x_return_status OUT NOCOPY VARCHAR2

Line 994: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

990: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
991: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
992: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
993: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
994: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
995: ,x_msg_count OUT NOCOPY NUMBER
996: ,x_msg_data OUT NOCOPY VARCHAR2
997: ,x_return_status OUT NOCOPY VARCHAR2
998: ) IS

Line 1167: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1163: END EXECUTE_CREATE_TASK_ASGMTS;
1164:
1165:
1166: PROCEDURE Execute_Update_Task_Asgmts
1167: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1168: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1169: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1170: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1171: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 1170: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1166: PROCEDURE Execute_Update_Task_Asgmts
1167: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1168: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1169: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1170: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1171: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1172: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1173: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1174: ,x_msg_count OUT NOCOPY NUMBER

Line 1171: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1167: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1168: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1169: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1170: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1171: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1172: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1173: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1174: ,x_msg_count OUT NOCOPY NUMBER
1175: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1172: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1168: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1169: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1170: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1171: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1172: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1173: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1174: ,x_msg_count OUT NOCOPY NUMBER
1175: ,x_msg_data OUT NOCOPY VARCHAR2
1176: ,x_return_status OUT NOCOPY VARCHAR2

Line 1173: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1169: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1170: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1171: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1172: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1173: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1174: ,x_msg_count OUT NOCOPY NUMBER
1175: ,x_msg_data OUT NOCOPY VARCHAR2
1176: ,x_return_status OUT NOCOPY VARCHAR2
1177: ) IS

Line 1338: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1334: END EXECUTE_UPDATE_TASK_ASGMTS;
1335:
1336:
1337: PROCEDURE Create_Task_Assignments
1338: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1339: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1340: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1341: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1342: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 1341: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1337: PROCEDURE Create_Task_Assignments
1338: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1339: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1340: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1341: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1342: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1343: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1344: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1345: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE

Line 1342: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1338: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1339: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1340: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1341: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1342: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1343: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1344: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1345: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
1346: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE

Line 1343: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1339: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1340: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1341: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1342: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1343: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1344: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1345: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
1346: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
1347: ,x_msg_count OUT NOCOPY NUMBER

Line 1344: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1340: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1341: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1342: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1343: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1344: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1345: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
1346: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
1347: ,x_msg_count OUT NOCOPY NUMBER
1348: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1650: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

1646: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1647: END IF;
1648:
1649: IF p_pm_product_code IS NOT NULL
1650: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1651:
1652: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1653: pa_interface_utils_pub.map_new_amg_msg
1654: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'

Line 1653: pa_interface_utils_pub.map_new_amg_msg

1649: IF p_pm_product_code IS NOT NULL
1650: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1651:
1652: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1653: pa_interface_utils_pub.map_new_amg_msg
1654: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
1655: ,p_msg_attribute => 'CHANGE'
1656: ,p_resize_flag => 'N'
1657: ,p_msg_context => 'GENERAL'

Line 1685: IF p_pa_project_id is NOT NULL AND p_pa_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

1681: l_module_name := 'PA_PM_ADD_TASK_ASSIGNMENT';
1682:
1683: --> Project Id check.
1684:
1685: IF p_pa_project_id is NOT NULL AND p_pa_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1686:
1687: l_project_id := p_pa_project_id;
1688:
1689: --dbms_output.put_line('Project_id successfully passed..Check ' || l_project_id);

Line 1744: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := l_project_id; --bug 2471668 ( in the project context )

1740:
1741: -- Function security procedure check whether user have the
1742: -- privilege to add task or not
1743: --dbms_output.put_line('Security Initialize successful.');
1744: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := l_project_id; --bug 2471668 ( in the project context )
1745:
1746: --Get the CBS flag 16598322
1747: l_cbs_enabled_project := PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(p_Project_Id => l_project_id);
1748:

Line 1773: pa_interface_utils_pub.map_new_amg_msg

1769: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1770: END IF;
1771: --dbms_output.put_line('PA_PM_ADD_TASK_ASSIGNMENT function check successful.');
1772: IF l_function_allowed = 'N' THEN
1773: pa_interface_utils_pub.map_new_amg_msg
1774: ( p_old_message_code => 'PA_FUNCTION_SECURITY_ENFORCED'
1775: ,p_msg_attribute => 'CHANGE'
1776: ,p_resize_flag => 'Y'
1777: ,p_msg_context => 'GENERAL'

Line 1806: pa_interface_utils_pub.map_new_amg_msg

1802:
1803: -- The user does not have update privileges on this project
1804: -- Hence , raise error
1805: --dbms_output.put_line('pa_security.allow_query or update not allowed..');
1806: pa_interface_utils_pub.map_new_amg_msg
1807: ( p_old_message_code => 'PA_PROJECT_SECURITY_ENFORCED'
1808: ,p_msg_attribute => 'CHANGE'
1809: ,p_resize_flag => 'Y'
1810: ,p_msg_context => 'GENERAL'

Line 1832: pa_interface_utils_pub.map_new_amg_msg

1828: IF NVL(PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ), 'N') = 'N' THEN
1829: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1830: THEN
1831: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS N..');
1832: pa_interface_utils_pub.map_new_amg_msg
1833: ( p_old_message_code => 'PA_PS_WP_NOT_SEP_FN_AMG'
1834: ,p_msg_attribute => 'CHANGE'
1835: ,p_resize_flag => 'N'
1836: ,p_msg_context => 'GENERAL'

Line 1856: (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

1852: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1853: END IF;
1854:
1855: IF p_pa_structure_version_id IS NOT NULL AND
1856: (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1857:
1858: l_struct_elem_version_id := p_pa_structure_version_id;
1859:
1860: ELSE

Line 1869: l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1865:
1866: --dbms_output.put_line(' structure version is: ' || l_struct_elem_version_id );
1867: --dbms_output.put_line(' testing str if..' );
1868: IF ( l_struct_elem_version_id IS NULL OR
1869: l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1870: )
1871:
1872: THEN
1873: --dbms_output.put_line(' test struct.null or g miss..');

Line 1878: pa_interface_utils_pub.map_new_amg_msg

1874:
1875: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1876: THEN
1877: --dbms_output.put_line(' test struct.null or gmiss err..');
1878: pa_interface_utils_pub.map_new_amg_msg
1879: ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
1880: ,p_msg_attribute => 'CHANGE'
1881: ,p_resize_flag => 'N'
1882: ,p_msg_context => 'GENERAL'

Line 1927: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

1923: OPEN C_Get_Budget_Version_Id(l_struct_elem_version_id);
1924: FETCH C_Get_Budget_Version_Id INTO l_budget_version_id;
1925: CLOSE C_Get_Budget_Version_Id;
1926:
1927: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
1928: l_budget_version_id IS NULL )
1929: THEN
1930: --dbms_output.put_line(' budget version not obtained.. successful' );
1931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 2129: p_task_assignments_in(i).pa_task_element_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

2125: l_d_task_id := NULL;
2126: l_task_elem_version_id := NULL;
2127:
2128: IF p_task_assignments_in.exists(i) AND p_task_assignments_in(i).pa_task_element_version_id IS NOT NULL AND
2129: p_task_assignments_in(i).pa_task_element_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
2130: OPEN C_task_version(p_task_assignments_in(i).pa_task_element_version_id);
2131: FETCH C_task_version INTO l_task_elem_version_id, l_d_task_id;
2132: CLOSE C_task_version;
2133:

Line 2136: p_task_assignments_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

2132: CLOSE C_task_version;
2133:
2134:
2135: ELSIF p_task_assignments_in.exists(i) AND p_task_assignments_in(i).pa_task_id IS NOT NULL AND
2136: p_task_assignments_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
2137:
2138: l_d_task_id := p_task_assignments_in(i).pa_task_id;
2139:
2140: --dbms_output.put_line('l_d_task_id valid input:'|| l_d_task_id);

Line 2149: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

2145: END IF;
2146:
2147: --dbms_output.put_line('l_d_task_id'|| l_d_task_id);
2148:
2149: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
2150: l_d_task_id IS NULL )
2151: THEN
2152: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2153: THEN

Line 2169: p_task_assignments_in(i).pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

2165:
2166:
2167: ELSIF p_task_assignments_in.exists(i) AND
2168: p_task_assignments_in(i).pm_task_reference IS NOT NULL AND
2169: p_task_assignments_in(i).pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2170:
2171: --dbms_output.put_line('l_d_task_reference'|| p_task_assignments_in(i).pm_task_reference);
2172:
2173:

Line 2183: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

2179: ,p_return_status => l_return_status);
2180:
2181: --dbms_output.put_line('l_d_task_id'|| l_d_task_id);
2182:
2183: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
2184: l_d_task_id IS NULL )
2185: THEN
2186: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2187: THEN

Line 2206: IF ( l_task_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

2202: END IF;
2203:
2204:
2205:
2206: IF ( l_task_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
2207: l_task_elem_version_id IS NULL )
2208: THEN
2209: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2210: THEN

Line 2242: p_task_assignments_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

2238:
2239: lk_task_elem_version_id_tbl(k_index) := l_task_elem_version_id;
2240: --dbms_output.put_line('test 1:');
2241: IF p_task_assignments_in(i).resource_list_member_id IS NOT NULL AND
2242: p_task_assignments_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
2243:
2244:
2245: OPEN C_Res_List_Mem_Check(p_task_assignments_in(i).resource_list_member_id);
2246: Fetch C_Res_List_Mem_Check into C_Res_List_Mem_Check_Rec;

Line 2292: p_task_assignments_in(i).cbs_element_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

2288: END IF;
2289: -- ADD CBS VALIDATIONS HERE 16598322
2290: IF l_cbs_enabled_project = 'Y' THEN
2291: IF p_task_assignments_in(i).cbs_element_id IS NOT NULL AND
2292: p_task_assignments_in(i).cbs_element_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
2293:
2294: PA_ALTERNATE_TASK_PVT.Is_Cost_Element_Valid(
2295: p_Cbs_Element_Id =>p_task_assignments_in(i).cbs_element_id,
2296: p_Task_Id =>l_d_task_id,

Line 2326: p_task_assignments_in(i).start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and

2322: END IF;
2323:
2324:
2325: IF p_task_assignments_in(i).start_date IS NOT NULL and
2326: p_task_assignments_in(i).start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
2327: p_task_assignments_in(i).end_date IS NOT NULL and
2328: p_task_assignments_in(i).end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
2329: p_task_assignments_in(i).start_date > p_task_assignments_in(i).end_date THEN
2330:

Line 2328: p_task_assignments_in(i).end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and

2324:
2325: IF p_task_assignments_in(i).start_date IS NOT NULL and
2326: p_task_assignments_in(i).start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
2327: p_task_assignments_in(i).end_date IS NOT NULL and
2328: p_task_assignments_in(i).end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
2329: p_task_assignments_in(i).start_date > p_task_assignments_in(i).end_date THEN
2330:
2331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2332: IF p_pm_product_code = 'MSPROJECT'

Line 2358: p_task_assignments_in(i).pm_task_asgmt_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

2354: END IF;
2355:
2356: --dbms_output.put_line('test 7:');
2357: IF p_task_assignments_in(i).pm_task_asgmt_reference IS NULL OR
2358: p_task_assignments_in(i).pm_task_asgmt_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2359: --dbms_output.put_line('pm_task_asgmt_reference is NULL/G_MISS...error');
2360: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2361: THEN
2362: PA_UTILS.ADD_MESSAGE

Line 3061: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3057:
3058:
3059:
3060: PROCEDURE Create_Task_Assignment_Periods
3061: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3062: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3063: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3064: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3065: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 3064: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

3060: PROCEDURE Create_Task_Assignment_Periods
3061: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3062: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3063: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3064: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3065: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3066: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3067: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3068: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE

Line 3065: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

3061: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3062: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3063: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3064: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3065: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3066: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3067: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3068: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3069: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE

Line 3066: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3062: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3063: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3064: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3065: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3066: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3067: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3068: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3069: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
3070: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE

Line 3067: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3063: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3064: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3065: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3066: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3067: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3068: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3069: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
3070: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
3071: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE

Line 3132: IF p_pa_structure_version_id IS NOT NULL AND (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

3128: -- Set API return status to success
3129: x_return_status := FND_API.G_RET_STS_SUCCESS;
3130:
3131: -- Added for bug 5469303
3132: IF p_pa_structure_version_id IS NOT NULL AND (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
3133: l_struct_elem_version_id := p_pa_structure_version_id;
3134: ELSE
3135: l_struct_elem_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id( p_project_id => p_pa_project_id);
3136: END IF;

Line 3138: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_struct_elem_version_id IS NULL ) THEN

3134: ELSE
3135: l_struct_elem_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id( p_project_id => p_pa_project_id);
3136: END IF;
3137:
3138: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_struct_elem_version_id IS NULL ) THEN
3139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3140: pa_interface_utils_pub.map_new_amg_msg ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
3141: ,p_msg_attribute => 'CHANGE'
3142: ,p_resize_flag => 'N'

Line 3140: pa_interface_utils_pub.map_new_amg_msg ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'

3136: END IF;
3137:
3138: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_struct_elem_version_id IS NULL ) THEN
3139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3140: pa_interface_utils_pub.map_new_amg_msg ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
3141: ,p_msg_attribute => 'CHANGE'
3142: ,p_resize_flag => 'N'
3143: ,p_msg_context => 'GENERAL'
3144: ,p_attribute1 => ''

Line 3157: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_budget_version_id IS NULL ) THEN

3153: OPEN C_Get_Budget_Version_Id(l_struct_elem_version_id);
3154: FETCH C_Get_Budget_Version_Id INTO l_budget_version_id;
3155: CLOSE C_Get_Budget_Version_Id;
3156:
3157: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_budget_version_id IS NULL ) THEN
3158: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3159: PA_UTILS.ADD_MESSAGE (p_app_short_name => 'PA',
3160: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'
3161: );

Line 3335: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3331: END Create_Task_Assignment_Periods;
3332:
3333:
3334: PROCEDURE Update_Task_Assignment_Periods
3335: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3336: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3337: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3338: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3339: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 3338: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

3334: PROCEDURE Update_Task_Assignment_Periods
3335: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3336: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3337: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3338: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3339: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3340: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3341: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3342: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE

Line 3339: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

3335: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3336: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3337: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3338: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3339: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3340: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3341: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3342: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3343: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE

Line 3340: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3336: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3337: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3338: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3339: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3340: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3341: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3342: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3343: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
3344: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE

Line 3341: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3337: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3338: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3339: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3340: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3341: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3342: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3343: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
3344: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
3345: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE

Line 3408: IF p_pa_structure_version_id IS NOT NULL AND (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

3404:
3405: x_return_status := FND_API.G_RET_STS_SUCCESS;
3406:
3407: -- Added for bug 5469303
3408: IF p_pa_structure_version_id IS NOT NULL AND (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
3409: l_struct_elem_version_id := p_pa_structure_version_id;
3410: ELSE
3411: l_struct_elem_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id( p_project_id => p_pa_project_id);
3412: END IF;

Line 3414: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_struct_elem_version_id IS NULL ) THEN

3410: ELSE
3411: l_struct_elem_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id( p_project_id => p_pa_project_id);
3412: END IF;
3413:
3414: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_struct_elem_version_id IS NULL ) THEN
3415: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3416: pa_interface_utils_pub.map_new_amg_msg ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
3417: ,p_msg_attribute => 'CHANGE'
3418: ,p_resize_flag => 'N'

Line 3416: pa_interface_utils_pub.map_new_amg_msg ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'

3412: END IF;
3413:
3414: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_struct_elem_version_id IS NULL ) THEN
3415: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3416: pa_interface_utils_pub.map_new_amg_msg ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
3417: ,p_msg_attribute => 'CHANGE'
3418: ,p_resize_flag => 'N'
3419: ,p_msg_context => 'GENERAL'
3420: ,p_attribute1 => ''

Line 3434: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_budget_version_id IS NULL ) THEN

3430: OPEN C_Get_Budget_Version_Id(l_struct_elem_version_id);
3431: FETCH C_Get_Budget_Version_Id INTO l_budget_version_id;
3432: CLOSE C_Get_Budget_Version_Id;
3433:
3434: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_budget_version_id IS NULL ) THEN
3435: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3436: PA_UTILS.ADD_MESSAGE (p_app_short_name => 'PA',
3437: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'
3438: );

Line 3612: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3608: END Update_Task_Assignment_Periods;
3609:
3610:
3611: PROCEDURE Delete_Task_Assignments
3612: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3613: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3614: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3615: --Either project reference or project id is required
3616: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 3616: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

3612: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3613: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3614: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3615: --Either project reference or project id is required
3616: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3617: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3618: --Structure version id is required
3619: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3620: --Pass in list of task assignment id's or references as information at a minimum

Line 3617: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3613: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3614: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3615: --Either project reference or project id is required
3616: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3617: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3618: --Structure version id is required
3619: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3620: --Pass in list of task assignment id's or references as information at a minimum
3621: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE

Line 3619: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3615: --Either project reference or project id is required
3616: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3617: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3618: --Structure version id is required
3619: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3620: --Pass in list of task assignment id's or references as information at a minimum
3621: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3622: ,x_msg_count OUT NOCOPY NUMBER
3623: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3775: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3771:
3772:
3773:
3774: PROCEDURE Update_Task_Assignments
3775: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3776: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3777: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3778: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3779: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 3778: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

3774: PROCEDURE Update_Task_Assignments
3775: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3776: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3777: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3778: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3779: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3780: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3781: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3782: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE

Line 3779: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

3775: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3776: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3777: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3778: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3779: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3780: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3781: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3782: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3783: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE

Line 3780: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3776: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3777: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3778: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3779: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3780: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3781: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3782: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3783: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
3784: ,x_msg_count OUT NOCOPY NUMBER

Line 3781: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3777: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3778: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3779: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3780: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3781: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3782: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3783: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
3784: ,x_msg_count OUT NOCOPY NUMBER
3785: ,x_msg_data OUT NOCOPY VARCHAR2

Line 4338: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

4334: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
4335: END IF;
4336:
4337: IF p_pm_product_code IS NOT NULL
4338: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
4339:
4340: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4341: pa_interface_utils_pub.map_new_amg_msg
4342: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'

Line 4341: pa_interface_utils_pub.map_new_amg_msg

4337: IF p_pm_product_code IS NOT NULL
4338: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
4339:
4340: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4341: pa_interface_utils_pub.map_new_amg_msg
4342: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
4343: ,p_msg_attribute => 'CHANGE'
4344: ,p_resize_flag => 'N'
4345: ,p_msg_context => 'GENERAL'

Line 4376: IF p_pa_project_id is NOT NULL AND p_pa_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

4372:
4373: --
4374:
4375:
4376: IF p_pa_project_id is NOT NULL AND p_pa_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4377:
4378: l_project_id := p_pa_project_id;
4379:
4380: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 4439: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := l_project_id; --bug 2471668 ( in the project context )

4435:
4436: -- Function security procedure check whether user have the
4437: -- privilege to UPDATE task or not
4438:
4439: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := l_project_id; --bug 2471668 ( in the project context )
4440: --Get the CBS flag 16598322
4441: l_cbs_enabled_project := PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(p_Project_Id => l_project_id);
4442:
4443: PA_PM_FUNCTION_SECURITY_PUB.check_function_security

Line 4462: pa_interface_utils_pub.map_new_amg_msg

4458: RAISE FND_API.G_EXC_ERROR;
4459: END IF;
4460:
4461: IF l_function_allowed = 'N' THEN
4462: pa_interface_utils_pub.map_new_amg_msg
4463: ( p_old_message_code => 'PA_FUNCTION_SECURITY_ENFORCED'
4464: ,p_msg_attribute => 'CHANGE'
4465: ,p_resize_flag => 'Y'
4466: ,p_msg_context => 'GENERAL'

Line 4504: pa_interface_utils_pub.map_new_amg_msg

4500:
4501: -- The user does not have update privileges on this project
4502: -- Hence , raise error
4503:
4504: pa_interface_utils_pub.map_new_amg_msg
4505: ( p_old_message_code => 'PA_PROJECT_SECURITY_ENFORCED'
4506: ,p_msg_attribute => 'CHANGE'
4507: ,p_resize_flag => 'Y'
4508: ,p_msg_context => 'GENERAL'

Line 4531: pa_interface_utils_pub.map_new_amg_msg

4527: IF NVL(PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ), 'N') = 'N' THEN
4528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4529: THEN
4530: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS N..');
4531: pa_interface_utils_pub.map_new_amg_msg
4532: ( p_old_message_code => 'PA_PS_WP_NOT_SEP_FN_AMG'
4533: ,p_msg_attribute => 'CHANGE'
4534: ,p_resize_flag => 'N'
4535: ,p_msg_context => 'GENERAL'

Line 4552: (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

4548: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
4549: END IF;
4550:
4551: IF p_pa_structure_version_id IS NOT NULL AND
4552: (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
4553:
4554: l_struct_elem_version_id := p_pa_structure_version_id;
4555:
4556: ELSE

Line 4567: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

4563:
4564: --dbms_output.put_line(' structure version: ' || l_struct_elem_version_id );
4565: --Project Structures Integration
4566:
4567: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4568: l_struct_elem_version_id IS NULL )
4569: THEN
4570: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4571: THEN

Line 4572: pa_interface_utils_pub.map_new_amg_msg

4568: l_struct_elem_version_id IS NULL )
4569: THEN
4570: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4571: THEN
4572: pa_interface_utils_pub.map_new_amg_msg
4573: ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
4574: ,p_msg_attribute => 'CHANGE'
4575: ,p_resize_flag => 'N'
4576: ,p_msg_context => 'GENERAL'

Line 4629: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

4625: OPEN C_Get_Budget_Version_Id(l_struct_elem_version_id);
4626: FETCH C_Get_Budget_Version_Id INTO l_budget_version_id;
4627: CLOSE C_Get_Budget_Version_Id;
4628:
4629: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4630: l_budget_version_id IS NULL ) THEN
4631: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4632: THEN
4633: PA_UTILS.ADD_MESSAGE

Line 4763: p_task_assignments_in(i).pa_task_assignment_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

4759:
4760: C_Res_Asgmt_Data_Rec := NULL;
4761:
4762: IF p_task_assignments_in(i).pa_task_assignment_id is not NULL AND
4763: p_task_assignments_in(i).pa_task_assignment_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4764:
4765: OPEN C_Res_Asgmt_Data(p_task_assignments_in(i).pa_task_assignment_id);
4766: FETCH C_Res_Asgmt_Data into C_Res_Asgmt_Data_Rec;
4767: CLOSE C_Res_Asgmt_Data;

Line 4775: p_task_assignments_in(i).pa_task_element_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

4771: END IF;
4772:
4773:
4774: IF l_task_elem_version_id IS NULL AND p_task_assignments_in.exists(i) AND p_task_assignments_in(i).pa_task_element_version_id IS NOT NULL AND
4775: p_task_assignments_in(i).pa_task_element_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4776:
4777: OPEN C_task_version(p_task_assignments_in(i).pa_task_element_version_id);
4778: FETCH C_task_version INTO l_task_elem_version_id, l_d_task_id;
4779: CLOSE C_task_version;

Line 4784: p_task_assignments_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

4780:
4781:
4782: ELSIF l_task_elem_version_id IS NULL AND p_task_assignments_in.exists(i) AND
4783: p_task_assignments_in(i).pa_task_id IS NOT NULL AND
4784: p_task_assignments_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4785:
4786: l_d_task_id := p_task_assignments_in(i).pa_task_id;
4787:
4788: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 4799: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

4795: pa_debug.g_err_stage:='l_d_task_id'|| l_d_task_id;
4796: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
4797: END IF;
4798:
4799: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4800: l_d_task_id IS NULL )
4801: THEN
4802: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4803: THEN

Line 4821: p_task_assignments_in(i).pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

4817:
4818:
4819: ELSIF l_task_elem_version_id IS NULL AND p_task_assignments_in.exists(i) AND
4820: p_task_assignments_in(i).pm_task_reference IS NOT NULL AND
4821: p_task_assignments_in(i).pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
4822:
4823: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4824: pa_debug.g_err_stage:='l_d_task_reference'|| p_task_assignments_in(i).pm_task_reference;
4825: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 4841: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

4837: pa_debug.g_err_stage:='l_d_task_id'|| l_d_task_id;
4838: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
4839: END IF;
4840:
4841: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4842: l_d_task_id IS NULL )
4843: THEN
4844: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4845: THEN

Line 4863: l_task_elem_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

4859:
4860: END IF;
4861:
4862: IF l_task_elem_version_id is not NULL AND
4863: l_task_elem_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4864:
4865: l_task_elem_version_id_tbl.extend(1);
4866:
4867: l_task_elem_version_id_tbl(i):= l_task_elem_version_id;

Line 4892: p_task_assignments_in(i).pa_task_assignment_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

4888: l_task_assignments_in(i).pm_task_asgmt_reference := p_task_assignments_in(i).pm_task_asgmt_reference;
4889:
4890: lp_resource_assignment_id_tbl.extend(1);
4891: IF p_task_assignments_in(i).pa_task_assignment_id is NOT null AND
4892: p_task_assignments_in(i).pa_task_assignment_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4893:
4894:
4895: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4896: pa_debug.g_err_stage:='Accepting Task Assignment Id given:' || p_task_assignments_in(i).pa_task_assignment_id ;

Line 4902: p_task_assignments_in(i).pm_task_asgmt_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

4898: END IF;
4899: lp_resource_assignment_id_tbl(i) := p_task_assignments_in(i).pa_task_assignment_id;
4900:
4901: ELSIF p_task_assignments_in(i).pm_task_asgmt_reference is not null AND
4902: p_task_assignments_in(i).pm_task_asgmt_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
4903:
4904: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4905: pa_debug.g_err_stage:='Converting Task Asgmt Reference:' || p_task_assignments_in(i).pm_task_asgmt_reference ;
4906: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 4974: p_task_assignments_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

4970:
4971: IF p_task_assignments_in(i).p_context <> 'D' THEN --Validations of Not Delete Context..(Update or Add)
4972:
4973: IF p_task_assignments_in(i).resource_list_member_id IS NOT NULL AND
4974: p_task_assignments_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4975:
4976: C_Res_List_Mem_Check_Rec := NULL;
4977:
4978: OPEN C_Res_List_Mem_Check(p_task_assignments_in(i).resource_list_member_id);

Line 5002: p_task_assignments_in(i).resource_list_member_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

4998:
4999: ELSIF p_task_assignments_in(i).pa_task_assignment_id IS NULL AND
5000: p_task_assignments_in(i).p_context <> 'D' AND
5001: (p_task_assignments_in(i).resource_list_member_id IS NULL OR
5002: p_task_assignments_in(i).resource_list_member_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
5003: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5004: THEN
5005: IF p_pm_product_code = 'MSPROJECT'
5006: THEN

Line 5029: p_task_assignments_in(i).cbs_element_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

5025:
5026: -- ADD CBS VALIDATIONS HERE 16598322
5027: IF l_cbs_enabled_project = 'Y' AND p_task_assignments_in(i).p_context <> 'D' THEN
5028: IF p_task_assignments_in(i).cbs_element_id IS NOT NULL AND
5029: p_task_assignments_in(i).cbs_element_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
5030:
5031: PA_ALTERNATE_TASK_PVT.Is_Cost_Element_Valid(
5032: p_Cbs_Element_Id =>p_task_assignments_in(i).cbs_element_id,
5033: p_Task_Id =>l_d_task_id,

Line 5067: p_task_assignments_in(i).start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and

5063: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5064: END IF;
5065:
5066: IF p_task_assignments_in(i).start_date IS NOT NULL and
5067: p_task_assignments_in(i).start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
5068: p_task_assignments_in(i).end_date IS NOT NULL and
5069: p_task_assignments_in(i).end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
5070: p_task_assignments_in(i).start_date > p_task_assignments_in(i).end_date THEN
5071:

Line 5069: p_task_assignments_in(i).end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and

5065:
5066: IF p_task_assignments_in(i).start_date IS NOT NULL and
5067: p_task_assignments_in(i).start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
5068: p_task_assignments_in(i).end_date IS NOT NULL and
5069: p_task_assignments_in(i).end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
5070: p_task_assignments_in(i).start_date > p_task_assignments_in(i).end_date THEN
5071:
5072: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5073: IF p_pm_product_code = 'MSPROJECT'

Line 5101: l_task_assignments_in(i).pm_task_asgmt_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

5097: -- Made the pm_task_asgmt_reference to refer to l_task_assignments_in plsql table.
5098: -- For Bug 8842724
5099: IF p_task_assignments_in(i).pa_task_assignment_id IS NULL and
5100: (l_task_assignments_in(i).pm_task_asgmt_reference IS NULL OR
5101: l_task_assignments_in(i).pm_task_asgmt_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
5102: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5103: THEN
5104: PA_UTILS.ADD_MESSAGE
5105: (p_app_short_name => 'PA',

Line 5120: p_task_assignments_in(i).use_task_schedule_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND

5116: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5117: END IF;
5118:
5119: IF p_task_assignments_in(i).use_task_schedule_flag IS NOT NULL AND
5120: p_task_assignments_in(i).use_task_schedule_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
5121: p_task_assignments_in(i).use_task_schedule_flag not in ('Y', 'N') THEN
5122: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5123: THEN
5124: pa_interface_utils_pub.map_new_amg_msg

Line 5124: pa_interface_utils_pub.map_new_amg_msg

5120: p_task_assignments_in(i).use_task_schedule_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
5121: p_task_assignments_in(i).use_task_schedule_flag not in ('Y', 'N') THEN
5122: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5123: THEN
5124: pa_interface_utils_pub.map_new_amg_msg
5125: ( p_old_message_code => 'PA_TASK_SCHED_FLAG_INVALID' -->>>>
5126: ,p_msg_attribute => 'CHANGE'
5127: ,p_resize_flag => 'N'
5128: ,p_msg_context => 'GENERAL'

Line 5147: l_currency_code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

5143: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
5144: END IF;
5145:
5146: -- 4108372: Should default currency code to default value instead of NULL
5147: l_currency_code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
5148:
5149: IF p_task_assignments_in(i).currency_code IS NOT NULL AND
5150: p_task_assignments_in(i).currency_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
5151:

Line 5150: p_task_assignments_in(i).currency_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

5146: -- 4108372: Should default currency code to default value instead of NULL
5147: l_currency_code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
5148:
5149: IF p_task_assignments_in(i).currency_code IS NOT NULL AND
5150: p_task_assignments_in(i).currency_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
5151:
5152: OPEN C_currency_exists(p_task_assignments_in(i).currency_code, l_project_id );
5153: FETCH C_currency_exists INTO C_currency_exists_rec;
5154:

Line 5160: pa_interface_utils_pub.map_new_amg_msg

5156: l_currency_code := p_task_assignments_in(i).currency_code ;
5157: ELSIF C_currency_exists%NOTFOUND THEN
5158: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5159: THEN
5160: pa_interface_utils_pub.map_new_amg_msg
5161: ( p_old_message_code => 'PA_INVALID_CURRENCY' -->>>>
5162: ,p_msg_attribute => 'CHANGE'
5163: ,p_resize_flag => 'N'
5164: ,p_msg_context => 'GENERAL'

Line 5189: lp_resource_assignment_id_tbl(i) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

5185:
5186:
5187:
5188: IF lp_resource_assignment_id_tbl(i) IS NOT NULL AND --Delete Content
5189: lp_resource_assignment_id_tbl(i) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
5190: p_task_assignments_in(i).p_context = 'D' THEN
5191:
5192: OPEN C_Res_Asgmt_Data(lp_resource_assignment_id_tbl(i));
5193: FETCH C_Res_Asgmt_Data into C_Res_Asgmt_Data_Rec;

Line 5210: lp_resource_assignment_id_tbl(i) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

5206: ld_resource_assignment_id_tbl(del_index) := lp_resource_assignment_id_tbl(i);
5207:
5208:
5209: ELSIF lp_resource_assignment_id_tbl(i) IS NOT NULL AND --Update Content
5210: lp_resource_assignment_id_tbl(i) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
5211: p_task_assignments_in(i).p_context <> 'D' THEN
5212:
5213: OPEN C_Res_Asgmt_Data(lp_resource_assignment_id_tbl(i));
5214: FETCH C_Res_Asgmt_Data into C_Res_Asgmt_Data_Rec;

Line 5237: p_task_assignments_in(i).billable_work_percent <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

5233: END IF;
5234:
5235:
5236: IF p_task_assignments_in(i).billable_work_percent IS NOT NULL AND
5237: p_task_assignments_in(i).billable_work_percent <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
5238: ( p_task_assignments_in(i).billable_work_percent < 0 OR
5239: p_task_assignments_in(i).billable_work_percent > 100) THEN
5240: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5241: THEN

Line 5277: p_task_assignments_in(i).mfg_cost_type_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

5273: l_Cost_Type_exists := NULL;
5274: l_cost_type_id := NULL;
5275:
5276: IF p_task_assignments_in(i).mfg_cost_type_id IS NOT NULL AND
5277: p_task_assignments_in(i).mfg_cost_type_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
5278:
5279: OPEN C_Cost_Type_Exists(p_task_assignments_in(i).mfg_cost_type_id );
5280: FETCH C_Cost_Type_Exists INTO C_Cost_Type_Exists_rec;
5281:

Line 5290: p_task_assignments_in(i).mfg_cost_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

5286: END IF;
5287: CLOSE C_Cost_Type_Exists;
5288:
5289: ELSIF p_task_assignments_in(i).mfg_cost_type IS NOT NULL AND
5290: p_task_assignments_in(i).mfg_cost_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
5291:
5292: OPEN C_Cost_Type(p_task_assignments_in(i).mfg_cost_type_id );
5293: FETCH C_Cost_Type INTO C_Cost_Type_rec;
5294:

Line 5309: pa_interface_utils_pub.map_new_amg_msg

5305:
5306: IF l_Cost_Type_exists is NOT NULL and l_Cost_Type_exists = 'N' THEN
5307: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5308: THEN
5309: pa_interface_utils_pub.map_new_amg_msg
5310: ( p_old_message_code => 'PA_INVALID_COST_TYPE' -->>>>
5311: ,p_msg_attribute => 'CHANGE'
5312: ,p_resize_flag => 'N'
5313: ,p_msg_context => 'GENERAL'

Line 5334: AND ((p_task_assignments_in(i).spread_curve_id IS NOT NULL AND p_task_assignments_in(i).spread_curve_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) OR

5330: l_spread_curve_code := NULL;
5331: l_fixed_date := p_task_assignments_in(i).fixed_date;
5332:
5333: IF ( (l_time_phased_code IS NULL OR (l_time_phased_code <> 'P' AND l_time_phased_code<> 'G'))
5334: AND ((p_task_assignments_in(i).spread_curve_id IS NOT NULL AND p_task_assignments_in(i).spread_curve_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) OR
5335: (p_task_assignments_in(i).spread_curve_name IS NOT NULL AND p_task_assignments_in(i).spread_curve_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ))) THEN
5336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5337: pa_interface_utils_pub.map_new_amg_msg
5338: ( p_old_message_code => 'PA_DISABL_WP_NA' -->>>>

Line 5335: (p_task_assignments_in(i).spread_curve_name IS NOT NULL AND p_task_assignments_in(i).spread_curve_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ))) THEN

5331: l_fixed_date := p_task_assignments_in(i).fixed_date;
5332:
5333: IF ( (l_time_phased_code IS NULL OR (l_time_phased_code <> 'P' AND l_time_phased_code<> 'G'))
5334: AND ((p_task_assignments_in(i).spread_curve_id IS NOT NULL AND p_task_assignments_in(i).spread_curve_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) OR
5335: (p_task_assignments_in(i).spread_curve_name IS NOT NULL AND p_task_assignments_in(i).spread_curve_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ))) THEN
5336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5337: pa_interface_utils_pub.map_new_amg_msg
5338: ( p_old_message_code => 'PA_DISABL_WP_NA' -->>>>
5339: ,p_msg_attribute => 'CHANGE'

Line 5337: pa_interface_utils_pub.map_new_amg_msg

5333: IF ( (l_time_phased_code IS NULL OR (l_time_phased_code <> 'P' AND l_time_phased_code<> 'G'))
5334: AND ((p_task_assignments_in(i).spread_curve_id IS NOT NULL AND p_task_assignments_in(i).spread_curve_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) OR
5335: (p_task_assignments_in(i).spread_curve_name IS NOT NULL AND p_task_assignments_in(i).spread_curve_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ))) THEN
5336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5337: pa_interface_utils_pub.map_new_amg_msg
5338: ( p_old_message_code => 'PA_DISABL_WP_NA' -->>>>
5339: ,p_msg_attribute => 'CHANGE'
5340: ,p_resize_flag => 'N'
5341: ,p_msg_context => 'GENERAL'

Line 5352: p_task_assignments_in(i).spread_curve_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

5348: RAISE FND_API.G_EXC_ERROR;
5349: END IF;
5350:
5351: IF p_task_assignments_in(i).spread_curve_id IS NOT NULL AND
5352: p_task_assignments_in(i).spread_curve_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5353: THEN
5354: OPEN C_Spread_Curve_Exists(p_task_assignments_in(i).spread_curve_id
5355: );
5356: FETCH C_Spread_Curve_Exists INTO c_spread_curve_exists_rec;

Line 5366: PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

5362: CLOSE C_Spread_Curve_Exists;
5363:
5364: ELSIF p_task_assignments_in(i).spread_curve_name IS NOT NULL AND
5365: p_task_assignments_in(i). spread_curve_name <>
5366: PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
5367: OPEN C_Spread_Curve (p_task_assignments_in(i).spread_curve_name);
5368: FETCH C_Spread_Curve INTO c_spread_curve_rec;
5369: IF C_Spread_Curve %FOUND THEN
5370: l_spread_curve_id := c_spread_curve_rec.spread_curve_id;

Line 5381: pa_interface_utils_pub.map_new_amg_msg

5377:
5378: IF (l_spread_curve_exists is NOT NULL and l_spread_curve_exists = 'N') OR
5379: (p_task_assignments_in(i).spread_curve_id IS NULL) THEN
5380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5381: pa_interface_utils_pub.map_new_amg_msg
5382: ( p_old_message_code => 'PA_INVALID_SPREAD_CURVE' -->>>>
5383: ,p_msg_attribute => 'CHANGE'
5384: ,p_resize_flag => 'N'
5385: ,p_msg_context => 'GENERAL'

Line 5405: IF l_spread_curve_code = 'FIXED_DATE' and (l_fixed_date is null or l_fixed_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN

5401: CLOSE C_Spread_Curve_Code;
5402: END IF;
5403:
5404: IF l_spread_curve_code is NOT NULL THEN
5405: IF l_spread_curve_code = 'FIXED_DATE' and (l_fixed_date is null or l_fixed_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN
5406: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5407: pa_interface_utils_pub.map_new_amg_msg
5408: ( p_old_message_code => 'PA_FIXED_DATE_MISSING' -->>>>
5409: ,p_msg_attribute => 'CHANGE'

Line 5407: pa_interface_utils_pub.map_new_amg_msg

5403:
5404: IF l_spread_curve_code is NOT NULL THEN
5405: IF l_spread_curve_code = 'FIXED_DATE' and (l_fixed_date is null or l_fixed_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN
5406: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5407: pa_interface_utils_pub.map_new_amg_msg
5408: ( p_old_message_code => 'PA_FIXED_DATE_MISSING' -->>>>
5409: ,p_msg_attribute => 'CHANGE'
5410: ,p_resize_flag => 'N'
5411: ,p_msg_context => 'GENERAL'

Line 5423: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

5419: END IF;
5420:
5421:
5422: IF l_spread_curve_code <> 'FIXED_DATE' and l_fixed_date <>
5423: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
5424: pa_interface_utils_pub.map_new_amg_msg
5425: ( p_old_message_code => 'PA_APPL_ONLY_FIXED_DATE' -->>>>
5426: ,p_msg_attribute => 'CHANGE'
5427: ,p_resize_flag => 'N'

Line 5424: pa_interface_utils_pub.map_new_amg_msg

5420:
5421:
5422: IF l_spread_curve_code <> 'FIXED_DATE' and l_fixed_date <>
5423: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
5424: pa_interface_utils_pub.map_new_amg_msg
5425: ( p_old_message_code => 'PA_APPL_ONLY_FIXED_DATE' -->>>>
5426: ,p_msg_attribute => 'CHANGE'
5427: ,p_resize_flag => 'N'
5428: ,p_msg_context => 'GENERAL'

Line 5443: IF p_task_assignments_in(i).spread_curve_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_assignments_in(i). spread_curve_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

5439:
5440: END IF;
5441:
5442: -- Retain existing spread curve if spread curve is not specified
5443: IF p_task_assignments_in(i).spread_curve_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_assignments_in(i). spread_curve_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
5444: -- Made the pm_task_asgmt_reference to refer to l_task_assignments_in plsql table.
5445: -- For Bug 8842724
5446:
5447: IF p_task_assignments_in(i).pa_task_assignment_id is NULL OR p_task_assignments_in(i).pa_task_assignment_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 5447: IF p_task_assignments_in(i).pa_task_assignment_id is NULL OR p_task_assignments_in(i).pa_task_assignment_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

5443: IF p_task_assignments_in(i).spread_curve_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_assignments_in(i). spread_curve_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
5444: -- Made the pm_task_asgmt_reference to refer to l_task_assignments_in plsql table.
5445: -- For Bug 8842724
5446:
5447: IF p_task_assignments_in(i).pa_task_assignment_id is NULL OR p_task_assignments_in(i).pa_task_assignment_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
5448: OPEN C_Res_Asgmt_Id(p_pa_project_id,l_task_assignments_in(i).pm_task_asgmt_reference,p_task_assignments_in(i).pa_task_element_version_id,p_task_assignments_in(i).resource_list_member_id);
5449: FETCH C_Res_Asgmt_Id INTO c_res_asgmt_id_rec;
5450: IF C_Res_Asgmt_Id%FOUND THEN
5451: l_task_assignment_id := c_res_asgmt_id_rec.resource_assignment_id;

Line 6767: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

6763:
6764:
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

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 6846: IF p_task_asgmt_index(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

6842: FOR i in 1..p_task_asgmt_index.COUNT LOOP
6843:
6844: --dbms_output.put_line('Entering Fetch Loop: p_task_asgmt_index.COUNT' || p_task_asgmt_index.COUNT);
6845:
6846: IF p_task_asgmt_index(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6847: OR p_task_asgmt_index(i) IS NULL THEN
6848:
6849: --dbms_output.put_line('Asgmt index is not passed.');
6850:

Line 6854: pa_interface_utils_pub.map_new_amg_msg

6850:
6851: RETURN;
6852:
6853: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6854: pa_interface_utils_pub.map_new_amg_msg
6855: ( p_old_message_code => 'PA_INDEX_NOT_PROVIDED'
6856: ,p_msg_attribute => 'CHANGE'
6857: ,p_resize_flag => 'N'
6858: ,p_msg_context => 'GENERAL'

Line 6879: IF g_task_asgmts_out_tbl(p_task_asgmt_index(i)).pa_task_assignment_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

6875:
6876: -- assign global table fields to the outgoing parameter
6877: -- we don't want to return the big number G_PA_MISS_NUM
6878:
6879: IF g_task_asgmts_out_tbl(p_task_asgmt_index(i)).pa_task_assignment_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
6880: g_task_asgmts_out_tbl(p_task_asgmt_index(i)).pa_task_assignment_id = NULL
6881: THEN
6882:
6883: p_pa_task_assignment_id(i) := NULL;

Line 6894: IF g_task_asgmts_out_tbl(p_task_asgmt_index(i)).pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

6890: --dbms_output.put_line('after set');
6891:
6892: END IF;
6893:
6894: IF g_task_asgmts_out_tbl(p_task_asgmt_index(i)).pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
6895: g_task_asgmts_out_tbl(p_task_asgmt_index(i)).pa_task_id = NULL
6896: THEN
6897: --dbms_output.put_line('task id is null');
6898: p_pa_task_id(i) := NULL;

Line 6906: IF g_task_asgmts_out_tbl(p_task_asgmt_index(i)).resource_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR

6902: p_pa_task_id(i) := g_task_asgmts_out_tbl(p_task_asgmt_index(i)).pa_task_id;
6903: --dbms_output.put_line('task id is set');
6904: END IF;
6905:
6906: IF g_task_asgmts_out_tbl(p_task_asgmt_index(i)).resource_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR
6907: g_task_asgmts_out_tbl(p_task_asgmt_index(i)).resource_alias = NULL
6908: THEN
6909: --dbms_output.put_line('null resource alias');
6910: p_resource_alias(i) := NULL;

Line 6918: IF g_task_asgmts_out_tbl(p_task_asgmt_index(i)).resource_list_member_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

6914: p_resource_alias(i) := g_task_asgmts_out_tbl(p_task_asgmt_index(i)).resource_alias;
6915: --dbms_output.put_line('after setting resource alias');
6916: END IF;
6917:
6918: IF g_task_asgmts_out_tbl(p_task_asgmt_index(i)).resource_list_member_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
6919: g_task_asgmts_out_tbl(p_task_asgmt_index(i)).resource_list_member_id = NULL
6920: THEN
6921: --dbms_output.put_line('null resource list member id');
6922: p_resource_list_member_id(i) := NULL;

Line 6931: IF g_task_asgmts_out_tbl(p_task_asgmt_index(i)).cbs_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

6927: --dbms_output.put_line('after setting resource list member id');
6928: END IF;
6929:
6930: -- Added for CBS 16598322
6931: IF g_task_asgmts_out_tbl(p_task_asgmt_index(i)).cbs_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
6932: g_task_asgmts_out_tbl(p_task_asgmt_index(i)).cbs_element_id = NULL
6933: THEN
6934: p_cbs_element_id(i) := NULL;
6935: ELSE

Line 7005: ,p_pm_task_asgmt_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

7001: ,p_pa_project_id IN NUMBER
7002: ,p_pa_structure_version_id IN NUMBER
7003: ,p_pa_task_id IN NUMBER
7004: ,p_pa_task_elem_ver_id IN NUMBER
7005: ,p_pm_task_asgmt_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7006: ,p_pa_task_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7007: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7008: ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7009: ,p_cbs_element_id IN NUMBER := null -- Added for CBS 16598322

Line 7006: ,p_pa_task_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

7002: ,p_pa_structure_version_id IN NUMBER
7003: ,p_pa_task_id IN NUMBER
7004: ,p_pa_task_elem_ver_id IN NUMBER
7005: ,p_pm_task_asgmt_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7006: ,p_pa_task_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7007: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7008: ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7009: ,p_cbs_element_id IN NUMBER := null -- Added for CBS 16598322
7010: -- Bug 3937017 Added a new parameter p_add_error_msg_flag

Line 7007: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

7003: ,p_pa_task_id IN NUMBER
7004: ,p_pa_task_elem_ver_id IN NUMBER
7005: ,p_pm_task_asgmt_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7006: ,p_pa_task_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7007: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7008: ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7009: ,p_cbs_element_id IN NUMBER := null -- Added for CBS 16598322
7010: -- Bug 3937017 Added a new parameter p_add_error_msg_flag
7011: ,p_add_error_msg_flag IN VARCHAR2 DEFAULT 'Y'

Line 7008: ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

7004: ,p_pa_task_elem_ver_id IN NUMBER
7005: ,p_pm_task_asgmt_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7006: ,p_pa_task_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7007: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7008: ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7009: ,p_cbs_element_id IN NUMBER := null -- Added for CBS 16598322
7010: -- Bug 3937017 Added a new parameter p_add_error_msg_flag
7011: ,p_add_error_msg_flag IN VARCHAR2 DEFAULT 'Y'
7012: -- Bug 3872176 Added a new parameter p_published_version_flag

Line 7132: IF p_pa_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

7128: OPEN l_project_id_csr;
7129: FETCH l_project_id_csr INTO l_dummy, l_template_flag, l_version_enabled_flag;
7130: CLOSE l_project_id_csr;
7131:
7132: IF p_pa_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7133: AND p_pa_project_id IS NOT NULL THEN
7134:
7135: IF l_dummy IS NULL THEN
7136:

Line 7139: pa_interface_utils_pub.map_new_amg_msg

7135: IF l_dummy IS NULL THEN
7136:
7137: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7138: THEN
7139: pa_interface_utils_pub.map_new_amg_msg
7140: ( p_old_message_code => 'PA_INVALID_PROJECT_ID'
7141: ,p_msg_attribute => 'CHANGE'
7142: ,p_resize_flag => 'N'
7143: ,p_msg_context => 'GENERAL'

Line 7158: pa_interface_utils_pub.map_new_amg_msg

7154: ELSE
7155:
7156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7157: THEN
7158: pa_interface_utils_pub.map_new_amg_msg
7159: ( p_old_message_code => 'PA_PROJECT_ID_MISSING'
7160: ,p_msg_attribute => 'CHANGE'
7161: ,p_resize_flag => 'N'
7162: ,p_msg_context => 'GENERAL'

Line 7175: (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

7171:
7172: END IF;
7173:
7174: IF p_pa_structure_version_id IS NOT NULL AND
7175: (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
7176:
7177: l_struct_elem_version_id := p_pa_structure_version_id;
7178:
7179: --Added by rtarway for BUG 3872176

Line 7213: l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

7209: --dbms_output.put_line(' structure version is: ' || l_struct_elem_version_id );
7210: --dbms_output.put_line(' testing str if..' );
7211:
7212: IF ( l_struct_elem_version_id IS NULL OR
7213: l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7214: )
7215:
7216: THEN
7217: --dbms_output.put_line(' test struct.null or g miss..');

Line 7222: pa_interface_utils_pub.map_new_amg_msg

7218:
7219: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7220: THEN
7221: --dbms_output.put_line(' test struct.null or gmiss err..');
7222: pa_interface_utils_pub.map_new_amg_msg
7223: ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
7224: ,p_msg_attribute => 'CHANGE'
7225: ,p_resize_flag => 'N'
7226: ,p_msg_context => 'GENERAL'

Line 7236: IF p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

7232: END IF;
7233: RAISE FND_API.G_EXC_ERROR;
7234: END IF;
7235:
7236: IF p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7237: AND p_pa_task_id IS NOT NULL
7238: THEN
7239:
7240: -- Get segment1 for AMG messages

Line 7254: pa_interface_utils_pub.map_new_amg_msg

7250: IF l_task_ver_id is NULL
7251: THEN
7252: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7253: THEN
7254: pa_interface_utils_pub.map_new_amg_msg
7255: ( p_old_message_code => 'PA_TASK_ID_INVALID'
7256: ,p_msg_attribute => 'CHANGE'
7257: ,p_resize_flag => 'N'
7258: ,p_msg_context => 'PROJ'

Line 7271: END IF; --IF p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

7267: RAISE FND_API.G_EXC_ERROR;
7268: END IF;
7269:
7270: --p_out_task_id := p_pa_task_id; --JRAJ.
7271: END IF; --IF p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7272:
7273:
7274:
7275: IF p_pa_task_assignment_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 7275: IF p_pa_task_assignment_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

7271: END IF; --IF p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7272:
7273:
7274:
7275: IF p_pa_task_assignment_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7276: AND p_pa_task_assignment_id IS NOT NULL
7277: THEN
7278: --dbms_output.put_line('task assignment id is passed'||p_pa_task_assignment_id);
7279: -- Get segment1 for AMG messages

Line 7294: pa_interface_utils_pub.map_new_amg_msg

7290: IF l_task_asgmt_id_csr%NOTFOUND
7291: THEN
7292: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7293: THEN
7294: pa_interface_utils_pub.map_new_amg_msg
7295: ( p_old_message_code => 'PA_TASK_ASGMT_ID_INVALID'
7296: ,p_msg_attribute => 'CHANGE'
7297: ,p_resize_flag => 'N'
7298: ,p_msg_context => 'PROJ'

Line 7313: ELSIF p_pm_task_asgmt_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

7309:
7310: CLOSE l_task_asgmt_id_csr;
7311:
7312: x_pa_task_assignment_id := p_pa_task_assignment_id; --JRAJ.
7313: ELSIF p_pm_task_asgmt_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7314: AND p_pm_task_asgmt_reference IS NOT NULL
7315: THEN
7316:
7317:

Line 7331: IF p_pa_task_elem_ver_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

7327:
7328: -- 4216541
7329: IF l_task_asgmt_id IS NULL THEN
7330:
7331: IF p_pa_task_elem_ver_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
7332: p_pa_task_elem_ver_id IS NOT NULL AND
7333: p_resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
7334: p_resource_list_member_id IS NOT NULL
7335: THEN

Line 7333: p_resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

7329: IF l_task_asgmt_id IS NULL THEN
7330:
7331: IF p_pa_task_elem_ver_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
7332: p_pa_task_elem_ver_id IS NOT NULL AND
7333: p_resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
7334: p_resource_list_member_id IS NOT NULL
7335: THEN
7336:
7337: OPEN c_task_asgmt_from_id_csr(l_struct_elem_version_id);

Line 7341: END IF; -- IF p_pa_task_elem_ver_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

7337: OPEN c_task_asgmt_from_id_csr(l_struct_elem_version_id);
7338: FETCH c_task_asgmt_from_id_csr INTO l_task_asgmt_id ;
7339: CLOSE c_task_asgmt_from_id_csr;
7340:
7341: END IF; -- IF p_pa_task_elem_ver_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
7342: -- END OF 4216541
7343:
7344: IF l_task_asgmt_id IS NULL THEN
7345:

Line 7412: pa_interface_utils_pub.map_new_amg_msg

7408: ELSE
7409:
7410: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7411: THEN
7412: pa_interface_utils_pub.map_new_amg_msg
7413: ( p_old_message_code => 'PA_TASK_ASGMT_REF_ID_MISSING'
7414: ,p_msg_attribute => 'CHANGE'
7415: ,p_resize_flag => 'N'
7416: ,p_msg_context => 'PROJ'

Line 7426: END IF; -- If p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

7422: END IF;
7423:
7424: RAISE FND_API.G_EXC_ERROR;
7425:
7426: END IF; -- If p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7427: --dbms_output.put_line('l_task_asgmt_id'||l_task_asgmt_id);
7428: EXCEPTION
7429:
7430: WHEN FND_API.G_EXC_ERROR