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_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

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_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
25: ,p_end_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_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
25: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
26: ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
25: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
26: ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
27: ,p_planned_total_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

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_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
25: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
26: ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
27: ,p_planned_total_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
28: ,p_planned_total_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 25: ,p_end_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_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
25: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
26: ,p_planned_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
27: ,p_planned_total_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
28: ,p_planned_total_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
29: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

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

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

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

Line 29: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

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

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

Line 32: ,p_attribute_category IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

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

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

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

30: --This parameter is added for Bug 3948128: TA Delay CR by DHI
31: ,p_scheduled_delay IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
32: ,p_attribute_category IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
33: ,p_attribute1 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
34: ,p_attribute2 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
35: ,p_attribute3 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
36: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
37: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
38: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

31: ,p_scheduled_delay IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
32: ,p_attribute_category IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
33: ,p_attribute1 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
34: ,p_attribute2 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
35: ,p_attribute3 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
36: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
37: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
38: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
39: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

32: ,p_attribute_category IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
33: ,p_attribute1 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
34: ,p_attribute2 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
35: ,p_attribute3 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
36: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
37: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
38: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
39: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
40: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

33: ,p_attribute1 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
34: ,p_attribute2 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
35: ,p_attribute3 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
36: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
37: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
38: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
39: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
40: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
41: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 38: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

34: ,p_attribute2 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
35: ,p_attribute3 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
36: ,p_attribute4 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
37: ,p_attribute5 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
38: ,p_attribute6 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
39: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
40: ,p_attribute8 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
41: ,p_attribute9 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
42: ,p_attribute10 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 39: ,p_attribute7 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

55: ,p_attribute23 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
56: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
57: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
58: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
59: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
60: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
61: ,p_attribute29 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
62: ,p_attribute30 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
63: ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

56: ,p_attribute24 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
57: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
58: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
59: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
60: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
61: ,p_attribute29 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
62: ,p_attribute30 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
63: ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
64: ,up_use_task_schedule_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

57: ,p_attribute25 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
58: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
59: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
60: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
61: ,p_attribute29 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
62: ,p_attribute30 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
63: ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
64: ,up_use_task_schedule_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
65: ,up_raw_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

58: ,p_attribute26 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
59: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
60: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
61: ,p_attribute29 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
62: ,p_attribute30 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
63: ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
64: ,up_use_task_schedule_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
65: ,up_raw_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
66: ,up_burd_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

59: ,p_attribute27 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
60: ,p_attribute28 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
61: ,p_attribute29 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
62: ,p_attribute30 IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
63: ,up_description IN PA_VC_1000_240 := PA_VC_1000_240(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
64: ,up_use_task_schedule_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
65: ,up_raw_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
66: ,up_burd_cost_rate_override IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
67: ,up_billable_work_percent IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

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

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

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

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

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

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

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

Line 68: ,up_mfg_cost_type IN PA_VC_1000_10 := PA_VC_1000_10(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

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

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

Line 70: ,p_context_flag IN PA_VC_1000_1 := PA_VC_1000_1(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

259:
260: IF p_resource_list_member_id.exists(i) THEN
261: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).resource_list_member_id := p_resource_list_member_id(i);
262: ELSE
263: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).resource_list_member_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
264: END IF;
265:
266: IF p_start_date.exists(i) THEN
267: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).start_date := p_start_date(i);

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

265:
266: IF p_start_date.exists(i) THEN
267: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).start_date := p_start_date(i);
268: ELSE
269: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).start_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
270: END IF;
271:
272: IF p_end_date.exists(i) THEN
273: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).end_date := p_end_date(i);

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

271:
272: IF p_end_date.exists(i) THEN
273: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).end_date := p_end_date(i);
274: ELSE
275: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).end_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
276: END IF;
277:
278: IF p_planned_quantity.exists(i) THEN
279: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

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

281: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
282: END IF;
283: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_quantity := p_planned_quantity(i);
284: ELSE
285: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_quantity := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
286: END IF;
287:
288: IF p_planned_total_raw_cost.exists(i) THEN
289: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_total_raw_cost := p_planned_total_raw_cost(i);

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

287:
288: IF p_planned_total_raw_cost.exists(i) THEN
289: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_total_raw_cost := p_planned_total_raw_cost(i);
290: ELSE
291: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_total_raw_cost := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
292: END IF;
293:
294: IF p_planned_total_bur_cost.exists(i) THEN
295: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_total_bur_cost := p_planned_total_bur_cost(i);

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

293:
294: IF p_planned_total_bur_cost.exists(i) THEN
295: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_total_bur_cost := p_planned_total_bur_cost(i);
296: ELSE
297: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).planned_total_bur_cost := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
298: END IF;
299:
300: IF p_currency_code.exists(i) THEN
301: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).currency_code := p_currency_code(i);

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

299:
300: IF p_currency_code.exists(i) THEN
301: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).currency_code := p_currency_code(i);
302: ELSE
303: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).currency_code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
304: END IF;
305:
306: --This parameter is added for Bug 3948128: TA Delay CR by DHI
307: IF p_scheduled_delay.exists(i) THEN

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

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

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

312:
313: IF p_attribute_category.exists(i) THEN
314: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute_category := p_attribute_category(i);
315: ELSE
316: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute_category := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
317: END IF;
318:
319: IF p_attribute1.exists(i) THEN
320: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute1 := p_attribute1(i);

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

318:
319: IF p_attribute1.exists(i) THEN
320: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute1 := p_attribute1(i);
321: ELSE
322: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute1 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
323: END IF;
324:
325: IF p_attribute2.exists(i) THEN
326: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute2 := p_attribute2(i);

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

324:
325: IF p_attribute2.exists(i) THEN
326: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute2 := p_attribute2(i);
327: ELSE
328: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
329: END IF;
330:
331: IF p_attribute3.exists(i) THEN
332: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute3 := p_attribute3(i);

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

330:
331: IF p_attribute3.exists(i) THEN
332: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute3 := p_attribute3(i);
333: ELSE
334: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute3 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
335: END IF;
336:
337: IF p_attribute4.exists(i) THEN
338: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute4 := p_attribute4(i);

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

336:
337: IF p_attribute4.exists(i) THEN
338: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute4 := p_attribute4(i);
339: ELSE
340: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute4 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
341: END IF;
342:
343: IF p_attribute5.exists(i) THEN
344: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute5 := p_attribute5(i);

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

342:
343: IF p_attribute5.exists(i) THEN
344: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute5 := p_attribute5(i);
345: ELSE
346: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute5 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
347: END IF;
348:
349: IF p_attribute6.exists(i) THEN
350: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute6 := p_attribute6(i);

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

348:
349: IF p_attribute6.exists(i) THEN
350: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute6 := p_attribute6(i);
351: ELSE
352: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute6 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
353: END IF;
354:
355: IF p_attribute7.exists(i) THEN
356: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute7 := p_attribute7(i);

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

354:
355: IF p_attribute7.exists(i) THEN
356: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute7 := p_attribute7(i);
357: ELSE
358: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute7 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
359: END IF;
360:
361: IF p_attribute8.exists(i) THEN
362: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute8 := p_attribute8(i);

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

360:
361: IF p_attribute8.exists(i) THEN
362: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute8 := p_attribute8(i);
363: ELSE
364: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute8 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
365: END IF;
366:
367: IF p_attribute9.exists(i) THEN
368: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute9 := p_attribute9(i);

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

366:
367: IF p_attribute9.exists(i) THEN
368: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute9 := p_attribute9(i);
369: ELSE
370: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute9 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
371: END IF;
372:
373: IF p_attribute10.exists(i) THEN
374: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute10 := p_attribute10(i);

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

372:
373: IF p_attribute10.exists(i) THEN
374: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute10 := p_attribute10(i);
375: ELSE
376: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute10 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
377: END IF;
378:
379: IF p_attribute11.exists(i) THEN
380: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute11 := p_attribute11(i);

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

378:
379: IF p_attribute11.exists(i) THEN
380: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute11 := p_attribute11(i);
381: ELSE
382: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute11 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
383: END IF;
384: IF p_attribute12.exists(i) THEN
385: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute12 := p_attribute12(i);
386: ELSE

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

383: END IF;
384: IF p_attribute12.exists(i) THEN
385: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute12 := p_attribute12(i);
386: ELSE
387: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute12 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
388: END IF;
389: IF p_attribute13.exists(i) THEN
390: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute13 := p_attribute13(i);
391: ELSE

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

