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

Line 319: FROM pa_proj_elem_ver_schedule

315:
316: -- xxlu added for DFF attributes for calling create_schedule_version
317: CURSOR cur_ver_sch_attr_rec(c_element_version_id IN NUMBER) IS
318: SELECT *
319: FROM pa_proj_elem_ver_schedule
320: WHERE element_version_id = c_element_version_id
321: AND project_id = p_project_id
322: ;
323: l_ver_sch_attr_rec cur_ver_sch_attr_rec%ROWTYPE;

Line 863: FROM pa_proj_elem_ver_schedule

859:
860: -- xxlu added for DFF attributes for calling create_schedule_version
861: CURSOR cur_ver_sch_attr_rec(c_element_version_id IN NUMBER) IS
862: SELECT *
863: FROM pa_proj_elem_ver_schedule
864: WHERE element_version_id = c_element_version_id
865: and project_id = p_project_id
866: ;
867: l_ver_sch_attr_rec cur_ver_sch_attr_rec%ROWTYPE;

Line 1360: update pa_proj_elem_ver_schedule

1356:
1357: --Bug 2732907
1358: IF l_ref_task_version_id IS NOT NULL
1359: THEN
1360: update pa_proj_elem_ver_schedule
1361: set WQ_PLANNED_QUANTITY = null
1362: where element_version_id = l_ref_task_version_id
1363: and project_id = p_project_id
1364: and proj_element_id = p_parent_task_id;

Line 1446: update pa_proj_elem_ver_schedule

1442:
1443: --Bug 2732907
1444: IF l_ref_task_version_id IS NOT NULL
1445: THEN
1446: update pa_proj_elem_ver_schedule
1447: set WQ_PLANNED_QUANTITY = null
1448: where element_version_id = l_ref_task_version_id
1449: and project_id = p_project_id
1450: and proj_element_id = p_parent_task_id;

Line 2340: FROM pa_proj_elem_ver_schedule

2336:
2337: CURSOR cur_proj_sch( c_task_version_id NUMBER )
2338: IS
2339: SELECT pev_schedule_id, record_version_number
2340: FROM pa_proj_elem_ver_schedule
2341: WHERE element_version_id = c_task_version_id
2342: AND project_id = p_project_id
2343: AND proj_element_id = p_task_id; --This will give u unique record.
2344:

Line 2375: FROM pa_proj_elem_ver_schedule

2371:
2372: -- xxlu added for DFF attributes for calling update_schedule_version
2373: CURSOR cur_ver_sch_attr_rec(c_element_version_id IN NUMBER) IS
2374: SELECT *
2375: FROM pa_proj_elem_ver_schedule
2376: WHERE element_version_id = c_element_version_id
2377: and project_id = p_project_id;
2378: l_ver_sch_attr_rec cur_ver_sch_attr_rec%ROWTYPE;
2379: -- end xxlu changes

Line 2466: from pa_proj_elem_ver_schedule ppevs, pa_proj_elements ppe

2462: cursor l_task_cur(p_project_id NUMBER, p_struct_ver_id NUMBER) is
2463: /* --bug 3880482
2464: select
2465: element_version_id,planned_effort,actual_start_date,actual_finish_date
2466: from pa_proj_elem_ver_schedule ppevs, pa_proj_elements ppe
2467: where ppevs.project_id = ppe.project_id
2468: and ppevs.proj_element_id = ppe.proj_element_id
2469: and ppe.object_type = 'PA_TASKS'
2470: and ppevs.project_id = p_project_id;

Line 2478: pa_proj_elem_ver_schedule ppevs

2474: ,ppevs.planned_effort
2475: ,ppevs.actual_start_date
2476: ,ppevs.actual_finish_date
2477: FROM
2478: pa_proj_elem_ver_schedule ppevs
2479: ,pa_proj_element_versions ppv
2480: WHERE
2481: ppevs.project_id = ppv.project_id
2482: and ppevs.proj_element_id = ppv.proj_element_id

Line 3749: DELETE FROM pa_proj_elem_ver_schedule where project_id = p_project_id;

3745:
3746: PA_PROJ_ELEMENTS_PKG.DELETE_ROW( cur_proj_elems_rec.rowid );
3747: END LOOP;
3748:
3749: DELETE FROM pa_proj_elem_ver_schedule where project_id = p_project_id;
3750: DELETE FROM pa_proj_elem_ver_structure where project_id = p_project_id;
3751:
3752: /* Code to delete project records from tables: pa_progress_rollup, pa_proj_progress_attr
3753: and pa_proj_workplan_attr. */

