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_PROJ_PROGRESS_ATTR

Line 844: from pa_project_statuses po, pa_proj_progress_attr ppp, pa_proj_elements ppe -- Bug 4535784 Changed from pa_resource_types to pa_project_statuses

840: IS
841: SELECT trunc(p_as_of_date) FROM DUAL
842: MINUS
843: SELECT PA_PROGRESS_UTILS.AS_OF_DATE(ppe.project_id, ppe.proj_element_id, ppp.progress_cycle_id, ppe.object_type, 'WORKPLAN', p_proj_element_id/* Amit : Modified for IB4 Progress CR. */) as_of_date
844: from pa_project_statuses po, pa_proj_progress_attr ppp, pa_proj_elements ppe -- Bug 4535784 Changed from pa_resource_types to pa_project_statuses
845: where ppe.project_id = ppp.project_id(+)
846: AND ppp.structure_type (+) = 'WORKPLAN'
847: and ppe.project_id= p_project_id
848: and ppe.proj_element_id = p_object_id

Line 862: from pa_resource_types po, pa_proj_progress_attr ppp, PA_TASK_ASSIGNMENTS_V ppe

858: IS
859: SELECT trunc(p_as_of_date) FROM DUAL
860: MINUS
861: SELECT PA_PROGRESS_UTILS.AS_OF_DATE(ppe.project_id, ppe.resource_list_member_id, ppp.progress_cycle_id, 'PA_ASSIGNMENTS', 'WORKPLAN', p_proj_element_id/* Amit : Modified for IB4 Progress CR. */) as_of_date
862: from pa_resource_types po, pa_proj_progress_attr ppp, PA_TASK_ASSIGNMENTS_V ppe
863: where ppe.project_id = ppp.project_id(+)
864: AND ppp.structure_type (+) = 'WORKPLAN'
865: and ppe.project_id= p_project_id
866: and ppe.resource_list_member_id = p_object_id /* Modified for IB4 Progress CR. */

Line 1135: FROM pa_proj_progress_attr

1131:
1132: CURSOR cur_pa_proj_prg_attr
1133: IS
1134: SELECT progress_cycle_id
1135: FROM pa_proj_progress_attr
1136: WHERE project_id = p_project_id
1137: AND structure_type = p_structure_type;
1138:
1139: CURSOR cur_pa_proj

Line 1368: FROM pa_proj_progress_attr

1364:
1365: CURSOR cur_pa_proj_prg_attr
1366: IS
1367: SELECT progress_cycle_id
1368: FROM pa_proj_progress_attr
1369: WHERE project_id = p_project_id
1370: AND structure_type = p_structure_type;
1371:
1372: l_proj_finish_date DATE;

Line 1845: FROM pa_proj_progress_attr

1841: PERCENT_COMP_ENABLE_FLAG,
1842: task_weight_basis_code,
1843: ALLOW_COLLAB_PROG_ENTRY,
1844: ALLOW_PHY_PRCNT_CMP_OVERRIDES
1845: FROM pa_proj_progress_attr
1846: WHERE project_id = p_project_id
1847: AND structure_type = p_structure_type;
1848:
1849: BEGIN

Line 1928: FROM pa_proj_elements ppe, pa_task_types ptt, pa_proj_progress_attr pppa, pa_proj_elem_ver_structure ppvs, pa_proj_structure_types ppst

1924: decode(ppe.object_type,'PA_TASKS',ptt.PROG_ENTRY_ENABLE_FLAG,'Y'),
1925: pppa.ALLOW_COLLAB_PROG_ENTRY,
1926: pppa.ALLOW_PHY_PRCNT_CMP_OVERRIDES,
1927: pppa.TASK_WEIGHT_BASIS_CODE
1928: FROM pa_proj_elements ppe, pa_task_types ptt, pa_proj_progress_attr pppa, pa_proj_elem_ver_structure ppvs, pa_proj_structure_types ppst
1929: WHERE ppe.project_id = p_project_id
1930: AND ppe.proj_element_id = p_object_id
1931: AND ppe.object_type = p_object_type
1932: AND ppe.type_id = ptt.task_type_id(+)

Line 2335: from pa_proj_progress_attr

2331: varchar2
2332: IS
2333: cursor prog_cycle is
2334: select 'N'
2335: from pa_proj_progress_attr
2336: where progress_cycle_id = p_progress_cycle_id
2337: and structure_type = 'WORKPLAN';-- FPM Dev CR 3
2338:
2339: retval varchar2(1);

Line 2476: from pa_proj_progress_attr

2472: l_wq_enable_flag varchar2(1);
2473: begin
2474: select wq_enable_flag
2475: into l_wq_enable_flag
2476: from pa_proj_progress_attr
2477: where project_id = p_project_id
2478: and object_Type = 'PA_STRUCTURES'
2479: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
2480: ;