388: END IF;
389: IF p_attribute13.exists(i) THEN
390: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute13 := p_attribute13(i);
391: ELSE
392: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute13 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
393: END IF;
394: IF p_attribute14.exists(i) THEN
395: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute14 := p_attribute14(i);
396: ELSE

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

393: END IF;
394: IF p_attribute14.exists(i) THEN
395: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute14 := p_attribute14(i);
396: ELSE
397: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute14 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
398: END IF;
399: IF p_attribute15.exists(i) THEN
400: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute15 := p_attribute15(i);
401: ELSE

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

398: END IF;
399: IF p_attribute15.exists(i) THEN
400: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute15 := p_attribute15(i);
401: ELSE
402: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute15 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
403: END IF;
404: IF p_attribute16.exists(i) THEN
405: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute16 := p_attribute16(i);
406: ELSE

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

403: END IF;
404: IF p_attribute16.exists(i) THEN
405: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute16 := p_attribute16(i);
406: ELSE
407: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute16 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
408: END IF;
409: IF p_attribute17.exists(i) THEN
410: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute17 := p_attribute17(i);
411: ELSE

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

408: END IF;
409: IF p_attribute17.exists(i) THEN
410: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute17 := p_attribute17(i);
411: ELSE
412: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute17 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
413: END IF;
414: IF p_attribute18.exists(i) THEN
415: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute18 := p_attribute18(i);
416: ELSE

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

413: END IF;
414: IF p_attribute18.exists(i) THEN
415: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute18 := p_attribute18(i);
416: ELSE
417: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute18 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
418: END IF;
419: IF p_attribute19.exists(i) THEN
420: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute19 := p_attribute19(i);
421: ELSE

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

418: END IF;
419: IF p_attribute19.exists(i) THEN
420: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute19 := p_attribute19(i);
421: ELSE
422: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute19 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
423: END IF;
424: IF p_attribute20.exists(i) THEN
425: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute20 := p_attribute20(i);
426: ELSE

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

423: END IF;
424: IF p_attribute20.exists(i) THEN
425: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute20 := p_attribute20(i);
426: ELSE
427: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute20 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
428: END IF;
429: IF p_attribute21.exists(i) THEN
430: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute21 := p_attribute21(i);
431: ELSE

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

428: END IF;
429: IF p_attribute21.exists(i) THEN
430: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute21 := p_attribute21(i);
431: ELSE
432: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute21 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
433: END IF;
434: IF p_attribute22.exists(i) THEN
435: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute22 := p_attribute22(i);
436: ELSE

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

433: END IF;
434: IF p_attribute22.exists(i) THEN
435: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute22 := p_attribute22(i);
436: ELSE
437: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute22 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
438: END IF;
439: IF p_attribute23.exists(i) THEN
440: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute23 := p_attribute23(i);
441: ELSE

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

438: END IF;
439: IF p_attribute23.exists(i) THEN
440: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute23 := p_attribute23(i);
441: ELSE
442: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute23 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
443: END IF;
444: IF p_attribute24.exists(i) THEN
445: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute24 := p_attribute24(i);
446: ELSE

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

443: END IF;
444: IF p_attribute24.exists(i) THEN
445: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute24 := p_attribute24(i);
446: ELSE
447: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute24 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
448: END IF;
449: IF p_attribute25.exists(i) THEN
450: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute25 := p_attribute25(i);
451: ELSE

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

448: END IF;
449: IF p_attribute25.exists(i) THEN
450: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute25 := p_attribute25(i);
451: ELSE
452: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute25 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
453: END IF;
454: IF p_attribute26.exists(i) THEN
455: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute26 := p_attribute26(i);
456: ELSE

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

453: END IF;
454: IF p_attribute26.exists(i) THEN
455: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute26 := p_attribute26(i);
456: ELSE
457: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute26 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
458: END IF;
459: IF p_attribute27.exists(i) THEN
460: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute27 := p_attribute27(i);
461: ELSE

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

458: END IF;
459: IF p_attribute27.exists(i) THEN
460: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute27 := p_attribute27(i);
461: ELSE
462: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute27 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
463: END IF;
464: IF p_attribute28.exists(i) THEN
465: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute28 := p_attribute28(i);
466: ELSE

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

463: END IF;
464: IF p_attribute28.exists(i) THEN
465: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute28 := p_attribute28(i);
466: ELSE
467: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute28 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
468: END IF;
469: IF p_attribute29.exists(i) THEN
470: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute29 := p_attribute29(i);
471: ELSE

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

468: END IF;
469: IF p_attribute29.exists(i) THEN
470: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute29 := p_attribute29(i);
471: ELSE
472: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute29 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
473: END IF;
474: IF p_attribute30.exists(i) THEN
475: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute30 := p_attribute30(i);
476: ELSE

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

473: END IF;
474: IF p_attribute30.exists(i) THEN
475: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute30 := p_attribute30(i);
476: ELSE
477: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).attribute30 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
478: END IF;
479: IF up_description.exists(i) THEN
480: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).description := up_description(i);
481: ELSE

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

478: END IF;
479: IF up_description.exists(i) THEN
480: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).description := up_description(i);
481: ELSE
482: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).description := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
483: END IF;
484:
485: IF up_use_task_schedule_flag.exists(i) THEN
486: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).use_task_schedule_flag := up_use_task_schedule_flag(i);

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

484:
485: IF up_use_task_schedule_flag.exists(i) THEN
486: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).use_task_schedule_flag := up_use_task_schedule_flag(i);
487: ELSE
488: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).use_task_schedule_flag := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
489: END IF;
490:
491: IF up_raw_cost_rate_override.exists(i) THEN
492: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).raw_cost_rate_override := up_raw_cost_rate_override(i);

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

490:
491: IF up_raw_cost_rate_override.exists(i) THEN
492: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).raw_cost_rate_override := up_raw_cost_rate_override(i);
493: ELSE
494: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).raw_cost_rate_override := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
495: END IF;
496: IF up_burd_cost_rate_override.exists(i) THEN
497: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).burd_cost_rate_override := up_burd_cost_rate_override(i);
498: ELSE

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

495: END IF;
496: IF up_burd_cost_rate_override.exists(i) THEN
497: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).burd_cost_rate_override := up_burd_cost_rate_override(i);
498: ELSE
499: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).burd_cost_rate_override := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
500: END IF;
501: IF up_mfg_cost_type.exists(i) THEN
502: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).mfg_cost_type := up_mfg_cost_type(i);
503: ELSE

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

500: END IF;
501: IF up_mfg_cost_type.exists(i) THEN
502: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).mfg_cost_type := up_mfg_cost_type(i);
503: ELSE
504: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).mfg_cost_type := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
505: END IF;
506: IF up_mfg_cost_type_id.exists(i) THEN
507: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).mfg_cost_type_id := up_mfg_cost_type_id(i);
508: ELSE

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

505: END IF;
506: IF up_mfg_cost_type_id.exists(i) THEN
507: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).mfg_cost_type_id := up_mfg_cost_type_id(i);
508: ELSE
509: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).mfg_cost_type_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
510: END IF;
511: IF up_billable_work_percent.exists(i) THEN
512: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).billable_work_percent := up_billable_work_percent(i);
513: ELSE

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

510: END IF;
511: IF up_billable_work_percent.exists(i) THEN
512: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).billable_work_percent := up_billable_work_percent(i);
513: ELSE
514: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).billable_work_percent := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
515: END IF;
516: IF p_context_flag.exists(i) THEN
517: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).p_context := p_context_flag(i);
518: ELSE

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

515: END IF;
516: IF p_context_flag.exists(i) THEN
517: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).p_context := p_context_flag(i);
518: ELSE
519: g_task_asgmts_in_tbl(g_task_asgmts_tbl_count).p_context := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
520: END IF;
521:
522:
523: END LOOP;

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

591: END LOAD_TASK_ASSIGNMENTS;
592:
593:
594: PROCEDURE Load_Task_Asgmt_Periods
595: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
596: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
597: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
598: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
599: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

594: PROCEDURE Load_Task_Asgmt_Periods
595: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
596: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
597: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
598: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
599: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
600: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
601: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
602: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

595: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
596: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
597: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
598: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
599: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
600: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
601: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
602: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
603: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

596: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
597: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
598: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
599: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
600: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
601: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
602: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
603: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
604: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 601: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

597: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
598: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
599: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
600: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
601: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
602: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
603: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
604: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
605: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

598: ,p_pm_project_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
599: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
600: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
601: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
602: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
603: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
604: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
605: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
606: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