Line 4444: DELETE FROM pa_proj_elem_ver_schedule WHERE element_version_id = cur_task_vers_rec.element_version_id and project_id = p_project_id;

4440: (object_id_to1 = cur_task_vers_rec.element_version_id OR
4441: object_id_from1 = cur_task_vers_rec.element_version_id);
4442:
4443: --it is possible that COSTING and WORKPLAN str are same. so delete from schedule versions as well.
4444: DELETE FROM pa_proj_elem_ver_schedule WHERE element_version_id = cur_task_vers_rec.element_version_id and project_id = p_project_id;
4445:
4446: DELETE FROM pa_proj_element_versions WHERE element_version_id = cur_task_vers_rec.element_version_id;
4447:
4448: DELETE FROM pa_proj_elements WHERE proj_element_id = cur_task_vers_rec.proj_element_id;

Line 6269: pa_proj_elem_ver_schedule a,

6265:
6266: CURSOR c1 IS
6267: select MAX(a.last_update_date)
6268: from pa_proj_element_versions b,
6269: pa_proj_elem_ver_schedule a,
6270: pa_proj_elem_ver_structure c
6271: where p_structure_version_id = c.element_version_id
6272: and l_project_id = c.project_id
6273: and c.status_code <> 'STRUCTURE_PUBLISHED'

Line 6283: pa_proj_elem_ver_schedule a,