Line 2642: From pa_proj_progress_attr ppa,pa_proj_structure_types pst,pa_structure_types st

2638: -- This cursor obtains the task weight basis code for the project id.
2639: Cursor cur_weight_basis_code (c_project_id pa_projects_all.project_id%TYPE)
2640: Is
2641: Select ppa.task_weight_basis_code
2642: From pa_proj_progress_attr ppa,pa_proj_structure_types pst,pa_structure_types st
2643: Where ppa.project_id = c_project_id
2644: And ppa.object_type = 'PA_STRUCTURES'
2645: And ppa.structure_type = p_structure_type -- FPM Dev CR 3
2646: And ppa.object_id = pst.proj_element_id

Line 2650: l_weight_basis_code PA_PROJ_PROGRESS_ATTR.task_weight_basis_code%TYPE;

2646: And ppa.object_id = pst.proj_element_id
2647: And st.structure_type = 'WORKPLAN'
2648: And st.structure_type_id = pst.structure_type_id;
2649:
2650: l_weight_basis_code PA_PROJ_PROGRESS_ATTR.task_weight_basis_code%TYPE;
2651: BEGIN
2652: open cur_weight_basis_code(p_project_id);
2653: fetch cur_weight_basis_code into l_weight_basis_code;
2654: close cur_weight_basis_code;

Line 2723: from pa_proj_progress_attr

2719: l_allow_phy_prcnt_cmp_overrds VARCHAR2(1) := NULL;
2720:
2721: cursor c1(p_project_id NUMBER, p_structure_type VARCHAR2) is
2722: select percent_comp_enable_flag,allow_phy_prcnt_cmp_overrides
2723: from pa_proj_progress_attr
2724: where project_id = p_project_id
2725: and structure_type = p_structure_type;
2726:
2727: l_c1rec c1%rowtype;

Line 6285: From pa_proj_progress_attr

6281: x_return_status := FND_API.G_RET_STS_SUCCESS ;
6282:
6283: Select TASK_WEIGHT_BASIS_CODE
6284: INTO l_TASK_WEIGHT_BASIS_CODE
6285: From pa_proj_progress_attr
6286: Where Project_ID = p_project_id
6287: AND Structure_type = p_structure_type;
6288:
6289: If l_TASK_WEIGHT_BASIS_CODE = 'EFFORT' then

Line 6548: from pa_proj_progress_attr

6544: BEGIN
6545:
6546: select remain_effort_enable_flag
6547: into l_return_value
6548: from pa_proj_progress_attr
6549: where project_id = p_project_id
6550: and structure_type = p_structure_type;
6551:
6552: return(l_return_value);

Line 6578: from pa_proj_progress_attr pppa

6574: -- Progress Management Changes. Bug # 3420093.
6575:
6576: cursor c1 (p_project_id NUMBER, p_object_id NUMBER) is
6577: select pppa.task_weight_basis_code
6578: from pa_proj_progress_attr pppa
6579: where pppa.project_id = p_project_id
6580: and pppa.structure_type = p_structure_type;
6581:
6582: cursor c2 (p_project_id NUMBER, p_proj_element_id NUMBER, p_structure_version_id NUMBER) is

Line 10982: from pa_proj_progress_attr

10978: begin
10979: /*
10980: select next_progress_update_date
10981: into l_prog_act_summ_date
10982: from pa_proj_progress_attr
10983: where project_id = p_project_id
10984: and object_type = 'PA_STRUCTURES'
10985: and structure_type = 'WORKPLAN';
10986:

Line 11879: from pa_proj_progress_attr pppa

11875: , c_structure_type VARCHAR2
11876: , c_object_type VARCHAR2)
11877: IS
11878: SELECT task_weight_basis_code
11879: from pa_proj_progress_attr pppa
11880: where pppa.project_id = c_project_id
11881: AND pppa.object_id = c_task_id
11882: AND pppa.structure_type = c_structure_type
11883: and pppa.object_type = c_object_type;

Line 13304: pa_proj_progress_attr ppp,

13300: SELECT ppe.project_id project_id,
13301: PA_PROGRESS_UTILS.AS_OF_DATE(ppe.project_id, ppe.proj_element_id, ppp.progress_cycle_id, ppe.object_type) as_of_date ,
13302: ppe.object_type object_type
13303: FROM --pa_project_statuses po, --removed for bug 13687289
13304: pa_proj_progress_attr ppp,
13305: pa_proj_elements ppe
13306: WHERE ppe.project_id = ppp.project_id(+)
13307: AND ppp.structure_type (+) = 'WORKPLAN'
13308: AND ppe.project_id = p_project_id