599: ,p_pa_project_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
600: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
601: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
602: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
603: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
604: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
605: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
606: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
607: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 604: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

600: ,p_pa_structure_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
601: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
602: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
603: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
604: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
605: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
606: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
607: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
608: --Name of the period if available

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

601: ,p_pm_task_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
602: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
603: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
604: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
605: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
606: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
607: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
608: --Name of the period if available
609: ,p_period_name IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 606: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

602: ,p_pa_task_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
603: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
604: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
605: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
606: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
607: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
608: --Name of the period if available
609: ,p_period_name IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
610: --Start date of the period

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

603: ,p_pa_task_element_version_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
604: ,p_pm_task_asgmt_reference IN PA_VC_1000_25 := PA_VC_1000_25(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
605: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
606: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
607: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
608: --Name of the period if available
609: ,p_period_name IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
610: --Start date of the period
611: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

Line 609: ,p_period_name IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

605: ,p_pa_task_assignment_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
606: ,p_resource_alias IN PA_VC_1000_80 := PA_VC_1000_80(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
607: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
608: --Name of the period if available
609: ,p_period_name IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
610: --Start date of the period
611: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
612: --End date of the period
613: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

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

607: ,p_resource_list_member_id IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
608: --Name of the period if available
609: ,p_period_name IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
610: --Start date of the period
611: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
612: --End date of the period
613: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
614: ,p_txn_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
615: ,p_txn_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

609: ,p_period_name IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
610: --Start date of the period
611: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
612: --End date of the period
613: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
614: ,p_txn_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
615: ,p_txn_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
616: ,p_txn_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
617: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

610: --Start date of the period
611: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
612: --End date of the period
613: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
614: ,p_txn_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
615: ,p_txn_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
616: ,p_txn_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
617: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
618: ,x_msg_count OUT NOCOPY NUMBER

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

611: ,p_start_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
612: --End date of the period
613: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
614: ,p_txn_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
615: ,p_txn_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
616: ,p_txn_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
617: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
618: ,x_msg_count OUT NOCOPY NUMBER
619: ,x_msg_data OUT NOCOPY VARCHAR2

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

612: --End date of the period
613: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
614: ,p_txn_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
615: ,p_txn_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
616: ,p_txn_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
617: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
618: ,x_msg_count OUT NOCOPY NUMBER
619: ,x_msg_data OUT NOCOPY VARCHAR2
620: ,x_return_status OUT NOCOPY VARCHAR2

Line 617: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

613: ,p_end_date IN PA_date_1000_date := PA_date_1000_date(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
614: ,p_txn_quantity IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
615: ,p_txn_raw_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
616: ,p_txn_bur_cost IN PA_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
617: ,p_currency_code IN PA_VC_1000_30 := PA_VC_1000_30(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
618: ,x_msg_count OUT NOCOPY NUMBER
619: ,x_msg_data OUT NOCOPY VARCHAR2
620: ,x_return_status OUT NOCOPY VARCHAR2
621: ) IS

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

726:
727: IF p_pm_project_reference.exists(i) THEN
728: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_project_reference := p_pm_project_reference(i);
729: ELSE
730: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_project_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
731: END IF;
732:
733: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
734: 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 740: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_project_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

736: END IF;
737: IF p_pa_project_id.exists(i) THEN
738: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_project_id := p_pa_project_id(i);
739: ELSE
740: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_project_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
741: END IF;
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).pa_project_id:' || g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_project_id;
744: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

746:
747: IF p_pa_structure_version_id.exists(i) THEN
748: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_structure_version_id := p_pa_structure_version_id(i);
749: ELSE
750: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_structure_version_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
751: END IF;
752: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
753: 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;
754: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

756:
757: IF p_pm_task_reference.exists(i) THEN
758: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_task_reference := p_pm_task_reference(i);
759: ELSE
760: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_task_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
761: END IF;
762: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
763: 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;
764: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

766:
767: IF p_pa_task_id.exists(i) THEN
768: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_id := p_pa_task_id(i);
769: ELSE
770: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
771: END IF;
772: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
773: 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;
774: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

780: pa_debug.g_err_stage:='In Load task asgmts periods. p_pa_task_element_version_id(' || i || '):' || p_pa_task_element_version_id(i) ;
781: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
782: END IF;
783: ELSE
784: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_element_version_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
785: END IF;
786:
787: IF p_pa_task_assignment_id.exists(i) THEN
788: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_assignment_id := p_pa_task_assignment_id(i);

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

786:
787: IF p_pa_task_assignment_id.exists(i) THEN
788: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_assignment_id := p_pa_task_assignment_id(i);
789: ELSE
790: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pa_task_assignment_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
791: END IF;
792: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
793: 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;
794: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

796:
797: IF p_pm_task_asgmt_reference.exists(i) THEN
798: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_task_asgmt_reference := p_pm_task_asgmt_reference(i);
799: ELSE
800: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).pm_task_asgmt_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
801: END IF;
802: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
803: 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 ;
804: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

806:
807: IF p_resource_alias.exists(i) THEN
808: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).resource_alias := p_resource_alias(i);
809: ELSE
810: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).resource_alias := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
811: END IF;
812: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
813: 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 ;
814: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

816:
817: IF p_resource_list_member_id.exists(i) THEN
818: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).resource_list_member_id := p_resource_list_member_id(i);
819: ELSE
820: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).resource_list_member_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
821: END IF;
822: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
823: 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 ;
824: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

825: END IF;
826: IF p_start_date.exists(i) THEN
827: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).start_date := p_start_date(i);
828: ELSE
829: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).start_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
830: END IF;
831: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
832: 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 ;
833: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

835:
836: IF p_end_date.exists(i) THEN
837: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).end_date := p_end_date(i);
838: ELSE
839: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).end_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
840: END IF;
841: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
842: 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 ;
843: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

845:
846: IF p_period_name.exists(i) THEN
847: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).period_name := p_period_name(i);
848: ELSE
849: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).period_name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
850: END IF;
851: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
852: 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 ;
853: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

855:
856: IF p_txn_quantity.exists(i) THEN
857: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).quantity := p_txn_quantity(i);
858: ELSE
859: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).quantity := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
860: END IF;
861: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
862: 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 ;
863: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

865:
866: IF p_txn_raw_cost.exists(i) THEN
867: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_raw_cost := p_txn_raw_cost(i);
868: ELSE
869: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_raw_cost := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
870: END IF;
871: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
872: 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 ;
873: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

874: END IF;
875: IF p_txn_bur_cost.exists(i) THEN
876: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_burdened_cost := p_txn_bur_cost(i);
877: ELSE
878: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_burdened_cost := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
879: END IF;
880: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
881: 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 ;
882: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

883: END IF;
884: IF p_currency_code.exists(i) THEN
885: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_currency_code := p_currency_code(i);
886: ELSE
887: g_asgmts_periods_tbl(g_asgmts_periods_tbl_count).txn_currency_code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
888: END IF;
889: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
890: 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 ;
891: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

967: -- 01-APR-2004
968: --
969:
970: PROCEDURE Execute_Create_Task_Asgmts
971: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
972: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
973: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
974: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
975: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

970: PROCEDURE Execute_Create_Task_Asgmts
971: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
972: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
973: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
974: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
975: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
976: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
977: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
978: ,x_msg_count OUT NOCOPY NUMBER

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

971: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
972: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
973: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
974: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
975: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
976: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
977: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
978: ,x_msg_count OUT NOCOPY NUMBER
979: ,x_msg_data OUT NOCOPY VARCHAR2

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

972: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
973: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
974: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
975: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
976: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
977: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
978: ,x_msg_count OUT NOCOPY NUMBER
979: ,x_msg_data OUT NOCOPY VARCHAR2
980: ,x_return_status OUT NOCOPY VARCHAR2

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

973: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
974: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
975: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
976: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
977: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
978: ,x_msg_count OUT NOCOPY NUMBER
979: ,x_msg_data OUT NOCOPY VARCHAR2
980: ,x_return_status OUT NOCOPY VARCHAR2
981: ) IS

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

1146: END EXECUTE_CREATE_TASK_ASGMTS;
1147:
1148:
1149: PROCEDURE Execute_Update_Task_Asgmts
1150: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1151: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1152: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1153: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1154: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

1149: PROCEDURE Execute_Update_Task_Asgmts
1150: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1151: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1152: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1153: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1154: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1155: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1156: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1157: ,x_msg_count OUT NOCOPY NUMBER

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

1150: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1151: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1152: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1153: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1154: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1155: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1156: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1157: ,x_msg_count OUT NOCOPY NUMBER
1158: ,x_msg_data OUT NOCOPY VARCHAR2

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

1151: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1152: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1153: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1154: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1155: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1156: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1157: ,x_msg_count OUT NOCOPY NUMBER
1158: ,x_msg_data OUT NOCOPY VARCHAR2
1159: ,x_return_status OUT NOCOPY VARCHAR2

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

1152: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1153: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1154: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1155: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1156: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1157: ,x_msg_count OUT NOCOPY NUMBER
1158: ,x_msg_data OUT NOCOPY VARCHAR2
1159: ,x_return_status OUT NOCOPY VARCHAR2
1160: ) IS

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

1317: END EXECUTE_UPDATE_TASK_ASGMTS;
1318:
1319:
1320: PROCEDURE Create_Task_Assignments
1321: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1322: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1323: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1324: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1325: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

1320: PROCEDURE Create_Task_Assignments
1321: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1322: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1323: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1324: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1325: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1326: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1327: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1328: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE

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

1321: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1322: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1323: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1324: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1325: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1326: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1327: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1328: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
1329: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE

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

1322: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1323: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1324: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1325: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1326: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1327: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1328: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
1329: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
1330: ,x_msg_count OUT NOCOPY NUMBER

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

1323: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1324: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1325: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1326: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1327: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1328: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
1329: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
1330: ,x_msg_count OUT NOCOPY NUMBER
1331: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1595: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

1591: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1592: END IF;
1593:
1594: IF p_pm_product_code IS NOT NULL
1595: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1596:
1597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1598: pa_interface_utils_pub.map_new_amg_msg
1599: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'

Line 1598: pa_interface_utils_pub.map_new_amg_msg

1594: IF p_pm_product_code IS NOT NULL
1595: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1596:
1597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1598: pa_interface_utils_pub.map_new_amg_msg
1599: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
1600: ,p_msg_attribute => 'CHANGE'
1601: ,p_resize_flag => 'N'
1602: ,p_msg_context => 'GENERAL'

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

1626: l_module_name := 'PA_PM_ADD_TASK_ASSIGNMENT';
1627:
1628: --> Project Id check.
1629:
1630: IF p_pa_project_id is NOT NULL AND p_pa_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1631:
1632: l_project_id := p_pa_project_id;
1633:
1634: --dbms_output.put_line('Project_id successfully passed..Check ' || l_project_id);

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

1685:
1686: -- Function security procedure check whether user have the
1687: -- privilege to add task or not
1688: --dbms_output.put_line('Security Initialize successful.');
1689: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := l_project_id; --bug 2471668 ( in the project context )
1690:
1691: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
1692: (p_api_version_number => p_api_version_number,
1693: p_responsibility_id => l_resp_id,

Line 1715: pa_interface_utils_pub.map_new_amg_msg

1711: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1712: END IF;
1713: --dbms_output.put_line('PA_PM_ADD_TASK_ASSIGNMENT function check successful.');
1714: IF l_function_allowed = 'N' THEN
1715: pa_interface_utils_pub.map_new_amg_msg
1716: ( p_old_message_code => 'PA_FUNCTION_SECURITY_ENFORCED'
1717: ,p_msg_attribute => 'CHANGE'
1718: ,p_resize_flag => 'Y'
1719: ,p_msg_context => 'GENERAL'

Line 1748: pa_interface_utils_pub.map_new_amg_msg

1744:
1745: -- The user does not have update privileges on this project
1746: -- Hence , raise error
1747: --dbms_output.put_line('pa_security.allow_query or update not allowed..');
1748: pa_interface_utils_pub.map_new_amg_msg
1749: ( p_old_message_code => 'PA_PROJECT_SECURITY_ENFORCED'
1750: ,p_msg_attribute => 'CHANGE'
1751: ,p_resize_flag => 'Y'
1752: ,p_msg_context => 'GENERAL'

Line 1774: pa_interface_utils_pub.map_new_amg_msg

1770: IF NVL(PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ), 'N') = 'N' THEN
1771: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1772: THEN
1773: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS N..');
1774: pa_interface_utils_pub.map_new_amg_msg
1775: ( p_old_message_code => 'PA_PS_WP_NOT_SEP_FN_AMG'
1776: ,p_msg_attribute => 'CHANGE'
1777: ,p_resize_flag => 'N'
1778: ,p_msg_context => 'GENERAL'

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

1794: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
1795: END IF;
1796:
1797: IF p_pa_structure_version_id IS NOT NULL AND
1798: (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1799:
1800: l_struct_elem_version_id := p_pa_structure_version_id;
1801:
1802: ELSE

Line 1811: l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1807:
1808: --dbms_output.put_line(' structure version is: ' || l_struct_elem_version_id );
1809: --dbms_output.put_line(' testing str if..' );
1810: IF ( l_struct_elem_version_id IS NULL OR
1811: l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1812: )
1813:
1814: THEN
1815: --dbms_output.put_line(' test struct.null or g miss..');

Line 1820: pa_interface_utils_pub.map_new_amg_msg

1816:
1817: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1818: THEN
1819: --dbms_output.put_line(' test struct.null or gmiss err..');
1820: pa_interface_utils_pub.map_new_amg_msg
1821: ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
1822: ,p_msg_attribute => 'CHANGE'
1823: ,p_resize_flag => 'N'
1824: ,p_msg_context => 'GENERAL'

Line 1869: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

1865: OPEN C_Get_Budget_Version_Id(l_struct_elem_version_id);
1866: FETCH C_Get_Budget_Version_Id INTO l_budget_version_id;
1867: CLOSE C_Get_Budget_Version_Id;
1868:
1869: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
1870: l_budget_version_id IS NULL )
1871: THEN
1872: --dbms_output.put_line(' budget version not obtained.. successful' );
1873: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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

2034: l_d_task_id := NULL;
2035: l_task_elem_version_id := NULL;
2036:
2037: IF p_task_assignments_in.exists(i) AND p_task_assignments_in(i).pa_task_element_version_id IS NOT NULL AND
2038: p_task_assignments_in(i).pa_task_element_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
2039: OPEN C_task_version(p_task_assignments_in(i).pa_task_element_version_id);
2040: FETCH C_task_version INTO l_task_elem_version_id, l_d_task_id;
2041: CLOSE C_task_version;
2042:

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

2041: CLOSE C_task_version;
2042:
2043:
2044: ELSIF p_task_assignments_in.exists(i) AND p_task_assignments_in(i).pa_task_id IS NOT NULL AND
2045: p_task_assignments_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
2046:
2047: l_d_task_id := p_task_assignments_in(i).pa_task_id;
2048:
2049: --dbms_output.put_line('l_d_task_id valid input:'|| l_d_task_id);

Line 2058: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

2054: END IF;
2055:
2056: --dbms_output.put_line('l_d_task_id'|| l_d_task_id);
2057:
2058: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
2059: l_d_task_id IS NULL )
2060: THEN
2061: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2062: THEN

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

2074:
2075:
2076: ELSIF p_task_assignments_in.exists(i) AND
2077: p_task_assignments_in(i).pm_task_reference IS NOT NULL AND
2078: p_task_assignments_in(i).pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2079:
2080: --dbms_output.put_line('l_d_task_reference'|| p_task_assignments_in(i).pm_task_reference);
2081:
2082:

Line 2092: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

2088: ,p_return_status => l_return_status);
2089:
2090: --dbms_output.put_line('l_d_task_id'|| l_d_task_id);
2091:
2092: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
2093: l_d_task_id IS NULL )
2094: THEN
2095: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2096: THEN

