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_STATUS_PUB dependencies on PA_INTERFACE_UTILS_PUB

Line 28: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

24: , p_commit IN VARCHAR2 := FND_API.G_FALSE
25: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
26: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
27: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
28: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
29: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
31: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
32: , p_as_of_date IN DATE

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

25: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
26: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
27: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
28: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
29: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
31: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
32: , p_as_of_date IN DATE
33: , p_percent_complete IN NUMBER

Line 30: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

26: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
27: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
28: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
29: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
31: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
32: , p_as_of_date IN DATE
33: , p_percent_complete IN NUMBER
34: , p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 31: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

27: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
28: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
29: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
30: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
31: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
32: , p_as_of_date IN DATE
33: , p_percent_complete IN NUMBER
34: , p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
35: , p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

30: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
31: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
32: , p_as_of_date IN DATE
33: , p_percent_complete IN NUMBER
34: , p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
35: , p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
36: , p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
37: , p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
38: , p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 35: , p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

31: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
32: , p_as_of_date IN DATE
33: , p_percent_complete IN NUMBER
34: , p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
35: , p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
36: , p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
37: , p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
38: , p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
39: , p_progress_status_code IN VARCHAR2 := 'PROGRESS_STAT_ON_TRACK'

Line 36: , p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

32: , p_as_of_date IN DATE
33: , p_percent_complete IN NUMBER
34: , p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
35: , p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
36: , p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
37: , p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
38: , p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
39: , p_progress_status_code IN VARCHAR2 := 'PROGRESS_STAT_ON_TRACK'
40: , p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 37: , p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

33: , p_percent_complete IN NUMBER
34: , p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
35: , p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
36: , p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
37: , p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
38: , p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
39: , p_progress_status_code IN VARCHAR2 := 'PROGRESS_STAT_ON_TRACK'
40: , p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41: , p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 38: , p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

34: , p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
35: , p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
36: , p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
37: , p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
38: , p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
39: , p_progress_status_code IN VARCHAR2 := 'PROGRESS_STAT_ON_TRACK'
40: , p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41: , p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
42: , p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 40: , p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

36: , p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
37: , p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
38: , p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
39: , p_progress_status_code IN VARCHAR2 := 'PROGRESS_STAT_ON_TRACK'
40: , p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41: , p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
42: , p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
43: , p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
44: , p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 41: , p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

37: , p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
38: , p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
39: , p_progress_status_code IN VARCHAR2 := 'PROGRESS_STAT_ON_TRACK'
40: , p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41: , p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
42: , p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
43: , p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
44: , p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
45: , p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 42: , p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

38: , p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
39: , p_progress_status_code IN VARCHAR2 := 'PROGRESS_STAT_ON_TRACK'
40: , p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41: , p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
42: , p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
43: , p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
44: , p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
45: , p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
46: , p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 43: , p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

39: , p_progress_status_code IN VARCHAR2 := 'PROGRESS_STAT_ON_TRACK'
40: , p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41: , p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
42: , p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
43: , p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
44: , p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
45: , p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
46: , p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
47: , p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 44: , p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

40: , p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41: , p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
42: , p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
43: , p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
44: , p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
45: , p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
46: , p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
47: , p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48: , p_structure_type IN VARCHAR2 := 'FINANCIAL'

Line 45: , p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

41: , p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
42: , p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
43: , p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
44: , p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
45: , p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
46: , p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
47: , p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48: , p_structure_type IN VARCHAR2 := 'FINANCIAL'
49: , p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 46: , p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

42: , p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
43: , p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
44: , p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
45: , p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
46: , p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
47: , p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48: , p_structure_type IN VARCHAR2 := 'FINANCIAL'
49: , p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
50: , p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 47: , p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

43: , p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
44: , p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
45: , p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
46: , p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
47: , p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48: , p_structure_type IN VARCHAR2 := 'FINANCIAL'
49: , p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
50: , p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
51: , p_etc_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM /* FP M Task Progress 3420093*/

Line 49: , p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

45: , p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
46: , p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
47: , p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48: , p_structure_type IN VARCHAR2 := 'FINANCIAL'
49: , p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
50: , p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
51: , p_etc_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM /* FP M Task Progress 3420093*/
52: , p_pm_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3606627
53: , p_pm_task_assgn_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3606627

Line 50: , p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

46: , p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
47: , p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48: , p_structure_type IN VARCHAR2 := 'FINANCIAL'
49: , p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
50: , p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
51: , p_etc_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM /* FP M Task Progress 3420093*/
52: , p_pm_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3606627
53: , p_pm_task_assgn_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3606627
54: , p_actual_cost_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627

Line 51: , p_etc_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM /* FP M Task Progress 3420093*/

47: , p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
48: , p_structure_type IN VARCHAR2 := 'FINANCIAL'
49: , p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
50: , p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
51: , p_etc_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM /* FP M Task Progress 3420093*/
52: , p_pm_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3606627
53: , p_pm_task_assgn_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3606627
54: , p_actual_cost_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627
55: , p_actual_effort_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627

Line 52: , p_pm_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3606627

48: , p_structure_type IN VARCHAR2 := 'FINANCIAL'
49: , p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
50: , p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
51: , p_etc_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM /* FP M Task Progress 3420093*/
52: , p_pm_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3606627
53: , p_pm_task_assgn_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3606627
54: , p_actual_cost_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627
55: , p_actual_effort_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627
56: , p_populate_pji_tables IN VARCHAR2 := 'Y' -- Bug 3606627

Line 53: , p_pm_task_assgn_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3606627

49: , p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
50: , p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
51: , p_etc_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM /* FP M Task Progress 3420093*/
52: , p_pm_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3606627
53: , p_pm_task_assgn_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3606627
54: , p_actual_cost_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627
55: , p_actual_effort_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627
56: , p_populate_pji_tables IN VARCHAR2 := 'Y' -- Bug 3606627
57: , p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627

Line 54: , p_actual_cost_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627

50: , p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
51: , p_etc_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM /* FP M Task Progress 3420093*/
52: , p_pm_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3606627
53: , p_pm_task_assgn_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3606627
54: , p_actual_cost_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627
55: , p_actual_effort_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627
56: , p_populate_pji_tables IN VARCHAR2 := 'Y' -- Bug 3606627
57: , p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
58: , p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 55: , p_actual_effort_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627

51: , p_etc_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM /* FP M Task Progress 3420093*/
52: , p_pm_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3606627
53: , p_pm_task_assgn_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 3606627
54: , p_actual_cost_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627
55: , p_actual_effort_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627
56: , p_populate_pji_tables IN VARCHAR2 := 'Y' -- Bug 3606627
57: , p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
58: , p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59: -- Fix for Bug # 3988457.

Line 58: , p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

54: , p_actual_cost_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627
55: , p_actual_effort_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3606627
56: , p_populate_pji_tables IN VARCHAR2 := 'Y' -- Bug 3606627
57: , p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
58: , p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59: -- Fix for Bug # 3988457.
60: )
61: IS
62:

Line 314: IF (p_task_id = 0 AND p_object_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_object_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

310: -- User can pass task_id or task reference
311: -- User can pass object_type and object_id or object_reference
312: -- User can pass task _id as 0 and object_type and object_id as miss char
313:
314: IF (p_task_id = 0 AND p_object_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_object_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
315: IF g1_debug_mode = 'Y' THEN
316: pa_debug.write(x_Module=>'PA_STATUS_PUB.UPDATE_PROGRESS', x_Msg => 'Case 1 : task_id is passed as 0 and object_type and object_id is not passed', x_Log_Level=> 3);
317: END IF;
318: -- Must be Project-Level Progress Data

Line 326: ELSIF (((p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id <> 0) OR (p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_pm_task_reference IS NOT NULL))

322: FETCH c_get_structure_information INTO l_object_id, l_object_version_id;
323: CLOSE c_get_structure_information;
324: l_task_id := null;
325: l_structure_version_id := l_object_version_id;
326: ELSIF (((p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id <> 0) OR (p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_pm_task_reference IS NOT NULL))
327: AND p_object_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_object_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
328:
329: IF g1_debug_mode = 'Y' THEN
330: pa_debug.write(x_Module=>'PA_STATUS_PUB.UPDATE_PROGRESS', x_Msg => 'Case 2 : task_id is passed or task_ref is passed and object_type and object_id is not passed', x_Log_Level=> 3);

Line 327: AND p_object_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_object_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

323: CLOSE c_get_structure_information;
324: l_task_id := null;
325: l_structure_version_id := l_object_version_id;
326: ELSIF (((p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id <> 0) OR (p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_pm_task_reference IS NOT NULL))
327: AND p_object_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_object_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
328:
329: IF g1_debug_mode = 'Y' THEN
330: pa_debug.write(x_Module=>'PA_STATUS_PUB.UPDATE_PROGRESS', x_Msg => 'Case 2 : task_id is passed or task_ref is passed and object_type and object_id is not passed', x_Log_Level=> 3);
331: END IF;

Line 352: ELSIF (p_object_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_object_type IS NOT NULL) THEN

348: OPEN c_get_element_information(p_project_id, l_object_id, l_object_type, p_structure_type);
349: FETCH c_get_element_information INTO l_object_version_id, l_structure_version_id;
350: CLOSE c_get_element_information;
351: l_task_id := l_task_id_out;
352: ELSIF (p_object_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_object_type IS NOT NULL) THEN
353: IF g1_debug_mode = 'Y' THEN
354: pa_debug.write(x_Module=>'PA_STATUS_PUB.UPDATE_PROGRESS', x_Msg => 'Case 3 : object_type is passed', x_Log_Level=> 3);
355: END IF;
356:

Line 374: IF ((p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL)

370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
373: IF p_object_type = 'PA_TASKS' THEN
374: IF ((p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL)
375: OR (p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_pm_task_reference IS NOT NULL)) THEN
376:
377: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
378: ( p_pa_project_id => l_project_id_out

Line 375: OR (p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_pm_task_reference IS NOT NULL)) THEN

371: END IF;
372:
373: IF p_object_type = 'PA_TASKS' THEN
374: IF ((p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL)
375: OR (p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_pm_task_reference IS NOT NULL)) THEN
376:
377: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
378: ( p_pa_project_id => l_project_id_out
379: , p_structure_type => p_structure_type

Line 391: IF ((p_object_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_object_id IS NOT NULL)

387: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
388: RAISE FND_API.G_EXC_ERROR;
389: END IF;
390: END IF;
391: IF ((p_object_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_object_id IS NOT NULL)
392: OR (p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_pm_task_reference IS NOT NULL)) THEN
393:
394: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
395: ( p_pa_project_id => l_project_id_out

Line 392: OR (p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_pm_task_reference IS NOT NULL)) THEN

388: RAISE FND_API.G_EXC_ERROR;
389: END IF;
390: END IF;
391: IF ((p_object_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_object_id IS NOT NULL)
392: OR (p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_pm_task_reference IS NOT NULL)) THEN
393:
394: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
395: ( p_pa_project_id => l_project_id_out
396: , p_structure_type => p_structure_type

Line 447: IF ((p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL)

443: END IF;
444: ELSIF p_object_type = 'PA_ASSIGNMENTS' THEN
445:
446: --Added by rtarway for BUG 3872176
447: IF ((p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL)
448: OR (p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_pm_task_reference IS NOT NULL)) THEN
449:
450: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
451: ( p_pa_project_id => l_project_id_out

Line 448: OR (p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_pm_task_reference IS NOT NULL)) THEN

444: ELSIF p_object_type = 'PA_ASSIGNMENTS' THEN
445:
446: --Added by rtarway for BUG 3872176
447: IF ((p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL)
448: OR (p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_pm_task_reference IS NOT NULL)) THEN
449:
450: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
451: ( p_pa_project_id => l_project_id_out
452: , p_structure_type => p_structure_type

Line 488: IF p_object_id IS NOT NULL AND p_object_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

484: end if;
485: --end add by rtarway BUG 3872176
486:
487:
488: IF p_object_id IS NOT NULL AND p_object_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
489: l_valid_rlm_id := 'N';
490: l_ta_display_flag := 'X';
491: OPEN c_verify_rlm_id(l_project_id_out, p_object_id, l_structure_version_id, l_task_version_id);
492: FETCH c_verify_rlm_id INTO l_valid_rlm_id, l_ta_display_flag;

Line 548: END IF; --(p_task_id = 0 AND p_object_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_object_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

544: CLOSE c_get_structure_information;
545: l_task_id := null;
546: l_structure_version_id := l_object_version_id;
547: END IF; -- p_object_type = 'PA_TASKS'
548: END IF; --(p_task_id = 0 AND p_object_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_object_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
549:
550: IF g1_debug_mode = 'Y' THEN
551: pa_debug.write(x_Module=>'PA_STATUS_PUB.UPDATE_PROGRESS', x_Msg => 'l_object_type='||l_object_type, x_Log_Level=> 3);
552: pa_debug.write(x_Module=>'PA_STATUS_PUB.UPDATE_PROGRESS', x_Msg => 'l_object_id='||l_object_id, x_Log_Level=> 3);

Line 622: IF (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN

618: RAISE FND_API.G_EXC_ERROR;
619: END IF;
620: END IF;
621:
622: IF (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN
623: l_pm_product_code := NULL;
624: ELSE
625: l_pm_product_code := p_pm_product_code;
626: END IF;

Line 628: IF (p_description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN

624: ELSE
625: l_pm_product_code := p_pm_product_code;
626: END IF;
627:
628: IF (p_description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN
629: l_description := NULL;
630: ELSE
631: l_description := p_description;
632: END IF;

Line 636: IF (p_progress_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

632: END IF;
633:
634: l_as_of_date := TRUNC(p_as_of_date);
635:
636: IF (p_progress_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
637: l_progress_status_code := null;
638: ELSE
639: l_progress_status_code := p_progress_status_code;
640: END IF;

Line 642: IF (p_progress_comment = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

638: ELSE
639: l_progress_status_code := p_progress_status_code;
640: END IF;
641:
642: IF (p_progress_comment = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
643: l_progress_comment := null;
644: ELSE
645: l_progress_comment := p_progress_comment;
646: END IF;

Line 648: IF (p_actual_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN

644: ELSE
645: l_progress_comment := p_progress_comment;
646: END IF;
647:
648: IF (p_actual_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN
649: l_actual_start_date := null;
650: ELSE
651: l_actual_start_date := p_actual_start_date;
652: END IF;

Line 654: IF (p_actual_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN

650: ELSE
651: l_actual_start_date := p_actual_start_date;
652: END IF;
653:
654: IF (p_actual_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN
655: l_actual_finish_date := null;
656: ELSE
657: l_actual_finish_date := p_actual_finish_date;
658: END IF;

Line 660: IF (p_estimated_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN

656: ELSE
657: l_actual_finish_date := p_actual_finish_date;
658: END IF;
659:
660: IF (p_estimated_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN
661: l_estimated_start_date := null;
662: ELSE
663: l_estimated_start_date := p_estimated_start_date;
664: END IF;

Line 666: IF (p_estimated_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN

662: ELSE
663: l_estimated_start_date := p_estimated_start_date;
664: END IF;
665:
666: IF (p_estimated_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN
667: l_estimated_finish_date := null;
668: ELSE
669: l_estimated_finish_date := p_estimated_finish_date;
670: END IF;

Line 672: IF (p_scheduled_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN

668: ELSE
669: l_estimated_finish_date := p_estimated_finish_date;
670: END IF;
671:
672: IF (p_scheduled_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN
673: l_scheduled_start_date := null;
674: ELSE
675: l_scheduled_start_date := p_scheduled_start_date;
676: END IF;

Line 678: IF (p_scheduled_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN

674: ELSE
675: l_scheduled_start_date := p_scheduled_start_date;
676: END IF;
677:
678: IF (p_scheduled_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) THEN
679: l_scheduled_finish_date := null;
680: ELSE
681: l_scheduled_finish_date := p_scheduled_finish_date;
682: END IF;

Line 684: IF (p_est_remaining_effort = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

680: ELSE
681: l_scheduled_finish_date := p_scheduled_finish_date;
682: END IF;
683:
684: IF (p_est_remaining_effort = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
685: l_est_remaining_effort := null;
686: ELSE
687: l_est_remaining_effort := p_est_remaining_effort;
688: END IF;

Line 690: IF (p_etc_cost = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

686: ELSE
687: l_est_remaining_effort := p_est_remaining_effort;
688: END IF;
689:
690: IF (p_etc_cost = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
691: l_etc_cost := null;
692: ELSE
693: l_etc_cost := p_etc_cost;
694: END IF;

Line 696: IF (p_ACTUAL_COST_TO_DATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

692: ELSE
693: l_etc_cost := p_etc_cost;
694: END IF;
695:
696: IF (p_ACTUAL_COST_TO_DATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
697: l_ACTUAL_COST_TO_DATE := null;
698: ELSE
699: l_ACTUAL_COST_TO_DATE := p_ACTUAL_COST_TO_DATE;
700: END IF;

Line 702: IF (p_ACTUAL_EFFORT_TO_DATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

698: ELSE
699: l_ACTUAL_COST_TO_DATE := p_ACTUAL_COST_TO_DATE;
700: END IF;
701:
702: IF (p_ACTUAL_EFFORT_TO_DATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
703: l_ACTUAL_EFFORT_TO_DATE := null;
704: ELSE
705: l_ACTUAL_EFFORT_TO_DATE := p_ACTUAL_EFFORT_TO_DATE;
706: END IF;

Line 710: IF (p_actual_work_quantity = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR p_actual_work_quantity = 0) THEN

706: END IF;
707:
708:
709: -- Bug 2736387 added check for 0 also in beflow if condition
710: IF (p_actual_work_quantity = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR p_actual_work_quantity = 0) THEN
711: l_actual_work_quantity := null;
712: ELSE
713: l_actual_work_quantity := p_actual_work_quantity;
714: END IF;

Line 778: IF p_task_status = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_task_status IS NULL --bug 2791395

774: -- Bug 3606627 : Now p_task_status column is being used for deliverable status too
775: -- So we can not default values here. Defaulting is happening in update_task_progress and
776: -- update_deliverable_progress
777: /* Bug2751159 -- Added following IF condition to get the appropriate task_status */
778: IF p_task_status = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_task_status IS NULL --bug 2791395
779: THEN
780: /* IF p_percent_complete = 100 THEN
781: l_task_status := '127'; ---COMPLETED -- 127 bug 2826235
782: ELSIF p_percent_complete > 0 THEN

Line 988: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

984: , p_commit IN VARCHAR2 := FND_API.G_FALSE
985: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
986: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
987: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
988: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
989: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
990: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
991: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
992: , p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

985: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
986: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
987: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
988: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
989: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
990: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
991: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
992: , p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
993: , p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 990: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

986: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
987: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
988: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
989: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
990: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
991: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
992: , p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
993: , p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
994: , p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

987: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
988: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
989: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
990: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
991: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
992: , p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
993: , p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
994: , p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
995: , p_as_of_date IN DATE

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

988: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
989: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
990: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
991: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
992: , p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
993: , p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
994: , p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
995: , p_as_of_date IN DATE
996: , p_bcws_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

989: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
990: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
991: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
992: , p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
993: , p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
994: , p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
995: , p_as_of_date IN DATE
996: , p_bcws_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
997: , p_acwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 994: , p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

990: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
991: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
992: , p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
993: , p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
994: , p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
995: , p_as_of_date IN DATE
996: , p_bcws_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
997: , p_acwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
998: , p_bcwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 996: , p_bcws_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

992: , p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
993: , p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
994: , p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
995: , p_as_of_date IN DATE
996: , p_bcws_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
997: , p_acwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
998: , p_bcwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
999: , p_bac_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1000: , p_bcws_itd IN NUMBER

Line 997: , p_acwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

993: , p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
994: , p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
995: , p_as_of_date IN DATE
996: , p_bcws_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
997: , p_acwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
998: , p_bcwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
999: , p_bac_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1000: , p_bcws_itd IN NUMBER
1001: , p_acwp_itd IN NUMBER

Line 998: , p_bcwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

994: , p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
995: , p_as_of_date IN DATE
996: , p_bcws_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
997: , p_acwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
998: , p_bcwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
999: , p_bac_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1000: , p_bcws_itd IN NUMBER
1001: , p_acwp_itd IN NUMBER
1002: , p_bcwp_itd IN NUMBER

Line 999: , p_bac_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

995: , p_as_of_date IN DATE
996: , p_bcws_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
997: , p_acwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
998: , p_bcwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
999: , p_bac_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1000: , p_bcws_itd IN NUMBER
1001: , p_acwp_itd IN NUMBER
1002: , p_bcwp_itd IN NUMBER
1003: , p_bac_itd IN NUMBER

Line 1004: , p_bqws_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1000: , p_bcws_itd IN NUMBER
1001: , p_acwp_itd IN NUMBER
1002: , p_bcwp_itd IN NUMBER
1003: , p_bac_itd IN NUMBER
1004: , p_bqws_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1005: , p_aqwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1006: , p_bqwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1007: , p_baq_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1008: , p_bqws_itd IN NUMBER

Line 1005: , p_aqwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1001: , p_acwp_itd IN NUMBER
1002: , p_bcwp_itd IN NUMBER
1003: , p_bac_itd IN NUMBER
1004: , p_bqws_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1005: , p_aqwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1006: , p_bqwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1007: , p_baq_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1008: , p_bqws_itd IN NUMBER
1009: , p_aqwp_itd IN NUMBER

Line 1006: , p_bqwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1002: , p_bcwp_itd IN NUMBER
1003: , p_bac_itd IN NUMBER
1004: , p_bqws_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1005: , p_aqwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1006: , p_bqwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1007: , p_baq_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1008: , p_bqws_itd IN NUMBER
1009: , p_aqwp_itd IN NUMBER
1010: , p_bqwp_itd IN NUMBER

Line 1007: , p_baq_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1003: , p_bac_itd IN NUMBER
1004: , p_bqws_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1005: , p_aqwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1006: , p_bqwp_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1007: , p_baq_current IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1008: , p_bqws_itd IN NUMBER
1009: , p_aqwp_itd IN NUMBER
1010: , p_bqwp_itd IN NUMBER
1011: , p_baq_itd IN NUMBER

Line 1111: PA_INTERFACE_UTILS_PUB.g_project_id := l_project_id_out;

1107: -- such functions to be executed, the API should not proceed further
1108: -- since the user does not have access to such functions
1109:
1110: --Bug 2471668
1111: PA_INTERFACE_UTILS_PUB.g_project_id := l_project_id_out;
1112:
1113: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
1114: (p_api_version_number => p_api_version_number,
1115: p_responsibility_id => l_resp_id,

Line 1213: IF (p_resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

1209: -- ---------------------------------------------------------------
1210: -- Convert Resource List Member Values to Id
1211: -- ---------------------------------------------------------------
1212:
1213: IF (p_resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1214:
1215: IF (p_resource_list_member_id = 0) THEN
1216: -- Must be Task-Level Earned Value Data
1217:

Line 1270: IF (p_bcws_current = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

1266: -- ------------------------------------------------------------------------------
1267: -- Set Defaults
1268: -- ------------------------------------------------------------------------------
1269:
1270: IF (p_bcws_current = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1271: l_bcws_current := 0;
1272: ELSE
1273: l_bcws_current := p_bcws_current;
1274: END IF;

Line 1275: IF (p_acwp_current = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

1271: l_bcws_current := 0;
1272: ELSE
1273: l_bcws_current := p_bcws_current;
1274: END IF;
1275: IF (p_acwp_current = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1276: l_acwp_current := 0;
1277: ELSE
1278: l_acwp_current := p_acwp_current ;
1279: END IF;

Line 1280: IF (p_bcwp_current = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

1276: l_acwp_current := 0;
1277: ELSE
1278: l_acwp_current := p_acwp_current ;
1279: END IF;
1280: IF (p_bcwp_current = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1281: l_bcwp_current := 0;
1282: ELSE
1283: l_bcwp_current := p_bcwp_current;
1284: END IF;

Line 1285: IF (p_bac_current = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

1281: l_bcwp_current := 0;
1282: ELSE
1283: l_bcwp_current := p_bcwp_current;
1284: END IF;
1285: IF (p_bac_current = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1286: l_bac_current := 0;
1287: ELSE
1288: l_bac_current := p_bac_current;
1289: END IF;

Line 1291: IF (p_bqws_current = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

1287: ELSE
1288: l_bac_current := p_bac_current;
1289: END IF;
1290:
1291: IF (p_bqws_current = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1292: l_bqws_current := 0;
1293: ELSE
1294: l_bqws_current := p_bqws_current;
1295: END IF;

Line 1296: IF (p_aqwp_current = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

1292: l_bqws_current := 0;
1293: ELSE
1294: l_bqws_current := p_bqws_current;
1295: END IF;
1296: IF (p_aqwp_current = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1297: l_aqwp_current := 0;
1298: ELSE
1299: l_aqwp_current := p_aqwp_current;
1300: END IF;

Line 1301: IF (p_bqwp_current = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

1297: l_aqwp_current := 0;
1298: ELSE
1299: l_aqwp_current := p_aqwp_current;
1300: END IF;
1301: IF (p_bqwp_current = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1302: l_bqwp_current := 0;
1303: ELSE
1304: l_bqwp_current := p_bqwp_current;
1305: END IF;

Line 1306: IF (p_baq_current = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

1302: l_bqwp_current := 0;
1303: ELSE
1304: l_bqwp_current := p_bqwp_current;
1305: END IF;
1306: IF (p_baq_current = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1307: l_baq_current := 0;
1308: ELSE
1309: l_baq_current := p_baq_current;
1310: END IF;

Line 1539: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1535: PROCEDURE Load_Task_Progress
1536: (p_api_version_number IN NUMBER
1537: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1538: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1539: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1540: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1541: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1542: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
1543: ,p_as_of_date IN DATE

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

1536: (p_api_version_number IN NUMBER
1537: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1538: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1539: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1540: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1541: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1542: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
1543: ,p_as_of_date IN DATE
1544: ,p_task_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

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

1537: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1538: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1539: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1540: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1541: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1542: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
1543: ,p_as_of_date IN DATE
1544: ,p_task_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1545: ,p_task_name IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 1544: ,p_task_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

1540: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1541: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1542: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
1543: ,p_as_of_date IN DATE
1544: ,p_task_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1545: ,p_task_name IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1546: ,p_task_number IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1547: ,p_pm_task_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1548: ,p_percent_complete IN PA_NUM_1000_NUM

Line 1545: ,p_task_name IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1541: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1542: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
1543: ,p_as_of_date IN DATE
1544: ,p_task_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1545: ,p_task_name IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1546: ,p_task_number IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1547: ,p_pm_task_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1548: ,p_percent_complete IN PA_NUM_1000_NUM
1549: ,p_description IN PA_VC_1000_2000 := PA_VC_1000_2000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 1546: ,p_task_number IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1542: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
1543: ,p_as_of_date IN DATE
1544: ,p_task_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1545: ,p_task_name IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1546: ,p_task_number IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1547: ,p_pm_task_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1548: ,p_percent_complete IN PA_NUM_1000_NUM
1549: ,p_description IN PA_VC_1000_2000 := PA_VC_1000_2000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1550: ,p_object_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 1547: ,p_pm_task_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1543: ,p_as_of_date IN DATE
1544: ,p_task_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1545: ,p_task_name IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1546: ,p_task_number IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1547: ,p_pm_task_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1548: ,p_percent_complete IN PA_NUM_1000_NUM
1549: ,p_description IN PA_VC_1000_2000 := PA_VC_1000_2000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1550: ,p_object_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1551: ,p_object_version_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 1549: ,p_description IN PA_VC_1000_2000 := PA_VC_1000_2000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1545: ,p_task_name IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1546: ,p_task_number IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1547: ,p_pm_task_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1548: ,p_percent_complete IN PA_NUM_1000_NUM
1549: ,p_description IN PA_VC_1000_2000 := PA_VC_1000_2000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1550: ,p_object_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1551: ,p_object_version_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1552: ,p_object_type IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1553: ,p_progress_status_code IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 1550: ,p_object_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

1546: ,p_task_number IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1547: ,p_pm_task_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1548: ,p_percent_complete IN PA_NUM_1000_NUM
1549: ,p_description IN PA_VC_1000_2000 := PA_VC_1000_2000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1550: ,p_object_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1551: ,p_object_version_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1552: ,p_object_type IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1553: ,p_progress_status_code IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1554: ,p_progress_comment IN PA_VC_1000_4000 := PA_VC_1000_4000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 1551: ,p_object_version_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

1547: ,p_pm_task_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1548: ,p_percent_complete IN PA_NUM_1000_NUM
1549: ,p_description IN PA_VC_1000_2000 := PA_VC_1000_2000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1550: ,p_object_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1551: ,p_object_version_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1552: ,p_object_type IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1553: ,p_progress_status_code IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1554: ,p_progress_comment IN PA_VC_1000_4000 := PA_VC_1000_4000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1555: ,p_actual_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

Line 1552: ,p_object_type IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1548: ,p_percent_complete IN PA_NUM_1000_NUM
1549: ,p_description IN PA_VC_1000_2000 := PA_VC_1000_2000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1550: ,p_object_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1551: ,p_object_version_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1552: ,p_object_type IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1553: ,p_progress_status_code IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1554: ,p_progress_comment IN PA_VC_1000_4000 := PA_VC_1000_4000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1555: ,p_actual_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1556: ,p_actual_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

Line 1553: ,p_progress_status_code IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1549: ,p_description IN PA_VC_1000_2000 := PA_VC_1000_2000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1550: ,p_object_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1551: ,p_object_version_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1552: ,p_object_type IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1553: ,p_progress_status_code IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1554: ,p_progress_comment IN PA_VC_1000_4000 := PA_VC_1000_4000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1555: ,p_actual_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1556: ,p_actual_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1557: ,p_estimated_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

Line 1554: ,p_progress_comment IN PA_VC_1000_4000 := PA_VC_1000_4000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1550: ,p_object_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1551: ,p_object_version_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1552: ,p_object_type IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1553: ,p_progress_status_code IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1554: ,p_progress_comment IN PA_VC_1000_4000 := PA_VC_1000_4000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1555: ,p_actual_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1556: ,p_actual_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1557: ,p_estimated_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1558: ,p_estimated_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

Line 1555: ,p_actual_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1551: ,p_object_version_id IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1552: ,p_object_type IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1553: ,p_progress_status_code IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1554: ,p_progress_comment IN PA_VC_1000_4000 := PA_VC_1000_4000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1555: ,p_actual_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1556: ,p_actual_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1557: ,p_estimated_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1558: ,p_estimated_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1559: ,p_scheduled_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

Line 1556: ,p_actual_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1552: ,p_object_type IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1553: ,p_progress_status_code IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1554: ,p_progress_comment IN PA_VC_1000_4000 := PA_VC_1000_4000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1555: ,p_actual_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1556: ,p_actual_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1557: ,p_estimated_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1558: ,p_estimated_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1559: ,p_scheduled_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1560: ,p_scheduled_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

Line 1557: ,p_estimated_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1553: ,p_progress_status_code IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1554: ,p_progress_comment IN PA_VC_1000_4000 := PA_VC_1000_4000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1555: ,p_actual_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1556: ,p_actual_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1557: ,p_estimated_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1558: ,p_estimated_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1559: ,p_scheduled_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1560: ,p_scheduled_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1561: ,p_task_status IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 1558: ,p_estimated_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1554: ,p_progress_comment IN PA_VC_1000_4000 := PA_VC_1000_4000(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1555: ,p_actual_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1556: ,p_actual_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1557: ,p_estimated_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1558: ,p_estimated_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1559: ,p_scheduled_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1560: ,p_scheduled_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1561: ,p_task_status IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1562: ,p_est_remaining_effort IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 1559: ,p_scheduled_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1555: ,p_actual_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1556: ,p_actual_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1557: ,p_estimated_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1558: ,p_estimated_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1559: ,p_scheduled_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1560: ,p_scheduled_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1561: ,p_task_status IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1562: ,p_est_remaining_effort IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1563: ,p_actual_work_quantity IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 1560: ,p_scheduled_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)

1556: ,p_actual_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1557: ,p_estimated_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1558: ,p_estimated_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1559: ,p_scheduled_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1560: ,p_scheduled_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1561: ,p_task_status IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1562: ,p_est_remaining_effort IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1563: ,p_actual_work_quantity IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1564: ,p_etc_cost IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) /* FP M Task Progress 3420093*/

Line 1561: ,p_task_status IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

1557: ,p_estimated_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1558: ,p_estimated_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1559: ,p_scheduled_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1560: ,p_scheduled_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1561: ,p_task_status IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1562: ,p_est_remaining_effort IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1563: ,p_actual_work_quantity IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1564: ,p_etc_cost IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) /* FP M Task Progress 3420093*/
1565: ,p_pm_deliverable_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627

Line 1562: ,p_est_remaining_effort IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

1558: ,p_estimated_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1559: ,p_scheduled_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1560: ,p_scheduled_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1561: ,p_task_status IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1562: ,p_est_remaining_effort IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1563: ,p_actual_work_quantity IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1564: ,p_etc_cost IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) /* FP M Task Progress 3420093*/
1565: ,p_pm_deliverable_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627
1566: ,p_pm_task_assgn_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627

Line 1563: ,p_actual_work_quantity IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

1559: ,p_scheduled_start_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1560: ,p_scheduled_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1561: ,p_task_status IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1562: ,p_est_remaining_effort IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1563: ,p_actual_work_quantity IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1564: ,p_etc_cost IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) /* FP M Task Progress 3420093*/
1565: ,p_pm_deliverable_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627
1566: ,p_pm_task_assgn_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627
1567: ,p_actual_cost_to_date IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) -- Bug 3606627

Line 1564: ,p_etc_cost IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) /* FP M Task Progress 3420093*/

1560: ,p_scheduled_finish_date IN PA_DATE_1000_DATE := PA_DATE_1000_DATE(PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1561: ,p_task_status IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1562: ,p_est_remaining_effort IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1563: ,p_actual_work_quantity IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1564: ,p_etc_cost IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) /* FP M Task Progress 3420093*/
1565: ,p_pm_deliverable_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627
1566: ,p_pm_task_assgn_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627
1567: ,p_actual_cost_to_date IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) -- Bug 3606627
1568: ,p_actual_effort_to_date IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) -- Bug 3606627

Line 1565: ,p_pm_deliverable_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627

1561: ,p_task_status IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1562: ,p_est_remaining_effort IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1563: ,p_actual_work_quantity IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1564: ,p_etc_cost IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) /* FP M Task Progress 3420093*/
1565: ,p_pm_deliverable_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627
1566: ,p_pm_task_assgn_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627
1567: ,p_actual_cost_to_date IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) -- Bug 3606627
1568: ,p_actual_effort_to_date IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) -- Bug 3606627
1569: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1566: ,p_pm_task_assgn_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627

1562: ,p_est_remaining_effort IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1563: ,p_actual_work_quantity IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1564: ,p_etc_cost IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) /* FP M Task Progress 3420093*/
1565: ,p_pm_deliverable_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627
1566: ,p_pm_task_assgn_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627
1567: ,p_actual_cost_to_date IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) -- Bug 3606627
1568: ,p_actual_effort_to_date IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) -- Bug 3606627
1569: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1570: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1567: ,p_actual_cost_to_date IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) -- Bug 3606627

1563: ,p_actual_work_quantity IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1564: ,p_etc_cost IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) /* FP M Task Progress 3420093*/
1565: ,p_pm_deliverable_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627
1566: ,p_pm_task_assgn_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627
1567: ,p_actual_cost_to_date IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) -- Bug 3606627
1568: ,p_actual_effort_to_date IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) -- Bug 3606627
1569: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1570: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1571: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1568: ,p_actual_effort_to_date IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) -- Bug 3606627

1564: ,p_etc_cost IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) /* FP M Task Progress 3420093*/
1565: ,p_pm_deliverable_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627
1566: ,p_pm_task_assgn_reference IN PA_VC_1000_150 := PA_VC_1000_150(PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) -- Bug 3606627
1567: ,p_actual_cost_to_date IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) -- Bug 3606627
1568: ,p_actual_effort_to_date IN PA_NUM_1000_NUM := PA_NUM_1000_NUM(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) -- Bug 3606627
1569: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1570: ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1571: ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1572: )

Line 1636: -- if (((P_TASK_ID(i) is null) or (P_TASK_ID(i) =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)) and ((P_PM_TASK_REFERENCE(i) is null) or (P_PM_TASK_REFERENCE(i) =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))) then

1632: END IF;
1633:
1634: FOR i in 1..1000 LOOP
1635: -- Bug 3606627 : Commented the code which return if task_id is null. Now task_id can be null for Deleiverable.
1636: -- if (((P_TASK_ID(i) is null) or (P_TASK_ID(i) =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)) and ((P_PM_TASK_REFERENCE(i) is null) or (P_PM_TASK_REFERENCE(i) =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))) then
1637: -- return;
1638: --else
1639:
1640: -- Bug 3673618 : Introduced local variables to store the value first.

Line 1643: IF P_TASK_ID.count = 1 AND P_TASK_ID(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

1639:
1640: -- Bug 3673618 : Introduced local variables to store the value first.
1641: -- This is done to ensure that if any parameter is not passed it does not give error subscript out of bound
1642:
1643: IF P_TASK_ID.count = 1 AND P_TASK_ID(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1644: l_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1645: ELSE
1646: l_TASK_ID := P_TASK_ID(i);
1647: END IF;

Line 1644: l_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

1640: -- Bug 3673618 : Introduced local variables to store the value first.
1641: -- This is done to ensure that if any parameter is not passed it does not give error subscript out of bound
1642:
1643: IF P_TASK_ID.count = 1 AND P_TASK_ID(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1644: l_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1645: ELSE
1646: l_TASK_ID := P_TASK_ID(i);
1647: END IF;
1648:

Line 1651: IF P_TASK_NAME.count = 1 AND P_TASK_NAME(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

1647: END IF;
1648:
1649:
1650:
1651: IF P_TASK_NAME.count = 1 AND P_TASK_NAME(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1652: l_TASK_NAME := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1653: ELSE
1654: l_TASK_NAME := P_TASK_NAME(i);
1655: END IF;

Line 1652: l_TASK_NAME := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

1648:
1649:
1650:
1651: IF P_TASK_NAME.count = 1 AND P_TASK_NAME(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1652: l_TASK_NAME := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1653: ELSE
1654: l_TASK_NAME := P_TASK_NAME(i);
1655: END IF;
1656:

Line 1658: IF P_TASK_NUMBER.count = 1 AND P_TASK_NUMBER(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

1654: l_TASK_NAME := P_TASK_NAME(i);
1655: END IF;
1656:
1657:
1658: IF P_TASK_NUMBER.count = 1 AND P_TASK_NUMBER(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1659: l_TASK_NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1660: ELSE
1661: l_TASK_NUMBER := P_TASK_NUMBER(i);
1662: END IF;

Line 1659: l_TASK_NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

1655: END IF;
1656:
1657:
1658: IF P_TASK_NUMBER.count = 1 AND P_TASK_NUMBER(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1659: l_TASK_NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1660: ELSE
1661: l_TASK_NUMBER := P_TASK_NUMBER(i);
1662: END IF;
1663:

Line 1666: IF p_PM_TASK_REFERENCE.count = 1 AND p_PM_TASK_REFERENCE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

1662: END IF;
1663:
1664: --end if;
1665:
1666: IF p_PM_TASK_REFERENCE.count = 1 AND p_PM_TASK_REFERENCE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1667: l_PM_TASK_REFERENCE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1668: ELSE
1669: l_PM_TASK_REFERENCE := p_PM_TASK_REFERENCE(i);
1670: END IF;

Line 1667: l_PM_TASK_REFERENCE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

1663:
1664: --end if;
1665:
1666: IF p_PM_TASK_REFERENCE.count = 1 AND p_PM_TASK_REFERENCE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1667: l_PM_TASK_REFERENCE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1668: ELSE
1669: l_PM_TASK_REFERENCE := p_PM_TASK_REFERENCE(i);
1670: END IF;
1671:

Line 1673: IF p_PERCENT_COMPLETE.count = 1 AND p_PERCENT_COMPLETE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

1669: l_PM_TASK_REFERENCE := p_PM_TASK_REFERENCE(i);
1670: END IF;
1671:
1672:
1673: IF p_PERCENT_COMPLETE.count = 1 AND p_PERCENT_COMPLETE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1674: l_PERCENT_COMPLETE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1675: ELSE
1676: l_PERCENT_COMPLETE := p_PERCENT_COMPLETE(i);
1677: END IF;

Line 1674: l_PERCENT_COMPLETE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

1670: END IF;
1671:
1672:
1673: IF p_PERCENT_COMPLETE.count = 1 AND p_PERCENT_COMPLETE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1674: l_PERCENT_COMPLETE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1675: ELSE
1676: l_PERCENT_COMPLETE := p_PERCENT_COMPLETE(i);
1677: END IF;
1678:

Line 1679: IF p_DESCRIPTION.count = 1 AND p_DESCRIPTION(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

1675: ELSE
1676: l_PERCENT_COMPLETE := p_PERCENT_COMPLETE(i);
1677: END IF;
1678:
1679: IF p_DESCRIPTION.count = 1 AND p_DESCRIPTION(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1680: l_DESCRIPTION := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1681: ELSE
1682: l_DESCRIPTION := p_DESCRIPTION(i);
1683: END IF;

Line 1680: l_DESCRIPTION := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

1676: l_PERCENT_COMPLETE := p_PERCENT_COMPLETE(i);
1677: END IF;
1678:
1679: IF p_DESCRIPTION.count = 1 AND p_DESCRIPTION(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1680: l_DESCRIPTION := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1681: ELSE
1682: l_DESCRIPTION := p_DESCRIPTION(i);
1683: END IF;
1684:

Line 1685: IF p_OBJECT_ID.count = 1 AND p_OBJECT_ID(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

1681: ELSE
1682: l_DESCRIPTION := p_DESCRIPTION(i);
1683: END IF;
1684:
1685: IF p_OBJECT_ID.count = 1 AND p_OBJECT_ID(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1686: l_OBJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1687: ELSE
1688: l_OBJECT_ID := p_OBJECT_ID(i);
1689: END IF;

Line 1686: l_OBJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

1682: l_DESCRIPTION := p_DESCRIPTION(i);
1683: END IF;
1684:
1685: IF p_OBJECT_ID.count = 1 AND p_OBJECT_ID(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1686: l_OBJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1687: ELSE
1688: l_OBJECT_ID := p_OBJECT_ID(i);
1689: END IF;
1690:

Line 1691: IF p_OBJECT_VERSION_ID.count = 1 AND p_OBJECT_VERSION_ID(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

1687: ELSE
1688: l_OBJECT_ID := p_OBJECT_ID(i);
1689: END IF;
1690:
1691: IF p_OBJECT_VERSION_ID.count = 1 AND p_OBJECT_VERSION_ID(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1692: l_OBJECT_VERSION_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1693: ELSE
1694: l_OBJECT_VERSION_ID := p_OBJECT_VERSION_ID(i);
1695: END IF;

Line 1692: l_OBJECT_VERSION_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

1688: l_OBJECT_ID := p_OBJECT_ID(i);
1689: END IF;
1690:
1691: IF p_OBJECT_VERSION_ID.count = 1 AND p_OBJECT_VERSION_ID(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1692: l_OBJECT_VERSION_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1693: ELSE
1694: l_OBJECT_VERSION_ID := p_OBJECT_VERSION_ID(i);
1695: END IF;
1696:

Line 1697: IF p_OBJECT_TYPE.count = 1 AND p_OBJECT_TYPE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

1693: ELSE
1694: l_OBJECT_VERSION_ID := p_OBJECT_VERSION_ID(i);
1695: END IF;
1696:
1697: IF p_OBJECT_TYPE.count = 1 AND p_OBJECT_TYPE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1698: l_OBJECT_TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1699: ELSE
1700: l_OBJECT_TYPE := p_OBJECT_TYPE(i);
1701: END IF;

Line 1698: l_OBJECT_TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

1694: l_OBJECT_VERSION_ID := p_OBJECT_VERSION_ID(i);
1695: END IF;
1696:
1697: IF p_OBJECT_TYPE.count = 1 AND p_OBJECT_TYPE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1698: l_OBJECT_TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1699: ELSE
1700: l_OBJECT_TYPE := p_OBJECT_TYPE(i);
1701: END IF;
1702:

Line 1703: IF p_PROGRESS_STATUS_CODE.count = 1 AND p_PROGRESS_STATUS_CODE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

1699: ELSE
1700: l_OBJECT_TYPE := p_OBJECT_TYPE(i);
1701: END IF;
1702:
1703: IF p_PROGRESS_STATUS_CODE.count = 1 AND p_PROGRESS_STATUS_CODE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1704: l_PROGRESS_STATUS_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1705: ELSE
1706: l_PROGRESS_STATUS_CODE := p_PROGRESS_STATUS_CODE(i);
1707: END IF;

Line 1704: l_PROGRESS_STATUS_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

1700: l_OBJECT_TYPE := p_OBJECT_TYPE(i);
1701: END IF;
1702:
1703: IF p_PROGRESS_STATUS_CODE.count = 1 AND p_PROGRESS_STATUS_CODE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1704: l_PROGRESS_STATUS_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1705: ELSE
1706: l_PROGRESS_STATUS_CODE := p_PROGRESS_STATUS_CODE(i);
1707: END IF;
1708:

Line 1709: IF p_PROGRESS_COMMENT.count = 1 AND p_PROGRESS_COMMENT(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

1705: ELSE
1706: l_PROGRESS_STATUS_CODE := p_PROGRESS_STATUS_CODE(i);
1707: END IF;
1708:
1709: IF p_PROGRESS_COMMENT.count = 1 AND p_PROGRESS_COMMENT(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1710: l_PROGRESS_COMMENT := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1711: ELSE
1712: l_PROGRESS_COMMENT := p_PROGRESS_COMMENT(i);
1713: END IF;

Line 1710: l_PROGRESS_COMMENT := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

1706: l_PROGRESS_STATUS_CODE := p_PROGRESS_STATUS_CODE(i);
1707: END IF;
1708:
1709: IF p_PROGRESS_COMMENT.count = 1 AND p_PROGRESS_COMMENT(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1710: l_PROGRESS_COMMENT := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1711: ELSE
1712: l_PROGRESS_COMMENT := p_PROGRESS_COMMENT(i);
1713: END IF;
1714:

Line 1715: IF p_ACTUAL_START_DATE.count = 1 AND p_ACTUAL_START_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

1711: ELSE
1712: l_PROGRESS_COMMENT := p_PROGRESS_COMMENT(i);
1713: END IF;
1714:
1715: IF p_ACTUAL_START_DATE.count = 1 AND p_ACTUAL_START_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
1716: l_ACTUAL_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
1717: ELSE
1718: l_ACTUAL_START_DATE := p_ACTUAL_START_DATE(i);
1719: END IF;

Line 1716: l_ACTUAL_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;

1712: l_PROGRESS_COMMENT := p_PROGRESS_COMMENT(i);
1713: END IF;
1714:
1715: IF p_ACTUAL_START_DATE.count = 1 AND p_ACTUAL_START_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
1716: l_ACTUAL_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
1717: ELSE
1718: l_ACTUAL_START_DATE := p_ACTUAL_START_DATE(i);
1719: END IF;
1720:

Line 1721: IF p_ACTUAL_FINISH_DATE.count = 1 AND p_ACTUAL_FINISH_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

1717: ELSE
1718: l_ACTUAL_START_DATE := p_ACTUAL_START_DATE(i);
1719: END IF;
1720:
1721: IF p_ACTUAL_FINISH_DATE.count = 1 AND p_ACTUAL_FINISH_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
1722: l_ACTUAL_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
1723: ELSE
1724: l_ACTUAL_FINISH_DATE := p_ACTUAL_FINISH_DATE(i);
1725: END IF;

Line 1722: l_ACTUAL_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;

1718: l_ACTUAL_START_DATE := p_ACTUAL_START_DATE(i);
1719: END IF;
1720:
1721: IF p_ACTUAL_FINISH_DATE.count = 1 AND p_ACTUAL_FINISH_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
1722: l_ACTUAL_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
1723: ELSE
1724: l_ACTUAL_FINISH_DATE := p_ACTUAL_FINISH_DATE(i);
1725: END IF;
1726:

Line 1727: IF p_ESTIMATED_START_DATE.count = 1 AND p_ESTIMATED_START_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

1723: ELSE
1724: l_ACTUAL_FINISH_DATE := p_ACTUAL_FINISH_DATE(i);
1725: END IF;
1726:
1727: IF p_ESTIMATED_START_DATE.count = 1 AND p_ESTIMATED_START_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
1728: l_ESTIMATED_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
1729: ELSE
1730: l_ESTIMATED_START_DATE := p_ESTIMATED_START_DATE(i);
1731: END IF;

Line 1728: l_ESTIMATED_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;

1724: l_ACTUAL_FINISH_DATE := p_ACTUAL_FINISH_DATE(i);
1725: END IF;
1726:
1727: IF p_ESTIMATED_START_DATE.count = 1 AND p_ESTIMATED_START_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
1728: l_ESTIMATED_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
1729: ELSE
1730: l_ESTIMATED_START_DATE := p_ESTIMATED_START_DATE(i);
1731: END IF;
1732:

Line 1733: IF p_ESTIMATED_FINISH_DATE.count = 1 AND p_ESTIMATED_FINISH_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

1729: ELSE
1730: l_ESTIMATED_START_DATE := p_ESTIMATED_START_DATE(i);
1731: END IF;
1732:
1733: IF p_ESTIMATED_FINISH_DATE.count = 1 AND p_ESTIMATED_FINISH_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
1734: l_ESTIMATED_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
1735: ELSE
1736: l_ESTIMATED_FINISH_DATE := p_ESTIMATED_FINISH_DATE(i);
1737: END IF;

Line 1734: l_ESTIMATED_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;

1730: l_ESTIMATED_START_DATE := p_ESTIMATED_START_DATE(i);
1731: END IF;
1732:
1733: IF p_ESTIMATED_FINISH_DATE.count = 1 AND p_ESTIMATED_FINISH_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
1734: l_ESTIMATED_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
1735: ELSE
1736: l_ESTIMATED_FINISH_DATE := p_ESTIMATED_FINISH_DATE(i);
1737: END IF;
1738:

Line 1739: IF p_SCHEDULED_START_DATE.count = 1 AND p_SCHEDULED_START_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

1735: ELSE
1736: l_ESTIMATED_FINISH_DATE := p_ESTIMATED_FINISH_DATE(i);
1737: END IF;
1738:
1739: IF p_SCHEDULED_START_DATE.count = 1 AND p_SCHEDULED_START_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
1740: l_SCHEDULED_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
1741: ELSE
1742: l_SCHEDULED_START_DATE := p_SCHEDULED_START_DATE(i);
1743: END IF;

Line 1740: l_SCHEDULED_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;

1736: l_ESTIMATED_FINISH_DATE := p_ESTIMATED_FINISH_DATE(i);
1737: END IF;
1738:
1739: IF p_SCHEDULED_START_DATE.count = 1 AND p_SCHEDULED_START_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
1740: l_SCHEDULED_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
1741: ELSE
1742: l_SCHEDULED_START_DATE := p_SCHEDULED_START_DATE(i);
1743: END IF;
1744:

Line 1745: IF p_SCHEDULED_FINISH_DATE.count = 1 AND p_SCHEDULED_FINISH_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN

1741: ELSE
1742: l_SCHEDULED_START_DATE := p_SCHEDULED_START_DATE(i);
1743: END IF;
1744:
1745: IF p_SCHEDULED_FINISH_DATE.count = 1 AND p_SCHEDULED_FINISH_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
1746: l_SCHEDULED_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
1747: ELSE
1748: l_SCHEDULED_FINISH_DATE := p_SCHEDULED_FINISH_DATE(i);
1749: END IF;

Line 1746: l_SCHEDULED_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;

1742: l_SCHEDULED_START_DATE := p_SCHEDULED_START_DATE(i);
1743: END IF;
1744:
1745: IF p_SCHEDULED_FINISH_DATE.count = 1 AND p_SCHEDULED_FINISH_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
1746: l_SCHEDULED_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
1747: ELSE
1748: l_SCHEDULED_FINISH_DATE := p_SCHEDULED_FINISH_DATE(i);
1749: END IF;
1750:

Line 1751: IF p_TASK_STATUS.count = 1 AND p_TASK_STATUS(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

1747: ELSE
1748: l_SCHEDULED_FINISH_DATE := p_SCHEDULED_FINISH_DATE(i);
1749: END IF;
1750:
1751: IF p_TASK_STATUS.count = 1 AND p_TASK_STATUS(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1752: l_TASK_STATUS := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1753: ELSE
1754: l_TASK_STATUS := p_TASK_STATUS(i);
1755: END IF;

Line 1752: l_TASK_STATUS := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

1748: l_SCHEDULED_FINISH_DATE := p_SCHEDULED_FINISH_DATE(i);
1749: END IF;
1750:
1751: IF p_TASK_STATUS.count = 1 AND p_TASK_STATUS(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1752: l_TASK_STATUS := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1753: ELSE
1754: l_TASK_STATUS := p_TASK_STATUS(i);
1755: END IF;
1756:

Line 1757: IF p_EST_REMAINING_EFFORT.count = 1 AND p_EST_REMAINING_EFFORT(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

1753: ELSE
1754: l_TASK_STATUS := p_TASK_STATUS(i);
1755: END IF;
1756:
1757: IF p_EST_REMAINING_EFFORT.count = 1 AND p_EST_REMAINING_EFFORT(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1758: l_EST_REMAINING_EFFORT := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1759: ELSE
1760: l_EST_REMAINING_EFFORT := p_EST_REMAINING_EFFORT(i);
1761: END IF;

Line 1758: l_EST_REMAINING_EFFORT := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

1754: l_TASK_STATUS := p_TASK_STATUS(i);
1755: END IF;
1756:
1757: IF p_EST_REMAINING_EFFORT.count = 1 AND p_EST_REMAINING_EFFORT(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1758: l_EST_REMAINING_EFFORT := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1759: ELSE
1760: l_EST_REMAINING_EFFORT := p_EST_REMAINING_EFFORT(i);
1761: END IF;
1762:

Line 1763: IF p_ACTUAL_WORK_QUANTITY.count = 1 AND p_ACTUAL_WORK_QUANTITY(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

1759: ELSE
1760: l_EST_REMAINING_EFFORT := p_EST_REMAINING_EFFORT(i);
1761: END IF;
1762:
1763: IF p_ACTUAL_WORK_QUANTITY.count = 1 AND p_ACTUAL_WORK_QUANTITY(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1764: l_ACTUAL_WORK_QUANTITY := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1765: ELSE
1766: l_ACTUAL_WORK_QUANTITY := p_ACTUAL_WORK_QUANTITY(i);
1767: END IF;

Line 1764: l_ACTUAL_WORK_QUANTITY := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

1760: l_EST_REMAINING_EFFORT := p_EST_REMAINING_EFFORT(i);
1761: END IF;
1762:
1763: IF p_ACTUAL_WORK_QUANTITY.count = 1 AND p_ACTUAL_WORK_QUANTITY(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1764: l_ACTUAL_WORK_QUANTITY := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1765: ELSE
1766: l_ACTUAL_WORK_QUANTITY := p_ACTUAL_WORK_QUANTITY(i);
1767: END IF;
1768:

Line 1769: IF p_ETC_COST.count = 1 AND p_ETC_COST(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

1765: ELSE
1766: l_ACTUAL_WORK_QUANTITY := p_ACTUAL_WORK_QUANTITY(i);
1767: END IF;
1768:
1769: IF p_ETC_COST.count = 1 AND p_ETC_COST(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1770: l_ETC_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1771: ELSE
1772: l_ETC_COST := p_ETC_COST(i);
1773: END IF;

Line 1770: l_ETC_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

1766: l_ACTUAL_WORK_QUANTITY := p_ACTUAL_WORK_QUANTITY(i);
1767: END IF;
1768:
1769: IF p_ETC_COST.count = 1 AND p_ETC_COST(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1770: l_ETC_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1771: ELSE
1772: l_ETC_COST := p_ETC_COST(i);
1773: END IF;
1774:

Line 1776: IF p_PM_DELIVERABLE_REFERENCE.count = 1 AND p_PM_DELIVERABLE_REFERENCE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

1772: l_ETC_COST := p_ETC_COST(i);
1773: END IF;
1774:
1775: --Bug 3606627 : Assign new variables Start
1776: IF p_PM_DELIVERABLE_REFERENCE.count = 1 AND p_PM_DELIVERABLE_REFERENCE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1777: l_PM_DELIVERABLE_REFERENCE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1778: ELSE
1779: l_PM_DELIVERABLE_REFERENCE := p_PM_DELIVERABLE_REFERENCE(i);
1780: END IF;

Line 1777: l_PM_DELIVERABLE_REFERENCE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

1773: END IF;
1774:
1775: --Bug 3606627 : Assign new variables Start
1776: IF p_PM_DELIVERABLE_REFERENCE.count = 1 AND p_PM_DELIVERABLE_REFERENCE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1777: l_PM_DELIVERABLE_REFERENCE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1778: ELSE
1779: l_PM_DELIVERABLE_REFERENCE := p_PM_DELIVERABLE_REFERENCE(i);
1780: END IF;
1781:

Line 1782: IF p_PM_TASK_ASSGN_REFERENCE.count = 1 AND p_PM_TASK_ASSGN_REFERENCE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

1778: ELSE
1779: l_PM_DELIVERABLE_REFERENCE := p_PM_DELIVERABLE_REFERENCE(i);
1780: END IF;
1781:
1782: IF p_PM_TASK_ASSGN_REFERENCE.count = 1 AND p_PM_TASK_ASSGN_REFERENCE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1783: l_PM_TASK_ASSGN_REFERENCE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1784: ELSE
1785: l_PM_TASK_ASSGN_REFERENCE := p_PM_TASK_ASSGN_REFERENCE(i);
1786: END IF;

Line 1783: l_PM_TASK_ASSGN_REFERENCE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

1779: l_PM_DELIVERABLE_REFERENCE := p_PM_DELIVERABLE_REFERENCE(i);
1780: END IF;
1781:
1782: IF p_PM_TASK_ASSGN_REFERENCE.count = 1 AND p_PM_TASK_ASSGN_REFERENCE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1783: l_PM_TASK_ASSGN_REFERENCE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1784: ELSE
1785: l_PM_TASK_ASSGN_REFERENCE := p_PM_TASK_ASSGN_REFERENCE(i);
1786: END IF;
1787:

Line 1788: IF p_ACTUAL_COST_TO_DATE.count = 1 AND p_ACTUAL_COST_TO_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

1784: ELSE
1785: l_PM_TASK_ASSGN_REFERENCE := p_PM_TASK_ASSGN_REFERENCE(i);
1786: END IF;
1787:
1788: IF p_ACTUAL_COST_TO_DATE.count = 1 AND p_ACTUAL_COST_TO_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1789: l_ACTUAL_COST_TO_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1790: ELSE
1791: l_ACTUAL_COST_TO_DATE := p_ACTUAL_COST_TO_DATE(i);
1792: END IF;

Line 1789: l_ACTUAL_COST_TO_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

1785: l_PM_TASK_ASSGN_REFERENCE := p_PM_TASK_ASSGN_REFERENCE(i);
1786: END IF;
1787:
1788: IF p_ACTUAL_COST_TO_DATE.count = 1 AND p_ACTUAL_COST_TO_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1789: l_ACTUAL_COST_TO_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1790: ELSE
1791: l_ACTUAL_COST_TO_DATE := p_ACTUAL_COST_TO_DATE(i);
1792: END IF;
1793:

Line 1794: IF p_ACTUAL_EFFORT_TO_DATE.count = 1 AND p_ACTUAL_EFFORT_TO_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

1790: ELSE
1791: l_ACTUAL_COST_TO_DATE := p_ACTUAL_COST_TO_DATE(i);
1792: END IF;
1793:
1794: IF p_ACTUAL_EFFORT_TO_DATE.count = 1 AND p_ACTUAL_EFFORT_TO_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1795: l_ACTUAL_EFFORT_TO_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1796: ELSE
1797: l_ACTUAL_EFFORT_TO_DATE := p_ACTUAL_EFFORT_TO_DATE(i);
1798: END IF;

Line 1795: l_ACTUAL_EFFORT_TO_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

1791: l_ACTUAL_COST_TO_DATE := p_ACTUAL_COST_TO_DATE(i);
1792: END IF;
1793:
1794: IF p_ACTUAL_EFFORT_TO_DATE.count = 1 AND p_ACTUAL_EFFORT_TO_DATE(1) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
1795: l_ACTUAL_EFFORT_TO_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1796: ELSE
1797: l_ACTUAL_EFFORT_TO_DATE := p_ACTUAL_EFFORT_TO_DATE(i);
1798: END IF;
1799:

Line 1829: IF(((l_TASK_ID is null) or (l_TASK_ID =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))

1825: pa_debug.write(x_Module=>'PA_STATUS_PUB.LOAD_TASK_PROGRESS', x_Msg => 'l_ACTUAL_EFFORT_TO_DATE :'||l_ACTUAL_EFFORT_TO_DATE, x_Log_Level=> 3);
1826: END IF;
1827:
1828: -- Bug 3673618 : Added this condition to do not process blank records.
1829: IF(((l_TASK_ID is null) or (l_TASK_ID =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1830: and ((l_PM_TASK_REFERENCE is null) or (l_PM_TASK_REFERENCE =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1831: and ((l_OBJECT_ID is null) or (l_OBJECT_ID =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1832: and ((l_PM_DELIVERABLE_REFERENCE is null) or (l_PM_DELIVERABLE_REFERENCE =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1833: and ((l_PM_TASK_ASSGN_REFERENCE is null) or (l_PM_TASK_ASSGN_REFERENCE =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))

Line 1830: and ((l_PM_TASK_REFERENCE is null) or (l_PM_TASK_REFERENCE =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))

1826: END IF;
1827:
1828: -- Bug 3673618 : Added this condition to do not process blank records.
1829: IF(((l_TASK_ID is null) or (l_TASK_ID =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1830: and ((l_PM_TASK_REFERENCE is null) or (l_PM_TASK_REFERENCE =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1831: and ((l_OBJECT_ID is null) or (l_OBJECT_ID =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1832: and ((l_PM_DELIVERABLE_REFERENCE is null) or (l_PM_DELIVERABLE_REFERENCE =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1833: and ((l_PM_TASK_ASSGN_REFERENCE is null) or (l_PM_TASK_ASSGN_REFERENCE =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1834: )

Line 1831: and ((l_OBJECT_ID is null) or (l_OBJECT_ID =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))

1827:
1828: -- Bug 3673618 : Added this condition to do not process blank records.
1829: IF(((l_TASK_ID is null) or (l_TASK_ID =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1830: and ((l_PM_TASK_REFERENCE is null) or (l_PM_TASK_REFERENCE =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1831: and ((l_OBJECT_ID is null) or (l_OBJECT_ID =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1832: and ((l_PM_DELIVERABLE_REFERENCE is null) or (l_PM_DELIVERABLE_REFERENCE =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1833: and ((l_PM_TASK_ASSGN_REFERENCE is null) or (l_PM_TASK_ASSGN_REFERENCE =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1834: )
1835: THEN

Line 1832: and ((l_PM_DELIVERABLE_REFERENCE is null) or (l_PM_DELIVERABLE_REFERENCE =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))

1828: -- Bug 3673618 : Added this condition to do not process blank records.
1829: IF(((l_TASK_ID is null) or (l_TASK_ID =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1830: and ((l_PM_TASK_REFERENCE is null) or (l_PM_TASK_REFERENCE =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1831: and ((l_OBJECT_ID is null) or (l_OBJECT_ID =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1832: and ((l_PM_DELIVERABLE_REFERENCE is null) or (l_PM_DELIVERABLE_REFERENCE =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1833: and ((l_PM_TASK_ASSGN_REFERENCE is null) or (l_PM_TASK_ASSGN_REFERENCE =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1834: )
1835: THEN
1836: return;

Line 1833: and ((l_PM_TASK_ASSGN_REFERENCE is null) or (l_PM_TASK_ASSGN_REFERENCE =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))

1829: IF(((l_TASK_ID is null) or (l_TASK_ID =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1830: and ((l_PM_TASK_REFERENCE is null) or (l_PM_TASK_REFERENCE =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1831: and ((l_OBJECT_ID is null) or (l_OBJECT_ID =PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1832: and ((l_PM_DELIVERABLE_REFERENCE is null) or (l_PM_DELIVERABLE_REFERENCE =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1833: and ((l_PM_TASK_ASSGN_REFERENCE is null) or (l_PM_TASK_ASSGN_REFERENCE =PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1834: )
1835: THEN
1836: return;
1837: END IF;

Line 1844: --IF(P_TASK_NAME(i) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1840: G_TASK_PROGRESS_tbl_count := G_TASK_PROGRESS_tbl_count + 1;
1841: G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).TASK_ID := l_TASK_ID;
1842: --G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).TASK_ID := P_TASK_ID(i);
1843:
1844: --IF(P_TASK_NAME(i) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1845: -- G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).TASK_NAME := substr(P_TASK_NAME(i), 1, 20);
1846: --ELSE
1847: -- G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).TASK_NAME := P_TASK_NAME(i);
1848: --END IF;

Line 1850: IF(l_TASK_NAME <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1846: --ELSE
1847: -- G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).TASK_NAME := P_TASK_NAME(i);
1848: --END IF;
1849:
1850: IF(l_TASK_NAME <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1851: G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).TASK_NAME := substrb(l_TASK_NAME, 1, 20); --5458363
1852: ELSE
1853: G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).TASK_NAME := l_TASK_NAME;
1854: END IF;

Line 1856: --IF(P_TASK_NUMBER(i) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1852: ELSE
1853: G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).TASK_NAME := l_TASK_NAME;
1854: END IF;
1855:
1856: --IF(P_TASK_NUMBER(i) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1857: -- G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).TASK_NUMBER := substr(P_TASK_NUMBER(i), 1, 25);
1858: --ELSE
1859: -- G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).TASK_NUMBER := P_TASK_NUMBER(i);
1860: --END IF;

Line 1862: IF(l_TASK_NUMBER <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1858: --ELSE
1859: -- G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).TASK_NUMBER := P_TASK_NUMBER(i);
1860: --END IF;
1861:
1862: IF(l_TASK_NUMBER <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1863: G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).TASK_NUMBER := substrb(l_TASK_NUMBER, 1, 25); --5458363
1864: ELSE
1865: G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).TASK_NUMBER := l_TASK_NUMBER;
1866: END IF;

Line 1874: --IF(p_DESCRIPTION(i) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1870:
1871: G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).PERCENT_COMPLETE := l_PERCENT_COMPLETE;
1872: --G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).PERCENT_COMPLETE := p_PERCENT_COMPLETE(i);
1873:
1874: --IF(p_DESCRIPTION(i) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1875: -- G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).DESCRIPTION := substr(p_DESCRIPTION(i), 1, 250);
1876: --ELSE
1877: -- G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).DESCRIPTION := p_DESCRIPTION(i);
1878: --END IF;

Line 1880: IF(l_DESCRIPTION <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1876: --ELSE
1877: -- G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).DESCRIPTION := p_DESCRIPTION(i);
1878: --END IF;
1879:
1880: IF(l_DESCRIPTION <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1881: G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).DESCRIPTION := substrb(l_DESCRIPTION, 1, 250); --5458363
1882: ELSE
1883: G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).DESCRIPTION := l_DESCRIPTION;
1884: END IF;

Line 1892: --IF(p_OBJECT_TYPE(i) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1888:
1889: --G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).OBJECT_VERSION_ID := p_OBJECT_VERSION_ID(i);
1890: G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).OBJECT_VERSION_ID := l_OBJECT_VERSION_ID;
1891:
1892: --IF(p_OBJECT_TYPE(i) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1893: -- G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).OBJECT_TYPE := substr(p_OBJECT_TYPE(i), 1, 30);
1894: --ELSE
1895: -- G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).OBJECT_TYPE := p_OBJECT_TYPE(i);
1896: --END IF;

Line 1898: IF(l_OBJECT_TYPE <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

1894: --ELSE
1895: -- G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).OBJECT_TYPE := p_OBJECT_TYPE(i);
1896: --END IF;
1897:
1898: IF(l_OBJECT_TYPE <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1899: G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).OBJECT_TYPE := substrb(l_OBJECT_TYPE, 1, 30); --5458363
1900: ELSE
1901: G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).OBJECT_TYPE := l_OBJECT_TYPE;
1902: END IF;

Line 2269: G_TASK_PROGRESS_in_tbl(i).PROGRESS_STATUS_CODE <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2265:
2266: --Commented by rtarway for BUG 3901982
2267: --maansari6/28 bug 3673618
2268: /*IF G_TASK_PROGRESS_in_tbl(i).PROGRESS_STATUS_CODE IS NOT NULL AND
2269: G_TASK_PROGRESS_in_tbl(i).PROGRESS_STATUS_CODE <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2270: THEN*/
2271: --Added by rtarway for BUG 3901982
2272: IF (
2273: ( G_TASK_PROGRESS_in_tbl(i).PROGRESS_STATUS_CODE IS NOT NULL AND

Line 2274: G_TASK_PROGRESS_in_tbl(i).PROGRESS_STATUS_CODE <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2270: THEN*/
2271: --Added by rtarway for BUG 3901982
2272: IF (
2273: ( G_TASK_PROGRESS_in_tbl(i).PROGRESS_STATUS_CODE IS NOT NULL AND
2274: G_TASK_PROGRESS_in_tbl(i).PROGRESS_STATUS_CODE <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2275: AND G_STRUCTURE_TYPE = 'WORKPLAN'
2276: ) OR
2277: ( l_PERCENT_COMPLETE IS NOT NULL AND
2278: l_PERCENT_COMPLETE <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND G_STRUCTURE_TYPE = 'FINANCIAL'

Line 2278: l_PERCENT_COMPLETE <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND G_STRUCTURE_TYPE = 'FINANCIAL'

2274: G_TASK_PROGRESS_in_tbl(i).PROGRESS_STATUS_CODE <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2275: AND G_STRUCTURE_TYPE = 'WORKPLAN'
2276: ) OR
2277: ( l_PERCENT_COMPLETE IS NOT NULL AND
2278: l_PERCENT_COMPLETE <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND G_STRUCTURE_TYPE = 'FINANCIAL'
2279: )
2280: )
2281: THEN
2282: --rtarway, 3964278

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

2877: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2878: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2879: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2880: , p_project_id IN NUMBER
2881: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2882: , p_project_id_out OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2883: )
2884: IS
2885: l_api_name CONSTANT VARCHAR2(30) := 'Project_Level_Validations';

Line 2953: PA_INTERFACE_UTILS_PUB.g_project_id := l_project_id_out;

2949: -- such functions to be executed, the API should not proceed further
2950: -- since the user does not have access to such functions
2951:
2952: --Bug 2471668
2953: PA_INTERFACE_UTILS_PUB.g_project_id := l_project_id_out;
2954:
2955: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
2956: (p_api_version_number => p_api_version_number,
2957: p_responsibility_id => l_resp_id,

Line 3055: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3051: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3052: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3053: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3054: ,p_debug_mode IN VARCHAR2 :='N'
3055: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3056: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
3057: ,p_project_id IN NUMBER
3058: ,p_structure_version_id IN NUMBER
3059: ,p_structure_type IN VARCHAR2