6279: /*
6280: CURSOR c1 IS
6281: SELECT MAX(a.last_update_date)
6282: FROM pa_proj_element_versions b,
6283: pa_proj_elem_ver_schedule a,
6284: pa_proj_elem_ver_structure c
6285: WHERE a.element_version_id (+)= b.element_version_id
6286: AND a.project_id (+) = b.project_id
6287: AND a.proj_element_id (+) = b.proj_element_id

Line 6388: FROM pa_proj_elem_ver_schedule

6384:
6385: --This cursor gets the schedule start date from the source project
6386: CURSOR cur_get_src_sch_st_date(c_project_id NUMBER, c_struc_ver_id NUMBER) IS
6387: SELECT scheduled_start_date
6388: FROM pa_proj_elem_ver_schedule
6389: WHERE project_id = c_project_id
6390: AND element_version_id = c_struc_ver_id;
6391:
6392: l_debug_mode VARCHAR2(1);

Line 6743: -- p_copy_ppevSchedules_flag NUMBER Y Whether pa_proj_elem_ver_schedule entry from the source project

6739: -- p_src_project_id NUMBER Y The source project id
6740: -- p_dest_project_id NUMBER Y The destination project id
6741: -- p_dest_fn_structure_id NUMBER Y The destination project's financial structure id
6742: -- p_shared VARCHAR2 Y Whether source/destination project is shared or not
6743: -- p_copy_ppevSchedules_flag NUMBER Y Whether pa_proj_elem_ver_schedule entry from the source project
6744: -- should be copied into the destination project or not
6745: -- p_target_start_date DATE Y The start date of the destination project
6746: -- p_target_finish_date DATE Y The finish date of the destination project
6747: -- p_calendar_id NUMBER Y The calendar id

Line 6804: FROM pa_proj_elem_ver_schedule

6800:
6801: --This cursor gets the schedule start date from the source project
6802: CURSOR cur_get_src_sch_st_date(c_project_id NUMBER, c_struc_ver_id NUMBER) IS
6803: SELECT scheduled_start_date
6804: FROM pa_proj_elem_ver_schedule
6805: WHERE project_id = c_project_id
6806: AND element_version_id = c_struc_ver_id;
6807:
6808: --Bug 3387963 - Cursor to get destination and source project's organization id

Line 7386: --Copy entries into pa_proj_elem_ver_schedule

7382: CLOSE cur_get_src_sch_st_date;
7383: l_delta := p_target_start_date - l_src_sch_st_date;
7384: END IF;
7385:
7386: --Copy entries into pa_proj_elem_ver_schedule
7387: INSERT INTO pa_proj_elem_ver_schedule(
7388: PEV_SCHEDULE_ID
7389: ,ELEMENT_VERSION_ID
7390: ,PROJECT_ID

Line 7387: INSERT INTO pa_proj_elem_ver_schedule(

7383: l_delta := p_target_start_date - l_src_sch_st_date;
7384: END IF;
7385:
7386: --Copy entries into pa_proj_elem_ver_schedule
7387: INSERT INTO pa_proj_elem_ver_schedule(
7388: PEV_SCHEDULE_ID
7389: ,ELEMENT_VERSION_ID
7390: ,PROJECT_ID
7391: ,PROJ_ELEMENT_ID

Line 7438: pa_proj_elem_ver_schedule_s.nextval

7434: ,source_object_id
7435: ,source_object_type
7436: )
7437: SELECT
7438: pa_proj_elem_ver_schedule_s.nextval
7439: ,ppev1.ELEMENT_VERSION_ID
7440: ,p_dest_project_id
7441: ,ppev1.PROJ_ELEMENT_ID
7442: ,SYSDATE

Line 7494: FROM pa_proj_elem_ver_schedule ppevs,

7490: ,ppevs.ATTRIBUTE14
7491: ,ppevs.ATTRIBUTE15
7492: ,p_dest_project_id
7493: ,'PA_PROJECTS'
7494: FROM pa_proj_elem_ver_schedule ppevs,
7495: pa_proj_element_versions ppev1,
7496: pa_proj_element_versions ppev2
7497: WHERE ppev1.project_id = p_dest_project_id
7498: AND ppev1.attribute15 = ppevs.element_version_id

Line 7666: FROM pa_proj_elem_ver_schedule

7662:
7663: --This cursor gets the schedule start date from the source project
7664: CURSOR cur_get_src_sch_st_date(c_project_id NUMBER, c_struc_ver_id NUMBER) IS
7665: SELECT scheduled_start_date
7666: FROM pa_proj_elem_ver_schedule
7667: WHERE project_id = c_project_id
7668: AND element_version_id = c_struc_ver_id;
7669:
7670: CURSOR cur_get_working_ver_num(c_project_id NUMBER, c_proj_element_id NUMBER) IS

Line 9558: --Copy entries into pa_proj_elem_ver_schedule

9554: CLOSE cur_get_src_sch_st_date;
9555: l_delta := p_target_start_date - l_src_sch_st_date;
9556: END IF;
9557:
9558: --Copy entries into pa_proj_elem_ver_schedule
9559: INSERT INTO pa_proj_elem_ver_schedule(
9560: PEV_SCHEDULE_ID
9561: ,ELEMENT_VERSION_ID
9562: ,PROJECT_ID

Line 9559: INSERT INTO pa_proj_elem_ver_schedule(

9555: l_delta := p_target_start_date - l_src_sch_st_date;
9556: END IF;
9557:
9558: --Copy entries into pa_proj_elem_ver_schedule
9559: INSERT INTO pa_proj_elem_ver_schedule(
9560: PEV_SCHEDULE_ID
9561: ,ELEMENT_VERSION_ID
9562: ,PROJECT_ID
9563: ,PROJ_ELEMENT_ID

Line 9619: pa_proj_elem_ver_schedule_s.nextval

9615: ,EXT_REMAIN_DURATION
9616: ,EXT_SCH_DURATION --Bug 3762437
9617: )
9618: SELECT
9619: pa_proj_elem_ver_schedule_s.nextval
9620: ,ppev.ELEMENT_VERSION_ID
9621: ,p_dest_PROJECT_ID
9622: ,ppev.PROJ_ELEMENT_ID
9623: ,SYSDATE

Line 9685: pa_proj_elem_ver_schedule ppevs

9681: ,EXT_ACT_DURATION
9682: ,EXT_REMAIN_DURATION
9683: ,EXT_SCH_DURATION --Bug 3762437
9684: FROM pa_proj_element_versions ppev,
9685: pa_proj_elem_ver_schedule ppevs
9686: WHERE ppev.project_id = p_dest_project_id
9687: AND ppev.parent_structure_version_id = rec_dest_wp_struc_versions.element_version_id
9688: AND ppev.attribute15 = ppevs.element_version_id
9689: AND ppevs.project_id = p_src_project_id ;

Line 9756: ,p_copy_ppevSchedules_flag => 'Y' --Copy pa_proj_elem_ver_schedules or not

9752: ,p_src_project_id => p_src_project_id
9753: ,p_dest_project_id => p_dest_project_id
9754: ,p_dest_fn_structure_id => l_dest_wp_structure_id
9755: ,p_shared => l_shared
9756: ,p_copy_ppevSchedules_flag => 'Y' --Copy pa_proj_elem_ver_schedules or not
9757: ,p_target_start_date => p_target_start_date
9758: ,p_target_finish_date => p_target_finish_date
9759: ,p_calendar_id => p_calendar_id
9760: ,x_return_status => l_return_status

Line 9890: --bug 3912603, insert records into pa_proj_elem_ver_Schedule, Satish, start

9886: ,p_dest_project_id
9887: ,'PA_PROJECTS'
9888: );
9889:
9890: --bug 3912603, insert records into pa_proj_elem_ver_Schedule, Satish, start
9891: PA_TASK_PUB1.Create_Schedule_Version(
9892: p_element_version_id => l_new_wp_ver_id
9893: ,p_scheduled_start_date => SYSDATE
9894: ,p_scheduled_end_date => SYSDATE

Line 9907: --bug 3912603, insert records into pa_proj_elem_ver_Schedule, Satish, end

9903: x_msg_data := l_msg_data;
9904: END IF;
9905: RAISE FND_API.G_EXC_ERROR;
9906: END IF;
9907: --bug 3912603, insert records into pa_proj_elem_ver_Schedule, Satish, end
9908:
9909: END IF;
9910: END IF;--If there is atleast one WP version selected
9911:

Line 9957: ,p_copy_ppevSchedules_flag => 'N' --Copy pa_proj_elem_ver_schedules or not

9953: ,p_src_project_id => p_src_project_id
9954: ,p_dest_project_id => p_dest_project_id
9955: ,p_dest_fn_structure_id => l_dest_fn_structure_id
9956: ,p_shared => l_shared
9957: ,p_copy_ppevSchedules_flag => 'N' --Copy pa_proj_elem_ver_schedules or not
9958: ,p_target_start_date => p_target_start_date
9959: ,p_target_finish_date => p_target_finish_date
9960: ,p_calendar_id => p_calendar_id
9961: ,x_return_status => l_return_status

Line 9991: /*UPDATE pa_proj_elem_ver_schedule

9987: --Updating Duration
9988: IF l_workplan_enabled = 'Y' THEN
9989: -- Bug 3657808 Remove duration calculation using calendar
9990: -- and rewritting the query
9991: /*UPDATE pa_proj_elem_ver_schedule
9992: SET duration = PA_PROJ_TASK_STRUC_PUB.calc_duration( p_calendar_id,
9993: scheduled_start_date,
9994: scheduled_finish_date )
9995: WHERE project_id = p_dest_project_id;*/

