[Home] [Help]
3004: -- added for Bug Fix: 4537865
3005: l_tmp_struct_ver_id NUMBER;
3006: -- added for Bug fix: 4537865
3007: l_new_pev_structure_id PA_PROJ_ELEM_VER_STRUCTURE.PEV_STRUCTURE_ID%TYPE;
3008: l_new_pev_schedule_id PA_PROJ_ELEM_VER_SCHEDULE.PEV_SCHEDULE_ID%TYPE;
3009: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;
3010:
3011: l_original_baseline_flag VARCHAR2(1);
3012: l_current_baseline_flag VARCHAR2(1);
3034:
3035: CURSOR get_scheduled_dates(c_project_id NUMBER, c_structure_version_id NUMBER)
3036: IS
3037: SELECT scheduled_start_date, scheduled_finish_date
3038: FROM pa_proj_elem_ver_schedule
3039: WHERE project_id = c_project_id
3040: AND element_version_id = c_structure_version_id;
3041:
3042: CURSOR get_proj_rec_ver_number(c_project_id NUMBER)
3114: l_struc_ver_attr_rec get_structure_ver_attr_csr%ROWTYPE;
3115:
3116: CURSOR get_ver_schedule_attr_csr(c_element_version_id NUMBER, c_project_id NUMBER) IS
3117: SELECT *
3118: FROM PA_PROJ_ELEM_VER_SCHEDULE
3119: WHERE element_version_id = c_element_version_id
3120: AND project_id = c_project_id;
3121: l_ver_sch_attr_rec get_ver_schedule_attr_csr%ROWTYPE;
3122:
4833: and ppev2.parent_structure_version_id = l_new_struct_ver_id
4834: ;
4835:
4836:
4837: INSERT INTO pa_proj_elem_ver_schedule(
4838: PEV_SCHEDULE_ID
4839: ,ELEMENT_VERSION_ID
4840: ,PROJECT_ID
4841: ,PROJ_ELEMENT_ID
4894: ,EXT_SCH_DURATION
4895: ,DEF_SCH_TOOL_TSK_TYPE_CODE -- 4295770 Added
4896: )
4897: SELECT
4898: pa_proj_elem_ver_schedule_s.nextval
4899: ,ppev1.ELEMENT_VERSION_ID
4900: ,l_PROJECT_ID
4901: ,ppev1.PROJ_ELEMENT_ID
4902: ,SYSDATE
4952: ,ppevs.EXT_ACT_DURATION
4953: ,ppevs.EXT_REMAIN_DURATION
4954: ,ppevs.EXT_SCH_DURATION
4955: ,ppevs.DEF_SCH_TOOL_TSK_TYPE_CODE -- 4295770 Added
4956: FROM pa_proj_elem_ver_schedule ppevs,
4957: pa_proj_element_versions ppev1
4958: where ppev1.attribute15 = ppevs.element_version_id
4959: and ppevs.project_id = l_project_id
4960: and ppev1.project_id = l_project_id
6292:
6293: CURSOR l_get_ver_schedule_attr_csr(c_element_version_id NUMBER)
6294: IS
6295: SELECT a.*
6296: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
6297: PA_PROJ_ELEMENT_VERSIONS b
6298: WHERE b.element_version_id = c_element_version_id
6299: AND b.project_id = a.project_id
6300: AND b.element_version_id = a.element_version_id;
7216:
7217: CURSOR l_get_ver_schedule_attr_csr(c_element_version_id NUMBER)
7218: IS
7219: SELECT a.*
7220: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
7221: PA_PROJ_ELEMENT_VERSIONS b
7222: WHERE b.element_version_id = c_element_version_id
7223: AND b.element_version_id = a.element_version_id
7224: AND b.project_id = a.project_id;
8467: CURSOR c0( c_project_id NUMBER ) IS
8468: SELECT b.proj_element_id, b.scheduled_start_date,
8469: b.scheduled_finish_date, a.element_version_id, duration,
8470: a.wbs_number, a.wbs_level, a.display_sequence
8471: FROM PA_PROJ_ELEMENT_VERSIONS A, PA_PROJ_ELEM_VER_SCHEDULE B
8472: WHERE a.parent_structure_version_id = p_structure_version_id
8473: AND a.element_version_id = b.element_version_id
8474: AND a.project_id = b.project_id
8475: AND a.project_id = c_project_id
8482: SCHEDULED_FINISH_DATE, ELEMENT_VERSION_ID, DURATION, WBS_NUMBER,
8483: OLD_LEVEL , DISPLAY_SEQUENCE, LEVEL WBS_LEVEL
8484: FROM
8485: (
8486: select /*+ ordered use_nl(b a t) index(t pa_tasks_n8) index(a PA_PROJ_ELEMENT_VERSIONS_N1) index(t PA_PROJ_ELEM_VER_SCHEDULE_U2) */
8487: /* t.project_id , t.task_id , t.parent_task_id , a.display_sequence ,
8488: a.level_sequence, a.parent_structure_version_id , B.PROJ_ELEMENT_ID,
8489: B.SCHEDULED_START_DATE, B.SCHEDULED_FINISH_DATE, A.ELEMENT_VERSION_ID, DURATION,
8490: A.WBS_NUMBER, A.WBS_LEVEL OLD_LEVEL
8488: a.level_sequence, a.parent_structure_version_id , B.PROJ_ELEMENT_ID,
8489: B.SCHEDULED_START_DATE, B.SCHEDULED_FINISH_DATE, A.ELEMENT_VERSION_ID, DURATION,
8490: A.WBS_NUMBER, A.WBS_LEVEL OLD_LEVEL
8491: from
8492: PA_TASKS T, PA_PROJ_ELEMENT_VERSIONS A, PA_PROJ_ELEM_VER_SCHEDULE B
8493: where
8494: T.PROJECT_ID = p_project_id AND A.PROJ_ELEMENT_ID = T.TASK_ID
8495: AND A.PROJECT_ID = T.PROJECT_ID --AND A.PARENT_STRUCTURE_VERSION_ID = :B1
8496: AND A.ELEMENT_VERSION_ID = B.ELEMENT_VERSION_ID
8580: delete PA_PROJ_ELEMENTS_TMP;
8581:
8582: INSERT INTO PA_PROJ_ELEMENTS_TMP(PROJECT_ID, TASK_ID, PARENT_TASK_ID, DISPLAY_SEQUENCE, LEVEL_SEQUENCE, PARENT_STRUCTURE_VERSION_ID,
8583: PROJ_ELEMENT_ID, SCHEDULED_START_DATE, SCHEDULED_FINISH_DATE, ELEMENT_VERSION_ID, DURATION, WBS_NUMBER, OLD_LEVEL, DEFER_CODE, TOP_TASK_ID) /* Modified insert statement for bug#14765516 */
8584: SELECT /*+ ordered use_nl(b a t) index(t pa_tasks_n8) index(a PA_PROJ_ELEMENT_VERSIONS_N1) index(t PA_PROJ_ELEM_VER_SCHEDULE_U2) */
8585: t.project_id , t.task_id , t.parent_task_id , a.display_sequence ,
8586: a.level_sequence, a.parent_structure_version_id , B.PROJ_ELEMENT_ID,
8587: B.SCHEDULED_START_DATE, B.SCHEDULED_FINISH_DATE, A.ELEMENT_VERSION_ID, DURATION,
8588: A.WBS_NUMBER, A.WBS_LEVEL OLD_LEVEL,a.defer_code, t.top_task_id
8586: a.level_sequence, a.parent_structure_version_id , B.PROJ_ELEMENT_ID,
8587: B.SCHEDULED_START_DATE, B.SCHEDULED_FINISH_DATE, A.ELEMENT_VERSION_ID, DURATION,
8588: A.WBS_NUMBER, A.WBS_LEVEL OLD_LEVEL,a.defer_code, t.top_task_id
8589: from
8590: PA_TASKS T, PA_PROJ_ELEMENT_VERSIONS A, PA_PROJ_ELEM_VER_SCHEDULE B
8591: where
8592: T.PROJECT_ID = p_project_id AND A.PROJ_ELEMENT_ID = T.TASK_ID
8593: AND A.PROJECT_ID = T.PROJECT_ID --AND A.PARENT_STRUCTURE_VERSION_ID = :B1
8594: AND A.ELEMENT_VERSION_ID = B.ELEMENT_VERSION_ID;
8698: IS
8699: CURSOR c1( c_project_id NUMBER ) IS
8700: SELECT B.PROJ_ELEMENT_ID, B.SCHEDULED_START_DATE,
8701: B.SCHEDULED_FINISH_DATE, A.ELEMENT_VERSION_ID , duration
8702: FROM PA_PROJ_ELEMENT_VERSIONS A, PA_PROJ_ELEM_VER_SCHEDULE B, PA_PROJ_ELEMENTS C
8703: WHERE A.PARENT_STRUCTURE_VERSION_ID = p_structure_version_id
8704: AND A.ELEMENT_VERSION_ID = B.ELEMENT_VERSION_ID
8705: AND A.PROJ_ELEMENT_ID = C.proj_element_id
8706: AND A.PROJECT_ID = B.PROJECT_ID
8711: /* Commented below cursor and replaced with the one above for Huawei enhancement bug 13923366
8712: * bug 13923366 - testing delete_task sceanrio
8713: SELECT B.PROJ_ELEMENT_ID, B.SCHEDULED_START_DATE,
8714: B.SCHEDULED_FINISH_DATE, A.ELEMENT_VERSION_ID , duration
8715: FROM PA_PROJ_ELEMENT_VERSIONS A, PA_PROJ_ELEM_VER_SCHEDULE B, PA_PROJ_ELEMENTS C
8716: WHERE A.PARENT_STRUCTURE_VERSION_ID = p_structure_version_id
8717: AND A.ELEMENT_VERSION_ID = B.ELEMENT_VERSION_ID
8718: AND A.PROJECT_ID = B.PROJECT_ID
8719: AND A.project_id = c_project_id;
8723: -- TYPE c_array IS TABLE OF c1%ROWTYPE; /* commented for bug#14765516 */
8724: -- l_data c_array; /* commented for bug#14765516 */
8725: /*bug#14765516 changes starts*/
8726: TYPE PROJ_ELEMENT_ID_t IS TABLE OF
8727: PA_PROJ_ELEM_VER_SCHEDULE.PROJ_ELEMENT_ID%TYPE;
8728: TYPE SCHEDULED_START_DATE_t IS TABLE OF
8729: PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_START_DATE%TYPE;
8730: TYPE SCHEDULED_FINISH_DATE_t IS TABLE OF
8731: PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE;
8725: /*bug#14765516 changes starts*/
8726: TYPE PROJ_ELEMENT_ID_t IS TABLE OF
8727: PA_PROJ_ELEM_VER_SCHEDULE.PROJ_ELEMENT_ID%TYPE;
8728: TYPE SCHEDULED_START_DATE_t IS TABLE OF
8729: PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_START_DATE%TYPE;
8730: TYPE SCHEDULED_FINISH_DATE_t IS TABLE OF
8731: PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE;
8732: TYPE ELEMENT_VERSION_ID_t IS TABLE OF
8733: PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
8727: PA_PROJ_ELEM_VER_SCHEDULE.PROJ_ELEMENT_ID%TYPE;
8728: TYPE SCHEDULED_START_DATE_t IS TABLE OF
8729: PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_START_DATE%TYPE;
8730: TYPE SCHEDULED_FINISH_DATE_t IS TABLE OF
8731: PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE;
8732: TYPE ELEMENT_VERSION_ID_t IS TABLE OF
8733: PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
8734: TYPE duration_t IS TABLE OF PA_PROJ_ELEM_VER_SCHEDULE.duration%TYPE;
8735:
8730: TYPE SCHEDULED_FINISH_DATE_t IS TABLE OF
8731: PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE;
8732: TYPE ELEMENT_VERSION_ID_t IS TABLE OF
8733: PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
8734: TYPE duration_t IS TABLE OF PA_PROJ_ELEM_VER_SCHEDULE.duration%TYPE;
8735:
8736: v_PROJ_ELEMENT_ID PROJ_ELEMENT_ID_t;
8737: v_SCHEDULED_START_DATE SCHEDULED_START_DATE_t;
8738: v_SCHEDULED_FINISH_DATE SCHEDULED_FINISH_DATE_t;
8750: CURSOR c2 (c_project_id NUMBER)
8751: IS
8752: SELECT B.SCHEDULED_START_DATE,
8753: B.SCHEDULED_FINISH_DATE, C.record_version_number
8754: FROM PA_PROJ_ELEMENT_VERSIONS A, PA_PROJ_ELEM_VER_SCHEDULE B,
8755: PA_PROJECTS_ALL C
8756: WHERE A.PARENT_STRUCTURE_VERSION_ID = p_structure_version_id
8757: AND A.ELEMENT_VERSION_ID = p_structure_version_id
8758: AND A.ELEMENT_VERSION_ID = B.ELEMENT_VERSION_ID
9044: RAISE FND_API.G_EXC_ERROR;
9045: END IF;
9046:
9047: --delete schedule info for structure versions and tasks
9048: delete from pa_proj_elem_ver_schedule
9049: where project_id = p_project_id;
9050:
9051: --create_structure_version
9052: PA_PROJECT_STRUCTURE_PUB1.create_structure_Version(
10033: --bug 2843569
10034: CURSOR get_scheduled_dates(c_project_Id NUMBER,
10035: c_element_version_id NUMBER) IS
10036: select a.scheduled_start_date, a.scheduled_finish_date
10037: from pa_proj_elem_ver_schedule a
10038: where a.project_id = c_project_id
10039: and a.element_version_id = c_element_version_id;
10040: l_get_sch_dates_cur get_scheduled_dates%ROWTYPE;
10041: l_proj_rec_ver_num NUMBER;
10305: record_version_number = record_version_number+1
10306: WHERE project_id = p_project_id;
10307:
10308: --Delete all schedule rows
10309: DELETE FROM pa_proj_elem_ver_schedule
10310: WHERE project_id = p_project_id;
10311:
10312: --Delete wp attr row
10313: OPEN get_wp_attr_rvn;
10739:
10740: END LOOP;
10741: CLOSE sel_struc_and_task_vers;
10742:
10743: INSERT INTO PA_PROJ_ELEM_VER_SCHEDULE(
10744: pev_schedule_id,
10745: element_version_id,
10746: project_id,
10747: proj_element_id,
10759: source_object_id,
10760: source_object_type
10761: )
10762: SELECT
10763: pa_proj_elem_ver_schedule_s.nextval,
10764: PPEV.element_version_id,
10765: PPEV.project_id,
10766: PPEV.proj_element_id,
10767: SYSDATE,
10997: record_version_number = record_version_number+1
10998: WHERE project_id = p_project_id;
10999:
11000: --Delete all schedule rows
11001: DELETE FROM pa_proj_elem_ver_schedule
11002: WHERE project_id = p_project_id;
11003:
11004: --Delete wp attr row
11005: OPEN get_wp_attr_rvn;
12070: select ppvsch.pev_schedule_id,
12071: ppvsch.scheduled_start_date, ppvsch.scheduled_finish_date,
12072: ppvsch.estimated_start_date, ppvsch.estimated_finish_date,
12073: ppvsch.actual_start_date, ppvsch.actual_finish_date
12074: from pa_proj_elem_ver_schedule ppvsch,
12075: pa_proj_element_versions ppv
12076: where ppv.parent_structure_version_id = p_structure_version_id
12077: and ppv.project_id = ppvsch.project_id
12078: and ppv.proj_element_id = ppvsch.proj_element_id
12115: l_actual_finish_date;
12116: EXIT WHEN get_dates%NOTFOUND;
12117:
12118: --Update calendar id
12119: UPDATE PA_PROJ_ELEM_VER_SCHEDULE
12120: SET calendar_id = p_calendar_id
12121: WHERE pev_schedule_id = l_pev_schedule_id;
12122:
12123: --Update schedule dates
12144: end if;
12145: raise FND_API.G_EXC_ERROR;
12146: END IF;*/
12147:
12148: UPDATE PA_PROJ_ELEM_VER_SCHEDULE
12149: --SET DURATION = l_hours
12150: SET DURATION = l_sch_days
12151: WHERE pev_schedule_id = l_pev_schedule_id;
12152: END IF;
12176: end if;
12177: raise FND_API.G_EXC_ERROR;
12178: END IF; */
12179:
12180: UPDATE PA_PROJ_ELEM_VER_SCHEDULE
12181: --SET ESTIMATED_DURATION = l_hours
12182: SET ESTIMATED_DURATION = l_est_days
12183: WHERE pev_schedule_id = l_pev_schedule_id;
12184: END IF;
12207: end if;
12208: raise FND_API.G_EXC_ERROR;
12209: END IF;*/
12210:
12211: UPDATE PA_PROJ_ELEM_VER_SCHEDULE
12212: -- SET ACTUAL_DURATION = l_hours
12213: SET ACTUAL_DURATION = l_act_days
12214: WHERE pev_schedule_id = l_pev_schedule_id;
12215: END IF;
12279: pevsh.rowid
12280: from pa_proj_elements pe,
12281: pa_proj_element_versions pev,
12282: pa_proj_elem_ver_structure pevs,
12283: pa_proj_elem_ver_schedule pevsh
12284: where pev.element_version_id = p_structure_version_id and
12285: pev.proj_element_id = pe.proj_element_id and
12286: pev.project_id = pevs.project_id and
12287: pev.element_version_id = pevs.element_version_id and
12312: l_element_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
12313: l_pev_rvn PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
12314: l_pev_structure_id PA_PROJ_ELEM_VER_STRUCTURE.PEV_STRUCTURE_ID%TYPE;
12315: l_pevs_rvn PA_PROJ_ELEM_VER_STRUCTURE.RECORD_VERSION_NUMBER%TYPE;
12316: l_pev_schedule_id PA_PROJ_ELEM_VER_SCHEDULE.PEV_SCHEDULE_ID%TYPE;
12317: l_pevsh_rvn PA_PROJ_ELEM_VER_SCHEDULE.RECORD_VERSION_NUMBER%TYPE;
12318: l_pevsh_rowid VARCHAR2(255);
12319:
12320: l_task_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
12313: l_pev_rvn PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
12314: l_pev_structure_id PA_PROJ_ELEM_VER_STRUCTURE.PEV_STRUCTURE_ID%TYPE;
12315: l_pevs_rvn PA_PROJ_ELEM_VER_STRUCTURE.RECORD_VERSION_NUMBER%TYPE;
12316: l_pev_schedule_id PA_PROJ_ELEM_VER_SCHEDULE.PEV_SCHEDULE_ID%TYPE;
12317: l_pevsh_rvn PA_PROJ_ELEM_VER_SCHEDULE.RECORD_VERSION_NUMBER%TYPE;
12318: l_pevsh_rowid VARCHAR2(255);
12319:
12320: l_task_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
12321: l_task_rvn PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
12639: select a.name, a.version_number, c.scheduled_start_date,
12640: c.scheduled_finish_date, b.project_id
12641: from pa_proj_elem_ver_structure a,
12642: pa_proj_element_versions b,
12643: pa_proj_elem_ver_schedule c
12644: where b.element_version_id = p_structure_version_id
12645: and b.project_id = a.project_id
12646: and b.proj_element_id = a.proj_element_id
12647: and b.element_version_id = a.element_version_id
13095: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
13096:
13097: CURSOR get_summed_duration(c_parent_element_version_id NUMBER) IS
13098: SELECT sum(ppevs.duration)
13099: FROM pa_proj_elem_ver_schedule ppevs
13100: , pa_object_relationships por
13101: , pa_proj_element_versions ppev
13102: , pa_proj_elements ppe
13103: , pa_task_types ptt
13114: AND ptt.prog_entry_enable_flag = 'Y';
13115:
13116: CURSOR get_task_duration(c_element_version_id NUMBER, c_project_id NUMBER) IS
13117: SELECT duration
13118: FROM pa_proj_elem_ver_schedule
13119: WHERE element_version_id = c_element_version_id
13120: AND project_id = c_project_id;
13121:
13122: CURSOR get_existing_weights(c_parent_element_version_id NUMBER) IS
13310:
13311: CURSOR l_get_ver_schedule_attr_csr(c_element_version_id NUMBER)
13312: IS
13313: SELECT a.*
13314: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
13315: PA_PROJ_ELEMENT_VERSIONS b
13316: WHERE b.element_version_id = c_element_version_id
13317: AND b.project_id = a.project_id
13318: AND b.element_version_id = a.element_version_id;
13762: and ppev2.parent_structure_version_id = l_new_struct_ver_id
13763: ;
13764:
13765:
13766: INSERT INTO pa_proj_elem_ver_schedule(
13767: PEV_SCHEDULE_ID
13768: ,ELEMENT_VERSION_ID
13769: ,PROJECT_ID
13770: ,PROJ_ELEMENT_ID
13823: ,EXT_SCH_DURATION
13824: ,DEF_SCH_TOOL_TSK_TYPE_CODE -- Fix For Bug # 4321287.
13825: )
13826: SELECT
13827: pa_proj_elem_ver_schedule_s.nextval
13828: ,ppev1.ELEMENT_VERSION_ID
13829: ,l_PROJECT_ID
13830: ,ppev1.PROJ_ELEMENT_ID
13831: ,SYSDATE
13881: ,ppevs.EXT_ACT_DURATION
13882: ,ppevs.EXT_REMAIN_DURATION
13883: ,ppevs.EXT_SCH_DURATION
13884: ,ppevs.DEF_SCH_TOOL_TSK_TYPE_CODE -- Fix For Bug # 4321287.
13885: FROM pa_proj_elem_ver_schedule ppevs,
13886: pa_proj_element_versions ppev1
13887: where ppev1.attribute15 = ppevs.element_version_id
13888: and ppevs.project_id = l_project_id
13889: and ppev1.project_id = l_project_id
14400: --bug 2843569
14401: CURSOR get_scheduled_dates(c_project_Id NUMBER,
14402: c_element_version_id NUMBER) IS
14403: select a.scheduled_start_date, a.scheduled_finish_date
14404: from pa_proj_elem_ver_schedule a
14405: where a.project_id = c_project_id
14406: and a.element_version_id = c_element_version_id;
14407: l_get_sch_dates_cur get_scheduled_dates%ROWTYPE;
14408: l_proj_rec_ver_num NUMBER;
15450: END IF;
15451:
15452:
15453: --create schedule row for each task
15454: INSERT INTO PA_PROJ_ELEM_VER_SCHEDULE(
15455: pev_schedule_id,
15456: element_version_id,
15457: project_id,
15458: proj_element_id,
15469: last_update_login,
15470: source_object_id,
15471: source_object_type)
15472: SELECT
15473: pa_proj_elem_ver_schedule_s.nextval,
15474: PPEV.element_version_id,
15475: PPEV.project_id,
15476: PPEV.proj_element_id,
15477: SYSDATE,
16416: END IF;
16417:
16418: --delete all tasks not marked as financial in the structure keeping
16419: --delete schedule versions
16420: delete from pa_proj_elem_ver_schedule
16421: where project_id =p_project_id --Bug No 3634334
16422: and element_version_id IN (
16423: select element_version_id
16424: from pa_proj_element_versions
16951: END IF;
16952:
16953: --delete all tasks not marked as financial in the structure keeping
16954: --delete schedule versions
16955: delete from pa_proj_elem_ver_schedule
16956: where project_id =p_project_id --Bug No 3634334
16957: and element_version_id IN (
16958: select element_version_id
16959: from pa_proj_element_versions
17439: RAISE FND_API.G_EXC_ERROR;
17440: END IF;
17441:
17442: --create schedule row for each task
17443: INSERT INTO PA_PROJ_ELEM_VER_SCHEDULE(
17444: pev_schedule_id,
17445: element_version_id,
17446: project_id,
17447: proj_element_id,
17458: last_update_login,
17459: source_object_id,
17460: source_object_type)
17461: SELECT
17462: pa_proj_elem_ver_schedule_s.nextval,
17463: PPEV.element_version_id,
17464: PPEV.project_id,
17465: PPEV.proj_element_id,
17466: SYSDATE,
17830: RAISE FND_API.G_EXC_ERROR;
17831: END IF;
17832:
17833: --create schedule row for each task
17834: INSERT INTO PA_PROJ_ELEM_VER_SCHEDULE(
17835: pev_schedule_id,
17836: element_version_id,
17837: project_id,
17838: proj_element_id,
17850: source_object_id,
17851: source_object_type
17852: )
17853: SELECT
17854: pa_proj_elem_ver_schedule_s.nextval,
17855: PPEV.element_version_id,
17856: PPEV.project_id,
17857: PPEV.proj_element_id,
17858: SYSDATE,