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_ELEMENTS

Line 394: FROM pa_proj_elements

390: --Added for performance improvements bug 2679612
391: CURSOR cur_proj_elem
392: IS
393: SELECT project_id
394: FROM pa_proj_elements
395: WHERE proj_element_id = p_task_id;
396: l_project_id NUMBER;
397: --Added for performance improvements bug 2679612
398:

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 919: FROM pa_proj_elements ppe,

915: --Bug fix 2679612
916: CURSOR cur_pa_task_prg1
917: IS
918: SELECT WQ_PLANNED_QUANTITY
919: FROM pa_proj_elements ppe,
920: pa_proj_element_versions ppev,
921: pa_proj_elem_ver_schedule ppevsh
922: WHERE ppe.project_id = ppev.project_id
923: AND ppe.proj_element_id = p_task_id

Line 927: AND ppev.parent_structure_version_id = PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(ppe.project_id, 'WORKPLAN');

923: AND ppe.proj_element_id = p_task_id
924: AND ppev.proj_element_id = ppe.proj_element_id
925: AND ppev.element_version_id = ppevsh.element_version_id
926: AND ppev.project_id = ppevsh.project_id
927: AND ppev.parent_structure_version_id = PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(ppe.project_id, 'WORKPLAN');
928:
929: CURSOR cur_pa_task_prg2
930: IS
931: SELECT nvl(ppe.WQ_ACTUAL_ENTRY_CODE,ptt.ACTUAL_WQ_ENTRY_CODE)

Line 932: FROM pa_proj_elements ppe, pa_task_types ptt

928:
929: CURSOR cur_pa_task_prg2
930: IS
931: SELECT nvl(ppe.WQ_ACTUAL_ENTRY_CODE,ptt.ACTUAL_WQ_ENTRY_CODE)
932: FROM pa_proj_elements ppe, pa_task_types ptt
933: WHERE ppe.type_id = ptt.task_type_id(+)
934: AND ptt.object_type = 'PA_TASKS' /* bug 3279978 FP M Enhancement */
935: AND ppe.proj_element_id = p_task_id ;
936:

Line 1008: FROM pa_proj_elements

1004: --Added for performance improvements bug 2679612
1005: CURSOR cur_proj_elem
1006: IS
1007: SELECT project_id
1008: FROM pa_proj_elements
1009: WHERE proj_element_id = p_task_id;
1010: l_project_id NUMBER;
1011: --Added for performance improvements bug 2679612
1012:

Line 1651: FROM pa_proj_elements

1647: --Added for performance improvements bug 2679612
1648: CURSOR cur_proj_elem
1649: IS
1650: SELECT project_id
1651: FROM pa_proj_elements
1652: WHERE proj_element_id = p_task_id;
1653: l_project_id NUMBER;
1654: --Added for performance improvements bug 2679612
1655:

Line 1761: UPDATE pa_proj_elements

1757: THEN
1758: IF p_object_type = 'PA_TASKS'
1759: THEN
1760: l_proj_element_id := p_object_id;
1761: UPDATE pa_proj_elements
1762: SET progress_outdated_flag = 'N'
1763: WHERE proj_element_id = l_proj_element_id;
1764: ELSIF p_object_type = 'PA_STRUCTURES'
1765: THEN

Line 1766: UPDATE pa_proj_elements ppe

