[Home] [Help]
14: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
15: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
16: p_calling_mode IN VARCHAR2 := null,-- bug 4287638
17: p_debug_mode IN VARCHAR2 :='N',
18: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
19: p_action IN VARCHAR2 default 'SAVE',
20: p_bulk_load_flag IN VARCHAR2 default 'N',
21: p_progress_mode IN VARCHAR2 default 'FUTURE',
22: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
18: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
19: p_action IN VARCHAR2 default 'SAVE',
20: p_bulk_load_flag IN VARCHAR2 default 'N',
21: p_progress_mode IN VARCHAR2 default 'FUTURE',
22: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
23: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
24: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
25: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
26: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
19: p_action IN VARCHAR2 default 'SAVE',
20: p_bulk_load_flag IN VARCHAR2 default 'N',
21: p_progress_mode IN VARCHAR2 default 'FUTURE',
22: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
23: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
24: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
25: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
26: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
27: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
20: p_bulk_load_flag IN VARCHAR2 default 'N',
21: p_progress_mode IN VARCHAR2 default 'FUTURE',
22: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
23: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
24: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
25: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
26: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
27: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
28: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
21: p_progress_mode IN VARCHAR2 default 'FUTURE',
22: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
23: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
24: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
25: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
26: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
27: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
28: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
29: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
22: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
23: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
24: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
25: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
26: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
27: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
28: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
29: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
30: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
23: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
24: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
25: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
26: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
27: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
28: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
29: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
30: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
31: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
24: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
25: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
26: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
27: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
28: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
29: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
30: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
31: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
32: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
25: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
26: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
27: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
28: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
29: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
30: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
31: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
32: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
33: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
26: p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
27: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
28: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
29: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
30: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
31: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
32: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
33: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
34: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
27: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
28: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
29: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
30: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
31: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
32: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
33: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
34: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
35: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
28: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
29: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
30: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
31: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
32: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
33: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
34: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
35: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
36: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
29: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
30: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
31: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
32: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
33: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
34: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
35: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
36: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
37: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
30: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
31: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
32: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
33: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
34: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
35: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
36: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
37: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
38: p_record_version_number IN NUMBER,
31: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
32: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
33: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
34: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
35: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
36: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
37: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
38: p_record_version_number IN NUMBER,
39: p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
32: p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
33: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
34: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
35: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
36: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
37: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
38: p_record_version_number IN NUMBER,
39: p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40: p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
33: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
34: p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
35: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
36: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
37: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
38: p_record_version_number IN NUMBER,
39: p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40: p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
41: p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
35: p_estimated_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
36: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
37: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
38: p_record_version_number IN NUMBER,
39: p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40: p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
41: p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
42: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
43: p_structure_type IN VARCHAR2 := 'WORKPLAN',
36: p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
37: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
38: p_record_version_number IN NUMBER,
39: p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40: p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
41: p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
42: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
43: p_structure_type IN VARCHAR2 := 'WORKPLAN',
44: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
37: p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
38: p_record_version_number IN NUMBER,
39: p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40: p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
41: p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
42: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
43: p_structure_type IN VARCHAR2 := 'WORKPLAN',
44: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
45: p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
38: p_record_version_number IN NUMBER,
39: p_task_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
40: p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
41: p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
42: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
43: p_structure_type IN VARCHAR2 := 'WORKPLAN',
44: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
45: p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
46: p_prog_fom_wp_flag IN VARCHAR2 := 'N',
40: p_est_remaining_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
41: p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
42: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
43: p_structure_type IN VARCHAR2 := 'WORKPLAN',
44: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
45: p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
46: p_prog_fom_wp_flag IN VARCHAR2 := 'N',
47: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
48: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
41: p_actual_work_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
42: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
43: p_structure_type IN VARCHAR2 := 'WORKPLAN',
44: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
45: p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
46: p_prog_fom_wp_flag IN VARCHAR2 := 'N',
47: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
48: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
49: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
43: p_structure_type IN VARCHAR2 := 'WORKPLAN',
44: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
45: p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
46: p_prog_fom_wp_flag IN VARCHAR2 := 'N',
47: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
48: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
49: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
50: p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- 3910193
51: x_resource_list_member_id OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
44: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
45: p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
46: p_prog_fom_wp_flag IN VARCHAR2 := 'N',
47: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
48: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
49: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
50: p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- 3910193
51: x_resource_list_member_id OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
52: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
45: p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
46: p_prog_fom_wp_flag IN VARCHAR2 := 'N',
47: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
48: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
49: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
50: p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- 3910193
51: x_resource_list_member_id OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
52: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
53: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
46: p_prog_fom_wp_flag IN VARCHAR2 := 'N',
47: p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
48: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
49: p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
50: p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, -- 3910193
51: x_resource_list_member_id OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
52: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
53: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
54: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
801: l_element_struc_type := p_structure_type;
802:
803: IF p_structure_type = 'FINANCIAL' --maansari: fpm changes
804: THEN
805: IF ( p_est_remaining_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
806: and p_est_remaining_effort IS NOT NULL
807: ) OR
808: ( p_actual_work_quantity <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --BUG 4368945, rtarway p_actual_work_quantity should be checked
809: and --p_est_remaining_effort is not null ) OR
804: THEN
805: IF ( p_est_remaining_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
806: and p_est_remaining_effort IS NOT NULL
807: ) OR
808: ( p_actual_work_quantity <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --BUG 4368945, rtarway p_actual_work_quantity should be checked
809: and --p_est_remaining_effort is not null ) OR
810: p_actual_work_quantity IS NOT NULL
811: ) OR
812: ( p_actual_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
808: ( p_actual_work_quantity <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --BUG 4368945, rtarway p_actual_work_quantity should be checked
809: and --p_est_remaining_effort is not null ) OR
810: p_actual_work_quantity IS NOT NULL
811: ) OR
812: ( p_actual_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
813: and p_actual_effort IS NOT NULL
814: )
815: THEN
816: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
827: IF ( PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id) = 'N'
828: AND p_calling_module = 'AMG'
829: AND NVL(PA_FP_CALC_PLAN_PKG.g_is_wp_quantity_changed,'N') = 'N' AND p_structure_type = 'WORKPLAN')
830: THEN
831: IF ( p_est_remaining_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
832: and p_est_remaining_effort IS NOT NULL)
833: THEN
834: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
835: ,p_msg_name => 'PA_WP_VD_CANT_UPDATE_ETC');
1039: END IF;
1040: ----- Wrong MODE
1041:
1042: ----- Wrong DATE
1043: IF p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR p_as_of_date IS NULL
1044: THEN
1045: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1046: ,p_msg_name => 'PA_TP_INV_AOD'
1047: ,p_token1 => 'AS_OF_DATE'
1052: END IF;
1053: ----- Wrong DATE
1054:
1055: ----- Wrong PROGRESS STATUS
1056: IF p_progress_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_progress_status_code IS NULL
1057: THEN
1058: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1059: ,p_msg_name => 'PA_TP_INV_PRG_STAT');
1060: x_msg_data := 'PA_TP_INV_PRG_STAT';
1109: --End Add for BUG 3819619
1110:
1111: ----- Wrong STATUS
1112: -- Bug 4429929 : Added OR condition below
1113: IF ((p_task_status = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_task_status IS NULL)OR(PA_PROGRESS_UTILS.get_system_task_status(p_task_status)= 'CANCELLED'))
1114: THEN
1115: IF p_object_type = 'PA_TASKS'
1116: THEN
1117: IF p_pm_product_code = 'MSPROJECT'
1140: ----- Wrong STATUS
1141: END IF; --<< l_element_struc_type >>
1142:
1143:
1144: IF (p_actual_work_quantity = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1145: --BUG 4368945, rtarway, should also be checked for null as AMG can pass it as null
1146: OR p_actual_work_quantity is null)
1147: THEN
1148: l_actual_work_quantity := 0;
1175: l_actual_work_quantity := nvl(round(p_actual_work_quantity,2),0);
1176: END IF;
1177: END IF;
1178:
1179: IF p_est_remaining_effort = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1180: ----- OR p_est_remaining_effort < 0 ---4378391 (5726773 allow neg ETC)
1181: THEN
1182: l_est_remaining_effort := 0;
1183: ELSE
1199: --3779387
1200: */
1201:
1202: --maansari: fpm changes 3420093
1203: IF p_actual_effort = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1204: THEN
1205: l_actual_effort := 0;
1206: ELSE
1207: --bug 3824042
1211:
1212: /*3970229 --3779387 negative actuals are allowed */
1213:
1214: --maansari4/5
1215: IF ( p_planned_effort = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM or
1216: p_planned_effort IS NULL or
1217: p_planned_effort = 0 )
1218: THEN
1219: l_planned_effort := 1;
1221: l_planned_effort := nvl(p_planned_effort,0);
1222: END IF;
1223: --maansari4/5
1224:
1225: IF p_planned_cost = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1226: THEN
1227: l_planned_cost := 0;
1228: ELSE
1229: l_planned_cost := nvl(p_planned_cost,0);
1230: END IF;
1231: --End maansari:
1232:
1233:
1234: IF p_percent_complete = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1235: OR p_percent_complete is null
1236: THEN
1237: l_percent_complete := 0;
1238: ELSE
1238: ELSE
1239: l_percent_complete := round(p_percent_complete,8); --Bug 6854114
1240: END IF;
1241:
1242: IF p_scheduled_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1243: THEN
1244: l_scheduled_start_date := null;
1245: ELSE
1246: l_scheduled_start_date := p_scheduled_start_date;
1245: ELSE
1246: l_scheduled_start_date := p_scheduled_start_date;
1247: END IF;
1248:
1249: IF p_scheduled_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1250: THEN
1251: l_scheduled_finish_date := null;
1252: ELSE
1253: l_scheduled_finish_date := p_scheduled_finish_date;
1252: ELSE
1253: l_scheduled_finish_date := p_scheduled_finish_date;
1254: END IF;
1255:
1256: IF p_actual_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1257: THEN
1258: l_actual_start_date := null;
1259: ELSE
1260: l_actual_start_date := p_actual_start_date;
1259: ELSE
1260: l_actual_start_date := p_actual_start_date;
1261: END IF;
1262:
1263: IF p_actual_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1264: THEN
1265: l_actual_finish_date := null;
1266: ELSE
1267: l_actual_finish_date := p_actual_finish_date;
1266: ELSE
1267: l_actual_finish_date := p_actual_finish_date;
1268: END IF;
1269:
1270: IF p_estimated_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1271: THEN
1272: l_estimated_start_date := null;
1273: ELSE
1274: l_estimated_start_date := p_estimated_start_date;
1273: ELSE
1274: l_estimated_start_date := p_estimated_start_date;
1275: END IF;
1276:
1277: IF p_estimated_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1278: THEN
1279: l_estimated_finish_date := null;
1280: ELSE
1281: l_estimated_finish_date := p_estimated_finish_date;
1280: ELSE
1281: l_estimated_finish_date := p_estimated_finish_date;
1282: END IF;
1283:
1284: IF p_task_status = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1285: THEN
1286: l_task_status := null;
1287: ELSE
1288: l_task_status := p_task_status;
1287: ELSE
1288: l_task_status := p_task_status;
1289: END IF;
1290:
1291: IF (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN
1292: l_pm_product_code := NULL;
1293: ELSE
1294: l_pm_product_code := p_pm_product_code;
1295: END IF;
1299: FETCH cur_check_published_version INTO l_published_structure;
1300: CLOSE cur_check_published_version;
1301:
1302: IF l_published_structure = 'Y'
1303: OR p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1304: OR p_prog_fom_wp_flag = 'N' --Not a working workplan progress.
1305: THEN
1306: l_structure_version_id := null;
1307: ELSE
1709: -- here to populate variable l_base_percent_complete.
1710: -- So that we can do status and % complete check further
1711: -- Actual and correct % compete will be calculated in partial rollup and rollup API's
1712: AND l_base_percent_comp_deriv_code in( 'EFFORT','COST') --maansari: fpm changes --bug 3784733
1713: AND p_actual_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1714: AND p_actual_effort IS NOT NULL
1715: THEN
1716: --maansari7/27 bug 3784733
1717: l_planned_effort := l_actual_effort+l_est_remaining_effort;
1740:
1741: --maansari5/6 bug3614860
1742:
1743: --do not copy base pc to override pc. maansari5/21
1744: IF ( p_percent_complete = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
1745: p_percent_complete IS NULL)
1746: AND l_percent_complete = 0
1747: THEN
1748: l_percent_complete := null;
1750:
1751: ---------Added by rtarway--------------------------
1752: -- Added For Bug 3630743
1753: --It is added here so that previous checks do not get affected by the changed value of l_est_remaining_effort
1754: IF p_est_remaining_effort = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1755: AND NVL( l_lowest_level_task, 'N' ) <> 'N'
1756: AND ( PA_PROGRESS_UTILS.check_assignment_exists(p_project_id,p_object_version_id,p_object_type) <> 'N' ) -- Bug 3784904 Changed from object_id to object_version_id
1757: AND l_element_struc_type = 'WORKPLAN'
1758: AND l_est_remaining_eff_flag <> 'N'
1878: l_process := 'CORRECT';
1879: END IF;
1880:
1881: --validate actuals
1882: IF ( l_actual_start_date IS NOT NULL AND l_actual_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ) OR
1883: -- 4533112 : It was start date again in below condition, changed it to shd be finish date here
1884: ( l_actual_finish_date IS NOT NULL AND l_actual_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ) OR
1885: ( p_actual_work_quantity IS NOT NULL AND p_actual_work_quantity <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
1886: THEN
1880:
1881: --validate actuals
1882: IF ( l_actual_start_date IS NOT NULL AND l_actual_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ) OR
1883: -- 4533112 : It was start date again in below condition, changed it to shd be finish date here
1884: ( l_actual_finish_date IS NOT NULL AND l_actual_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ) OR
1885: ( p_actual_work_quantity IS NOT NULL AND p_actual_work_quantity <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
1886: THEN
1887: --Add message
1888: --You cannot pass actuals for backdated progress.
1881: --validate actuals
1882: IF ( l_actual_start_date IS NOT NULL AND l_actual_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ) OR
1883: -- 4533112 : It was start date again in below condition, changed it to shd be finish date here
1884: ( l_actual_finish_date IS NOT NULL AND l_actual_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ) OR
1885: ( p_actual_work_quantity IS NOT NULL AND p_actual_work_quantity <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
1886: THEN
1887: --Add message
1888: --You cannot pass actuals for backdated progress.
1889: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2176: END IF;
2177:
2178: -- Bug 3922325 : Moved date defaulting code below
2179: -- BEGIN: Fix for Bug # 3957607.
2180: IF p_eff_rollup_percent_complete <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2181: AND p_eff_rollup_percent_complete IS NOT NULL
2182: AND p_percent_complete <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2183: AND p_percent_complete IS NOT NULL
2184: THEN
2178: -- Bug 3922325 : Moved date defaulting code below
2179: -- BEGIN: Fix for Bug # 3957607.
2180: IF p_eff_rollup_percent_complete <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2181: AND p_eff_rollup_percent_complete IS NOT NULL
2182: AND p_percent_complete <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2183: AND p_percent_complete IS NOT NULL
2184: THEN
2185: -- Do not consider overriden pc if its same as effective rollup percent complete.
2186: -- This has to be done before we calculate: l_earned_value.
2741: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_PROGRESS', x_Msg => 'l_db_action Create', x_Log_Level=> 3);
2742: END IF;
2743:
2744: --bug 4185364
2745: /*IF p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2746: OR (p_progress_mode = 'BACKDATED' AND l_process = 'CORRECT')
2747: THEN
2748: l_percent_complete_id := null;
2749: ELSE
3288: ELSE
3289: l_aod := p_as_of_date;
3290: END IF;
3291:
3292: IF p_percent_complete_id IS NULL OR p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_working_aod IS NULL --- 4245168
3293: THEN
3294: l_percent_complete_id := PA_PROGRESS_UTILS.get_ppc_id(
3295: p_project_id => p_project_id
3296: ,p_object_id => p_object_id
4275: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
4276: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4277: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4278: ,p_debug_mode IN VARCHAR2 :='N'
4279: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4280: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
4281: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4282: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4283: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4277: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4278: ,p_debug_mode IN VARCHAR2 :='N'
4279: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4280: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
4281: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4282: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4283: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4284: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4285: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4278: ,p_debug_mode IN VARCHAR2 :='N'
4279: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4280: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
4281: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4282: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4283: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4284: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4285: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4286: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4279: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4280: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
4281: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4282: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4283: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4284: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4285: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4286: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4287: ,p_lowest_level_task IN VARCHAR2 := 'N'
4280: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
4281: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4282: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4283: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4284: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4285: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4286: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4287: ,p_lowest_level_task IN VARCHAR2 := 'N'
4288: ,p_process_whole_tree IN VARCHAR2 := 'Y'
4281: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4282: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4283: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4284: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4285: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4286: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4287: ,p_lowest_level_task IN VARCHAR2 := 'N'
4288: ,p_process_whole_tree IN VARCHAR2 := 'Y'
4289: ,p_structure_version_id IN NUMBER
4282: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4283: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4284: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4285: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4286: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4287: ,p_lowest_level_task IN VARCHAR2 := 'N'
4288: ,p_process_whole_tree IN VARCHAR2 := 'Y'
4289: ,p_structure_version_id IN NUMBER
4290: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
4359: END IF;
4360:
4361: -- 20 May : Amit : If Structure_version_id is null, then no processing shd be done
4362: -- Bug 3856161 : Added p_as_of_date check also
4363: IF p_structure_version_id IS NULL OR (p_as_of_date IS NULL OR p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ) THEN
4364: return;
4365: END IF;
4366:
4367: IF (p_commit = FND_API.G_TRUE) THEN
4483: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
4484: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4485: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4486: ,p_debug_mode IN VARCHAR2 :='N'
4487: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4488: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4489: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4490: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4491: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE
4484: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4485: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4486: ,p_debug_mode IN VARCHAR2 :='N'
4487: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4488: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4489: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4490: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4491: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE
4492: ,p_lowest_level_task IN VARCHAR2 := 'N'
4485: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4486: ,p_debug_mode IN VARCHAR2 :='N'
4487: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4488: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4489: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4490: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4491: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE
4492: ,p_lowest_level_task IN VARCHAR2 := 'N'
4493: ,p_task_version_id IN NUMBER
4486: ,p_debug_mode IN VARCHAR2 :='N'
4487: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4488: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4489: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4490: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4491: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE
4492: ,p_lowest_level_task IN VARCHAR2 := 'N'
4493: ,p_task_version_id IN NUMBER
4494: ,p_structure_version_id IN NUMBER
4655: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
4656: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4657: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4658: ,p_debug_mode IN VARCHAR2 :='N'
4659: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4660: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4661: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4662: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4663: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4656: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4657: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4658: ,p_debug_mode IN VARCHAR2 :='N'
4659: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4660: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4661: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4662: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4663: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4664: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4657: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4658: ,p_debug_mode IN VARCHAR2 :='N'
4659: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4660: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4661: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4662: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4663: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4664: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4665: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4658: ,p_debug_mode IN VARCHAR2 :='N'
4659: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4660: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4661: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4662: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4663: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4664: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4665: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4666: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4659: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4660: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4661: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4662: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4663: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4664: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4665: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4666: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4667: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4660: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4661: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4662: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4663: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4664: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4665: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4666: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4667: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4668: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4661: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4662: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4663: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4664: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4665: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4666: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4667: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4668: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4669: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4662: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4663: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4664: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4665: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4666: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4667: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4668: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4669: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4670: ,X_PROJ_PROGRESS_ATTR_ID IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4663: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4664: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4665: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4666: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4667: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4668: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4669: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4670: ,X_PROJ_PROGRESS_ATTR_ID IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4671: ,P_ALLOW_COLLAB_PROG_ENTRY IN VARCHAR2 := 'N'
4664: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4665: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4666: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4667: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4668: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4669: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4670: ,X_PROJ_PROGRESS_ATTR_ID IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4671: ,P_ALLOW_COLLAB_PROG_ENTRY IN VARCHAR2 := 'N'
4672: ,P_ALLW_PHY_PRCNT_CMP_OVERRIDES IN VARCHAR2 := 'N'
4665: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4666: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4667: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4668: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4669: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4670: ,X_PROJ_PROGRESS_ATTR_ID IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4671: ,P_ALLOW_COLLAB_PROG_ENTRY IN VARCHAR2 := 'N'
4672: ,P_ALLW_PHY_PRCNT_CMP_OVERRIDES IN VARCHAR2 := 'N'
4673: ,P_STRUCTURE_TYPE IN VARCHAR2 := 'WORKPLAN'
4719: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4720: FND_MSG_PUB.initialize;
4721: END IF;
4722:
4723: IF P_PROGRESS_CYCLE_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4724: THEN
4725: l_PROGRESS_CYCLE_ID := null;
4726: ELSE
4727: l_PROGRESS_CYCLE_ID := P_PROGRESS_CYCLE_ID;
4726: ELSE
4727: l_PROGRESS_CYCLE_ID := P_PROGRESS_CYCLE_ID;
4728: END IF;
4729:
4730: IF p_WQ_ENABLE_FLAG = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4731: THEN
4732: l_WQ_ENABLE_FLAG := 'N';
4733: ELSE
4734: l_WQ_ENABLE_FLAG := p_WQ_ENABLE_FLAG;
4733: ELSE
4734: l_WQ_ENABLE_FLAG := p_WQ_ENABLE_FLAG;
4735: END IF;
4736:
4737: IF p_REMAIN_EFFORT_ENABLE_FLAG = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4738: THEN
4739: l_REMAIN_EFFORT_ENABLE_FLAG := 'N';
4740: ELSE
4741: l_REMAIN_EFFORT_ENABLE_FLAG := p_REMAIN_EFFORT_ENABLE_FLAG;
4740: ELSE
4741: l_REMAIN_EFFORT_ENABLE_FLAG := p_REMAIN_EFFORT_ENABLE_FLAG;
4742: END IF;
4743:
4744: IF p_PERCENT_COMP_ENABLE_FLAG = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4745: THEN
4746: l_PERCENT_COMP_ENABLE_FLAG := 'N';
4747: ELSE
4748: l_PERCENT_COMP_ENABLE_FLAG := p_PERCENT_COMP_ENABLE_FLAG;
4747: ELSE
4748: l_PERCENT_COMP_ENABLE_FLAG := p_PERCENT_COMP_ENABLE_FLAG;
4749: END IF;
4750:
4751: IF p_NEXT_PROGRESS_UPDATE_DATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4752: THEN
4753: l_NEXT_PROGRESS_UPDATE_DATE := null;
4754: ELSE
4755: l_NEXT_PROGRESS_UPDATE_DATE := p_NEXT_PROGRESS_UPDATE_DATE;
4755: l_NEXT_PROGRESS_UPDATE_DATE := p_NEXT_PROGRESS_UPDATE_DATE;
4756: END IF;
4757:
4758: --bug 3010538
4759: IF p_TASK_WEIGHT_BASIS_CODE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4760: THEN
4761: l_task_weight_basis_code := 'DURATION';
4762: ELSE
4763: l_task_weight_basis_code := p_TASK_WEIGHT_BASIS_CODE;
4830: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
4831: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4832: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4833: ,p_debug_mode IN VARCHAR2 :='N'
4834: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4835: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4836: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4837: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4838: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4831: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4832: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4833: ,p_debug_mode IN VARCHAR2 :='N'
4834: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4835: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4836: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4837: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4838: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4839: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4832: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4833: ,p_debug_mode IN VARCHAR2 :='N'
4834: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4835: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4836: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4837: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4838: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4839: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4840: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4833: ,p_debug_mode IN VARCHAR2 :='N'
4834: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4835: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4836: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4837: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4838: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4839: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4840: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4841: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4834: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4835: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4836: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4837: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4838: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4839: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4840: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4841: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4842: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4835: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4836: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4837: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4838: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4839: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4840: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4841: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4842: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4843: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4836: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4837: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4838: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4839: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4840: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4841: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4842: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4843: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4844: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4837: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4838: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4839: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4840: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4841: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4842: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4843: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4844: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4845: ,P_PROJ_PROGRESS_ATTR_ID IN NUMBER
4838: ,P_PROGRESS_CYCLE_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4839: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4840: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4841: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4842: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4843: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4844: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4845: ,P_PROJ_PROGRESS_ATTR_ID IN NUMBER
4846: ,p_record_version_number IN NUMBER
4839: ,P_WQ_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4840: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4841: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4842: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4843: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4844: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4845: ,P_PROJ_PROGRESS_ATTR_ID IN NUMBER
4846: ,p_record_version_number IN NUMBER
4847: ,p_allow_collab_prog_entry IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4840: ,P_REMAIN_EFFORT_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4841: ,P_PERCENT_COMP_ENABLE_FLAG IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4842: ,P_NEXT_PROGRESS_UPDATE_DATE IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4843: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4844: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4845: ,P_PROJ_PROGRESS_ATTR_ID IN NUMBER
4846: ,p_record_version_number IN NUMBER
4847: ,p_allow_collab_prog_entry IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4848: ,p_allw_phy_prcnt_cmp_overrides IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4843: ,p_action_set_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4844: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4845: ,P_PROJ_PROGRESS_ATTR_ID IN NUMBER
4846: ,p_record_version_number IN NUMBER
4847: ,p_allow_collab_prog_entry IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4848: ,p_allw_phy_prcnt_cmp_overrides IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4849: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4850: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4851: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4844: ,p_TASK_WEIGHT_BASIS_CODE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4845: ,P_PROJ_PROGRESS_ATTR_ID IN NUMBER
4846: ,p_record_version_number IN NUMBER
4847: ,p_allow_collab_prog_entry IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4848: ,p_allw_phy_prcnt_cmp_overrides IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4849: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4850: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4851: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4852: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4845: ,P_PROJ_PROGRESS_ATTR_ID IN NUMBER
4846: ,p_record_version_number IN NUMBER
4847: ,p_allow_collab_prog_entry IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4848: ,p_allw_phy_prcnt_cmp_overrides IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4849: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4850: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4851: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4852: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4853: ) IS
4951: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4952: FND_MSG_PUB.initialize;
4953: END IF;
4954:
4955: /* IF P_PROGRESS_CYCLE_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4956: THEN
4957: l_PROGRESS_CYCLE_ID := null;
4958: ELSE
4959: l_PROGRESS_CYCLE_ID := P_PROGRESS_CYCLE_ID;
4958: ELSE
4959: l_PROGRESS_CYCLE_ID := P_PROGRESS_CYCLE_ID;
4960: END IF;
4961:
4962: IF p_WQ_ENABLE_FLAG = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4963: THEN
4964: l_WQ_ENABLE_FLAG := null;
4965: ELSE
4966: l_WQ_ENABLE_FLAG := p_WQ_ENABLE_FLAG;
4965: ELSE
4966: l_WQ_ENABLE_FLAG := p_WQ_ENABLE_FLAG;
4967: END IF;
4968:
4969: IF p_REMAIN_EFFORT_ENABLE_FLAG = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4970: THEN
4971: l_REMAIN_EFFORT_ENABLE_FLAG := null;
4972: ELSE
4973: l_REMAIN_EFFORT_ENABLE_FLAG := p_REMAIN_EFFORT_ENABLE_FLAG;
4972: ELSE
4973: l_REMAIN_EFFORT_ENABLE_FLAG := p_REMAIN_EFFORT_ENABLE_FLAG;
4974: END IF;
4975:
4976: IF p_PERCENT_COMP_ENABLE_FLAG = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4977: THEN
4978: l_PERCENT_COMP_ENABLE_FLAG := null;
4979: ELSE
4980: l_PERCENT_COMP_ENABLE_FLAG := p_PERCENT_COMP_ENABLE_FLAG;
4979: ELSE
4980: l_PERCENT_COMP_ENABLE_FLAG := p_PERCENT_COMP_ENABLE_FLAG;
4981: END IF;
4982:
4983: IF p_NEXT_PROGRESS_UPDATE_DATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4984: THEN
4985: l_NEXT_PROGRESS_UPDATE_DATE := null;
4986: ELSE
4987: l_NEXT_PROGRESS_UPDATE_DATE := p_NEXT_PROGRESS_UPDATE_DATE;
5035: --bug 3010538
5036: OPEN cur_task_weight_bas_code;
5037: FETCH cur_task_weight_bas_code into l_old_tk_wght_basis_code;
5038: CLOSE cur_task_weight_bas_code;
5039: IF p_TASK_WEIGHT_BASIS_CODE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5040: THEN
5041: --no value passed; same as old value
5042: l_task_weight_basis_code := l_old_tk_wght_basis_code;
5043: ELSE
5259: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
5260: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5261: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5262: ,p_debug_mode IN VARCHAR2 :='N'
5263: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5264: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5265: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5266: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5267: ,p_structure_type IN VARCHAR2 := 'WORKPLAN' -- Amit
5260: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5261: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5262: ,p_debug_mode IN VARCHAR2 :='N'
5263: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5264: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5265: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5266: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5267: ,p_structure_type IN VARCHAR2 := 'WORKPLAN' -- Amit
5268: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5261: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5262: ,p_debug_mode IN VARCHAR2 :='N'
5263: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5264: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5265: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5266: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5267: ,p_structure_type IN VARCHAR2 := 'WORKPLAN' -- Amit
5268: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5269: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5262: ,p_debug_mode IN VARCHAR2 :='N'
5263: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5264: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5265: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5266: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5267: ,p_structure_type IN VARCHAR2 := 'WORKPLAN' -- Amit
5268: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5269: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5270: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5366: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
5367: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5368: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5369: ,p_debug_mode IN VARCHAR2 :='N'
5370: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5371: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5372: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5373: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5374: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5367: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5368: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5369: ,p_debug_mode IN VARCHAR2 :='N'
5370: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5371: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5372: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5373: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5374: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5375: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5368: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5369: ,p_debug_mode IN VARCHAR2 :='N'
5370: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5371: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5372: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5373: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5374: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5375: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5376: ) IS
5455: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
5456: FND_MSG_PUB.initialize;
5457: END IF;
5458:
5459: IF p_task_version_id is NULL OR p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5460: THEN
5461: OPEN cur_ppevs( p_structure_version_id );
5462: FETCH cur_ppevs INTO l_project_id, l_proj_element_id;
5463: CLOSE cur_ppevs;
5468:
5469: OPEN cur_pa_ppr_str( l_project_id, l_proj_element_id );
5470: FETCH cur_pa_ppr_str INTO l_rollup_row_id;
5471: CLOSE cur_pa_ppr_str;
5472: ELSIF p_structure_version_id IS NOT NULL AND p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
5473: p_task_version_id IS NOT NULL AND p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5474: THEN
5475:
5476: OPEN cur_ppevs( p_task_version_id );
5469: OPEN cur_pa_ppr_str( l_project_id, l_proj_element_id );
5470: FETCH cur_pa_ppr_str INTO l_rollup_row_id;
5471: CLOSE cur_pa_ppr_str;
5472: ELSIF p_structure_version_id IS NOT NULL AND p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
5473: p_task_version_id IS NOT NULL AND p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5474: THEN
5475:
5476: OPEN cur_ppevs( p_task_version_id );
5477: FETCH cur_ppevs INTO l_project_id, l_proj_element_id;
5522: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
5523: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5524: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5525: ,p_debug_mode IN VARCHAR2 :='N'
5526: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5527: ,p_task_status IN VARCHAR2
5528: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5529: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5530: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5524: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5525: ,p_debug_mode IN VARCHAR2 :='N'
5526: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5527: ,p_task_status IN VARCHAR2
5528: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5529: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5530: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5531: ,p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5532: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
5525: ,p_debug_mode IN VARCHAR2 :='N'
5526: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5527: ,p_task_status IN VARCHAR2
5528: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5529: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5530: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5531: ,p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5532: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
5533: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
5526: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5527: ,p_task_status IN VARCHAR2
5528: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5529: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5530: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5531: ,p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5532: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
5533: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
5534: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
5527: ,p_task_status IN VARCHAR2
5528: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5529: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5530: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5531: ,p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5532: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
5533: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
5534: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
5535: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5528: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5529: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5530: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5531: ,p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5532: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
5533: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
5534: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
5535: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5536: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5529: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5530: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5531: ,p_object_type IN Varchar2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
5532: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
5533: ,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
5534: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
5535: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5536: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5537: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7098: raise;
7099: END push_down_task_status;
7100:
7101: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
7102: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7103: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7104: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7105: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7106: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
7099: END push_down_task_status;
7100:
7101: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
7102: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7103: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7104: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7105: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7106: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
7107: ,p_lowest_level_task IN VARCHAR2 := 'N'
7100:
7101: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
7102: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7103: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7104: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7105: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7106: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
7107: ,p_lowest_level_task IN VARCHAR2 := 'N'
7108: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
7101: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
7102: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7103: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7104: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7105: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7106: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
7107: ,p_lowest_level_task IN VARCHAR2 := 'N'
7108: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
7109: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
7102: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7103: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7104: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7105: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7106: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
7107: ,p_lowest_level_task IN VARCHAR2 := 'N'
7108: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
7109: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
7110: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7106: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
7107: ,p_lowest_level_task IN VARCHAR2 := 'N'
7108: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
7109: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
7110: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7111: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7112: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7113: ,p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
7114: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7107: ,p_lowest_level_task IN VARCHAR2 := 'N'
7108: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
7109: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
7110: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7111: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7112: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7113: ,p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
7114: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7115: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7108: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
7109: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
7110: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7111: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7112: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7113: ,p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
7114: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7115: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7116: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7233: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
7234: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
7235: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
7236: ,p_debug_mode IN VARCHAR2 :='N'
7237: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7238: ,p_project_id IN NUMBER
7239: ,p_working_str_version_id IN NUMBER
7240: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7241: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8841: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
8842: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
8843: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
8844: ,p_debug_mode IN VARCHAR2 :='N'
8845: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8846: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8847: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8848: ,p_task_version_id IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type()
8849: ,p_calling_context IN VARCHAR2 := 'STRUCTURE_VERSION'
8842: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
8843: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
8844: ,p_debug_mode IN VARCHAR2 :='N'
8845: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8846: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8847: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8848: ,p_task_version_id IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type()
8849: ,p_calling_context IN VARCHAR2 := 'STRUCTURE_VERSION'
8850: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8843: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
8844: ,p_debug_mode IN VARCHAR2 :='N'
8845: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8846: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8847: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8848: ,p_task_version_id IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type()
8849: ,p_calling_context IN VARCHAR2 := 'STRUCTURE_VERSION'
8850: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8851: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8963: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
8964: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
8965: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
8966: ,p_debug_mode IN VARCHAR2 :='N'
8967: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8968: ,P_Project_ID IN NUMBER
8969: ,P_Calling_Mode IN VARCHAR2
8970: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8971: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
9195: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
9196: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
9197: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
9198: ,p_debug_mode IN VARCHAR2 :='N'
9199: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9200: ,p_action IN VARCHAR2 :='SAVE'
9201: ,P_rollup_entire_wbs_flag IN VARCHAR2 :='N'
9202: ,p_progress_mode IN VARCHAR2 :='FUTURE'
9203: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9199: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9200: ,p_action IN VARCHAR2 :='SAVE'
9201: ,P_rollup_entire_wbs_flag IN VARCHAR2 :='N'
9202: ,p_progress_mode IN VARCHAR2 :='FUTURE'
9203: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9204: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9205: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9206: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9207: ,p_object_type IN VARCHAR2 :='PA_TASKS'
9200: ,p_action IN VARCHAR2 :='SAVE'
9201: ,P_rollup_entire_wbs_flag IN VARCHAR2 :='N'
9202: ,p_progress_mode IN VARCHAR2 :='FUTURE'
9203: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9204: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9205: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9206: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9207: ,p_object_type IN VARCHAR2 :='PA_TASKS'
9208: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9201: ,P_rollup_entire_wbs_flag IN VARCHAR2 :='N'
9202: ,p_progress_mode IN VARCHAR2 :='FUTURE'
9203: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9204: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9205: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9206: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9207: ,p_object_type IN VARCHAR2 :='PA_TASKS'
9208: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9209: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9202: ,p_progress_mode IN VARCHAR2 :='FUTURE'
9203: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9204: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9205: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9206: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9207: ,p_object_type IN VARCHAR2 :='PA_TASKS'
9208: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9209: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9210: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9204: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9205: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9206: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9207: ,p_object_type IN VARCHAR2 :='PA_TASKS'
9208: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9209: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9210: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9211: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9212: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9205: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9206: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9207: ,p_object_type IN VARCHAR2 :='PA_TASKS'
9208: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9209: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9210: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9211: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9212: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9213: ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9206: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9207: ,p_object_type IN VARCHAR2 :='PA_TASKS'
9208: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9209: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9210: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9211: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9212: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9213: ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9214: ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9207: ,p_object_type IN VARCHAR2 :='PA_TASKS'
9208: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9209: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9210: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9211: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9212: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9213: ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9214: ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9215: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9208: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9209: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9210: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9211: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9212: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9213: ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9214: ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9215: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9216: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9209: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9210: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9211: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9212: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9213: ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9214: ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9215: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9216: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9217: ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9210: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9211: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9212: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9213: ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9214: ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9215: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9216: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9217: ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9218: ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9211: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9212: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9213: ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9214: ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9215: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9216: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9217: ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9218: ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9219: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9212: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9213: ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9214: ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9215: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9216: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9217: ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9218: ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9219: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9220: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9213: ,p_actual_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9214: ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9215: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9216: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9217: ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9218: ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9219: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9220: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9221: ,p_est_remaining_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9214: ,p_actual_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9215: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9216: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9217: ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9218: ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9219: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9220: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9221: ,p_est_remaining_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9222: ,p_ETC_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9215: ,p_estimated_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9216: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9217: ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9218: ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9219: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9220: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9221: ,p_est_remaining_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9222: ,p_ETC_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9223: ,p_actual_work_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9216: ,p_estimated_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9217: ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9218: ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9219: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9220: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9221: ,p_est_remaining_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9222: ,p_ETC_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9223: ,p_actual_work_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9224: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9217: ,p_scheduled_start_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9218: ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9219: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9220: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9221: ,p_est_remaining_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9222: ,p_ETC_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9223: ,p_actual_work_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9224: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9225: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
9218: ,p_scheduled_finish_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
9219: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9220: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9221: ,p_est_remaining_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9222: ,p_ETC_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9223: ,p_actual_work_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9224: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9225: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
9226: ,p_actual_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9219: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9220: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9221: ,p_est_remaining_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9222: ,p_ETC_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9223: ,p_actual_work_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9224: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9225: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
9226: ,p_actual_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9227: ,p_actual_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9220: ,p_task_status IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9221: ,p_est_remaining_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9222: ,p_ETC_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9223: ,p_actual_work_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9224: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9225: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
9226: ,p_actual_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9227: ,p_actual_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9228: ,p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9222: ,p_ETC_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9223: ,p_actual_work_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9224: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9225: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
9226: ,p_actual_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9227: ,p_actual_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9228: ,p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9229: ,p_actual_cost_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9230: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9223: ,p_actual_work_quantity IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9224: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9225: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
9226: ,p_actual_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9227: ,p_actual_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9228: ,p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9229: ,p_actual_cost_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9230: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9231: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9224: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9225: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
9226: ,p_actual_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9227: ,p_actual_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9228: ,p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9229: ,p_actual_cost_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9230: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9231: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9232: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9225: ,p_structure_type IN VARCHAR2 :='WORKPLAN'
9226: ,p_actual_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9227: ,p_actual_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9228: ,p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9229: ,p_actual_cost_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9230: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9231: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9232: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9233: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9226: ,p_actual_effort IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9227: ,p_actual_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9228: ,p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9229: ,p_actual_cost_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9230: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9231: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9232: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9233: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9234: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9227: ,p_actual_cost IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9228: ,p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9229: ,p_actual_cost_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9230: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9231: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9232: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9233: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9234: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9235: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9228: ,p_actual_effort_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9229: ,p_actual_cost_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9230: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9231: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9232: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9233: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9234: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9235: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9236: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9229: ,p_actual_cost_this_period IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9230: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9231: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9232: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9233: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9234: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9235: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9236: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9237: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9230: ,p_object_sub_type IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9231: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9232: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9233: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9234: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9235: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9236: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9237: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9238: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9231: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9232: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9233: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9234: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9235: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9236: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9237: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9238: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9239: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9232: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9233: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9234: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9235: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9236: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9237: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9238: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9239: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9240: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9233: ,p_prog_fom_wp_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9234: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9235: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9236: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9237: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9238: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9239: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9240: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9241: ,p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9234: ,p_rollup_reporting_lines_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9235: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9236: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9237: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9238: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9239: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9240: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9241: ,p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9242: -- ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
9235: ,p_planned_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9236: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9237: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9238: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9239: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9240: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9241: ,p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9242: -- ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
9243: ,p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
9236: ,p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9237: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9238: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9239: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9240: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9241: ,p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9242: -- ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
9243: ,p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
9244: ,p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- 3910193
9237: ,p_rate_based_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9238: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9239: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9240: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9241: ,p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9242: -- ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
9243: ,p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
9244: ,p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- 3910193
9245: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
9238: ,p_resource_class_code IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9239: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9240: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9241: ,p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9242: -- ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
9243: ,p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
9244: ,p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- 3910193
9245: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
9246: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
9239: ,p_transfer_wp_pc_flag IN VARCHAR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9240: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9241: ,p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9242: -- ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
9243: ,p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
9244: ,p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- 3910193
9245: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
9246: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
9247: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
9240: ,p_txn_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
9241: ,p_rbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9242: -- ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
9243: ,p_resource_assignment_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3764224
9244: ,p_eff_rollup_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- 3910193
9245: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
9246: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
9247: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
9248: )
9798:
9799: l_object_type := 'PA_TASKS';
9800: l_task_version_id := null;
9801: -- FPM Dev CR 1 : Call of cursor c_get_latest_pub_task_ver
9802: IF p_object_type = 'PA_DELIVERABLES' AND (p_task_id IS NOT NULL AND p_task_id <>PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )THEN
9803: -- In deliverable case, we may not get task's structure version id. So we need to derive it.
9804: -- Bug 3957792 -- Proceed for roll-up only if task is not in cancelled status
9805: IF ( PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, p_task_id)) <> 'CANCELLED' ) THEN
9806: OPEN c_get_latest_pub_task_ver(p_task_id, p_project_id);
9837: -- Begin commenting out since we do not want this to be patched on pjd2qa unless this is tested
9838:
9839: -- Bug 3614828 : Added call of ASGN_DLV_TO_TASK_ROLLUP_PVT for partial rollup
9840: IF ((l_action = 'SAVE' AND p_calling_module = 'TASK_PROG_DET_PAGE' -- Code to fix Bug # 3821106.
9841: AND (p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
9842: AND (l_task_version_id IS NOT NULL AND l_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
9843: AND (p_object_type = 'PA_ASSIGNMENTS' OR p_object_type = 'PA_DELIVERABLES' ) --bug 4097524 added PA_TASKS also
9844: -- This condition can be modified to make PA_TASKS if we can make sure that task records are getting inserted at the last after inserting assignment and delievarble progress from Task Progress Details page
9845: -- This will improve performance as it will be called once only i.e. for tasks
9838:
9839: -- Bug 3614828 : Added call of ASGN_DLV_TO_TASK_ROLLUP_PVT for partial rollup
9840: IF ((l_action = 'SAVE' AND p_calling_module = 'TASK_PROG_DET_PAGE' -- Code to fix Bug # 3821106.
9841: AND (p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
9842: AND (l_task_version_id IS NOT NULL AND l_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
9843: AND (p_object_type = 'PA_ASSIGNMENTS' OR p_object_type = 'PA_DELIVERABLES' ) --bug 4097524 added PA_TASKS also
9844: -- This condition can be modified to make PA_TASKS if we can make sure that task records are getting inserted at the last after inserting assignment and delievarble progress from Task Progress Details page
9845: -- This will improve performance as it will be called once only i.e. for tasks
9846: -- as of now it will be called for each assignments and deliverables for a task
9846: -- as of now it will be called for each assignments and deliverables for a task
9847: AND p_structure_type = 'WORKPLAN')
9848: OR --bug 4101208
9849: (l_action = 'SAVE'
9850: AND (p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
9851: AND (l_task_version_id IS NOT NULL AND l_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
9852: AND ( p_object_type = 'PA_TASKS')
9853: AND p_structure_type = 'WORKPLAN')
9854: )
9847: AND p_structure_type = 'WORKPLAN')
9848: OR --bug 4101208
9849: (l_action = 'SAVE'
9850: AND (p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
9851: AND (l_task_version_id IS NOT NULL AND l_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
9852: AND ( p_object_type = 'PA_TASKS')
9853: AND p_structure_type = 'WORKPLAN')
9854: )
9855: THEN
10256: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
10257: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
10258: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
10259: ,p_debug_mode IN VARCHAR2 :='N'
10260: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10261: ,p_project_id IN NUMBER
10262: ,p_project_element_id IN NUMBER DEFAULT NULL --bug 4183307
10263: ,p_structure_version_id IN NUMBER DEFAULT NULL
10264: ,p_baselined_str_ver_id IN NUMBER DEFAULT NULL
10419: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
10420: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
10421: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
10422: ,p_debug_mode IN VARCHAR2 :='N'
10423: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10424: ,p_project_Id NUMBER
10425: ,p_structure_version_id NUMBER
10426: ,p_proj_element_id NUMBER
10427: ,p_object_id NUMBER
10428: ,p_object_type VARCHAR2
10429: ,p_as_of_date DATE
10430: ,p_resource_assignment_id NUMBER :=null -- Bug 4186007
10431: ,p_resource_list_member_id NUMBER :=null-- Bug 4186007
10432: ,p_rbs_element_id NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10433: ,p_rate_based_flag VARCHAR2 := 'Y' -- Default for Task
10434: ,p_resource_class_code VARCHAR2 :='PEOPLE' -- Default for Task
10435: -- ,p_TXN_CURRENCY_CODE VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Bug 3595585 Removed not needed
10436: ,p_act_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10431: ,p_resource_list_member_id NUMBER :=null-- Bug 4186007
10432: ,p_rbs_element_id NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10433: ,p_rate_based_flag VARCHAR2 := 'Y' -- Default for Task
10434: ,p_resource_class_code VARCHAR2 :='PEOPLE' -- Default for Task
10435: -- ,p_TXN_CURRENCY_CODE VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Bug 3595585 Removed not needed
10436: ,p_act_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10437: ,p_act_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10438: ,p_act_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10439: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10432: ,p_rbs_element_id NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10433: ,p_rate_based_flag VARCHAR2 := 'Y' -- Default for Task
10434: ,p_resource_class_code VARCHAR2 :='PEOPLE' -- Default for Task
10435: -- ,p_TXN_CURRENCY_CODE VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Bug 3595585 Removed not needed
10436: ,p_act_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10437: ,p_act_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10438: ,p_act_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10439: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10440: ,p_etc_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10433: ,p_rate_based_flag VARCHAR2 := 'Y' -- Default for Task
10434: ,p_resource_class_code VARCHAR2 :='PEOPLE' -- Default for Task
10435: -- ,p_TXN_CURRENCY_CODE VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Bug 3595585 Removed not needed
10436: ,p_act_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10437: ,p_act_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10438: ,p_act_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10439: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10440: ,p_etc_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10441: ,p_etc_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10434: ,p_resource_class_code VARCHAR2 :='PEOPLE' -- Default for Task
10435: -- ,p_TXN_CURRENCY_CODE VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Bug 3595585 Removed not needed
10436: ,p_act_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10437: ,p_act_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10438: ,p_act_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10439: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10440: ,p_etc_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10441: ,p_etc_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10442: ,p_etc_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10435: -- ,p_TXN_CURRENCY_CODE VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Bug 3595585 Removed not needed
10436: ,p_act_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10437: ,p_act_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10438: ,p_act_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10439: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10440: ,p_etc_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10441: ,p_etc_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10442: ,p_etc_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10443: ,p_etc_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10436: ,p_act_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10437: ,p_act_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10438: ,p_act_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10439: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10440: ,p_etc_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10441: ,p_etc_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10442: ,p_etc_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10443: ,p_etc_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10444: ,p_call_pji_apis_flag VARCHAR2 := 'Y'
10437: ,p_act_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10438: ,p_act_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10439: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10440: ,p_etc_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10441: ,p_etc_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10442: ,p_etc_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10443: ,p_etc_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10444: ,p_call_pji_apis_flag VARCHAR2 := 'Y'
10445: ,p_act_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10438: ,p_act_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10439: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10440: ,p_etc_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10441: ,p_etc_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10442: ,p_etc_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10443: ,p_etc_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10444: ,p_call_pji_apis_flag VARCHAR2 := 'Y'
10445: ,p_act_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10446: ,p_act_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10439: ,p_act_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10440: ,p_etc_TXN_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10441: ,p_etc_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10442: ,p_etc_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10443: ,p_etc_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10444: ,p_call_pji_apis_flag VARCHAR2 := 'Y'
10445: ,p_act_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10446: ,p_act_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10447: ,p_act_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10441: ,p_etc_PRJ_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10442: ,p_etc_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10443: ,p_etc_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10444: ,p_call_pji_apis_flag VARCHAR2 := 'Y'
10445: ,p_act_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10446: ,p_act_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10447: ,p_act_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10448: ,p_etc_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10449: ,p_etc_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10442: ,p_etc_POU_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10443: ,p_etc_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10444: ,p_call_pji_apis_flag VARCHAR2 := 'Y'
10445: ,p_act_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10446: ,p_act_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10447: ,p_act_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10448: ,p_etc_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10449: ,p_etc_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10450: ,p_etc_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10443: ,p_etc_effort_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM-- Bug 3595585
10444: ,p_call_pji_apis_flag VARCHAR2 := 'Y'
10445: ,p_act_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10446: ,p_act_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10447: ,p_act_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10448: ,p_etc_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10449: ,p_etc_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10450: ,p_etc_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10451: -- BUG # 3659659.
10444: ,p_call_pji_apis_flag VARCHAR2 := 'Y'
10445: ,p_act_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10446: ,p_act_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10447: ,p_act_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10448: ,p_etc_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10449: ,p_etc_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10450: ,p_etc_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10451: -- BUG # 3659659.
10452: ,p_txn_currency_code VARCHAR2 := null
10445: ,p_act_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10446: ,p_act_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10447: ,p_act_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10448: ,p_etc_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10449: ,p_etc_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10450: ,p_etc_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10451: -- BUG # 3659659.
10452: ,p_txn_currency_code VARCHAR2 := null
10453: ,p_prj_currency_code VARCHAR2 := null
10446: ,p_act_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10447: ,p_act_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10448: ,p_etc_TXN_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10449: ,p_etc_PRJ_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10450: ,p_etc_POU_raw_COST_this_period NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM -- Bug 3621404
10451: -- BUG # 3659659.
10452: ,p_txn_currency_code VARCHAR2 := null
10453: ,p_prj_currency_code VARCHAR2 := null
10454: ,p_pfn_currency_code VARCHAR2 := null
10565:
10566: x_return_status := FND_API.G_RET_STS_SUCCESS;
10567: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745
10568:
10569: IF NVL(p_structure_version_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug 3625085
10570: THEN
10571: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id);
10572: ELSE
10573: l_structure_version_id := p_structure_version_id;
10572: ELSE
10573: l_structure_version_id := p_structure_version_id;
10574: END IF;
10575:
10576: IF p_RBS_ELEMENT_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10577: THEN
10578: l_RBS_ELEMENT_ID := null;
10579: ELSE
10580: l_RBS_ELEMENT_ID := p_RBS_ELEMENT_ID;
10582:
10583: -- Bug 3595585 : Added following checks
10584:
10585:
10586: IF p_etc_effort_this_period = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10587: THEN
10588: l_ETC_QUANTITY := null;
10589: ELSE
10590: l_ETC_QUANTITY := p_etc_effort_this_period;
10589: ELSE
10590: l_ETC_QUANTITY := p_etc_effort_this_period;
10591: END IF;
10592:
10593: IF p_etc_TXN_COST_this_period = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10594: THEN
10595: l_ETC_TXN_BURDENED_COST := null;
10596: ELSE
10597: l_ETC_TXN_BURDENED_COST := p_etc_TXN_COST_this_period;
10596: ELSE
10597: l_ETC_TXN_BURDENED_COST := p_etc_TXN_COST_this_period;
10598: END IF;
10599:
10600: IF p_etc_PRJ_COST_this_period = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10601: THEN
10602: l_ETC_PRJ_BURDENED_COST := null;
10603: ELSE
10604: l_ETC_PRJ_BURDENED_COST := p_etc_PRJ_COST_this_period;
10603: ELSE
10604: l_ETC_PRJ_BURDENED_COST := p_etc_PRJ_COST_this_period;
10605: END IF;
10606:
10607: IF p_etc_POU_COST_this_period = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10608: THEN
10609: l_ETC_PFC_BURDENED_COST := null;
10610: ELSE
10611: l_ETC_PFC_BURDENED_COST := p_etc_POU_COST_this_period;
10626: END IF;
10627: -- Bug 3621404 : Raw Cost Changes
10628:
10629:
10630: IF p_etc_TXN_raw_COST_this_period = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10631: THEN
10632: l_etc_TXN_raw_COST_this_period := null;
10633: ELSE
10634: l_etc_TXN_raw_COST_this_period := p_etc_TXN_raw_COST_this_period;
10633: ELSE
10634: l_etc_TXN_raw_COST_this_period := p_etc_TXN_raw_COST_this_period;
10635: END IF;
10636:
10637: IF p_etc_PRJ_raw_COST_this_period = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10638: THEN
10639: l_etc_PRJ_raw_COST_this_period := null;
10640: ELSE
10641: l_etc_PRJ_raw_COST_this_period := p_etc_PRJ_raw_COST_this_period;
10640: ELSE
10641: l_etc_PRJ_raw_COST_this_period := p_etc_PRJ_raw_COST_this_period;
10642: END IF;
10643:
10644: IF p_etc_POU_raw_COST_this_period = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10645: THEN
10646: l_etc_POU_raw_COST_this_period := null;
10647: ELSE
10648: l_etc_POU_raw_COST_this_period := p_etc_POU_raw_COST_this_period;
10994: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
10995: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
10996: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
10997: ,p_debug_mode IN VARCHAR2 :='N'
10998: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10999: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
11000: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
11001: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
11002: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10995: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
10996: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
10997: ,p_debug_mode IN VARCHAR2 :='N'
10998: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10999: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
11000: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
11001: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
11002: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
11003: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10996: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
10997: ,p_debug_mode IN VARCHAR2 :='N'
10998: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10999: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
11000: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
11001: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
11002: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
11003: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
11004: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10997: ,p_debug_mode IN VARCHAR2 :='N'
10998: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10999: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
11000: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
11001: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
11002: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
11003: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
11004: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
11005: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10998: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10999: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
11000: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
11001: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
11002: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
11003: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
11004: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
11005: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
11006: )
11114: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
11115: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
11116: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
11117: ,p_debug_mode IN VARCHAR2 :='N'
11118: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
11119: ,p_project_id IN NUMBER
11120: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
11121: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
11122: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
11556: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
11557: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
11558: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
11559: ,p_debug_mode IN VARCHAR2 :='N'
11560: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
11561: ,p_project_id IN NUMBER
11562: ,p_working_str_ver_id IN NUMBER -- Bug 4190086
11563: ,p_pub_structure_version_id IN NUMBER -- Bug 3839288
11564: ,x_upd_new_elem_ver_id_flag OUT NOCOPY VARCHAR2 -- BUG 3951024, rtarway --File.Sql.39 bug 4440895
19836: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
19837: p_error_text => SUBSTRB('pa_progress_pub.get_summarized_actuals:'||SQLERRM,1,120));
19838: -- 4746476 : Priniting stack
19839: FOR i in 1..fnd_msg_pub.count_msg LOOP
19840: pa_interface_utils_pub.get_messages (
19841: p_encoded => Fnd_Api.G_FALSE
19842: ,p_data => l_data
19843: ,p_msg_index => i
19844: ,p_msg_index_out => l_msg_index_out );
19878: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
19879: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
19880: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
19881: ,p_debug_mode IN VARCHAR2 :='N'
19882: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19883: ,p_action IN VARCHAR2 :='SAVE'
19884: ,P_rollup_entire_wbs_flag IN VARCHAR2 :='N'
19885: ,p_progress_mode IN VARCHAR2 :='FUTURE'
19886: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19882: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19883: ,p_action IN VARCHAR2 :='SAVE'
19884: ,P_rollup_entire_wbs_flag IN VARCHAR2 :='N'
19885: ,p_progress_mode IN VARCHAR2 :='FUTURE'
19886: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19887: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19888: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19889: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19890: ,p_object_type IN VARCHAR2 :='PA_TASKS'
19883: ,p_action IN VARCHAR2 :='SAVE'
19884: ,P_rollup_entire_wbs_flag IN VARCHAR2 :='N'
19885: ,p_progress_mode IN VARCHAR2 :='FUTURE'
19886: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19887: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19888: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19889: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19890: ,p_object_type IN VARCHAR2 :='PA_TASKS'
19891: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
19884: ,P_rollup_entire_wbs_flag IN VARCHAR2 :='N'
19885: ,p_progress_mode IN VARCHAR2 :='FUTURE'
19886: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19887: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19888: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19889: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19890: ,p_object_type IN VARCHAR2 :='PA_TASKS'
19891: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
19892: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19885: ,p_progress_mode IN VARCHAR2 :='FUTURE'
19886: ,p_percent_complete_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19887: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19888: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19889: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19890: ,p_object_type IN VARCHAR2 :='PA_TASKS'
19891: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
19892: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19893: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19887: ,p_project_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19888: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19889: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19890: ,p_object_type IN VARCHAR2 :='PA_TASKS'
19891: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
19892: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19893: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19894: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19895: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19888: ,p_object_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19889: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19890: ,p_object_type IN VARCHAR2 :='PA_TASKS'
19891: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
19892: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19893: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19894: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19895: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19896: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19889: ,p_object_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19890: ,p_object_type IN VARCHAR2 :='PA_TASKS'
19891: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
19892: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19893: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19894: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19895: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19896: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19897: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19890: ,p_object_type IN VARCHAR2 :='PA_TASKS'
19891: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
19892: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19893: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19894: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19895: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19896: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19897: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19898: ,p_structure_type IN VARCHAR2 :='FINANCIAL'
19891: ,p_as_of_date IN DATE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
19892: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19893: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19894: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19895: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19896: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19897: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19898: ,p_structure_type IN VARCHAR2 :='FINANCIAL'
19899: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19892: ,p_percent_complete IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19893: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19894: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19895: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19896: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19897: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19898: ,p_structure_type IN VARCHAR2 :='FINANCIAL'
19899: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19900: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19893: ,p_progress_status_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19894: ,p_progress_comment IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19895: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19896: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19897: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19898: ,p_structure_type IN VARCHAR2 :='FINANCIAL'
19899: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19900: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19901: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
19895: ,p_brief_overview IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19896: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19897: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19898: ,p_structure_type IN VARCHAR2 :='FINANCIAL'
19899: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19900: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19901: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
19902: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
19903: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
19896: ,p_record_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19897: ,p_pm_product_code IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19898: ,p_structure_type IN VARCHAR2 :='FINANCIAL'
19899: ,p_task_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19900: ,p_structure_version_id IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19901: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
19902: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
19903: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
19904: IS
20023:
20024: x_return_status := FND_API.G_RET_STS_SUCCESS;
20025:
20026:
20027: IF p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20028: THEN
20029: l_task_id := 0;
20030: ELSE
20031: -- Bug 3876091 : Added IF for STRUCTURES
20041: l_task_id := 0;
20042: END IF;
20043:
20044:
20045: IF p_object_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20046: THEN
20047: l_object_id := 0;
20048: ELSE
20049: l_object_id := nvl(p_object_id, 0);
20048: ELSE
20049: l_object_id := nvl(p_object_id, 0);
20050: END IF;
20051:
20052: IF p_object_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20053: THEN
20054: l_object_version_id := 0;
20055: ELSE
20056: l_object_version_id := nvl(p_object_version_id, 0);
20055: ELSE
20056: l_object_version_id := nvl(p_object_version_id, 0);
20057: END IF;
20058:
20059: IF p_brief_overview = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
20060: THEN
20061: l_brief_overview := null;
20062: ELSE
20063: l_brief_overview := p_brief_overview;
20062: ELSE
20063: l_brief_overview := p_brief_overview;
20064: END IF;
20065:
20066: IF p_progress_comment = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
20067: THEN
20068: l_progress_comment := null;
20069: ELSE
20070: l_progress_comment := p_progress_comment;
20069: ELSE
20070: l_progress_comment := p_progress_comment;
20071: END IF;
20072:
20073: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
20074: THEN
20075: l_pm_product_code := null;
20076: ELSE
20077: l_pm_product_code := p_pm_product_code;
20094: */
20095: l_published_structure := 'Y';
20096: l_structure_version_id := null;
20097: -- Bug 4938333 End
20098: IF p_percent_complete = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20099: THEN
20100: l_percent_complete := 0;
20101: ELSE
20102: l_percent_complete := nvl(p_percent_complete,0);
20142: END IF;
20143: ---- if status is CANCELLED
20144:
20145: ----- Invalid DATE
20146: IF p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR p_as_of_date IS NULL
20147: THEN
20148: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
20149: ,p_msg_name => 'PA_TP_INV_AOD'
20150: ,p_token1 => 'AS_OF_DATE'
20577:
20578: ELSIF l_db_action = 'UPDATE'
20579: THEN
20580:
20581: IF p_percent_complete_id IS NULL OR p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20582: THEN
20583: l_percent_complete_id := PA_PROGRESS_UTILS.get_ppc_id(
20584: p_project_id => p_project_id
20585: ,p_object_id => l_object_id
20826: end if;
20827:
20828: IF l_msg_count = 1 AND x_msg_data IS NULL
20829: THEN
20830: Pa_Interface_Utils_Pub.get_messages
20831: ( p_encoded => Fnd_Api.G_TRUE
20832: , p_msg_index => 1
20833: , p_msg_count => l_msg_count
20834: , p_msg_data => l_msg_data
20877: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
20878: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
20879: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
20880: ,p_debug_mode IN VARCHAR2 :='N'
20881: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20882: ,p_project_id IN NUMBER
20883: ,p_structure_version_id IN NUMBER
20884: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
20885: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
21100: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
21101: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
21102: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
21103: ,p_debug_mode IN VARCHAR2 :='N'
21104: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21105: ,p_person_id NUMBER
21106: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
21107: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
21108: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
21252: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
21253: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
21254: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
21255: ,p_debug_mode IN VARCHAR2 :='N'
21256: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21257: ,p_project_id IN NUMBER
21258: ,p_task_id IN NUMBER
21259: ,p_task_version_id IN NUMBER
21260: ,p_as_of_date IN DATE
21402: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
21403: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
21404: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
21405: ,p_debug_mode IN VARCHAR2 :='N'
21406: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21407: ,p_project_id IN NUMBER
21408: ,p_src_str_ver_id IN NUMBER
21409: ,p_dst_str_ver_id IN NUMBER
21410: ,p_pub_wp_with_prog_flag IN VARCHAR2 := 'Y'
22561: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
22562: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
22563: ,p_calling_mode IN VARCHAR2 := null
22564: ,p_debug_mode IN VARCHAR2 :='N'
22565: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22566: ,p_action IN VARCHAR2 :='SAVE'
22567: ,p_rollup_entire_wbs_flag IN VARCHAR2 :='N'
22568: ,p_progress_mode IN VARCHAR2 :='FUTURE'
22569: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
22565: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22566: ,p_action IN VARCHAR2 :='SAVE'
22567: ,p_rollup_entire_wbs_flag IN VARCHAR2 :='N'
22568: ,p_progress_mode IN VARCHAR2 :='FUTURE'
22569: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
22570: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
22571: ,p_project_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22572: ,p_object_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
22573: ,p_object_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
23844: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
23845: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
23846: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
23847: ,p_debug_mode IN VARCHAR2 :='N'
23848: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
23849: ,p_project_id IN NUMBER
23850: ,p_working_str_version_id IN NUMBER
23851: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23852: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895