Line 9996: UPDATE pa_proj_elem_ver_schedule

9992: SET duration = PA_PROJ_TASK_STRUC_PUB.calc_duration( p_calendar_id,
9993: scheduled_start_date,
9994: scheduled_finish_date )
9995: WHERE project_id = p_dest_project_id;*/
9996: UPDATE pa_proj_elem_ver_schedule
9997: SET duration = trunc(scheduled_finish_date) - trunc(scheduled_start_date) + 1
9998: WHERE project_id = p_dest_project_id;
9999: END IF;
10000:

Line 10009: FROM pa_proj_elem_ver_schedule ppevs,

10005: ,BASELINE_DURATION
10006: ) = ( SELECT ppevs.scheduled_start_date
10007: ,ppevs.scheduled_finish_date
10008: ,ppevs.duration
10009: FROM pa_proj_elem_ver_schedule ppevs,
10010: pa_proj_element_versions ppev
10011: WHERE ppevs.project_id = p_dest_project_id
10012: AND ppevs.proj_element_id = ppev.proj_element_id
10013: AND ppevs.element_version_id = ppev.element_version_id

Line 10053: FROM pa_proj_elem_ver_schedule

10049: UPDATE pa_projects_all
10050: SET ( scheduled_START_DATE ,scheduled_FINISH_DATE, scheduled_duration, scheduled_as_of_date ) =
10051: ( SELECT SCHEDULED_START_DATE ,SCHEDULED_FINISH_DATE, duration,
10052: decode( SCHEDULED_START_DATE, null, null, sysdate )
10053: FROM pa_proj_elem_ver_schedule
10054: WHERE project_id = p_dest_project_id
10055: AND element_version_id = l_dest_latest_pub_ver_id
10056: )
10057: WHERE project_id = p_dest_project_id;

Line 10077: FROM pa_proj_elem_ver_schedule

10073: UPDATE pa_projects_all
10074: SET ( scheduled_START_DATE ,scheduled_FINISH_DATE, scheduled_duration, scheduled_as_of_date ) =
10075: ( SELECT SCHEDULED_START_DATE ,SCHEDULED_FINISH_DATE, duration,
10076: decode( SCHEDULED_START_DATE, null, null, sysdate )
10077: FROM pa_proj_elem_ver_schedule
10078: WHERE project_id = p_dest_project_id
10079: AND element_version_id = l_only_wp_ver_id
10080: )
10081: WHERE project_id = p_dest_project_id;

Line 10586: from pa_proj_elem_ver_schedule

10582: l_delta NUMBER;
10583: l_src_sch_st_date DATE;
10584: CURSOR get_src_sch_st_date(c_project_id NUMBER, c_struc_ver_id NUMBER) IS
10585: select scheduled_start_date
10586: from pa_proj_elem_ver_schedule
10587: where project_id = c_project_id
10588: and element_version_id = c_struc_ver_id;
10589:
10590:

Line 12628: INSERT INTO pa_proj_elem_ver_schedule(

12624: CLOSE get_src_sch_st_date;
12625: l_delta := p_target_start_date - l_src_sch_st_date;
12626: END IF;
12627:
12628: INSERT INTO pa_proj_elem_ver_schedule(
12629: PEV_SCHEDULE_ID
12630: ,ELEMENT_VERSION_ID
12631: ,PROJECT_ID
12632: ,PROJ_ELEMENT_ID

Line 12688: pa_proj_elem_ver_schedule_s.nextval

12684: ,EXT_REMAIN_DURATION
12685: ,EXT_SCH_DURATION --Bug 3762437
12686: )
12687: SELECT
12688: pa_proj_elem_ver_schedule_s.nextval
12689: ,ppev1.ELEMENT_VERSION_ID
12690: ,p_dest_PROJECT_ID
12691: ,ppev1.PROJ_ELEMENT_ID
12692: ,SYSDATE

Line 12754: FROM pa_proj_elem_ver_schedule ppevs,

12750: ,LEVEL_ASSIGNMENTS_FLAG
12751: ,EXT_ACT_DURATION
12752: ,EXT_REMAIN_DURATION
12753: ,EXT_SCH_DURATION --Bug 3762437
12754: FROM pa_proj_elem_ver_schedule ppevs,
12755: pa_proj_element_versions ppev1,
12756: pa_proj_element_versions ppev2
12757: where ppev1.attribute15 = ppevs.element_version_id
12758: and ppevs.project_id = p_src_project_id

Line 12777: /*UPDATE pa_proj_elem_ver_schedule

12773: THEN
12774: --updating duration
12775: -- Bug 3657808 Remove duration calculation using calendar
12776: -- and rewritting the query
12777: /*UPDATE pa_proj_elem_ver_schedule
12778: SET duration = PA_PROJ_TASK_STRUC_PUB.calc_duration( p_calendar_id,
12779: scheduled_start_date,
12780: scheduled_finish_date )
12781: WHERE project_id = p_dest_project_id;*/

Line 12782: UPDATE pa_proj_elem_ver_schedule

12778: SET duration = PA_PROJ_TASK_STRUC_PUB.calc_duration( p_calendar_id,
12779: scheduled_start_date,
12780: scheduled_finish_date )
12781: WHERE project_id = p_dest_project_id;*/
12782: UPDATE pa_proj_elem_ver_schedule
12783: SET duration = trunc(scheduled_finish_date) - trunc(scheduled_start_date) + 1
12784: WHERE project_id = p_dest_project_id;
12785: END IF;
12786:

Line 12793: from pa_proj_elem_ver_schedule ppevs,

12789: SET ( BASELINE_START_DATE ,BASELINE_FINISH_DATE,
12790: BASELINE_DURATION ) =
12791: ( Select ppevs.scheduled_start_date, ppevs.scheduled_finish_date,
12792: ppevs.duration
12793: from pa_proj_elem_ver_schedule ppevs,
12794: pa_proj_elem_ver_structure ppevst
12795: WHERE ppevs.project_id = p_dest_project_id
12796: and ppevst.project_id = p_dest_project_id
12797: and ppevst.current_flag = 'Y' --assuming this is the flag used to identify the baselined structure ver.

Line 12825: FROM pa_proj_elem_ver_schedule

12821: update pa_projects_all
12822: set ( scheduled_START_DATE ,scheduled_FINISH_DATE, scheduled_duration, scheduled_as_of_date ) =
12823: ( SELECT SCHEDULED_START_DATE ,SCHEDULED_FINISH_DATE,duration,
12824: decode(SCHEDULED_START_DATE, null, null, sysdate)
12825: FROM pa_proj_elem_ver_schedule
12826: WHERE project_id = p_dest_project_Id
12827: and element_version_id = l_latest_pub_str_ver_id)
12828: where project_id = p_dest_project_id;
12829: END IF;

Line 13358: CURSOR cur_parent_object_rel( c_task_version_id pa_proj_elem_ver_schedule.element_version_id%TYPE )

13354: AND parent_structure_version_id = c_structure_version_id
13355: AND object_type = 'PA_TASKS';
13356:
13357: --Cursor to get the parent version id of the task version id
13358: CURSOR cur_parent_object_rel( c_task_version_id pa_proj_elem_ver_schedule.element_version_id%TYPE )
13359: IS
13360: SELECT object_id_from1 -- parent task id
13361: ,object_relationship_id, -- relationship id reqd for update relationship API
13362: record_version_number,

Line 13369: CURSOR cur_ver_sch_attr_rec(c_element_version_id IN pa_proj_elem_ver_schedule.element_version_id%TYPE)

13365: WHERE object_id_to1 = c_task_version_id
13366: AND relationship_type = 'S';
13367:
13368: -- Added for DFF attributes for calling update_schedule_version
13369: CURSOR cur_ver_sch_attr_rec(c_element_version_id IN pa_proj_elem_ver_schedule.element_version_id%TYPE)
13370: IS
13371: SELECT *
13372: FROM pa_proj_elem_ver_schedule
13373: WHERE element_version_id = c_element_version_id

Line 13372: FROM pa_proj_elem_ver_schedule

13368: -- Added for DFF attributes for calling update_schedule_version
13369: CURSOR cur_ver_sch_attr_rec(c_element_version_id IN pa_proj_elem_ver_schedule.element_version_id%TYPE)
13370: IS
13371: SELECT *
13372: FROM pa_proj_elem_ver_schedule
13373: WHERE element_version_id = c_element_version_id
13374: AND project_id = p_project_id;
13375:
13376: l_ver_sch_attr_rec cur_ver_sch_attr_rec%ROWTYPE;

Line 13588: from pa_proj_elem_ver_schedule ppevs, pa_proj_elements ppe

13584:
13585: cursor l_task_cur(p_project_id NUMBER) is
13586: select
13587: element_version_id,planned_effort,actual_start_date,actual_finish_date
13588: from pa_proj_elem_ver_schedule ppevs, pa_proj_elements ppe
13589: where ppevs.project_id = ppe.project_id
13590: and ppevs.proj_element_id = ppe.proj_element_id
13591: and ppe.object_type = 'PA_TASKS'
13592: and ppevs.project_id = p_project_id;

Line 16040: l_wq_planned_quantity pa_proj_elem_ver_schedule.wq_planned_quantity%TYPE;

16036: -- l_wq_planned_quantity
16037: -- l_ver_sch_attr_rec (only for update task)
16038:
16039: DECLARE
16040: l_wq_planned_quantity pa_proj_elem_ver_schedule.wq_planned_quantity%TYPE;
16041: l_scheduled_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;
16042: l_scheduled_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;
16043: l_task_type_id pa_proj_elements.type_id%TYPE;
16044: BEGIN

Line 16041: l_scheduled_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;

16037: -- l_ver_sch_attr_rec (only for update task)
16038:
16039: DECLARE
16040: l_wq_planned_quantity pa_proj_elem_ver_schedule.wq_planned_quantity%TYPE;
16041: l_scheduled_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;
16042: l_scheduled_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;
16043: l_task_type_id pa_proj_elements.type_id%TYPE;
16044: BEGIN
16045:

Line 16042: l_scheduled_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;

16038:
16039: DECLARE
16040: l_wq_planned_quantity pa_proj_elem_ver_schedule.wq_planned_quantity%TYPE;
16041: l_scheduled_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;
16042: l_scheduled_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;
16043: l_task_type_id pa_proj_elements.type_id%TYPE;
16044: BEGIN
16045:
16046: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

Line 18508: FROM pa_proj_elem_ver_schedule

18504: --bug 4019845
18505: CURSOR get_scheduled_dates(c_project_id NUMBER, c_structure_version_id NUMBER)
18506: IS
18507: SELECT scheduled_start_date, scheduled_finish_date
18508: FROM pa_proj_elem_ver_schedule
18509: WHERE project_id = c_project_id
18510: AND element_version_id = c_structure_version_id;
18511:
18512: CURSOR get_proj_rec_ver_number(c_project_id NUMBER)

Line 20356: summed_effort pa_proj_elem_ver_schedule.planned_effort%TYPE

20352:
20353: -- This record contains the summary information of the child tasks for a parent task.
20354: TYPE CHILD_INFO_REC IS RECORD
20355: (
20356: summed_effort pa_proj_elem_ver_schedule.planned_effort%TYPE
20357: ,summed_duration pa_proj_elem_ver_schedule.duration%TYPE
20358: ,child_count Number
20359: ,cum_alloted_weightage pa_object_relationships.weighting_percentage%TYPE
20360: ,processed_child_count Number

Line 20357: ,summed_duration pa_proj_elem_ver_schedule.duration%TYPE

20353: -- This record contains the summary information of the child tasks for a parent task.
20354: TYPE CHILD_INFO_REC IS RECORD
20355: (
20356: summed_effort pa_proj_elem_ver_schedule.planned_effort%TYPE
20357: ,summed_duration pa_proj_elem_ver_schedule.duration%TYPE
20358: ,child_count Number
20359: ,cum_alloted_weightage pa_object_relationships.weighting_percentage%TYPE
20360: ,processed_child_count Number
20361: -- Following added for bug 3053472

Line 20379: TYPE duration_tbl IS TABLE OF pa_proj_elem_ver_schedule.duration%TYPE

20375:
20376: TYPE parent_task_ver_id_tbl IS TABLE OF pa_object_relationships.object_id_from1%TYPE --pa_proj_element_versions.element_version_id%TYPE 3746912
20377: INDEX BY BINARY_INTEGER;
20378:
20379: TYPE duration_tbl IS TABLE OF pa_proj_elem_ver_schedule.duration%TYPE
20380: INDEX BY BINARY_INTEGER;
20381:
20382: TYPE effort_tbl IS TABLE OF pji_xbs_plans_v.labor_effort%TYPE --pa_proj_elem_ver_schedule.planned_effort%TYPE 3746912
20383: INDEX BY BINARY_INTEGER;

Line 20382: TYPE effort_tbl IS TABLE OF pji_xbs_plans_v.labor_effort%TYPE --pa_proj_elem_ver_schedule.planned_effort%TYPE 3746912

20378:
20379: TYPE duration_tbl IS TABLE OF pa_proj_elem_ver_schedule.duration%TYPE
20380: INDEX BY BINARY_INTEGER;
20381:
20382: TYPE effort_tbl IS TABLE OF pji_xbs_plans_v.labor_effort%TYPE --pa_proj_elem_ver_schedule.planned_effort%TYPE 3746912
20383: INDEX BY BINARY_INTEGER;
20384:
20385: TYPE task_weightage_tbl IS TABLE OF pa_object_relationships.weighting_percentage%TYPE
20386: INDEX BY BINARY_INTEGER;

Line 20407: pa_proj_elem_ver_schedule sch,

20403: sch.duration,
20404: ptt.prog_entry_enable_flag
20405: from pa_proj_element_versions ver,
20406: pa_object_relationships rel,
20407: pa_proj_elem_ver_schedule sch,
20408: pa_proj_elements ele,
20409: pa_task_types ptt,
20410: pji_xbs_plans_v pxpv
20411: -- pji_fm_xbs_accum_tmp1 pfxat