Line 2115: IF ( l_task_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

2111: END IF;
2112:
2113:
2114:
2115: IF ( l_task_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
2116: l_task_elem_version_id IS NULL )
2117: THEN
2118: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2119: THEN

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

2147:
2148: lk_task_elem_version_id_tbl(k_index) := l_task_elem_version_id;
2149: --dbms_output.put_line('test 1:');
2150: IF p_task_assignments_in(i).resource_list_member_id IS NOT NULL AND
2151: p_task_assignments_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
2152:
2153:
2154: OPEN C_Res_List_Mem_Check(p_task_assignments_in(i).resource_list_member_id);
2155: Fetch C_Res_List_Mem_Check into C_Res_List_Mem_Check_Rec;

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

2184: RAISE FND_API.G_EXC_ERROR;
2185: END IF;
2186:
2187: IF p_task_assignments_in(i).start_date IS NOT NULL and
2188: p_task_assignments_in(i).start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
2189: p_task_assignments_in(i).end_date IS NOT NULL and
2190: p_task_assignments_in(i).end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
2191: p_task_assignments_in(i).start_date > p_task_assignments_in(i).end_date THEN
2192:

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

2186:
2187: IF p_task_assignments_in(i).start_date IS NOT NULL and
2188: p_task_assignments_in(i).start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
2189: p_task_assignments_in(i).end_date IS NOT NULL and
2190: p_task_assignments_in(i).end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
2191: p_task_assignments_in(i).start_date > p_task_assignments_in(i).end_date THEN
2192:
2193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2194: PA_UTILS.ADD_MESSAGE

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

2203: END IF;
2204:
2205: --dbms_output.put_line('test 7:');
2206: IF p_task_assignments_in(i).pm_task_asgmt_reference IS NULL OR
2207: p_task_assignments_in(i).pm_task_asgmt_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2208: --dbms_output.put_line('pm_task_asgmt_reference is NULL/G_MISS...error');
2209: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2210: THEN
2211: PA_UTILS.ADD_MESSAGE

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

2816:
2817:
2818:
2819: PROCEDURE Create_Task_Assignment_Periods
2820: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2821: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2822: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2823: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2824: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

2819: PROCEDURE Create_Task_Assignment_Periods
2820: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2821: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2822: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2823: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2824: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2825: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2826: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2827: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE

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

2820: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2821: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2822: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2823: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2824: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2825: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2826: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2827: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
2828: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE

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

2821: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2822: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2823: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2824: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2825: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2826: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2827: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
2828: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
2829: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE

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

2822: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2823: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2824: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2825: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2826: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2827: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
2828: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
2829: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
2830: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE

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

2887: -- Set API return status to success
2888: x_return_status := FND_API.G_RET_STS_SUCCESS;
2889:
2890: -- Added for bug 5469303
2891: IF p_pa_structure_version_id IS NOT NULL AND (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
2892: l_struct_elem_version_id := p_pa_structure_version_id;
2893: ELSE
2894: l_struct_elem_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id( p_project_id => p_pa_project_id);
2895: END IF;

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

2893: ELSE
2894: l_struct_elem_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id( p_project_id => p_pa_project_id);
2895: END IF;
2896:
2897: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_struct_elem_version_id IS NULL ) THEN
2898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2899: pa_interface_utils_pub.map_new_amg_msg ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
2900: ,p_msg_attribute => 'CHANGE'
2901: ,p_resize_flag => 'N'

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

2895: END IF;
2896:
2897: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_struct_elem_version_id IS NULL ) THEN
2898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2899: pa_interface_utils_pub.map_new_amg_msg ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
2900: ,p_msg_attribute => 'CHANGE'
2901: ,p_resize_flag => 'N'
2902: ,p_msg_context => 'GENERAL'
2903: ,p_attribute1 => ''

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

2912: OPEN C_Get_Budget_Version_Id(l_struct_elem_version_id);
2913: FETCH C_Get_Budget_Version_Id INTO l_budget_version_id;
2914: CLOSE C_Get_Budget_Version_Id;
2915:
2916: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_budget_version_id IS NULL ) THEN
2917: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2918: PA_UTILS.ADD_MESSAGE (p_app_short_name => 'PA',
2919: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'
2920: );

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

3090: END Create_Task_Assignment_Periods;
3091:
3092:
3093: PROCEDURE Update_Task_Assignment_Periods
3094: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3095: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3096: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3097: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3098: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

3093: PROCEDURE Update_Task_Assignment_Periods
3094: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3095: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3096: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3097: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3098: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3099: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3100: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3101: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE

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

3094: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3095: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3096: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3097: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3098: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3099: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3100: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3101: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3102: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE

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

3095: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3096: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3097: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3098: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3099: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3100: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3101: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3102: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
3103: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE

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

3096: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3097: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3098: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3099: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3100: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3101: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3102: ,p_task_assignment_periods_in IN PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_PERIODS_TBL_TYPE
3103: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
3104: ,p_task_assignment_periods_out OUT NOCOPY PA_TASK_ASSIGNMENTS_PUB.ASSIGNMENT_OUT_TBL_TYPE

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

3163:
3164: x_return_status := FND_API.G_RET_STS_SUCCESS;
3165:
3166: -- Added for bug 5469303
3167: IF p_pa_structure_version_id IS NOT NULL AND (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
3168: l_struct_elem_version_id := p_pa_structure_version_id;
3169: ELSE
3170: l_struct_elem_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id( p_project_id => p_pa_project_id);
3171: END IF;

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

3169: ELSE
3170: l_struct_elem_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id( p_project_id => p_pa_project_id);
3171: END IF;
3172:
3173: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_struct_elem_version_id IS NULL ) THEN
3174: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3175: pa_interface_utils_pub.map_new_amg_msg ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
3176: ,p_msg_attribute => 'CHANGE'
3177: ,p_resize_flag => 'N'

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

3171: END IF;
3172:
3173: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_struct_elem_version_id IS NULL ) THEN
3174: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3175: pa_interface_utils_pub.map_new_amg_msg ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
3176: ,p_msg_attribute => 'CHANGE'
3177: ,p_resize_flag => 'N'
3178: ,p_msg_context => 'GENERAL'
3179: ,p_attribute1 => ''

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

3189: OPEN C_Get_Budget_Version_Id(l_struct_elem_version_id);
3190: FETCH C_Get_Budget_Version_Id INTO l_budget_version_id;
3191: CLOSE C_Get_Budget_Version_Id;
3192:
3193: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_budget_version_id IS NULL ) THEN
3194: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3195: PA_UTILS.ADD_MESSAGE (p_app_short_name => 'PA',
3196: p_msg_name => 'PA_FP_PROJ_VERSION_MISMATCH'
3197: );

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

3367: END Update_Task_Assignment_Periods;
3368:
3369:
3370: PROCEDURE Delete_Task_Assignments
3371: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3372: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3373: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3374: --Either project reference or project id is required
3375: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

3371: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3372: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3373: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3374: --Either project reference or project id is required
3375: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3376: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3377: --Structure version id is required
3378: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3379: --Pass in list of task assignment id's or references as information at a minimum

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

3372: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3373: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3374: --Either project reference or project id is required
3375: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3376: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3377: --Structure version id is required
3378: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3379: --Pass in list of task assignment id's or references as information at a minimum
3380: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE

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

3374: --Either project reference or project id is required
3375: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3376: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3377: --Structure version id is required
3378: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3379: --Pass in list of task assignment id's or references as information at a minimum
3380: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3381: ,x_msg_count OUT NOCOPY NUMBER
3382: ,x_msg_data OUT NOCOPY VARCHAR2

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

3530:
3531:
3532:
3533: PROCEDURE Update_Task_Assignments
3534: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3535: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3536: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3537: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3538: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

3533: PROCEDURE Update_Task_Assignments
3534: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3535: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3536: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3537: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3538: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3539: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3540: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3541: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE

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

3534: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3535: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3536: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3537: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3538: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3539: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3540: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3541: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3542: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE

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

3535: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3536: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3537: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3538: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3539: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3540: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3541: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3542: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
3543: ,x_msg_count OUT NOCOPY NUMBER

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

3536: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3537: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3538: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3539: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3540: ,p_pa_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3541: ,p_task_assignments_in IN ASSIGNMENT_IN_TBL_TYPE
3542: ,p_task_assignments_out OUT NOCOPY ASSIGNMENT_OUT_TBL_TYPE
3543: ,x_msg_count OUT NOCOPY NUMBER
3544: ,x_msg_data OUT NOCOPY VARCHAR2

Line 4003: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

3999: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
4000: END IF;
4001:
4002: IF p_pm_product_code IS NOT NULL
4003: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
4004:
4005: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4006: pa_interface_utils_pub.map_new_amg_msg
4007: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'

Line 4006: pa_interface_utils_pub.map_new_amg_msg

4002: IF p_pm_product_code IS NOT NULL
4003: AND p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
4004:
4005: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4006: pa_interface_utils_pub.map_new_amg_msg
4007: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
4008: ,p_msg_attribute => 'CHANGE'
4009: ,p_resize_flag => 'N'
4010: ,p_msg_context => 'GENERAL'

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

4037:
4038: --
4039:
4040:
4041: IF p_pa_project_id is NOT NULL AND p_pa_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4042:
4043: l_project_id := p_pa_project_id;
4044:
4045: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

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

