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 535: FROM pa_proj_elem_ver_schedule

531:
532: -- xxlu added for DFF attributes for calling create_schedule_version
533: CURSOR cur_ver_sch_attr_rec(c_element_version_id IN NUMBER) IS
534: SELECT *
535: FROM pa_proj_elem_ver_schedule
536: WHERE element_version_id = c_element_version_id
537: AND project_id = p_project_id
538: ;
539: l_ver_sch_attr_rec cur_ver_sch_attr_rec%ROWTYPE;

Line 1079: FROM pa_proj_elem_ver_schedule

1075:
1076: -- xxlu added for DFF attributes for calling create_schedule_version
1077: CURSOR cur_ver_sch_attr_rec(c_element_version_id IN NUMBER) IS
1078: SELECT *
1079: FROM pa_proj_elem_ver_schedule
1080: WHERE element_version_id = c_element_version_id
1081: and project_id = p_project_id
1082: ;
1083: l_ver_sch_attr_rec cur_ver_sch_attr_rec%ROWTYPE;

Line 1576: update pa_proj_elem_ver_schedule

1572:
1573: --Bug 2732907
1574: IF l_ref_task_version_id IS NOT NULL
1575: THEN
1576: update pa_proj_elem_ver_schedule
1577: set WQ_PLANNED_QUANTITY = null
1578: where element_version_id = l_ref_task_version_id
1579: and project_id = p_project_id
1580: and proj_element_id = p_parent_task_id;

Line 1662: update pa_proj_elem_ver_schedule

1658:
1659: --Bug 2732907
1660: IF l_ref_task_version_id IS NOT NULL
1661: THEN
1662: update pa_proj_elem_ver_schedule
1663: set WQ_PLANNED_QUANTITY = null
1664: where element_version_id = l_ref_task_version_id
1665: and project_id = p_project_id
1666: and proj_element_id = p_parent_task_id;

Line 2557: FROM pa_proj_elem_ver_schedule

2553:
2554: CURSOR cur_proj_sch( c_task_version_id NUMBER )
2555: IS
2556: SELECT pev_schedule_id, record_version_number
2557: FROM pa_proj_elem_ver_schedule
2558: WHERE element_version_id = c_task_version_id
2559: AND project_id = p_project_id
2560: AND proj_element_id = p_task_id; --This will give u unique record.
2561:

Line 2592: FROM pa_proj_elem_ver_schedule

2588:
2589: -- xxlu added for DFF attributes for calling update_schedule_version
2590: CURSOR cur_ver_sch_attr_rec(c_element_version_id IN NUMBER) IS
2591: SELECT *
2592: FROM pa_proj_elem_ver_schedule
2593: WHERE element_version_id = c_element_version_id
2594: and project_id = p_project_id;
2595: l_ver_sch_attr_rec cur_ver_sch_attr_rec%ROWTYPE;
2596: -- end xxlu changes

Line 2683: from pa_proj_elem_ver_schedule ppevs, pa_proj_elements ppe

2679: cursor l_task_cur(p_project_id NUMBER, p_struct_ver_id NUMBER) is
2680: /* --bug 3880482
2681: select
2682: element_version_id,planned_effort,actual_start_date,actual_finish_date
2683: from pa_proj_elem_ver_schedule ppevs, pa_proj_elements ppe
2684: where ppevs.project_id = ppe.project_id
2685: and ppevs.proj_element_id = ppe.proj_element_id
2686: and ppe.object_type = 'PA_TASKS'
2687: and ppevs.project_id = p_project_id;

Line 2695: pa_proj_elem_ver_schedule ppevs

2691: ,ppevs.planned_effort
2692: ,ppevs.actual_start_date
2693: ,ppevs.actual_finish_date
2694: FROM
2695: pa_proj_elem_ver_schedule ppevs
2696: ,pa_proj_element_versions ppv
2697: WHERE
2698: ppevs.project_id = ppv.project_id
2699: and ppevs.proj_element_id = ppv.proj_element_id

Line 3970: DELETE FROM pa_proj_elem_ver_schedule where project_id = p_project_id;

3966:
3967: PA_PROJ_ELEMENTS_PKG.DELETE_ROW( cur_proj_elems_rec.rowid );
3968: END LOOP;
3969:
3970: DELETE FROM pa_proj_elem_ver_schedule where project_id = p_project_id;
3971: DELETE FROM pa_proj_elem_ver_structure where project_id = p_project_id;
3972:
3973: /* Code to delete project records from tables: pa_progress_rollup, pa_proj_progress_attr
3974: and pa_proj_workplan_attr. */

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

