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_STRUCT_TASK_ROLLUP_PUB dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 85: l_planned_effort PA_PROJ_ELEM_VER_SCHEDULE.PLANNED_EFFORT%TYPE;

81: --
82: l_structure_version_id NUMBER;
83: l_baseline_proj_id NUMBER;
84: l_versioning VARCHAR2(1);
85: l_planned_effort PA_PROJ_ELEM_VER_SCHEDULE.PLANNED_EFFORT%TYPE;
86: --
87: -- Dates changes
88: l_template_flag VARCHAR2(1);
89: l_record_version_number NUMBER;

Line 121: pa_proj_elem_ver_schedule pevs,

117: ppev.element_version_id lnk_task_ver_id,
118: ppev.project_id lnk_task_project_id
119: FROM pa_proj_element_versions ppev,
120: pa_proj_elements ppe,
121: pa_proj_elem_ver_schedule pevs,
122: --bug 4541039
123: pa_object_relationships por,
124: pa_proj_elem_ver_structure pevst
125: --bug 4541039

Line 172: pa_proj_elem_ver_schedule b

168: cp_lnk_proj_id_to NUMBER) IS
169: SELECT min(scheduled_start_date) lnk_task_sch_start_Dt
170: FROM (SELECT min(b.scheduled_start_date) scheduled_start_date --bug 3967855
171: FROM pa_proj_element_versions a,
172: pa_proj_elem_ver_schedule b
173: WHERE a.project_id = b.project_id
174: AND a.element_version_id = b.element_version_id
175: AND b.project_id = cp_lnk_proj_id_from --Bug 3634389 Added for performance
176: AND b.element_version_id IN (SELECT object_id_from1

Line 187: pa_proj_elem_ver_schedule d

183: -- AND object_type_from = 'PA_STRUCTURES') --Bug 3634389
184: UNION ALL
185: SELECT min(d.scheduled_start_date) scheduled_start_date --bug 3967855
186: FROM pa_proj_element_versions c,
187: pa_proj_elem_ver_schedule d
188: ,pa_proj_elem_ver_structure e --bug 4541039
189: WHERE c.project_id = d.project_id
190: AND d.project_id =e.project_id --Bug#6277752 Added for performance
191: AND d.element_version_id = e.element_version_id --Bug#6277752 Added for performance

Line 215: pa_proj_elem_ver_schedule b

211: cp_lnk_proj_id_to NUMBER) IS
212: SELECT max(scheduled_finish_date) lnk_task_sch_finish_Dt
213: FROM (SELECT max(b.scheduled_finish_date) scheduled_finish_date --bug 3967855
214: FROM pa_proj_element_versions a,
215: pa_proj_elem_ver_schedule b
216: WHERE a.project_id = b.project_id
217: AND a.element_version_id = b.element_version_id
218: AND b.project_id = cp_lnk_proj_id_from --Bug 3634389 Added for performance
219: AND b.element_version_id IN (SELECT object_id_from1

Line 230: pa_proj_elem_ver_schedule d

226: -- AND object_type_from = 'PA_STRUCTURES') --Bug 3634389
227: UNION ALL
228: SELECT max(d.scheduled_finish_date) scheduled_finish_date --bug 3967855
229: FROM pa_proj_element_versions c,
230: pa_proj_elem_ver_schedule d
231: ,pa_proj_elem_ver_structure e --bug 4541039
232: WHERE c.project_id = d.project_id
233: AND d.project_id =e.project_id --Bug#6277752 Added for performance
234: AND d.element_version_id = e.element_version_id --Bug#6277752 Added for performance

Line 255: from pa_proj_elem_ver_schedule a

251:
252: --bug 4238036
253: Cursor get_sch_dates(c_element_version_id NUMBER) IS
254: SELECT a.scheduled_start_date, a.scheduled_finish_date
255: from pa_proj_elem_ver_schedule a
256: where a.element_version_id = c_element_version_id;
257: l_parent_start_date DATE;
258: l_parent_finish_date DATE;
259: --bug 4238036

Line 269: from pa_proj_elem_ver_schedule

265: --bug 4416432 issue # 5 and 6
266: CURSOR get_scheduled_dates(c_project_Id NUMBER, c_element_version_id NUMBER)
267: IS
268: select scheduled_start_date, scheduled_finish_date
269: from pa_proj_elem_ver_schedule
270: where project_id = c_project_id
271: and element_version_id = c_element_version_id;
272: l_get_sch_dates_cur get_scheduled_dates%ROWTYPE;
273:

Line 415: UPDATE pa_proj_elem_ver_schedule

411: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Sch start date='||l_parent_start_date, 3);
412: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Sch finish date='||l_parent_finish_date, 3);
413: END IF;
414:
415: UPDATE pa_proj_elem_ver_schedule
416: SET scheduled_start_date = l_parent_start_date
417: ,scheduled_finish_date = l_parent_finish_date
418: ,record_version_number = NVL( record_version_number, 0 ) + 1
419: WHERE element_version_id = get_lnk_task_rec.lnk_task_ver_id

Line 499: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||

495: ' a.object_type, b.PLANNED_EFFORT, '||
496: ' NVL(a.wbs_level,0), b.scheduled_start_date+NVL(b.scheduled_start_date_rollup,0), '||
497: ' b.scheduled_finish_date+NVL(b.scheduled_finish_date_rollup,0), c.object_id_from1, '||
498: ' c.object_type_from FROM '||
499: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
500: ' pa_object_relationships c, pa_proj_elements d WHERE '||
501: ' a.element_version_id = c.object_id_to1(+) AND '||
502: ' c.relationship_type(+)= '||''''||'S'||''''||' AND '||
503: ' a.project_id = b.project_id AND '||

Line 523: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||

519: ' a.object_type, b.PLANNED_EFFORT, '||
520: ' nvl(a.wbs_level,0), b.scheduled_start_date+NVL(b.scheduled_start_date_rollup,0), '||
521: ' b.scheduled_finish_date+NVL(b.scheduled_finish_date_rollup,0), c.object_id_from1, '||
522: ' c.object_type_from FROM '||
523: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
524: ' pa_object_relationships c, pa_proj_elements d WHERE '||
525: ' a.element_version_id = c.object_id_to1 AND '||
526: ' c.relationship_type = '||''''||'S'||''''||' AND '||
527: ' a.project_id = b.project_id AND '||

Line 658: FROM pa_proj_elem_ver_schedule

654: --
655: FOR i IN l_rollup_table.FIRST..l_rollup_table.LAST LOOP
656: SELECT scheduled_start_date, scheduled_finish_date
657: into l_old_sch_st_date_tbl(i), l_old_sch_fn_date_tbl(i)
658: FROM pa_proj_elem_ver_schedule
659: WHERE project_id = l_proj_id_tbl(i)
660: AND element_version_id = l_elem_ver_id_tbl(i);
661: END LOOP;
662: --

Line 664: UPDATE pa_proj_elem_ver_schedule

660: AND element_version_id = l_elem_ver_id_tbl(i);
661: END LOOP;
662: --
663: FORALL i IN l_rollup_table.FIRST..l_rollup_table.LAST
664: UPDATE pa_proj_elem_ver_schedule
665: SET scheduled_start_date = l_sch_start_date_tbl(i),
666: scheduled_finish_date = l_sch_finish_date_tbl(i),
667: planned_effort = l_effort_tbl(i),
668: duration = l_sch_finish_date_tbl(i) - l_sch_start_date_tbl(i) + 1,

Line 721: FROM pa_proj_elem_ver_schedule

717: END LOOP;
718: --
719: FOR i IN l_rollup_table.FIRST..l_rollup_table.LAST LOOP
720: SELECT scheduled_start_date into l_old_sch_st_date_tbl(i)
721: FROM pa_proj_elem_ver_schedule
722: WHERE project_id = l_proj_id_tbl(i)
723: AND element_version_id = l_elem_ver_id_tbl(i);
724: END LOOP;
725: --

Line 727: UPDATE pa_proj_elem_ver_schedule

723: AND element_version_id = l_elem_ver_id_tbl(i);
724: END LOOP;
725: --
726: FORALL i IN l_rollup_table.FIRST..l_rollup_table.LAST
727: UPDATE pa_proj_elem_ver_schedule
728: SET scheduled_start_date_rollup = l_sch_start_date_tbl(i) - scheduled_start_date,
729: scheduled_finish_date_rollup = l_sch_finish_date_tbl(i) - scheduled_finish_date,
730: last_update_date = sysdate,
731: last_updated_by = FND_GLOBAL.USER_ID,

Line 1162: l_planned_effort PA_PROJ_ELEM_VER_SCHEDULE.PLANNED_EFFORT%TYPE;

1158:
1159: l_structure_version_id NUMBER;
1160: l_baseline_proj_id NUMBER;
1161: l_versioning VARCHAR2(1);
1162: l_planned_effort PA_PROJ_ELEM_VER_SCHEDULE.PLANNED_EFFORT%TYPE;
1163:
1164: --bug 4290472, rtarway
1165: str_start_date DATE;
1166: str_end_date DATE;

Line 1203: FROM pa_proj_elem_ver_schedule

1199: -- hyau get calendar id to calculate duration
1200: cursor get_calendar_id_csr(c_project_id NUMBER, c_element_version_id NUMBER)
1201: IS
1202: SELECT calendar_id
1203: FROM pa_proj_elem_ver_schedule
1204: WHERE element_version_id = c_element_version_id
1205: AND project_id = c_project_id;
1206:
1207: -- hsiu added for bulk update

Line 1211: from pa_proj_elem_ver_schedule

1207: -- hsiu added for bulk update
1208: CURSOR get_scheduled_dates(c_project_Id NUMBER, c_element_version_id NUMBER)
1209: IS
1210: select scheduled_start_date, scheduled_finish_date
1211: from pa_proj_elem_ver_schedule
1212: where project_id = c_project_id
1213: and element_version_id = c_element_version_id;
1214: l_get_sch_dates_cur get_scheduled_dates%ROWTYPE;
1215:

Line 1373: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||

1369: ' a.object_type, b.PLANNED_EFFORT, '||
1370: ' nvl(a.wbs_level,0), b.scheduled_start_date, '||
1371: ' b.scheduled_finish_date, c.object_id_from1, '||
1372: ' c.object_type_from from '||
1373: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
1374: ' pa_object_relationships c, pa_proj_elements d where '||
1375: ' a.element_version_id = c.object_id_to1(+) and '||
1376: ' c.relationship_type(+)= '||''''||'S'||''''||' and '||
1377: ' a.project_id = b.project_id and '||

Line 1397: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||

1393: ' a.object_type, b.PLANNED_EFFORT, '||
1394: ' nvl(a.wbs_level,0), b.scheduled_start_date, '||
1395: ' b.scheduled_finish_date, c.object_id_from1, '||
1396: ' c.object_type_from from '||
1397: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
1398: ' pa_object_relationships c, pa_proj_elements d where '||
1399: ' a.element_version_id = c.object_id_to1 and '||
1400: ' c.relationship_type = '||''''||'S'||''''||' and '||
1401: ' a.project_id = b.project_id and '||

Line 1424: -- ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||

1420: -- ' a.object_type, b.PLANNED_EFFORT, '||
1421: -- ' nvl(a.wbs_level,0), b.scheduled_start_date, '||
1422: -- ' b.scheduled_finish_date, c.object_id_from1, '||
1423: -- ' c.object_type_from from '||
1424: -- ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
1425: -- ' pa_object_relationships c where '||
1426: -- ' a.element_version_id = c.object_id_to1(+) and '||
1427: -- ' c.relationship_type(+) = '||''''||'S'||''''||' and '||
1428: -- ' a.project_id = b.project_id and '||

Line 1537: l_update_stmt := 'Update pa_proj_elem_ver_schedule '||

1533: ELSE
1534: /* BEGIN
1535: --Update the tasks
1536: l_CursorId := DBMS_SQL.OPEN_CURSOR;
1537: l_update_stmt := 'Update pa_proj_elem_ver_schedule '||
1538: 'set SCHEDULED_START_DATE = :sd, '||
1539: 'SCHEDULED_FINISH_DATE = :fd, '||
1540: 'PLANNED_EFFORT = :pe, '||
1541: 'DURATION = :dur, '||

Line 1679: from pa_proj_elem_ver_schedule

1675: --bug 3305199 hsiu
1676: FOR i IN l_rollup_table.first..l_rollup_table.last LOOP
1677: select scheduled_start_date, scheduled_finish_date
1678: into l_old_sch_st_date_tbl(i), l_old_sch_fn_date_tbl(i)
1679: from pa_proj_elem_ver_schedule
1680: where project_id = l_proj_id_tbl(i)
1681: and element_version_id = l_elem_ver_id_tbl(i);
1682: END LOOP;
1683: --end 3305199 hsiu

Line 1693: UPDATE pa_proj_elem_ver_schedule

1689: l_sch_start_date_tbl(i),
1690: l_sch_finish_date_tbl(i)),
1691: */
1692: FORALL i IN l_rollup_table.first..l_rollup_table.last
1693: UPDATE pa_proj_elem_ver_schedule
1694: set scheduled_start_date = l_sch_start_date_tbl(i),
1695: scheduled_finish_date = l_sch_finish_date_tbl(i),
1696: planned_effort = l_effort_tbl(i),
1697: duration = l_sch_finish_date_tbl(i) - l_sch_start_date_tbl(i) + 1,

Line 1718: from pa_proj_elem_ver_schedule

1714:
1715: FOR i IN l_rollup_table.first..l_rollup_table.last LOOP
1716: select scheduled_start_date, scheduled_finish_date
1717: into l_old_sch_st_date_tbl(i), l_old_sch_fn_date_tbl(i)
1718: from pa_proj_elem_ver_schedule
1719: where project_id = l_proj_id_tbl(i)
1720: and element_version_id = l_elem_ver_id_tbl(i);
1721:
1722: ---- Start of addition for bug 6393979

Line 1742: UPDATE pa_proj_elem_ver_schedule

1738: OPEN c_get_project_dates(l_baseline_proj_id);
1739: FETCH c_get_project_dates INTO str_start_date, str_end_date;
1740: CLOSE c_get_project_dates;*/
1741:
1742: UPDATE pa_proj_elem_ver_schedule
1743: set scheduled_start_date =str_start_date,
1744: scheduled_finish_date = str_end_date,
1745: duration = str_end_date - str_start_date + 1,
1746: last_update_date = sysdate,