4100:
4101: -- Function security procedure check whether user have the
4102: -- privilege to UPDATE task or not
4103:
4104: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := l_project_id; --bug 2471668 ( in the project context )
4105:
4106: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
4107: (p_api_version_number => p_api_version_number,
4108: p_responsibility_id => l_resp_id,

Line 4125: pa_interface_utils_pub.map_new_amg_msg

4121: RAISE FND_API.G_EXC_ERROR;
4122: END IF;
4123:
4124: IF l_function_allowed = 'N' THEN
4125: pa_interface_utils_pub.map_new_amg_msg
4126: ( p_old_message_code => 'PA_FUNCTION_SECURITY_ENFORCED'
4127: ,p_msg_attribute => 'CHANGE'
4128: ,p_resize_flag => 'Y'
4129: ,p_msg_context => 'GENERAL'

Line 4167: pa_interface_utils_pub.map_new_amg_msg

4163:
4164: -- The user does not have update privileges on this project
4165: -- Hence , raise error
4166:
4167: pa_interface_utils_pub.map_new_amg_msg
4168: ( p_old_message_code => 'PA_PROJECT_SECURITY_ENFORCED'
4169: ,p_msg_attribute => 'CHANGE'
4170: ,p_resize_flag => 'Y'
4171: ,p_msg_context => 'GENERAL'

Line 4194: pa_interface_utils_pub.map_new_amg_msg

4190: IF NVL(PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ), 'N') = 'N' THEN
4191: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4192: THEN
4193: --dbms_output.put_line('PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS IS N..');
4194: pa_interface_utils_pub.map_new_amg_msg
4195: ( p_old_message_code => 'PA_PS_WP_NOT_SEP_FN_AMG'
4196: ,p_msg_attribute => 'CHANGE'
4197: ,p_resize_flag => 'N'
4198: ,p_msg_context => 'GENERAL'

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

4211: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
4212: END IF;
4213:
4214: IF p_pa_structure_version_id IS NOT NULL AND
4215: (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
4216:
4217: l_struct_elem_version_id := p_pa_structure_version_id;
4218:
4219: ELSE

Line 4230: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

4226:
4227: --dbms_output.put_line(' structure version: ' || l_struct_elem_version_id );
4228: --Project Structures Integration
4229:
4230: IF ( l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4231: l_struct_elem_version_id IS NULL )
4232: THEN
4233: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4234: THEN

Line 4235: pa_interface_utils_pub.map_new_amg_msg

4231: l_struct_elem_version_id IS NULL )
4232: THEN
4233: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4234: THEN
4235: pa_interface_utils_pub.map_new_amg_msg
4236: ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
4237: ,p_msg_attribute => 'CHANGE'
4238: ,p_resize_flag => 'N'
4239: ,p_msg_context => 'GENERAL'

Line 4292: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

4288: OPEN C_Get_Budget_Version_Id(l_struct_elem_version_id);
4289: FETCH C_Get_Budget_Version_Id INTO l_budget_version_id;
4290: CLOSE C_Get_Budget_Version_Id;
4291:
4292: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4293: l_budget_version_id IS NULL ) THEN
4294: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4295: THEN
4296: PA_UTILS.ADD_MESSAGE

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

4413:
4414: C_Res_Asgmt_Data_Rec := NULL;
4415:
4416: IF p_task_assignments_in(i).pa_task_assignment_id is not NULL AND
4417: p_task_assignments_in(i).pa_task_assignment_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4418:
4419: OPEN C_Res_Asgmt_Data(p_task_assignments_in(i).pa_task_assignment_id);
4420: FETCH C_Res_Asgmt_Data into C_Res_Asgmt_Data_Rec;
4421: CLOSE C_Res_Asgmt_Data;

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

4425: END IF;
4426:
4427:
4428: 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
4429: p_task_assignments_in(i).pa_task_element_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4430:
4431: OPEN C_task_version(p_task_assignments_in(i).pa_task_element_version_id);
4432: FETCH C_task_version INTO l_task_elem_version_id, l_d_task_id;
4433: CLOSE C_task_version;

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

4434:
4435:
4436: ELSIF l_task_elem_version_id IS NULL AND p_task_assignments_in.exists(i) AND
4437: p_task_assignments_in(i).pa_task_id IS NOT NULL AND
4438: p_task_assignments_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4439:
4440: l_d_task_id := p_task_assignments_in(i).pa_task_id;
4441:
4442: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 4453: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

4449: pa_debug.g_err_stage:='l_d_task_id'|| l_d_task_id;
4450: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
4451: END IF;
4452:
4453: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4454: l_d_task_id IS NULL )
4455: THEN
4456: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4457: THEN

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

4471:
4472:
4473: ELSIF l_task_elem_version_id IS NULL AND p_task_assignments_in.exists(i) AND
4474: p_task_assignments_in(i).pm_task_reference IS NOT NULL AND
4475: p_task_assignments_in(i).pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
4476:
4477: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4478: pa_debug.g_err_stage:='l_d_task_reference'|| p_task_assignments_in(i).pm_task_reference;
4479: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

Line 4495: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

4491: pa_debug.g_err_stage:='l_d_task_id'|| l_d_task_id;
4492: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
4493: END IF;
4494:
4495: IF ( l_d_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
4496: l_d_task_id IS NULL )
4497: THEN
4498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4499: THEN

Line 4517: l_task_elem_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

4513:
4514: END IF;
4515:
4516: IF l_task_elem_version_id is not NULL AND
4517: l_task_elem_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4518:
4519: l_task_elem_version_id_tbl.extend(1);
4520:
4521: l_task_elem_version_id_tbl(i):= l_task_elem_version_id;

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

4539: END IF;
4540:
4541: lp_resource_assignment_id_tbl.extend(1);
4542: IF p_task_assignments_in(i).pa_task_assignment_id is NOT null AND
4543: p_task_assignments_in(i).pa_task_assignment_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4544:
4545:
4546: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4547: pa_debug.g_err_stage:='Accepting Task Assignment Id given:' || p_task_assignments_in(i).pa_task_assignment_id ;

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

4549: END IF;
4550: lp_resource_assignment_id_tbl(i) := p_task_assignments_in(i).pa_task_assignment_id;
4551:
4552: ELSIF p_task_assignments_in(i).pm_task_asgmt_reference is not null AND
4553: p_task_assignments_in(i).pm_task_asgmt_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
4554:
4555: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4556: pa_debug.g_err_stage:='Converting Task Asgmt Reference:' || p_task_assignments_in(i).pm_task_asgmt_reference ;
4557: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);

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

4595:
4596: IF p_task_assignments_in(i).p_context <> 'D' THEN --Validations of Not Delete Context..(Update or Add)
4597:
4598: IF p_task_assignments_in(i).resource_list_member_id IS NOT NULL AND
4599: p_task_assignments_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4600:
4601: C_Res_List_Mem_Check_Rec := NULL;
4602:
4603: OPEN C_Res_List_Mem_Check(p_task_assignments_in(i).resource_list_member_id);

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