4661: (object_id_to1 = cur_task_vers_rec.element_version_id OR
4662: object_id_from1 = cur_task_vers_rec.element_version_id);
4663:
4664: --it is possible that COSTING and WORKPLAN str are same. so delete from schedule versions as well.
4665: DELETE FROM pa_proj_elem_ver_schedule WHERE element_version_id = cur_task_vers_rec.element_version_id and project_id = p_project_id;
4666:
4667: DELETE FROM pa_proj_element_versions WHERE element_version_id = cur_task_vers_rec.element_version_id;
4668:
4669: DELETE FROM pa_proj_elements WHERE proj_element_id = cur_task_vers_rec.proj_element_id;

Line 6518: pa_proj_elem_ver_schedule a,

6514:
6515: CURSOR c1 IS
6516: select MAX(a.last_update_date)
6517: from pa_proj_element_versions b,
6518: pa_proj_elem_ver_schedule a,
6519: pa_proj_elem_ver_structure c
6520: where p_structure_version_id = c.element_version_id
6521: and l_project_id = c.project_id
6522: and c.status_code <> 'STRUCTURE_PUBLISHED'

Line 6532: pa_proj_elem_ver_schedule a,

6528: /*
6529: CURSOR c1 IS
6530: SELECT MAX(a.last_update_date)
6531: FROM pa_proj_element_versions b,
6532: pa_proj_elem_ver_schedule a,
6533: pa_proj_elem_ver_structure c
6534: WHERE a.element_version_id (+)= b.element_version_id
6535: AND a.project_id (+) = b.project_id
6536: AND a.proj_element_id (+) = b.proj_element_id

Line 6637: FROM pa_proj_elem_ver_schedule

6633:
6634: --This cursor gets the schedule start date from the source project
6635: CURSOR cur_get_src_sch_st_date(c_project_id NUMBER, c_struc_ver_id NUMBER) IS
6636: SELECT scheduled_start_date
6637: FROM pa_proj_elem_ver_schedule
6638: WHERE project_id = c_project_id
6639: AND element_version_id = c_struc_ver_id;
6640:
6641: l_debug_mode VARCHAR2(1);

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

6988: -- p_src_project_id NUMBER Y The source project id
6989: -- p_dest_project_id NUMBER Y The destination project id
6990: -- p_dest_fn_structure_id NUMBER Y The destination project's financial structure id
6991: -- p_shared VARCHAR2 Y Whether source/destination project is shared or not
6992: -- p_copy_ppevSchedules_flag NUMBER Y Whether pa_proj_elem_ver_schedule entry from the source project
6993: -- should be copied into the destination project or not
6994: -- p_target_start_date DATE Y The start date of the destination project
6995: -- p_target_finish_date DATE Y The finish date of the destination project
6996: -- p_calendar_id NUMBER Y The calendar id

Line 7053: FROM pa_proj_elem_ver_schedule

7049:
7050: --This cursor gets the schedule start date from the source project
7051: CURSOR cur_get_src_sch_st_date(c_project_id NUMBER, c_struc_ver_id NUMBER) IS
7052: SELECT scheduled_start_date
7053: FROM pa_proj_elem_ver_schedule
7054: WHERE project_id = c_project_id
7055: AND element_version_id = c_struc_ver_id;
7056:
7057: --Bug 3387963 - Cursor to get destination and source project's organization id

Line 7635: --Copy entries into pa_proj_elem_ver_schedule

7631: CLOSE cur_get_src_sch_st_date;
7632: l_delta := p_target_start_date - l_src_sch_st_date;
7633: END IF;
7634:
7635: --Copy entries into pa_proj_elem_ver_schedule
7636: INSERT INTO pa_proj_elem_ver_schedule(
7637: PEV_SCHEDULE_ID
7638: ,ELEMENT_VERSION_ID
7639: ,PROJECT_ID

Line 7636: INSERT INTO pa_proj_elem_ver_schedule(

7632: l_delta := p_target_start_date - l_src_sch_st_date;
7633: END IF;
7634:
7635: --Copy entries into pa_proj_elem_ver_schedule
7636: INSERT INTO pa_proj_elem_ver_schedule(
7637: PEV_SCHEDULE_ID
7638: ,ELEMENT_VERSION_ID
7639: ,PROJECT_ID
7640: ,PROJ_ELEMENT_ID

Line 7687: pa_proj_elem_ver_schedule_s.nextval

7683: ,source_object_id
7684: ,source_object_type
7685: )
7686: SELECT
7687: pa_proj_elem_ver_schedule_s.nextval
7688: ,ppev1.ELEMENT_VERSION_ID
7689: ,p_dest_project_id
7690: ,ppev1.PROJ_ELEMENT_ID
7691: ,SYSDATE

Line 7743: FROM pa_proj_elem_ver_schedule ppevs,

7739: ,ppevs.ATTRIBUTE14
7740: ,ppevs.ATTRIBUTE15
7741: ,p_dest_project_id
7742: ,'PA_PROJECTS'
7743: FROM pa_proj_elem_ver_schedule ppevs,
7744: pa_proj_element_versions ppev1,
7745: pa_proj_element_versions ppev2
7746: WHERE ppev1.project_id = p_dest_project_id
7747: AND ppev1.attribute15 = ppevs.element_version_id

Line 7915: FROM pa_proj_elem_ver_schedule

7911:
7912: --This cursor gets the schedule start date from the source project
7913: CURSOR cur_get_src_sch_st_date(c_project_id NUMBER, c_struc_ver_id NUMBER) IS
7914: SELECT scheduled_start_date
7915: FROM pa_proj_elem_ver_schedule
7916: WHERE project_id = c_project_id
7917: AND element_version_id = c_struc_ver_id;
7918:
7919: CURSOR cur_get_working_ver_num(c_project_id NUMBER, c_proj_element_id NUMBER) IS

Line 9850: --Copy entries into pa_proj_elem_ver_schedule

9846: CLOSE cur_get_src_sch_st_date;
9847: l_delta := p_target_start_date - l_src_sch_st_date;
9848: END IF;
9849:
9850: --Copy entries into pa_proj_elem_ver_schedule
9851: INSERT INTO pa_proj_elem_ver_schedule(
9852: PEV_SCHEDULE_ID
9853: ,ELEMENT_VERSION_ID
9854: ,PROJECT_ID

Line 9851: INSERT INTO pa_proj_elem_ver_schedule(

9847: l_delta := p_target_start_date - l_src_sch_st_date;
9848: END IF;
9849:
9850: --Copy entries into pa_proj_elem_ver_schedule
9851: INSERT INTO pa_proj_elem_ver_schedule(
9852: PEV_SCHEDULE_ID
9853: ,ELEMENT_VERSION_ID
9854: ,PROJECT_ID
9855: ,PROJ_ELEMENT_ID

Line 9912: pa_proj_elem_ver_schedule_s.nextval

9908: ,EXT_REMAIN_DURATION
9909: ,EXT_SCH_DURATION --Bug 3762437
9910: )
9911: SELECT
9912: pa_proj_elem_ver_schedule_s.nextval
9913: ,ppev.ELEMENT_VERSION_ID
9914: ,p_dest_PROJECT_ID
9915: ,ppev.PROJ_ELEMENT_ID
9916: ,SYSDATE

Line 9979: pa_proj_elem_ver_schedule ppevs

9975: ,EXT_ACT_DURATION
9976: ,EXT_REMAIN_DURATION
9977: ,EXT_SCH_DURATION --Bug 3762437
9978: FROM pa_proj_element_versions ppev,
9979: pa_proj_elem_ver_schedule ppevs
9980: WHERE ppev.project_id = p_dest_project_id
9981: AND ppev.parent_structure_version_id = rec_dest_wp_struc_versions.element_version_id
9982: AND ppev.attribute15 = ppevs.element_version_id
9983: AND ppevs.project_id = p_src_project_id ;

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

10046: ,p_src_project_id => p_src_project_id
10047: ,p_dest_project_id => p_dest_project_id
10048: ,p_dest_fn_structure_id => l_dest_wp_structure_id
10049: ,p_shared => l_shared
10050: ,p_copy_ppevSchedules_flag => 'Y' --Copy pa_proj_elem_ver_schedules or not
10051: ,p_target_start_date => p_target_start_date
10052: ,p_target_finish_date => p_target_finish_date
10053: ,p_calendar_id => p_calendar_id
10054: ,x_return_status => l_return_status

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

10180: ,p_dest_project_id
10181: ,'PA_PROJECTS'
10182: );
10183:
10184: --bug 3912603, insert records into pa_proj_elem_ver_Schedule, Satish, start
10185: PA_TASK_PUB1.Create_Schedule_Version(
10186: p_element_version_id => l_new_wp_ver_id
10187: ,p_scheduled_start_date => SYSDATE
10188: ,p_scheduled_end_date => SYSDATE

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

10197: x_msg_data := l_msg_data;
10198: END IF;
10199: RAISE FND_API.G_EXC_ERROR;
10200: END IF;
10201: --bug 3912603, insert records into pa_proj_elem_ver_Schedule, Satish, end
10202:
10203: END IF;
10204: END IF;--If there is atleast one WP version selected
10205:

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

10247: ,p_src_project_id => p_src_project_id
10248: ,p_dest_project_id => p_dest_project_id
10249: ,p_dest_fn_structure_id => l_dest_fn_structure_id
10250: ,p_shared => l_shared
10251: ,p_copy_ppevSchedules_flag => 'N' --Copy pa_proj_elem_ver_schedules or not
10252: ,p_target_start_date => p_target_start_date
10253: ,p_target_finish_date => p_target_finish_date
10254: ,p_calendar_id => p_calendar_id
10255: ,x_return_status => l_return_status

Line 10285: /*UPDATE pa_proj_elem_ver_schedule

10281: --Updating Duration
10282: IF l_workplan_enabled = 'Y' THEN
10283: -- Bug 3657808 Remove duration calculation using calendar
10284: -- and rewritting the query
10285: /*UPDATE pa_proj_elem_ver_schedule
10286: SET duration = PA_PROJ_TASK_STRUC_PUB.calc_duration( p_calendar_id,
10287: scheduled_start_date,
10288: scheduled_finish_date )
10289: WHERE project_id = p_dest_project_id;*/

