[Home] [Help]
1489:
1490: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
1491: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --bug 3830434
1492: -- 4746476 : added org_id in below select
1493: SELECT project_currency_code, org_id INTO l_prj_currency_code, l_org_id FROM pa_projects_all WHERE project_id = p_project_id;
1494:
1495: IF l_sharing_Enabled = 'N' AND p_structure_type = 'WORKPLAN' THEN
1496: l_split_workplan := 'Y';
1497: ELSE
3566: AND element_version_id = l_rollup_table1(i).object_id;
3567:
3568:
3569: IF l_rollup_table1(i).object_type = 'PA_STRUCTURES' THEN
3570: UPDATE pa_projects_all
3571: SET actual_start_date = l_rollup_table1(i).start_date1,
3572: actual_finish_date = l_rollup_table1(i).finish_date1
3573: WHERE project_id = p_project_id;
3574: END IF;
6666: l_prog_pa_period_name VARCHAR2(30) ;
6667: l_prog_gl_period_name VARCHAR2(30) ;
6668: l_current_flag VARCHAR2(1):= 'W' ;
6669: l_max_rollup_as_of_date2 DATE ;
6670: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE ;
6671: l_OTH_ACT_RAWCOST_TO_DATE_PC NUMBER ;
6672: l_PPL_ACT_RAWCOST_TO_DATE_PC NUMBER ;
6673: l_EQPMT_ACT_RAWCOST_TO_DATE_PC NUMBER ;
6674: l_OTH_ACT_RAWCOST_TO_DATE_FC NUMBER ;
6955: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
6956: l_structure_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id);
6957:
6958: --bug 3949093
6959: SELECT project_currency_code INTO l_prj_currency_code FROM pa_projects_all WHERE project_id = p_project_id;
6960:
6961: IF (l_sharing_Enabled = 'N' OR (l_sharing_Enabled = 'Y' AND l_structure_sharing_code <> 'SHARE_FULL')) THEN
6962: l_split_workplan := 'Y';
6963: ELSE
9720: ==============================================================================*/
9721:
9722: PROCEDURE copy_actuals_for_workplan(
9723: p_calling_context IN VARCHAR2 DEFAULT 'WP_PROGRESS'
9724: ,p_project_id IN pa_projects_all.project_id%TYPE
9725: ,p_source_struct_ver_id IN pa_proj_element_versions.element_version_id%TYPE
9726: ,p_target_struct_ver_id IN pa_proj_element_versions.element_version_id%TYPE
9727: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
9728: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
11795:
11796: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
11797: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --bug 3830434
11798: -- 4746476 : added org_id in below select
11799: SELECT project_currency_code, org_id INTO l_prj_currency_code, l_org_id FROM pa_projects_all WHERE project_id = p_project_id;
11800:
11801: IF l_sharing_Enabled = 'N' AND p_structure_type = 'WORKPLAN' THEN
11802: l_split_workplan := 'Y';
11803: ELSE
13644: AND element_version_id = l_rollup_table1(i).object_id;
13645:
13646:
13647: IF l_rollup_table1(i).object_type = 'PA_STRUCTURES' THEN
13648: UPDATE pa_projects_all
13649: SET actual_start_date = l_rollup_table1(i).start_date1,
13650: actual_finish_date = l_rollup_table1(i).finish_date1
13651: WHERE project_id = p_project_id;
13652: END IF;
15366: */
15367: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
15368: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --bug 3830434
15369: -- 4746476 : added org_id in below select
15370: SELECT project_currency_code, org_id INTO l_prj_currency_code, l_org_id FROM pa_projects_all WHERE project_id = p_project_id;
15371:
15372: IF l_sharing_Enabled = 'N' AND p_structure_type = 'WORKPLAN' THEN
15373: l_split_workplan := 'Y';
15374: ELSE
17265: AND element_version_id = l_rollup_table1(i).object_id;
17266:
17267:
17268: IF l_rollup_table1(i).object_type = 'PA_STRUCTURES' THEN
17269: UPDATE pa_projects_all
17270: SET actual_start_date = l_rollup_table1(i).start_date1,
17271: actual_finish_date = l_rollup_table1(i).finish_date1
17272: WHERE project_id = p_project_id;
17273: END IF;