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.

[Home] [Help]

APPS.PA_PROGRESS_PVT dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 324: FROM pa_proj_elem_ver_schedule

320:
321: CURSOR cur_sch_id( c_object_version_id NUMBER )
322: IS
323: SELECT pev_schedule_id, record_version_number
324: FROM pa_proj_elem_ver_schedule
325: WHERE project_id = p_project_id
326: AND element_version_id = c_object_version_id;
327:
328:

Line 332: FROM pa_proj_elem_ver_schedule

328:
329: CURSOR c_get_dates (c_project_id NUMBER, c_element_version_id NUMBER)
330: IS
331: SELECT scheduled_start_date, scheduled_finish_date
332: FROM pa_proj_elem_ver_schedule
333: WHERE PROJECT_ID = c_project_id
334: AND element_version_id = c_element_version_id;
335:
336: CURSOR c_get_dlv_status(c_task_id NUMBER) IS

Line 3552: UPDATE pa_proj_elem_ver_schedule

3548:
3549: END IF;
3550: -- 5119716 End
3551:
3552: UPDATE pa_proj_elem_ver_schedule
3553: SET ACTUAL_START_DATE = l_actual_start_date
3554: , ACTUAL_FINISH_DATE = l_actual_finish_date
3555: , ESTIMATED_START_DATE = l_rollup_table1(i).start_date2
3556: , ESTIMATED_FINISH_DATE = l_rollup_table1(i).finish_date2

Line 6722: FROM pa_proj_elem_ver_schedule

6718: -- Bug 3956299 Begin
6719: CURSOR c_get_dates (c_project_id NUMBER, c_element_version_id NUMBER)
6720: IS
6721: SELECT scheduled_start_date, scheduled_finish_date
6722: FROM pa_proj_elem_ver_schedule
6723: WHERE PROJECT_ID = c_project_id
6724: AND element_version_id = c_element_version_id;
6725:
6726: l_tsk_scheduled_start_date Date;

Line 10835: FROM pa_proj_elem_ver_schedule

10831:
10832: CURSOR cur_sch_id( c_object_version_id NUMBER )
10833: IS
10834: SELECT pev_schedule_id, record_version_number
10835: FROM pa_proj_elem_ver_schedule
10836: WHERE project_id = p_project_id
10837: AND element_version_id = c_object_version_id;
10838:
10839:

Line 10843: FROM pa_proj_elem_ver_schedule

10839:
10840: CURSOR c_get_dates (c_project_id NUMBER, c_element_version_id NUMBER)
10841: IS
10842: SELECT scheduled_start_date, scheduled_finish_date
10843: FROM pa_proj_elem_ver_schedule
10844: WHERE PROJECT_ID = c_project_id
10845: AND element_version_id = c_element_version_id;
10846:
10847: CURSOR c_get_dlv_status(c_task_id NUMBER) IS

Line 11694: select scheduled_start_date, scheduled_finish_date from pa_proj_elem_ver_schedule a

11690: l_subproj_task_version_id NUMBER;--4582956
11691: l_org_id NUMBER; -- 4746476
11692:
11693: CURSOR c1_rolldates(c_task_ver_id NUMBER, c_task_id NUMBER) IS
11694: select scheduled_start_date, scheduled_finish_date from pa_proj_elem_ver_schedule a
11695: where a.project_id = p_project_id
11696: AND a.proj_element_id = c_task_id and a.element_version_id = c_task_ver_id;
11697:
11698: l_tsk_sch_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;

Line 11698: l_tsk_sch_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;

11694: select scheduled_start_date, scheduled_finish_date from pa_proj_elem_ver_schedule a
11695: where a.project_id = p_project_id
11696: AND a.proj_element_id = c_task_id and a.element_version_id = c_task_ver_id;
11697:
11698: l_tsk_sch_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;
11699: l_tsk_sch_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;
11700: l_cnt number := 0;
11701:
11702: cursor c_progress_parent(c_project_id number)

Line 11699: l_tsk_sch_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;

11695: where a.project_id = p_project_id
11696: AND a.proj_element_id = c_task_id and a.element_version_id = c_task_ver_id;
11697:
11698: l_tsk_sch_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;
11699: l_tsk_sch_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;
11700: l_cnt number := 0;
11701:
11702: cursor c_progress_parent(c_project_id number)
11703: IS

Line 13628: UPDATE pa_proj_elem_ver_schedule

13624: END IF;
13625: END IF;
13626: -- 5119716 End
13627:
13628: UPDATE pa_proj_elem_ver_schedule
13629: SET ACTUAL_START_DATE = l_actual_start_date
13630: , ACTUAL_FINISH_DATE = l_actual_finish_date
13631: , ESTIMATED_START_DATE = l_rollup_table1(i).start_date2
13632: , ESTIMATED_FINISH_DATE = l_rollup_table1(i).finish_date2

Line 14395: FROM pa_proj_elem_ver_schedule

14391:
14392: CURSOR cur_sch_id( c_object_version_id NUMBER )
14393: IS
14394: SELECT pev_schedule_id, record_version_number
14395: FROM pa_proj_elem_ver_schedule
14396: WHERE project_id = p_project_id
14397: AND element_version_id = c_object_version_id;
14398:
14399:

Line 14403: FROM pa_proj_elem_ver_schedule

14399:
14400: CURSOR c_get_dates (c_project_id NUMBER, c_element_version_id NUMBER)
14401: IS
14402: SELECT scheduled_start_date, scheduled_finish_date
14403: FROM pa_proj_elem_ver_schedule
14404: WHERE PROJECT_ID = c_project_id
14405: AND element_version_id = c_element_version_id;
14406:
14407: CURSOR c_get_dlv_status(c_task_id NUMBER) IS

Line 15256: select scheduled_start_date, scheduled_finish_date from pa_proj_elem_ver_schedule a

15252: l_subproj_task_version_id NUMBER;--4582956
15253: l_org_id NUMBER; -- 4746476
15254:
15255: CURSOR c1_rolldates(c_task_ver_id NUMBER, c_task_id NUMBER) IS
15256: select scheduled_start_date, scheduled_finish_date from pa_proj_elem_ver_schedule a
15257: where a.project_id = p_project_id
15258: AND a.proj_element_id = c_task_id and a.element_version_id = c_task_ver_id;
15259:
15260: l_tsk_sch_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;

Line 15260: l_tsk_sch_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;

15256: select scheduled_start_date, scheduled_finish_date from pa_proj_elem_ver_schedule a
15257: where a.project_id = p_project_id
15258: AND a.proj_element_id = c_task_id and a.element_version_id = c_task_ver_id;
15259:
15260: l_tsk_sch_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;
15261: l_tsk_sch_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;
15262: l_cnt number := 0;
15263:
15264: /*

Line 15261: l_tsk_sch_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;

15257: where a.project_id = p_project_id
15258: AND a.proj_element_id = c_task_id and a.element_version_id = c_task_ver_id;
15259:
15260: l_tsk_sch_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;
15261: l_tsk_sch_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;
15262: l_cnt number := 0;
15263:
15264: /*
15265: cursor c_progress_parent(c_project_id number)

Line 17249: UPDATE pa_proj_elem_ver_schedule

17245: END IF;
17246: END IF;
17247: -- 5119716 End
17248:
17249: UPDATE pa_proj_elem_ver_schedule
17250: SET ACTUAL_START_DATE = l_actual_start_date
17251: , ACTUAL_FINISH_DATE = l_actual_finish_date
17252: , ESTIMATED_START_DATE = l_rollup_table1(i).start_date2
17253: , ESTIMATED_FINISH_DATE = l_rollup_table1(i).finish_date2