Line 10290: UPDATE pa_proj_elem_ver_schedule

10286: SET duration = PA_PROJ_TASK_STRUC_PUB.calc_duration( p_calendar_id,
10287: scheduled_start_date,
10288: scheduled_finish_date )
10289: WHERE project_id = p_dest_project_id;*/
10290: UPDATE pa_proj_elem_ver_schedule
10291: SET duration = trunc(scheduled_finish_date) - trunc(scheduled_start_date) + 1
10292: WHERE project_id = p_dest_project_id;
10293: END IF;
10294:

Line 10303: FROM pa_proj_elem_ver_schedule ppevs,

10299: ,BASELINE_DURATION
10300: ) = ( SELECT ppevs.scheduled_start_date
10301: ,ppevs.scheduled_finish_date
10302: ,ppevs.duration
10303: FROM pa_proj_elem_ver_schedule ppevs,
10304: pa_proj_element_versions ppev
10305: WHERE ppevs.project_id = p_dest_project_id
10306: AND ppevs.proj_element_id = ppev.proj_element_id
10307: AND ppevs.element_version_id = ppev.element_version_id

Line 10347: FROM pa_proj_elem_ver_schedule

10343: UPDATE pa_projects_all
10344: SET ( scheduled_START_DATE ,scheduled_FINISH_DATE, scheduled_duration, scheduled_as_of_date ) =
10345: ( SELECT SCHEDULED_START_DATE ,SCHEDULED_FINISH_DATE, duration,
10346: decode( SCHEDULED_START_DATE, null, null, sysdate )
10347: FROM pa_proj_elem_ver_schedule
10348: WHERE project_id = p_dest_project_id
10349: AND element_version_id = l_dest_latest_pub_ver_id
10350: )
10351: WHERE project_id = p_dest_project_id;

Line 10371: FROM pa_proj_elem_ver_schedule

10367: UPDATE pa_projects_all
10368: SET ( scheduled_START_DATE ,scheduled_FINISH_DATE, scheduled_duration, scheduled_as_of_date ) =
10369: ( SELECT SCHEDULED_START_DATE ,SCHEDULED_FINISH_DATE, duration,
10370: decode( SCHEDULED_START_DATE, null, null, sysdate )
10371: FROM pa_proj_elem_ver_schedule
10372: WHERE project_id = p_dest_project_id
10373: AND element_version_id = l_only_wp_ver_id
10374: )
10375: WHERE project_id = p_dest_project_id;

Line 10901: from pa_proj_elem_ver_schedule

10897: l_delta NUMBER;
10898: l_src_sch_st_date DATE;
10899: CURSOR get_src_sch_st_date(c_project_id NUMBER, c_struc_ver_id NUMBER) IS
10900: select scheduled_start_date
10901: from pa_proj_elem_ver_schedule
10902: where project_id = c_project_id
10903: and element_version_id = c_struc_ver_id;
10904:
10905:

Line 12955: INSERT INTO pa_proj_elem_ver_schedule(

12951: CLOSE get_src_sch_st_date;
12952: l_delta := p_target_start_date - l_src_sch_st_date;
12953: END IF;
12954:
12955: INSERT INTO pa_proj_elem_ver_schedule(
12956: PEV_SCHEDULE_ID
12957: ,ELEMENT_VERSION_ID
12958: ,PROJECT_ID
12959: ,PROJ_ELEMENT_ID

Line 13016: pa_proj_elem_ver_schedule_s.nextval

13012: ,EXT_REMAIN_DURATION
13013: ,EXT_SCH_DURATION --Bug 3762437
13014: )
13015: SELECT
13016: pa_proj_elem_ver_schedule_s.nextval
13017: ,ppev1.ELEMENT_VERSION_ID
13018: ,p_dest_PROJECT_ID
13019: ,ppev1.PROJ_ELEMENT_ID
13020: ,SYSDATE

Line 13083: FROM pa_proj_elem_ver_schedule ppevs,

13079: ,LEVEL_ASSIGNMENTS_FLAG
13080: ,EXT_ACT_DURATION
13081: ,EXT_REMAIN_DURATION
13082: ,EXT_SCH_DURATION --Bug 3762437
13083: FROM pa_proj_elem_ver_schedule ppevs,
13084: pa_proj_element_versions ppev1,
13085: pa_proj_element_versions ppev2
13086: where ppev1.attribute15 = ppevs.element_version_id
13087: and ppevs.project_id = p_src_project_id

Line 13106: /*UPDATE pa_proj_elem_ver_schedule

13102: THEN
13103: --updating duration
13104: -- Bug 3657808 Remove duration calculation using calendar
13105: -- and rewritting the query
13106: /*UPDATE pa_proj_elem_ver_schedule
13107: SET duration = PA_PROJ_TASK_STRUC_PUB.calc_duration( p_calendar_id,
13108: scheduled_start_date,
13109: scheduled_finish_date )
13110: WHERE project_id = p_dest_project_id;*/

Line 13111: UPDATE pa_proj_elem_ver_schedule

13107: SET duration = PA_PROJ_TASK_STRUC_PUB.calc_duration( p_calendar_id,
13108: scheduled_start_date,
13109: scheduled_finish_date )
13110: WHERE project_id = p_dest_project_id;*/
13111: UPDATE pa_proj_elem_ver_schedule
13112: SET duration = trunc(scheduled_finish_date) - trunc(scheduled_start_date) + 1
13113: WHERE project_id = p_dest_project_id;
13114: END IF;
13115:

Line 13122: from pa_proj_elem_ver_schedule ppevs,

13118: SET ( BASELINE_START_DATE ,BASELINE_FINISH_DATE,
13119: BASELINE_DURATION ) =
13120: ( Select ppevs.scheduled_start_date, ppevs.scheduled_finish_date,
13121: ppevs.duration
13122: from pa_proj_elem_ver_schedule ppevs,
13123: pa_proj_elem_ver_structure ppevst
13124: WHERE ppevs.project_id = p_dest_project_id
13125: and ppevst.project_id = p_dest_project_id
13126: and ppevst.current_flag = 'Y' --assuming this is the flag used to identify the baselined structure ver.

Line 13154: FROM pa_proj_elem_ver_schedule

13150: update pa_projects_all
13151: set ( scheduled_START_DATE ,scheduled_FINISH_DATE, scheduled_duration, scheduled_as_of_date ) =
13152: ( SELECT SCHEDULED_START_DATE ,SCHEDULED_FINISH_DATE,duration,
13153: decode(SCHEDULED_START_DATE, null, null, sysdate)
13154: FROM pa_proj_elem_ver_schedule
13155: WHERE project_id = p_dest_project_Id
13156: and element_version_id = l_latest_pub_str_ver_id)
13157: where project_id = p_dest_project_id;
13158: END IF;

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

13697: AND parent_structure_version_id = c_structure_version_id
13698: AND object_type = 'PA_TASKS';
13699:
13700: --Cursor to get the parent version id of the task version id
13701: CURSOR cur_parent_object_rel( c_task_version_id pa_proj_elem_ver_schedule.element_version_id%TYPE )
13702: IS
13703: SELECT object_id_from1 -- parent task id
13704: ,object_relationship_id, -- relationship id reqd for update relationship API
13705: record_version_number,

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

13708: WHERE object_id_to1 = c_task_version_id
13709: AND relationship_type = 'S';
13710:
13711: -- Added for DFF attributes for calling update_schedule_version
13712: CURSOR cur_ver_sch_attr_rec(c_element_version_id IN pa_proj_elem_ver_schedule.element_version_id%TYPE)
13713: IS
13714: SELECT *
13715: FROM pa_proj_elem_ver_schedule
13716: WHERE element_version_id = c_element_version_id

Line 13715: FROM pa_proj_elem_ver_schedule

13711: -- Added for DFF attributes for calling update_schedule_version
13712: CURSOR cur_ver_sch_attr_rec(c_element_version_id IN pa_proj_elem_ver_schedule.element_version_id%TYPE)
13713: IS
13714: SELECT *
13715: FROM pa_proj_elem_ver_schedule
13716: WHERE element_version_id = c_element_version_id
13717: AND project_id = p_project_id;
13718:
13719: l_ver_sch_attr_rec cur_ver_sch_attr_rec%ROWTYPE;

Line 13935: from pa_proj_elem_ver_schedule ppevs, pa_proj_elements ppe

13931:
13932: cursor l_task_cur(p_project_id NUMBER) is
13933: select
13934: element_version_id,planned_effort,actual_start_date,actual_finish_date
13935: from pa_proj_elem_ver_schedule ppevs, pa_proj_elements ppe
13936: where ppevs.project_id = ppe.project_id
13937: and ppevs.proj_element_id = ppe.proj_element_id
13938: and ppe.object_type = 'PA_TASKS'
13939: and ppevs.project_id = p_project_id;

Line 16618: l_wq_planned_quantity pa_proj_elem_ver_schedule.wq_planned_quantity%TYPE;

16614: -- l_wq_planned_quantity
16615: -- l_ver_sch_attr_rec (only for update task)
16616:
16617: DECLARE
16618: l_wq_planned_quantity pa_proj_elem_ver_schedule.wq_planned_quantity%TYPE;
16619: l_scheduled_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;
16620: l_scheduled_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;
16621: l_task_type_id pa_proj_elements.type_id%TYPE;
16622: BEGIN

Line 16619: l_scheduled_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;

16615: -- l_ver_sch_attr_rec (only for update task)
16616:
16617: DECLARE
16618: l_wq_planned_quantity pa_proj_elem_ver_schedule.wq_planned_quantity%TYPE;
16619: l_scheduled_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;
16620: l_scheduled_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;
16621: l_task_type_id pa_proj_elements.type_id%TYPE;
16622: BEGIN
16623:

Line 16620: l_scheduled_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;

16616:
16617: DECLARE
16618: l_wq_planned_quantity pa_proj_elem_ver_schedule.wq_planned_quantity%TYPE;
16619: l_scheduled_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;
16620: l_scheduled_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;
16621: l_task_type_id pa_proj_elements.type_id%TYPE;
16622: BEGIN
16623:
16624: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

Line 19301: FROM pa_proj_elem_ver_schedule

19297: --bug 4019845
19298: CURSOR get_scheduled_dates(c_project_id NUMBER, c_structure_version_id NUMBER)
19299: IS
19300: SELECT scheduled_start_date, scheduled_finish_date
19301: FROM pa_proj_elem_ver_schedule
19302: WHERE project_id = c_project_id
19303: AND element_version_id = c_structure_version_id;
19304:
19305: CURSOR get_proj_rec_ver_number(c_project_id NUMBER)

Line 21151: summed_effort pa_proj_elem_ver_schedule.planned_effort%TYPE

21147:
21148: -- This record contains the summary information of the child tasks for a parent task.
21149: TYPE CHILD_INFO_REC IS RECORD
21150: (
21151: summed_effort pa_proj_elem_ver_schedule.planned_effort%TYPE
21152: ,summed_duration pa_proj_elem_ver_schedule.duration%TYPE
21153: ,child_count Number
21154: ,cum_alloted_weightage pa_object_relationships.weighting_percentage%TYPE
21155: ,processed_child_count Number

Line 21152: ,summed_duration pa_proj_elem_ver_schedule.duration%TYPE

21148: -- This record contains the summary information of the child tasks for a parent task.
21149: TYPE CHILD_INFO_REC IS RECORD
21150: (
21151: summed_effort pa_proj_elem_ver_schedule.planned_effort%TYPE
21152: ,summed_duration pa_proj_elem_ver_schedule.duration%TYPE
21153: ,child_count Number
21154: ,cum_alloted_weightage pa_object_relationships.weighting_percentage%TYPE
21155: ,processed_child_count Number
21156: -- Following added for bug 3053472

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

21170:
21171: 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
21172: INDEX BY BINARY_INTEGER;
21173:
21174: TYPE duration_tbl IS TABLE OF pa_proj_elem_ver_schedule.duration%TYPE
21175: INDEX BY BINARY_INTEGER;
21176:
21177: TYPE effort_tbl IS TABLE OF pji_xbs_plans_v.labor_effort%TYPE --pa_proj_elem_ver_schedule.planned_effort%TYPE 3746912
21178: INDEX BY BINARY_INTEGER;

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

21173:
21174: TYPE duration_tbl IS TABLE OF pa_proj_elem_ver_schedule.duration%TYPE
21175: INDEX BY BINARY_INTEGER;
21176:
21177: TYPE effort_tbl IS TABLE OF pji_xbs_plans_v.labor_effort%TYPE --pa_proj_elem_ver_schedule.planned_effort%TYPE 3746912
21178: INDEX BY BINARY_INTEGER;
21179:
21180: TYPE task_weightage_tbl IS TABLE OF pa_object_relationships.weighting_percentage%TYPE
21181: INDEX BY BINARY_INTEGER;

Line 21202: pa_proj_elem_ver_schedule sch,

21198: sch.duration,
21199: ptt.prog_entry_enable_flag
21200: from pa_proj_element_versions ver,
21201: pa_object_relationships rel,
21202: pa_proj_elem_ver_schedule sch,
21203: pa_proj_elements ele,
21204: pa_task_types ptt,
21205: pji_xbs_plans_v pxpv
21206: -- pji_fm_xbs_accum_tmp1 pfxat