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_UTILS dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 2601: l_latest_pub_structure_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id); --maansari7/22

2597: CLOSE l_get_latest_pub_structure_ver;
2598: */
2599:
2600: --Added the following line instead of the above cursor.
2601: l_latest_pub_structure_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id); --maansari7/22
2602:
2603: OPEN l_get_element_version_id(p_task_id, l_latest_pub_structure_ver_id);
2604: FETCH l_get_element_version_id INTO l_element_version_id;
2605: CLOSE l_get_element_version_id;

Line 5551: l_program_flag := PA_PROJECT_STRUCTURE_UTILS.check_program_flag_enable(p_project_id);

5547: FROM pa_proj_elem_ver_structure ppevs
5548: WHERE ppevs.project_id = p_project_id
5549: AND ppevs.element_version_id = p_structure_version_id;
5550:
5551: l_program_flag := PA_PROJECT_STRUCTURE_UTILS.check_program_flag_enable(p_project_id);
5552:
5553: IF l_date_prog_applied_on_wver IS NOT NULL THEN
5554:
5555: If nvl(l_program_flag,'N') = 'Y' then

Line 7268: l_wp_task_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id);

7264: close c1;
7265:
7266: ELSE --get the project level data if financial task id is null bug 3753042
7267:
7268: l_wp_task_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id);
7269:
7270: open c3(p_project_id,l_wp_task_ver_id);
7271: fetch c3 into x_planned_work_qty;
7272: close c3;

Line 7286: l_wp_str_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id);

7282: End commenting the following code as we are now accepting workplan task id's in the API. */
7283:
7284:
7285: l_wp_task_id := p_wp_task_id;
7286: l_wp_str_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id);
7287:
7288: -- If task level information is requested.
7289:
7290: if (p_res_list_mem_id is null) then

Line 7433: l_fin_str_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_project_id);

7429: close c3;
7430:
7431: -- Get financial structure version id.
7432:
7433: l_fin_str_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_project_id);
7434:
7435: -- Get financial task version id.
7436:
7437: open c1(p_fin_task_id,l_fin_str_ver_id);

Line 13026: l_work_struc_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_project_id);

13022:
13023: l_prv_bcws_project_id := p_project_id;
13024: l_prv_bcws_struc_ver_id := p_structure_version_id;
13025:
13026: l_work_struc_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_project_id);
13027:
13028: -- To decide the structure_version_id passed is latest published or current working or published version
13029: IF PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_project_id) = p_structure_version_id THEN
13030: l_flag := 'W';

Line 13029: IF PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_project_id) = p_structure_version_id THEN

13025:
13026: l_work_struc_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_project_id);
13027:
13028: -- To decide the structure_version_id passed is latest published or current working or published version
13029: IF PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_project_id) = p_structure_version_id THEN
13030: l_flag := 'W';
13031: ELSIF PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id) = p_structure_version_id THEN
13032: l_flag := 'L';
13033: ELSE

Line 13031: ELSIF PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id) = p_structure_version_id THEN

13027:
13028: -- To decide the structure_version_id passed is latest published or current working or published version
13029: IF PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_project_id) = p_structure_version_id THEN
13030: l_flag := 'W';
13031: ELSIF PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id) = p_structure_version_id THEN
13032: l_flag := 'L';
13033: ELSE
13034: -- Doing this handling for split structures where it is possible to have multiple working versions.
13035: OPEN c1(p_structure_version_id);

Line 13085: l_baseline_struc_id := PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(p_project_id);

13081: AND pia.pa_period_type=ftcn.period_type;
13082: END IF;
13083:
13084: -- Retriving baseline structure id to retrive planned values information from baselined structure.
13085: l_baseline_struc_id := PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(p_project_id);
13086:
13087: IF l_baseline_struc_id = -1 THEN
13088: l_baseline_struc_id := p_structure_version_id;
13089: END IF;

Line 13100: IF (PA_PROJECT_STRUCTURE_UTILS.CHECK_STRUC_VER_PUBLISHED(p_project_id, p_structure_version_id) = 'Y') AND

13096: l_parent_task_id := NULL;
13097:
13098: -- Bug 7259306
13099: -- In the absence of progress, the planned value is calculated based on the as of date displayed in the progress report tab.
13100: IF (PA_PROJECT_STRUCTURE_UTILS.CHECK_STRUC_VER_PUBLISHED(p_project_id, p_structure_version_id) = 'Y') AND
13101: (PA_PROGRESS_UTILS.PROJ_TASK_PROG_EXISTS(p_project_id, cur_parent_tasks_info_rec.proj_element_id) = 'N') THEN
13102: l_as_of_date_ovr := get_def_as_of_date_prog_report(p_project_id, cur_parent_tasks_info_rec.proj_element_id);
13103: END IF;
13104: