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

Line 2978: l_new_pev_schedule_id PA_PROJ_ELEM_VER_SCHEDULE.PEV_SCHEDULE_ID%TYPE;

2974: -- added for Bug Fix: 4537865
2975: l_tmp_struct_ver_id NUMBER;
2976: -- added for Bug fix: 4537865
2977: l_new_pev_structure_id PA_PROJ_ELEM_VER_STRUCTURE.PEV_STRUCTURE_ID%TYPE;
2978: l_new_pev_schedule_id PA_PROJ_ELEM_VER_SCHEDULE.PEV_SCHEDULE_ID%TYPE;
2979: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;
2980:
2981: l_original_baseline_flag VARCHAR2(1);
2982: l_current_baseline_flag VARCHAR2(1);

Line 3008: FROM pa_proj_elem_ver_schedule

3004:
3005: CURSOR get_scheduled_dates(c_project_id NUMBER, c_structure_version_id NUMBER)
3006: IS
3007: SELECT scheduled_start_date, scheduled_finish_date
3008: FROM pa_proj_elem_ver_schedule
3009: WHERE project_id = c_project_id
3010: AND element_version_id = c_structure_version_id;
3011:
3012: CURSOR get_proj_rec_ver_number(c_project_id NUMBER)

Line 3088: FROM PA_PROJ_ELEM_VER_SCHEDULE

3084: l_struc_ver_attr_rec get_structure_ver_attr_csr%ROWTYPE;
3085:
3086: CURSOR get_ver_schedule_attr_csr(c_element_version_id NUMBER, c_project_id NUMBER) IS
3087: SELECT *
3088: FROM PA_PROJ_ELEM_VER_SCHEDULE
3089: WHERE element_version_id = c_element_version_id
3090: AND project_id = c_project_id;
3091: l_ver_sch_attr_rec get_ver_schedule_attr_csr%ROWTYPE;
3092:

Line 4777: INSERT INTO pa_proj_elem_ver_schedule(

4773: and ppev2.parent_structure_version_id = l_new_struct_ver_id
4774: ;
4775:
4776:
4777: INSERT INTO pa_proj_elem_ver_schedule(
4778: PEV_SCHEDULE_ID
4779: ,ELEMENT_VERSION_ID
4780: ,PROJECT_ID
4781: ,PROJ_ELEMENT_ID

Line 4838: pa_proj_elem_ver_schedule_s.nextval

4834: ,EXT_SCH_DURATION
4835: ,DEF_SCH_TOOL_TSK_TYPE_CODE -- 4295770 Added
4836: )
4837: SELECT
4838: pa_proj_elem_ver_schedule_s.nextval
4839: ,ppev1.ELEMENT_VERSION_ID
4840: ,l_PROJECT_ID
4841: ,ppev1.PROJ_ELEMENT_ID
4842: ,SYSDATE

Line 4896: FROM pa_proj_elem_ver_schedule ppevs,

4892: ,ppevs.EXT_ACT_DURATION
4893: ,ppevs.EXT_REMAIN_DURATION
4894: ,ppevs.EXT_SCH_DURATION
4895: ,ppevs.DEF_SCH_TOOL_TSK_TYPE_CODE -- 4295770 Added
4896: FROM pa_proj_elem_ver_schedule ppevs,
4897: pa_proj_element_versions ppev1
4898: where ppev1.attribute15 = ppevs.element_version_id
4899: and ppevs.project_id = l_project_id
4900: and ppev1.project_id = l_project_id

Line 6236: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

6232:
6233: CURSOR l_get_ver_schedule_attr_csr(c_element_version_id NUMBER)
6234: IS
6235: SELECT a.*
6236: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
6237: PA_PROJ_ELEMENT_VERSIONS b
6238: WHERE b.element_version_id = c_element_version_id
6239: AND b.project_id = a.project_id
6240: AND b.element_version_id = a.element_version_id;

Line 7160: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

7156:
7157: CURSOR l_get_ver_schedule_attr_csr(c_element_version_id NUMBER)
7158: IS
7159: SELECT a.*
7160: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
7161: PA_PROJ_ELEMENT_VERSIONS b
7162: WHERE b.element_version_id = c_element_version_id
7163: AND b.element_version_id = a.element_version_id
7164: AND b.project_id = a.project_id;

Line 8410: FROM PA_PROJ_ELEMENT_VERSIONS A, PA_PROJ_ELEM_VER_SCHEDULE B

8406: IS
8407: CURSOR c1( c_project_id NUMBER ) IS
8408: SELECT B.PROJ_ELEMENT_ID, B.SCHEDULED_START_DATE,
8409: B.SCHEDULED_FINISH_DATE, A.ELEMENT_VERSION_ID , duration
8410: FROM PA_PROJ_ELEMENT_VERSIONS A, PA_PROJ_ELEM_VER_SCHEDULE B
8411: WHERE A.PARENT_STRUCTURE_VERSION_ID = p_structure_version_id
8412: AND A.ELEMENT_VERSION_ID = B.ELEMENT_VERSION_ID
8413: AND A.PROJECT_ID = B.PROJECT_ID
8414: AND A.project_id = c_project_id;

Line 8676: delete from pa_proj_elem_ver_schedule

8672: RAISE FND_API.G_EXC_ERROR;
8673: END IF;
8674:
8675: --delete schedule info for structure versions and tasks
8676: delete from pa_proj_elem_ver_schedule
8677: where project_id = p_project_id;
8678:
8679: --create_structure_version
8680: PA_PROJECT_STRUCTURE_PUB1.create_structure_Version(

Line 9665: from pa_proj_elem_ver_schedule a

9661: --bug 2843569
9662: CURSOR get_scheduled_dates(c_project_Id NUMBER,
9663: c_element_version_id NUMBER) IS
9664: select a.scheduled_start_date, a.scheduled_finish_date
9665: from pa_proj_elem_ver_schedule a
9666: where a.project_id = c_project_id
9667: and a.element_version_id = c_element_version_id;
9668: l_get_sch_dates_cur get_scheduled_dates%ROWTYPE;
9669: l_proj_rec_ver_num NUMBER;

Line 9937: DELETE FROM pa_proj_elem_ver_schedule

9933: record_version_number = record_version_number+1
9934: WHERE project_id = p_project_id;
9935:
9936: --Delete all schedule rows
9937: DELETE FROM pa_proj_elem_ver_schedule
9938: WHERE project_id = p_project_id;
9939:
9940: --Delete wp attr row
9941: OPEN get_wp_attr_rvn;

Line 10371: INSERT INTO PA_PROJ_ELEM_VER_SCHEDULE(

10367:
10368: END LOOP;
10369: CLOSE sel_struc_and_task_vers;
10370:
10371: INSERT INTO PA_PROJ_ELEM_VER_SCHEDULE(
10372: pev_schedule_id,
10373: element_version_id,
10374: project_id,
10375: proj_element_id,

Line 10391: pa_proj_elem_ver_schedule_s.nextval,

10387: source_object_id,
10388: source_object_type
10389: )
10390: SELECT
10391: pa_proj_elem_ver_schedule_s.nextval,
10392: PPEV.element_version_id,
10393: PPEV.project_id,
10394: PPEV.proj_element_id,
10395: SYSDATE,

Line 10629: DELETE FROM pa_proj_elem_ver_schedule

10625: record_version_number = record_version_number+1
10626: WHERE project_id = p_project_id;
10627:
10628: --Delete all schedule rows
10629: DELETE FROM pa_proj_elem_ver_schedule
10630: WHERE project_id = p_project_id;
10631:
10632: --Delete wp attr row
10633: OPEN get_wp_attr_rvn;

Line 11702: from pa_proj_elem_ver_schedule ppvsch,

11698: select ppvsch.pev_schedule_id,
11699: ppvsch.scheduled_start_date, ppvsch.scheduled_finish_date,
11700: ppvsch.estimated_start_date, ppvsch.estimated_finish_date,
11701: ppvsch.actual_start_date, ppvsch.actual_finish_date
11702: from pa_proj_elem_ver_schedule ppvsch,
11703: pa_proj_element_versions ppv
11704: where ppv.parent_structure_version_id = p_structure_version_id
11705: and ppv.project_id = ppvsch.project_id
11706: and ppv.proj_element_id = ppvsch.proj_element_id

Line 11747: UPDATE PA_PROJ_ELEM_VER_SCHEDULE

11743: l_actual_finish_date;
11744: EXIT WHEN get_dates%NOTFOUND;
11745:
11746: --Update calendar id
11747: UPDATE PA_PROJ_ELEM_VER_SCHEDULE
11748: SET calendar_id = p_calendar_id
11749: WHERE pev_schedule_id = l_pev_schedule_id;
11750:
11751: --Update schedule dates

Line 11776: UPDATE PA_PROJ_ELEM_VER_SCHEDULE

11772: end if;
11773: raise FND_API.G_EXC_ERROR;
11774: END IF;*/
11775:
11776: UPDATE PA_PROJ_ELEM_VER_SCHEDULE
11777: --SET DURATION = l_hours
11778: SET DURATION = l_sch_days
11779: WHERE pev_schedule_id = l_pev_schedule_id;
11780: END IF;

Line 11808: UPDATE PA_PROJ_ELEM_VER_SCHEDULE

11804: end if;
11805: raise FND_API.G_EXC_ERROR;
11806: END IF; */
11807:
11808: UPDATE PA_PROJ_ELEM_VER_SCHEDULE
11809: --SET ESTIMATED_DURATION = l_hours
11810: SET ESTIMATED_DURATION = l_est_days
11811: WHERE pev_schedule_id = l_pev_schedule_id;
11812: END IF;

Line 11839: UPDATE PA_PROJ_ELEM_VER_SCHEDULE

11835: end if;
11836: raise FND_API.G_EXC_ERROR;
11837: END IF;*/
11838:
11839: UPDATE PA_PROJ_ELEM_VER_SCHEDULE
11840: -- SET ACTUAL_DURATION = l_hours
11841: SET ACTUAL_DURATION = l_act_days
11842: WHERE pev_schedule_id = l_pev_schedule_id;
11843: END IF;

Line 11911: pa_proj_elem_ver_schedule pevsh

11907: pevsh.rowid
11908: from pa_proj_elements pe,
11909: pa_proj_element_versions pev,
11910: pa_proj_elem_ver_structure pevs,
11911: pa_proj_elem_ver_schedule pevsh
11912: where pev.element_version_id = p_structure_version_id and
11913: pev.proj_element_id = pe.proj_element_id and
11914: pev.project_id = pevs.project_id and
11915: pev.element_version_id = pevs.element_version_id and

Line 11944: l_pev_schedule_id PA_PROJ_ELEM_VER_SCHEDULE.PEV_SCHEDULE_ID%TYPE;

11940: l_element_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
11941: l_pev_rvn PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
11942: l_pev_structure_id PA_PROJ_ELEM_VER_STRUCTURE.PEV_STRUCTURE_ID%TYPE;
11943: l_pevs_rvn PA_PROJ_ELEM_VER_STRUCTURE.RECORD_VERSION_NUMBER%TYPE;
11944: l_pev_schedule_id PA_PROJ_ELEM_VER_SCHEDULE.PEV_SCHEDULE_ID%TYPE;
11945: l_pevsh_rvn PA_PROJ_ELEM_VER_SCHEDULE.RECORD_VERSION_NUMBER%TYPE;
11946: l_pevsh_rowid VARCHAR2(255);
11947:
11948: l_task_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;

Line 11945: l_pevsh_rvn PA_PROJ_ELEM_VER_SCHEDULE.RECORD_VERSION_NUMBER%TYPE;

11941: l_pev_rvn PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
11942: l_pev_structure_id PA_PROJ_ELEM_VER_STRUCTURE.PEV_STRUCTURE_ID%TYPE;
11943: l_pevs_rvn PA_PROJ_ELEM_VER_STRUCTURE.RECORD_VERSION_NUMBER%TYPE;
11944: l_pev_schedule_id PA_PROJ_ELEM_VER_SCHEDULE.PEV_SCHEDULE_ID%TYPE;
11945: l_pevsh_rvn PA_PROJ_ELEM_VER_SCHEDULE.RECORD_VERSION_NUMBER%TYPE;
11946: l_pevsh_rowid VARCHAR2(255);
11947:
11948: l_task_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
11949: l_task_rvn PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;

Line 12271: pa_proj_elem_ver_schedule c

12267: select a.name, a.version_number, c.scheduled_start_date,
12268: c.scheduled_finish_date, b.project_id
12269: from pa_proj_elem_ver_structure a,
12270: pa_proj_element_versions b,
12271: pa_proj_elem_ver_schedule c
12272: where b.element_version_id = p_structure_version_id
12273: and b.project_id = a.project_id
12274: and b.proj_element_id = a.proj_element_id
12275: and b.element_version_id = a.element_version_id

Line 12727: FROM pa_proj_elem_ver_schedule ppevs

12723: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
12724:
12725: CURSOR get_summed_duration(c_parent_element_version_id NUMBER) IS
12726: SELECT sum(ppevs.duration)
12727: FROM pa_proj_elem_ver_schedule ppevs
12728: , pa_object_relationships por
12729: , pa_proj_element_versions ppev
12730: , pa_proj_elements ppe
12731: , pa_task_types ptt

Line 12746: FROM pa_proj_elem_ver_schedule

12742: AND ptt.prog_entry_enable_flag = 'Y';
12743:
12744: CURSOR get_task_duration(c_element_version_id NUMBER, c_project_id NUMBER) IS
12745: SELECT duration
12746: FROM pa_proj_elem_ver_schedule
12747: WHERE element_version_id = c_element_version_id
12748: AND project_id = c_project_id;
12749:
12750: CURSOR get_existing_weights(c_parent_element_version_id NUMBER) IS

Line 12942: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

12938:
12939: CURSOR l_get_ver_schedule_attr_csr(c_element_version_id NUMBER)
12940: IS
12941: SELECT a.*
12942: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
12943: PA_PROJ_ELEMENT_VERSIONS b
12944: WHERE b.element_version_id = c_element_version_id
12945: AND b.project_id = a.project_id
12946: AND b.element_version_id = a.element_version_id;

Line 13394: INSERT INTO pa_proj_elem_ver_schedule(

13390: and ppev2.parent_structure_version_id = l_new_struct_ver_id
13391: ;
13392:
13393:
13394: INSERT INTO pa_proj_elem_ver_schedule(
13395: PEV_SCHEDULE_ID
13396: ,ELEMENT_VERSION_ID
13397: ,PROJECT_ID
13398: ,PROJ_ELEMENT_ID

Line 13455: pa_proj_elem_ver_schedule_s.nextval

13451: ,EXT_SCH_DURATION
13452: ,DEF_SCH_TOOL_TSK_TYPE_CODE -- Fix For Bug # 4321287.
13453: )
13454: SELECT
13455: pa_proj_elem_ver_schedule_s.nextval
13456: ,ppev1.ELEMENT_VERSION_ID
13457: ,l_PROJECT_ID
13458: ,ppev1.PROJ_ELEMENT_ID
13459: ,SYSDATE

Line 13513: FROM pa_proj_elem_ver_schedule ppevs,

13509: ,ppevs.EXT_ACT_DURATION
13510: ,ppevs.EXT_REMAIN_DURATION
13511: ,ppevs.EXT_SCH_DURATION
13512: ,ppevs.DEF_SCH_TOOL_TSK_TYPE_CODE -- Fix For Bug # 4321287.
13513: FROM pa_proj_elem_ver_schedule ppevs,
13514: pa_proj_element_versions ppev1
13515: where ppev1.attribute15 = ppevs.element_version_id
13516: and ppevs.project_id = l_project_id
13517: and ppev1.project_id = l_project_id

Line 14030: from pa_proj_elem_ver_schedule a

14026: --bug 2843569
14027: CURSOR get_scheduled_dates(c_project_Id NUMBER,
14028: c_element_version_id NUMBER) IS
14029: select a.scheduled_start_date, a.scheduled_finish_date
14030: from pa_proj_elem_ver_schedule a
14031: where a.project_id = c_project_id
14032: and a.element_version_id = c_element_version_id;
14033: l_get_sch_dates_cur get_scheduled_dates%ROWTYPE;
14034: l_proj_rec_ver_num NUMBER;

Line 15078: INSERT INTO PA_PROJ_ELEM_VER_SCHEDULE(

15074: END IF;
15075:
15076:
15077: --create schedule row for each task
15078: INSERT INTO PA_PROJ_ELEM_VER_SCHEDULE(
15079: pev_schedule_id,
15080: element_version_id,
15081: project_id,
15082: proj_element_id,

Line 15097: pa_proj_elem_ver_schedule_s.nextval,

15093: last_update_login,
15094: source_object_id,
15095: source_object_type)
15096: SELECT
15097: pa_proj_elem_ver_schedule_s.nextval,
15098: PPEV.element_version_id,
15099: PPEV.project_id,
15100: PPEV.proj_element_id,
15101: SYSDATE,

Line 16044: delete from pa_proj_elem_ver_schedule

16040: END IF;
16041:
16042: --delete all tasks not marked as financial in the structure keeping
16043: --delete schedule versions
16044: delete from pa_proj_elem_ver_schedule
16045: where project_id =p_project_id --Bug No 3634334
16046: and element_version_id IN (
16047: select element_version_id
16048: from pa_proj_element_versions

Line 16579: delete from pa_proj_elem_ver_schedule

16575: END IF;
16576:
16577: --delete all tasks not marked as financial in the structure keeping
16578: --delete schedule versions
16579: delete from pa_proj_elem_ver_schedule
16580: where project_id =p_project_id --Bug No 3634334
16581: and element_version_id IN (
16582: select element_version_id
16583: from pa_proj_element_versions

Line 17067: INSERT INTO PA_PROJ_ELEM_VER_SCHEDULE(

17063: RAISE FND_API.G_EXC_ERROR;
17064: END IF;
17065:
17066: --create schedule row for each task
17067: INSERT INTO PA_PROJ_ELEM_VER_SCHEDULE(
17068: pev_schedule_id,
17069: element_version_id,
17070: project_id,
17071: proj_element_id,

Line 17086: pa_proj_elem_ver_schedule_s.nextval,

17082: last_update_login,
17083: source_object_id,
17084: source_object_type)
17085: SELECT
17086: pa_proj_elem_ver_schedule_s.nextval,
17087: PPEV.element_version_id,
17088: PPEV.project_id,
17089: PPEV.proj_element_id,
17090: SYSDATE,

Line 17458: INSERT INTO PA_PROJ_ELEM_VER_SCHEDULE(

17454: RAISE FND_API.G_EXC_ERROR;
17455: END IF;
17456:
17457: --create schedule row for each task
17458: INSERT INTO PA_PROJ_ELEM_VER_SCHEDULE(
17459: pev_schedule_id,
17460: element_version_id,
17461: project_id,
17462: proj_element_id,

Line 17478: pa_proj_elem_ver_schedule_s.nextval,

17474: source_object_id,
17475: source_object_type
17476: )
17477: SELECT
17478: pa_proj_elem_ver_schedule_s.nextval,
17479: PPEV.element_version_id,
17480: PPEV.project_id,
17481: PPEV.proj_element_id,
17482: SYSDATE,