eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROGRESS_PVT dependencies on PA_PROJECTS_ALL

Line 1484: SELECT project_currency_code, org_id INTO l_prj_currency_code, l_org_id FROM pa_projects_all WHERE project_id = p_project_id;

1480:
1481: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
1482: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --bug 3830434
1483: -- 4746476 : added org_id in below select
1484: SELECT project_currency_code, org_id INTO l_prj_currency_code, l_org_id FROM pa_projects_all WHERE project_id = p_project_id;
1485:
1486: IF l_sharing_Enabled = 'N' AND p_structure_type = 'WORKPLAN' THEN
1487: l_split_workplan := 'Y';
1488: ELSE

Line 3527: UPDATE pa_projects_all

3523: AND element_version_id = l_rollup_table1(i).object_id;
3524:
3525:
3526: IF l_rollup_table1(i).object_type = 'PA_STRUCTURES' THEN
3527: UPDATE pa_projects_all
3528: SET actual_start_date = l_rollup_table1(i).start_date1,
3529: actual_finish_date = l_rollup_table1(i).finish_date1
3530: WHERE project_id = p_project_id;
3531: END IF;

Line 6604: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE ;

6600: l_prog_pa_period_name VARCHAR2(30) ;
6601: l_prog_gl_period_name VARCHAR2(30) ;
6602: l_current_flag VARCHAR2(1):= 'W' ;
6603: l_max_rollup_as_of_date2 DATE ;
6604: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE ;
6605: l_OTH_ACT_RAWCOST_TO_DATE_PC NUMBER ;
6606: l_PPL_ACT_RAWCOST_TO_DATE_PC NUMBER ;
6607: l_EQPMT_ACT_RAWCOST_TO_DATE_PC NUMBER ;
6608: l_OTH_ACT_RAWCOST_TO_DATE_FC NUMBER ;

Line 6893: SELECT project_currency_code INTO l_prj_currency_code FROM pa_projects_all WHERE project_id = p_project_id;

6889: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
6890: l_structure_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id);
6891:
6892: --bug 3949093
6893: SELECT project_currency_code INTO l_prj_currency_code FROM pa_projects_all WHERE project_id = p_project_id;
6894:
6895: IF (l_sharing_Enabled = 'N' OR (l_sharing_Enabled = 'Y' AND l_structure_sharing_code <> 'SHARE_FULL')) THEN
6896: l_split_workplan := 'Y';
6897: ELSE

Line 9658: ,p_project_id IN pa_projects_all.project_id%TYPE

9654: ==============================================================================*/
9655:
9656: PROCEDURE copy_actuals_for_workplan(
9657: p_calling_context IN VARCHAR2 DEFAULT 'WP_PROGRESS'
9658: ,p_project_id IN pa_projects_all.project_id%TYPE
9659: ,p_source_struct_ver_id IN pa_proj_element_versions.element_version_id%TYPE
9660: ,p_target_struct_ver_id IN pa_proj_element_versions.element_version_id%TYPE
9661: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
9662: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895