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 841: 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

837: IS
838: SELECT trunc(p_as_of_date) FROM DUAL
839: MINUS
840: 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
841: 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
842: where ppe.project_id = ppp.project_id(+)
843: AND ppp.structure_type (+) = 'WORKPLAN'
844: and ppe.project_id= p_project_id
845: and ppe.proj_element_id = p_object_id

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

855: IS
856: SELECT trunc(p_as_of_date) FROM DUAL
857: MINUS
858: 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
859: from pa_resource_types po, pa_proj_progress_attr ppp, PA_TASK_ASSIGNMENTS_V ppe
860: where ppe.project_id = ppp.project_id(+)
861: AND ppp.structure_type (+) = 'WORKPLAN'
862: and ppe.project_id= p_project_id
863: and ppe.resource_list_member_id = p_object_id /* Modified for IB4 Progress CR. */

Line 1129: FROM pa_proj_progress_attr

1125:
1126: CURSOR cur_pa_proj_prg_attr
1127: IS
1128: SELECT progress_cycle_id
1129: FROM pa_proj_progress_attr
1130: WHERE project_id = p_project_id
1131: AND structure_type = p_structure_type;
1132:
1133: CURSOR cur_pa_proj

Line 1359: FROM pa_proj_progress_attr

1355:
1356: CURSOR cur_pa_proj_prg_attr
1357: IS
1358: SELECT progress_cycle_id
1359: FROM pa_proj_progress_attr
1360: WHERE project_id = p_project_id
1361: AND structure_type = p_structure_type;
1362:
1363: l_proj_finish_date DATE;

Line 1823: FROM pa_proj_progress_attr

1819: PERCENT_COMP_ENABLE_FLAG,
1820: task_weight_basis_code,
1821: ALLOW_COLLAB_PROG_ENTRY,
1822: ALLOW_PHY_PRCNT_CMP_OVERRIDES
1823: FROM pa_proj_progress_attr
1824: WHERE project_id = p_project_id
1825: AND structure_type = p_structure_type;
1826:
1827: BEGIN

Line 1906: 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

1902: decode(ppe.object_type,'PA_TASKS',ptt.PROG_ENTRY_ENABLE_FLAG,'Y'),
1903: pppa.ALLOW_COLLAB_PROG_ENTRY,
1904: pppa.ALLOW_PHY_PRCNT_CMP_OVERRIDES,
1905: pppa.TASK_WEIGHT_BASIS_CODE
1906: 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
1907: WHERE ppe.project_id = p_project_id
1908: AND ppe.proj_element_id = p_object_id
1909: AND ppe.object_type = p_object_type
1910: AND ppe.type_id = ptt.task_type_id(+)

Line 2311: from pa_proj_progress_attr

2307: varchar2
2308: IS
2309: cursor prog_cycle is
2310: select 'N'
2311: from pa_proj_progress_attr
2312: where progress_cycle_id = p_progress_cycle_id
2313: and structure_type = 'WORKPLAN';-- FPM Dev CR 3
2314:
2315: retval varchar2(1);

Line 2451: from pa_proj_progress_attr

2447: l_wq_enable_flag varchar2(1);
2448: begin
2449: select wq_enable_flag
2450: into l_wq_enable_flag
2451: from pa_proj_progress_attr
2452: where project_id = p_project_id
2453: and object_Type = 'PA_STRUCTURES'
2454: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
2455: ;

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

2613: -- This cursor obtains the task weight basis code for the project id.
2614: Cursor cur_weight_basis_code (c_project_id pa_projects_all.project_id%TYPE)
2615: Is
2616: Select ppa.task_weight_basis_code
2617: From pa_proj_progress_attr ppa,pa_proj_structure_types pst,pa_structure_types st
2618: Where ppa.project_id = c_project_id
2619: And ppa.object_type = 'PA_STRUCTURES'
2620: And ppa.structure_type = p_structure_type -- FPM Dev CR 3
2621: And ppa.object_id = pst.proj_element_id