4623:
4624: ELSIF p_task_assignments_in(i).pa_task_assignment_id IS NULL AND
4625: p_task_assignments_in(i).p_context <> 'D' AND
4626: (p_task_assignments_in(i).resource_list_member_id IS NULL OR
4627: p_task_assignments_in(i).resource_list_member_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
4628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4629: THEN
4630: PA_UTILS.ADD_MESSAGE
4631: (p_app_short_name => 'PA',

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

4641: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
4642: END IF;
4643:
4644: IF p_task_assignments_in(i).start_date IS NOT NULL and
4645: p_task_assignments_in(i).start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
4646: p_task_assignments_in(i).end_date IS NOT NULL and
4647: p_task_assignments_in(i).end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
4648: p_task_assignments_in(i).start_date > p_task_assignments_in(i).end_date THEN
4649:

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

4643:
4644: IF p_task_assignments_in(i).start_date IS NOT NULL and
4645: p_task_assignments_in(i).start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
4646: p_task_assignments_in(i).end_date IS NOT NULL and
4647: p_task_assignments_in(i).end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE and
4648: p_task_assignments_in(i).start_date > p_task_assignments_in(i).end_date THEN
4649:
4650: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4651: PA_UTILS.ADD_MESSAGE

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

4660: END IF;
4661:
4662: IF p_task_assignments_in(i).pa_task_assignment_id IS NULL and
4663: (p_task_assignments_in(i).pm_task_asgmt_reference IS NULL OR
4664: p_task_assignments_in(i).pm_task_asgmt_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
4665: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4666: THEN
4667: PA_UTILS.ADD_MESSAGE
4668: (p_app_short_name => 'PA',

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

4679: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
4680: END IF;
4681:
4682: IF p_task_assignments_in(i).use_task_schedule_flag IS NOT NULL AND
4683: p_task_assignments_in(i).use_task_schedule_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
4684: p_task_assignments_in(i).use_task_schedule_flag not in ('Y', 'N') THEN
4685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4686: THEN
4687: pa_interface_utils_pub.map_new_amg_msg

Line 4687: pa_interface_utils_pub.map_new_amg_msg

4683: p_task_assignments_in(i).use_task_schedule_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
4684: p_task_assignments_in(i).use_task_schedule_flag not in ('Y', 'N') THEN
4685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4686: THEN
4687: pa_interface_utils_pub.map_new_amg_msg
4688: ( p_old_message_code => 'PA_TASK_SCHED_FLAG_INVALID' -->>>>
4689: ,p_msg_attribute => 'CHANGE'
4690: ,p_resize_flag => 'N'
4691: ,p_msg_context => 'GENERAL'

Line 4710: l_currency_code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

4706: pa_debug.write(G_PKG_NAME ,pa_debug.g_err_stage,3);
4707: END IF;
4708:
4709: -- 4108372: Should default currency code to default value instead of NULL
4710: l_currency_code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
4711:
4712: IF p_task_assignments_in(i).currency_code IS NOT NULL AND
4713: p_task_assignments_in(i).currency_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
4714:

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

4709: -- 4108372: Should default currency code to default value instead of NULL
4710: l_currency_code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
4711:
4712: IF p_task_assignments_in(i).currency_code IS NOT NULL AND
4713: p_task_assignments_in(i).currency_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
4714:
4715: OPEN C_currency_exists(p_task_assignments_in(i).currency_code, l_project_id );
4716: FETCH C_currency_exists INTO C_currency_exists_rec;
4717:

Line 4723: pa_interface_utils_pub.map_new_amg_msg

4719: l_currency_code := p_task_assignments_in(i).currency_code ;
4720: ELSIF C_currency_exists%NOTFOUND THEN
4721: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4722: THEN
4723: pa_interface_utils_pub.map_new_amg_msg
4724: ( p_old_message_code => 'PA_INVALID_CURRENCY' -->>>>
4725: ,p_msg_attribute => 'CHANGE'
4726: ,p_resize_flag => 'N'
4727: ,p_msg_context => 'GENERAL'

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

4748:
4749:
4750:
4751: IF lp_resource_assignment_id_tbl(i) IS NOT NULL AND --Delete Content
4752: lp_resource_assignment_id_tbl(i) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
4753: p_task_assignments_in(i).p_context = 'D' THEN
4754:
4755: OPEN C_Res_Asgmt_Data(lp_resource_assignment_id_tbl(i));
4756: FETCH C_Res_Asgmt_Data into C_Res_Asgmt_Data_Rec;

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

4769: ld_resource_assignment_id_tbl(del_index) := lp_resource_assignment_id_tbl(i);
4770:
4771:
4772: ELSIF lp_resource_assignment_id_tbl(i) IS NOT NULL AND --Update Content
4773: lp_resource_assignment_id_tbl(i) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
4774: p_task_assignments_in(i).p_context <> 'D' THEN
4775:
4776: OPEN C_Res_Asgmt_Data(lp_resource_assignment_id_tbl(i));
4777: FETCH C_Res_Asgmt_Data into C_Res_Asgmt_Data_Rec;

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

4796: END IF;
4797:
4798:
4799: IF p_task_assignments_in(i).billable_work_percent IS NOT NULL AND
4800: p_task_assignments_in(i).billable_work_percent <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
4801: ( p_task_assignments_in(i).billable_work_percent < 0 OR
4802: p_task_assignments_in(i).billable_work_percent > 100) THEN
4803: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4804: THEN

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

4821: l_Cost_Type_exists := NULL;
4822: l_cost_type_id := NULL;
4823:
4824: IF p_task_assignments_in(i).mfg_cost_type_id IS NOT NULL AND
4825: p_task_assignments_in(i).mfg_cost_type_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4826:
4827: OPEN C_Cost_Type_Exists(p_task_assignments_in(i).mfg_cost_type_id );
4828: FETCH C_Cost_Type_Exists INTO C_Cost_Type_Exists_rec;
4829:

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

4834: END IF;
4835: CLOSE C_Cost_Type_Exists;
4836:
4837: ELSIF p_task_assignments_in(i).mfg_cost_type IS NOT NULL AND
4838: p_task_assignments_in(i).mfg_cost_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
4839:
4840: OPEN C_Cost_Type(p_task_assignments_in(i).mfg_cost_type_id );
4841: FETCH C_Cost_Type INTO C_Cost_Type_rec;
4842:

Line 4857: pa_interface_utils_pub.map_new_amg_msg

4853:
4854: IF l_Cost_Type_exists is NOT NULL and l_Cost_Type_exists = 'N' THEN
4855: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4856: THEN
4857: pa_interface_utils_pub.map_new_amg_msg
4858: ( p_old_message_code => 'PA_INVALID_COST_TYPE' -->>>>
4859: ,p_msg_attribute => 'CHANGE'
4860: ,p_resize_flag => 'N'
4861: ,p_msg_context => 'GENERAL'

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

6072:
6073:
6074:
6075: PROCEDURE Fetch_Task_Assignments
6076: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6077: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
6078: ,p_task_asgmt_index IN pa_num_1000_num := pa_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
6079: ,p_pm_task_asgmt_reference OUT NOCOPY pa_vc_1000_30
6080: ,p_pa_task_assignment_id OUT NOCOPY pa_num_1000_num

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

6074:
6075: PROCEDURE Fetch_Task_Assignments
6076: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6077: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
6078: ,p_task_asgmt_index IN pa_num_1000_num := pa_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
6079: ,p_pm_task_asgmt_reference OUT NOCOPY pa_vc_1000_30
6080: ,p_pa_task_assignment_id OUT NOCOPY pa_num_1000_num
6081: ,p_pm_task_reference OUT NOCOPY pa_vc_1000_30
6082: ,p_pa_task_id OUT NOCOPY pa_num_1000_num

Line 6151: IF p_task_asgmt_index(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

6147: FOR i in 1..p_task_asgmt_index.COUNT LOOP
6148:
6149: --dbms_output.put_line('Entering Fetch Loop: p_task_asgmt_index.COUNT' || p_task_asgmt_index.COUNT);
6150:
6151: IF p_task_asgmt_index(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6152: OR p_task_asgmt_index(i) IS NULL THEN
6153:
6154: --dbms_output.put_line('Asgmt index is not passed.');
6155:

Line 6159: pa_interface_utils_pub.map_new_amg_msg

6155:
6156: RETURN;
6157:
6158: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6159: pa_interface_utils_pub.map_new_amg_msg
6160: ( p_old_message_code => 'PA_INDEX_NOT_PROVIDED'
6161: ,p_msg_attribute => 'CHANGE'
6162: ,p_resize_flag => 'N'
6163: ,p_msg_context => 'GENERAL'

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

6180:
6181: -- assign global table fields to the outgoing parameter
6182: -- we don't want to return the big number G_PA_MISS_NUM
6183:
6184: IF g_task_asgmts_out_tbl(p_task_asgmt_index(i)).pa_task_assignment_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
6185: g_task_asgmts_out_tbl(p_task_asgmt_index(i)).pa_task_assignment_id = NULL
6186: THEN
6187:
6188: p_pa_task_assignment_id(i) := NULL;

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

6195: --dbms_output.put_line('after set');
6196:
6197: END IF;
6198:
6199: IF g_task_asgmts_out_tbl(p_task_asgmt_index(i)).pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
6200: g_task_asgmts_out_tbl(p_task_asgmt_index(i)).pa_task_id = NULL
6201: THEN
6202: --dbms_output.put_line('task id is null');
6203: p_pa_task_id(i) := NULL;

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

6207: p_pa_task_id(i) := g_task_asgmts_out_tbl(p_task_asgmt_index(i)).pa_task_id;
6208: --dbms_output.put_line('task id is set');
6209: END IF;
6210:
6211: IF g_task_asgmts_out_tbl(p_task_asgmt_index(i)).resource_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR
6212: g_task_asgmts_out_tbl(p_task_asgmt_index(i)).resource_alias = NULL
6213: THEN
6214: --dbms_output.put_line('null resource alias');
6215: p_resource_alias(i) := NULL;

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

6219: p_resource_alias(i) := g_task_asgmts_out_tbl(p_task_asgmt_index(i)).resource_alias;
6220: --dbms_output.put_line('after setting resource alias');
6221: END IF;
6222:
6223: IF g_task_asgmts_out_tbl(p_task_asgmt_index(i)).resource_list_member_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
6224: g_task_asgmts_out_tbl(p_task_asgmt_index(i)).resource_list_member_id = NULL
6225: THEN
6226: --dbms_output.put_line('null resource list member id');
6227: p_resource_list_member_id(i) := NULL;

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

6297: ,p_pa_project_id IN NUMBER
6298: ,p_pa_structure_version_id IN NUMBER
6299: ,p_pa_task_id IN NUMBER
6300: ,p_pa_task_elem_ver_id IN NUMBER
6301: ,p_pm_task_asgmt_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6302: ,p_pa_task_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6303: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6304: ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6305: -- Bug 3937017 Added a new parameter p_add_error_msg_flag

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

6298: ,p_pa_structure_version_id IN NUMBER
6299: ,p_pa_task_id IN NUMBER
6300: ,p_pa_task_elem_ver_id IN NUMBER
6301: ,p_pm_task_asgmt_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6302: ,p_pa_task_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6303: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6304: ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6305: -- Bug 3937017 Added a new parameter p_add_error_msg_flag
6306: ,p_add_error_msg_flag IN VARCHAR2 DEFAULT 'Y'

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

6299: ,p_pa_task_id IN NUMBER
6300: ,p_pa_task_elem_ver_id IN NUMBER
6301: ,p_pm_task_asgmt_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6302: ,p_pa_task_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6303: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6304: ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6305: -- Bug 3937017 Added a new parameter p_add_error_msg_flag
6306: ,p_add_error_msg_flag IN VARCHAR2 DEFAULT 'Y'
6307: -- Bug 3872176 Added a new parameter p_published_version_flag

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

6300: ,p_pa_task_elem_ver_id IN NUMBER
6301: ,p_pm_task_asgmt_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6302: ,p_pa_task_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6303: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6304: ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6305: -- Bug 3937017 Added a new parameter p_add_error_msg_flag
6306: ,p_add_error_msg_flag IN VARCHAR2 DEFAULT 'Y'
6307: -- Bug 3872176 Added a new parameter p_published_version_flag
6308: ,p_published_version_flag IN VARCHAR2 DEFAULT 'N'

Line 6426: IF p_pa_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

6422: OPEN l_project_id_csr;
6423: FETCH l_project_id_csr INTO l_dummy, l_template_flag, l_version_enabled_flag;
6424: CLOSE l_project_id_csr;
6425:
6426: IF p_pa_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6427: AND p_pa_project_id IS NOT NULL THEN
6428:
6429: IF l_dummy IS NULL THEN
6430:

Line 6433: pa_interface_utils_pub.map_new_amg_msg

6429: IF l_dummy IS NULL THEN
6430:
6431: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6432: THEN
6433: pa_interface_utils_pub.map_new_amg_msg
6434: ( p_old_message_code => 'PA_INVALID_PROJECT_ID'
6435: ,p_msg_attribute => 'CHANGE'
6436: ,p_resize_flag => 'N'
6437: ,p_msg_context => 'GENERAL'

Line 6452: pa_interface_utils_pub.map_new_amg_msg

6448: ELSE
6449:
6450: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6451: THEN
6452: pa_interface_utils_pub.map_new_amg_msg
6453: ( p_old_message_code => 'PA_PROJECT_ID_MISSING'
6454: ,p_msg_attribute => 'CHANGE'
6455: ,p_resize_flag => 'N'
6456: ,p_msg_context => 'GENERAL'

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

6465:
6466: END IF;
6467:
6468: IF p_pa_structure_version_id IS NOT NULL AND
6469: (p_pa_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
6470:
6471: l_struct_elem_version_id := p_pa_structure_version_id;
6472:
6473: --Added by rtarway for BUG 3872176

Line 6507: l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

6503: --dbms_output.put_line(' structure version is: ' || l_struct_elem_version_id );
6504: --dbms_output.put_line(' testing str if..' );
6505:
6506: IF ( l_struct_elem_version_id IS NULL OR
6507: l_struct_elem_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6508: )
6509:
6510: THEN
6511: --dbms_output.put_line(' test struct.null or g miss..');

Line 6516: pa_interface_utils_pub.map_new_amg_msg

6512:
6513: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6514: THEN
6515: --dbms_output.put_line(' test struct.null or gmiss err..');
6516: pa_interface_utils_pub.map_new_amg_msg
6517: ( p_old_message_code => 'PA_PS_STRUC_VER_REQ'
6518: ,p_msg_attribute => 'CHANGE'
6519: ,p_resize_flag => 'N'
6520: ,p_msg_context => 'GENERAL'

Line 6530: IF p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

6526: END IF;
6527: RAISE FND_API.G_EXC_ERROR;
6528: END IF;
6529:
6530: IF p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6531: AND p_pa_task_id IS NOT NULL
6532: THEN
6533:
6534: -- Get segment1 for AMG messages

Line 6548: pa_interface_utils_pub.map_new_amg_msg

6544: IF l_task_ver_id is NULL
6545: THEN
6546: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6547: THEN
6548: pa_interface_utils_pub.map_new_amg_msg
6549: ( p_old_message_code => 'PA_TASK_ID_INVALID'
6550: ,p_msg_attribute => 'CHANGE'
6551: ,p_resize_flag => 'N'
6552: ,p_msg_context => 'PROJ'

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

6561: RAISE FND_API.G_EXC_ERROR;
6562: END IF;
6563:
6564: --p_out_task_id := p_pa_task_id; --JRAJ.
6565: END IF; --IF p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6566:
6567:
6568:
6569: IF p_pa_task_assignment_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 6569: IF p_pa_task_assignment_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

6565: END IF; --IF p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6566:
6567:
6568:
6569: IF p_pa_task_assignment_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6570: AND p_pa_task_assignment_id IS NOT NULL
6571: THEN
6572: --dbms_output.put_line('task assignment id is passed'||p_pa_task_assignment_id);
6573: -- Get segment1 for AMG messages

Line 6588: pa_interface_utils_pub.map_new_amg_msg

6584: IF l_task_asgmt_id_csr%NOTFOUND
6585: THEN
6586: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6587: THEN
6588: pa_interface_utils_pub.map_new_amg_msg
6589: ( p_old_message_code => 'PA_TASK_ASGMT_ID_INVALID'
6590: ,p_msg_attribute => 'CHANGE'
6591: ,p_resize_flag => 'N'
6592: ,p_msg_context => 'PROJ'

Line 6607: ELSIF p_pm_task_asgmt_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

6603:
6604: CLOSE l_task_asgmt_id_csr;
6605:
6606: x_pa_task_assignment_id := p_pa_task_assignment_id; --JRAJ.
6607: ELSIF p_pm_task_asgmt_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6608: AND p_pm_task_asgmt_reference IS NOT NULL
6609: THEN
6610:
6611:

Line 6625: IF p_pa_task_elem_ver_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

6621:
6622: -- 4216541
6623: IF l_task_asgmt_id IS NULL THEN
6624:
6625: IF p_pa_task_elem_ver_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
6626: p_pa_task_elem_ver_id IS NOT NULL AND
6627: p_resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
6628: p_resource_list_member_id IS NOT NULL
6629: THEN

Line 6627: p_resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

6623: IF l_task_asgmt_id IS NULL THEN
6624:
6625: IF p_pa_task_elem_ver_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
6626: p_pa_task_elem_ver_id IS NOT NULL AND
6627: p_resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
6628: p_resource_list_member_id IS NOT NULL
6629: THEN
6630:
6631: OPEN c_task_asgmt_from_id_csr(l_struct_elem_version_id);

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

6631: OPEN c_task_asgmt_from_id_csr(l_struct_elem_version_id);
6632: FETCH c_task_asgmt_from_id_csr INTO l_task_asgmt_id ;
6633: CLOSE c_task_asgmt_from_id_csr;
6634:
6635: END IF; -- IF p_pa_task_elem_ver_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
6636: -- END OF 4216541
6637:
6638: IF l_task_asgmt_id IS NULL THEN
6639:

Line 6706: pa_interface_utils_pub.map_new_amg_msg

6702: ELSE
6703:
6704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6705: THEN
6706: pa_interface_utils_pub.map_new_amg_msg
6707: ( p_old_message_code => 'PA_TASK_ASGMT_REF_ID_MISSING'
6708: ,p_msg_attribute => 'CHANGE'
6709: ,p_resize_flag => 'N'
6710: ,p_msg_context => 'PROJ'

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

6716: END IF;
6717:
6718: RAISE FND_API.G_EXC_ERROR;
6719:
6720: END IF; -- If p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6721: --dbms_output.put_line('l_task_asgmt_id'||l_task_asgmt_id);
6722: EXCEPTION
6723:
6724: WHEN FND_API.G_EXC_ERROR