1762: SET progress_outdated_flag = 'N'
1763: WHERE proj_element_id = l_proj_element_id;
1764: ELSIF p_object_type = 'PA_STRUCTURES'
1765: THEN
1766: UPDATE pa_proj_elements ppe
1767: SET progress_outdated_flag = 'N'
1768: WHERE proj_element_id = ( SELECT proj_element_id
1769: FROM pa_proj_structure_types ppst
1770: WHERE ppst.structure_type_id = 1 --WORKPLAN

Line 1776: UPDATE pa_proj_elements

1772: AND project_id = p_project_id;
1773: END IF;
1774: ELSIF p_structure_version_id IS NOT NULL
1775: THEN
1776: UPDATE pa_proj_elements
1777: SET progress_outdated_flag = 'N'
1778: WHERE proj_element_id in ( SELECT proj_element_id
1779: FROM pa_proj_element_versions
1780: WHERE project_id = p_project_id

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 2118: select 'X' from pa_proj_elements

2114: AND rownum <= 1;
2115:
2116: Cursor c_proj_elements
2117: is
2118: select 'X' from pa_proj_elements
2119: where status_code = p_status_code
2120: AND rownum <= 1;
2121:
2122: Cursor c_proj_elem_ver_structure

Line 2156: -- Check referense in pa_proj_elements

2152: l_return_value := TRUE;
2153: end if;
2154: close c_prog_rollup;
2155: end if;
2156: -- Check referense in pa_proj_elements
2157: if(NOT l_return_value) then
2158: open c_proj_elements;
2159: fetch c_proj_elements into l_dummy;
2160: if(c_proj_elements%FOUND) then

Line 2198: FROM pa_proj_elements

2194: --Added for performance improvements bug 2679612
2195: CURSOR cur_proj_elem
2196: IS
2197: SELECT project_id
2198: FROM pa_proj_elements
2199: WHERE proj_element_id = p_task_id;
2200: l_project_id NUMBER;
2201: --Added for performance improvements bug 2679612
2202:

Line 2236: pa_proj_elements ppe,

2232: IS
2233: SELECT ppe.status_code
2234: FROM pa_object_relationships por,
2235: pa_proj_element_versions ppev,
2236: pa_proj_elements ppe,
2237: pa_project_statuses pps
2238: WHERE object_id_to1 = p_object_version_id
2239: AND ppev.element_version_id = por.object_id_from1
2240: AND ppev.proj_element_id = ppe.proj_element_id

Line 2269: FROM pa_proj_elements

2265:
2266: CURSOR cur_pa_proj_elems
2267: IS
2268: SELECT status_code
2269: FROM pa_proj_elements
2270: WHERE proj_element_id = p_object_id
2271: AND project_id = p_project_id
2272: AND object_type = p_object_type;
2273:

Line 2364: if (((p_object_type = 'PA_TASKS') AND (nvl(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_object_version_id ),'N') = 'N')) OR p_structure_version_id is not null) then

2360: l_rollup_date date;
2361: begin
2362:
2363: /* -- FPM Dev CR 4 : Added condition for PA_TASKS and structure_version_id
2364: if (((p_object_type = 'PA_TASKS') AND (nvl(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_object_version_id ),'N') = 'N')) OR p_structure_version_id is not null) then
2365:
2366: select max(as_of_date)
2367: into l_rollup_date
2368: from pa_progress_rollup

Line 2532: FROM pa_proj_elements PPE,

2528:
2529: CURSOR l_get_task_manager(c_element_version_id NUMBER)
2530: IS
2531: SELECT ppe.manager_person_id
2532: FROM pa_proj_elements PPE,
2533: pa_proj_element_versions PPEV
2534: WHERE ppev.element_version_id = c_element_version_id
2535: AND ppev.proj_element_id = ppe.proj_element_id;
2536:

Line 2650: from pa_proj_elements

2646: elsif (p_object_type = 'PA_TASKS') then
2647:
2648: select status_code
2649: into l_status_code
2650: from pa_proj_elements
2651: where project_id = p_project_id
2652: and proj_element_id = p_proj_element_id
2653: and object_type = p_object_type;
2654:

Line 2666: from pa_proj_elements ppe, pa_task_types ptt

2662: else
2663:
2664: select ptt.prog_entry_enable_flag
2665: into l_return_value
2666: from pa_proj_elements ppe, pa_task_types ptt
2667: where ppe.type_id = ptt.task_type_id(+)
2668: and ppe.project_id = p_project_id
2669: and ppe.proj_element_id = p_proj_element_id;
2670: end if;

Line 2785: FROM pa_proj_elements ppe,

2781: l_return_value VARCHAR2(1) := 'Y';
2782: l_dummy VARCHAR2(1);
2783: CURSOR c_get_del_associated_task IS
2784: SELECT 'x'
2785: FROM pa_proj_elements ppe,
2786: pa_object_relationships por,
2787: pa_task_types ttype
2788: WHERE
2789: ppe.object_type = 'PA_TASKS'

Line 3613: l_structure_version_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id, 'WORKPLAN');

3609: l_time_phase_code VARCHAR2(30);
3610: l_structure_version_id NUMBER;
3611: BEGIN
3612: if p_structure_version_id is null then
3613: l_structure_version_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id, 'WORKPLAN');
3614: else
3615: l_structure_version_id := p_structure_version_id;
3616: end if;
3617: BEGIN

Line 6229: from pa_proj_elements

6225: -- Cursor to get baselined dates.
6226:
6227: cursor cur_baselined_dates is
6228: select baseline_start_date, baseline_finish_date
6229: from pa_proj_elements
6230: where project_id = p_project_id
6231: and proj_element_id = p_proj_element_id;
6232:
6233: l_base_start_date DATE := NULL;

Line 6571: from pa_proj_elements ppe

6567: -- Begin: Fix for Bug # 3926529.
6568:
6569: cursor cur_baselined_dates is
6570: select ppe.baseline_start_date, ppe.baseline_finish_date
6571: from pa_proj_elements ppe
6572: where ppe.project_id = p_project_id
6573: and ppe.proj_element_id = p_proj_element_id;
6574:
6575: cursor cur_scheduled_dates is

Line 7146: from pa_proj_elements

7142: c1rec c1_task%rowtype;
7143:
7144: cursor c4(p_project_id number, p_proj_element_id number) is
7145: select wq_uom_code
7146: from pa_proj_elements
7147: where project_id = p_project_id
7148: and proj_element_id = p_proj_element_id;
7149:
7150: cursor c2(p_element_version_id NUMBER) is

Line 9550: p_dlv_proj_elt_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

9546:
9547: function published_dlv_prog_exists
9548: (
9549: p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
9550: p_dlv_proj_elt_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
9551: )return VARCHAR2
9552: IS
9553: l_result VARCHAR2(1) ;
9554:

Line 10016: l_lp_str_ver_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id,'WORKPLAN');

10012: if l_return_date is NULL then
10013:
10014: -- Get latest published structure version id.
10015:
10016: l_lp_str_ver_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id,'WORKPLAN');
10017:
10018: if p_start_end_flag = 'S' then
10019:
10020: open cur_lp_sch_start_date(l_lp_str_ver_id);

Line 10071: pa_proj_elements pe,

10067: bl.txn_currency_code,
10068: pr.txn_currency_code
10069: FROM
10070: pa_proj_element_versions pev,
10071: pa_proj_elements pe,
10072: pa_resource_assignments ra,
10073: pa_resource_list_members rlm,
10074: pa_budget_lines bl,
10075: pa_progress_rollup pr

Line 11787: FROM pa_proj_elements elem

11783: IS
11784: SELECT decode(elem.base_percent_comp_deriv_code, null
11785: , ttype.base_percent_comp_deriv_code,'^'
11786: ,ttype.base_percent_comp_deriv_code,elem.base_percent_comp_deriv_code)
11787: FROM pa_proj_elements elem
11788: , pa_task_types ttype
11789: where elem.proj_element_id = c_task_id
11790: AND elem.project_id = c_project_id
11791: AND elem.object_type =c_object_type

Line 12890: pa_proj_elements ppe,

12886: nvl(ppe.baseline_finish_date,ppevs.scheduled_finish_date) sch_end_date
12887: from pa_proj_element_versions ppev1,
12888: pa_proj_element_versions ppev2,
12889: pa_object_relationships por,
12890: pa_proj_elements ppe,
12891: pa_proj_elem_ver_schedule ppevs
12892: where ppev1.parent_structure_version_id = p_structure_version_id
12893: and ppev1.proj_element_id=ppe.proj_element_id
12894: and nvl(ppe.link_task_flag,'N') = 'N'

Line 13208: pa_proj_elements ppe

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
13212: AND ppe.proj_element_id = p_proj_element_id