Line 2625: l_weight_basis_code PA_PROJ_PROGRESS_ATTR.task_weight_basis_code%TYPE;

2621: And ppa.object_id = pst.proj_element_id
2622: And st.structure_type = 'WORKPLAN'
2623: And st.structure_type_id = pst.structure_type_id;
2624:
2625: l_weight_basis_code PA_PROJ_PROGRESS_ATTR.task_weight_basis_code%TYPE;
2626: BEGIN
2627: open cur_weight_basis_code(p_project_id);
2628: fetch cur_weight_basis_code into l_weight_basis_code;
2629: close cur_weight_basis_code;

Line 2698: from pa_proj_progress_attr

2694: l_allow_phy_prcnt_cmp_overrds VARCHAR2(1) := NULL;
2695:
2696: cursor c1(p_project_id NUMBER, p_structure_type VARCHAR2) is
2697: select percent_comp_enable_flag,allow_phy_prcnt_cmp_overrides
2698: from pa_proj_progress_attr
2699: where project_id = p_project_id
2700: and structure_type = p_structure_type;
2701:
2702: l_c1rec c1%rowtype;

Line 6250: From pa_proj_progress_attr

6246: x_return_status := FND_API.G_RET_STS_SUCCESS ;
6247:
6248: Select TASK_WEIGHT_BASIS_CODE
6249: INTO l_TASK_WEIGHT_BASIS_CODE
6250: From pa_proj_progress_attr
6251: Where Project_ID = p_project_id
6252: AND Structure_type = p_structure_type;
6253:
6254: If l_TASK_WEIGHT_BASIS_CODE = 'EFFORT' then

Line 6508: from pa_proj_progress_attr

6504: BEGIN
6505:
6506: select remain_effort_enable_flag
6507: into l_return_value
6508: from pa_proj_progress_attr
6509: where project_id = p_project_id
6510: and structure_type = p_structure_type;
6511:
6512: return(l_return_value);

Line 6538: from pa_proj_progress_attr pppa

6534: -- Progress Management Changes. Bug # 3420093.
6535:
6536: cursor c1 (p_project_id NUMBER, p_object_id NUMBER) is
6537: select pppa.task_weight_basis_code
6538: from pa_proj_progress_attr pppa
6539: where pppa.project_id = p_project_id
6540: and pppa.structure_type = p_structure_type;
6541:
6542: cursor c2 (p_project_id NUMBER, p_proj_element_id NUMBER, p_structure_version_id NUMBER) is

Line 10907: from pa_proj_progress_attr

10903: begin
10904: /*
10905: select next_progress_update_date
10906: into l_prog_act_summ_date
10907: from pa_proj_progress_attr
10908: where project_id = p_project_id
10909: and object_type = 'PA_STRUCTURES'
10910: and structure_type = 'WORKPLAN';
10911:

Line 11799: from pa_proj_progress_attr pppa

11795: , c_structure_type VARCHAR2
11796: , c_object_type VARCHAR2)
11797: IS
11798: SELECT task_weight_basis_code
11799: from pa_proj_progress_attr pppa
11800: where pppa.project_id = c_project_id
11801: AND pppa.object_id = c_task_id
11802: AND pppa.structure_type = c_structure_type
11803: and pppa.object_type = c_object_type;

Line 13207: pa_proj_progress_attr ppp,

13203: SELECT ppe.project_id project_id,
13204: PA_PROGRESS_UTILS.AS_OF_DATE(ppe.project_id, ppe.proj_element_id, ppp.progress_cycle_id, ppe.object_type) as_of_date ,
13205: ppe.object_type object_type
13206: FROM pa_project_statuses po,
13207: pa_proj_progress_attr ppp,
13208: pa_proj_elements ppe
13209: WHERE ppe.project_id = ppp.project_id(+)
13210: AND ppp.structure_type (+) = 'WORKPLAN'
13211: AND ppe.project_id = p_project_id