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 2576: l_latest_pub_structure_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id); --maansari7/22

2572: CLOSE l_get_latest_pub_structure_ver;
2573: */
2574:
2575: --Added the following line instead of the above cursor.
2576: l_latest_pub_structure_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id); --maansari7/22
2577:
2578: OPEN l_get_element_version_id(p_task_id, l_latest_pub_structure_ver_id);
2579: FETCH l_get_element_version_id INTO l_element_version_id;
2580: CLOSE l_get_element_version_id;

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

5514: FROM pa_proj_elem_ver_structure ppevs
5515: WHERE ppevs.project_id = p_project_id
5516: AND ppevs.element_version_id = p_structure_version_id;
5517:
5518: l_program_flag := PA_PROJECT_STRUCTURE_UTILS.check_program_flag_enable(p_project_id);
5519:
5520: IF l_date_prog_applied_on_wver IS NOT NULL THEN
5521:
5522: If nvl(l_program_flag,'N') = 'Y' then

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

7224: close c1;
7225:
7226: ELSE --get the project level data if financial task id is null bug 3753042
7227:
7228: l_wp_task_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id);
7229:
7230: open c3(p_project_id,l_wp_task_ver_id);
7231: fetch c3 into x_planned_work_qty;
7232: close c3;

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

7242: End commenting the following code as we are now accepting workplan task id's in the API. */
7243:
7244:
7245: l_wp_task_id := p_wp_task_id;
7246: l_wp_str_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id);
7247:
7248: -- If task level information is requested.
7249:
7250: if (p_res_list_mem_id is null) then

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

7389: close c3;
7390:
7391: -- Get financial structure version id.
7392:
7393: l_fin_str_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_project_id);
7394:
7395: -- Get financial task version id.
7396:
7397: open c1(p_fin_task_id,l_fin_str_ver_id);

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

12925:
12926: l_prv_bcws_project_id := p_project_id;
12927: l_prv_bcws_struc_ver_id := p_structure_version_id;
12928:
12929: l_work_struc_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_project_id);
12930:
12931: -- To decide the structure_version_id passed is latest published or current working or published version
12932: IF PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_project_id) = p_structure_version_id THEN
12933: l_flag := 'W';

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

12928:
12929: l_work_struc_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_project_id);
12930:
12931: -- To decide the structure_version_id passed is latest published or current working or published version
12932: IF PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_project_id) = p_structure_version_id THEN
12933: l_flag := 'W';
12934: ELSIF PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id) = p_structure_version_id THEN
12935: l_flag := 'L';
12936: ELSE

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

12930:
12931: -- To decide the structure_version_id passed is latest published or current working or published version
12932: IF PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_project_id) = p_structure_version_id THEN
12933: l_flag := 'W';
12934: ELSIF PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id) = p_structure_version_id THEN
12935: l_flag := 'L';
12936: ELSE
12937: -- Doing this handling for split structures where it is possible to have multiple working versions.
12938: OPEN c1(p_structure_version_id);

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

12984: AND pia.pa_period_type=ftcn.period_type;
12985: END IF;
12986:
12987: -- Retriving baseline structure id to retrive planned values information from baselined structure.
12988: l_baseline_struc_id := PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(p_project_id);
12989:
12990: IF l_baseline_struc_id = -1 THEN
12991: l_baseline_struc_id := p_structure_version_id;
12992: END IF;

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

12999: l_parent_task_id := NULL;
13000:
13001: -- Bug 7259306
13002: -- In the absence of progress, the planned value is calculated based on the as of date displayed in the progress report tab.
13003: IF (PA_PROJECT_STRUCTURE_UTILS.CHECK_STRUC_VER_PUBLISHED(p_project_id, p_structure_version_id) = 'Y') AND
13004: (PA_PROGRESS_UTILS.PROJ_TASK_PROG_EXISTS(p_project_id, cur_parent_tasks_info_rec.proj_element_id) = 'N') THEN
13005: l_as_of_date_ovr := get_def_as_of_date_prog_report(p_project_id, cur_parent_tasks_info_rec.proj_element_id);
13006: END IF;
13007: