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

Line 96: , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL

92: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
93: , p_dlvr_type_name IN VARCHAR2 := NULL
94: , p_dlvr_reference IN VARCHAR2 := NULL -- 3435905
95: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL
96: , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL
97: , p_actual_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE := NULL
98: , p_task_id IN NUMBER := NULL
99: , p_task_version_id IN NUMBER := NULL
100: , p_task_name IN VARCHAR2 := NULL

Line 97: , p_actual_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE := NULL

93: , p_dlvr_type_name IN VARCHAR2 := NULL
94: , p_dlvr_reference IN VARCHAR2 := NULL -- 3435905
95: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL
96: , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL
97: , p_actual_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE := NULL
98: , p_task_id IN NUMBER := NULL
99: , p_task_version_id IN NUMBER := NULL
100: , p_task_name IN VARCHAR2 := NULL
101: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL

Line 140: l_new_pev_schedule_id PA_PROJ_ELEM_VER_SCHEDULE.PEV_SCHEDULE_ID%TYPE := NULL;

136:
137: X_ROW_ID VARCHAR2(18);
138: l_proj_element_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE := NULL;
139: l_dlvr_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL;
140: l_new_pev_schedule_id PA_PROJ_ELEM_VER_SCHEDULE.PEV_SCHEDULE_ID%TYPE := NULL;
141: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE := NULL;
142: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL; -- 3570283 added
143: l_prog_rollup_method VARCHAR2(30) := NULL;
144:

Line 690: , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL

686: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
687: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
688: , p_dlvr_type_name IN VARCHAR2 := NULL
689: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL
690: , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL
691: , p_actual_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE := NULL
692: , p_task_id IN NUMBER := NULL
693: , p_task_version_id IN NUMBER := NULL
694: , p_task_name IN VARCHAR2 := NULL

Line 691: , p_actual_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE := NULL

687: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
688: , p_dlvr_type_name IN VARCHAR2 := NULL
689: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL
690: , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL
691: , p_actual_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE := NULL
692: , p_task_id IN NUMBER := NULL
693: , p_task_version_id IN NUMBER := NULL
694: , p_task_name IN VARCHAR2 := NULL
695: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL

Line 816: pa_proj_elem_ver_schedule pev

812: SELECT
813: pev.pev_schedule_id,
814: ROWID
815: FROM
816: pa_proj_elem_ver_schedule pev
817: WHERE
818: pev.proj_element_id = p_dlvr_item_id AND
819: pev.ELEMENT_VERSION_ID = p_dlvr_version_id AND
820: pev.PROJECT_ID = p_project_id;

Line 842: pa_proj_elem_ver_schedule pvs

838: pvs.scheduled_finish_date,
839: pvs.actual_finish_date
840: From
841: pa_proj_elements ppe,
842: pa_proj_elem_ver_schedule pvs
843: Where
844: ppe.project_id = p_project_id and
845: ppe.proj_element_id = p_dlvr_item_id and
846: ppe.object_type = l_object_type and

Line 1844: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE

1840: AND relationship_type = 'S'
1841: AND RELATIONSHIP_SUBTYPE ='STRUCTURE_TO_DELIVERABLE';
1842:
1843: --The following delete Statements remove the deliverable details
1844: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE
1845: WHERE ELEMENT_VERSION_ID = p_dlv_version_id ;
1846:
1847: DELETE FROM PA_PROJ_ELEMENT_VERSIONS
1848: WHERE ELEMENT_VERSION_ID = p_dlv_version_id ;

Line 1953: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE

1949: WHERE ELEMENT_VERSION_ID = l_action_version_id_tbl(i) ;
1950:
1951:
1952: FORALL i IN l_action_version_id_tbl.FIRST..l_action_version_id_tbl.LAST
1953: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE
1954: WHERE ELEMENT_VERSION_ID = l_action_version_id_tbl(i) ;
1955: END IF ;
1956:
1957: --<>Included on 12-Feb-2004 by avaithia

Line 3000: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE

2996:
2997: DELETE FROM PA_PROJ_STRUCTURE_TYPES
2998: WHERE proj_element_id = l_proj_element_id ;
2999:
3000: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE
3001: WHERE proj_element_id = l_proj_element_id
3002: AND project_id = p_project_id ;/* Included project_id clause for Performance Bug Fix 3614361 */
3003:
3004: /*3614361 Included Delete from PA_PROJ_ELEM_VER_STRUCTURE */

Line 3042: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE

3038:
3039: -- 3986132 end
3040:
3041: FORALL j IN l_dlv_version_tbl.FIRST..l_dlv_version_tbl.LAST
3042: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE
3043: WHERE project_id = p_project_id
3044: AND element_version_id = l_dlv_version_tbl(j);
3045:
3046: FORALL j IN l_dlv_proj_elt_tbl.FIRST..l_dlv_proj_elt_tbl.LAST

Line 3722: ,pa_proj_elem_ver_schedule pvs

3718: ,ppe.type_id
3719: ,pvs.scheduled_finish_date
3720: ,ptt.initial_status_code -- Bug#3515852
3721: FROM pa_proj_elements ppe
3722: ,pa_proj_elem_ver_schedule pvs
3723: ,pa_proj_element_versions pev
3724: ,pa_task_types ptt
3725: WHERE ppe.proj_element_id = c_proj_element_id
3726: AND ppe.object_type = 'PA_DELIVERABLES'

Line 3769: ,pa_proj_elem_ver_schedule pvs

3765: ,ppe.type_id
3766: ,pvs.scheduled_finish_date
3767: ,ptt.initial_status_code -- Bug#3515852
3768: FROM pa_proj_elements ppe
3769: ,pa_proj_elem_ver_schedule pvs
3770: ,pa_proj_element_versions pev
3771: ,pa_task_types ptt
3772: WHERE ppe.project_id = p_source_project_id
3773: AND ppe.object_type = 'PA_DELIVERABLES'

Line 4380: pa_debug.g_err_stage:= 'Populating PA_PROJ_ELEM_VER_SCHEDULE ';

4376: RETURNING element_version_id
4377: BULK COLLECT INTO l_target_element_ver_id_tbl ;
4378:
4379: IF l_debug_mode = 'Y' THEN
4380: pa_debug.g_err_stage:= 'Populating PA_PROJ_ELEM_VER_SCHEDULE ';
4381: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4382: END IF;
4383:
4384:

Line 4385: -- Populate pa_proj_elem_ver_schedule table

4381: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4382: END IF;
4383:
4384:
4385: -- Populate pa_proj_elem_ver_schedule table
4386: FORALL i in l_proj_element_id_tbl.FIRST..l_proj_element_id_tbl.LAST
4387: INSERT INTO PA_PROJ_ELEM_VER_SCHEDULE(
4388: pev_schedule_id
4389: ,element_version_id

Line 4387: INSERT INTO PA_PROJ_ELEM_VER_SCHEDULE(

4383:
4384:
4385: -- Populate pa_proj_elem_ver_schedule table
4386: FORALL i in l_proj_element_id_tbl.FIRST..l_proj_element_id_tbl.LAST
4387: INSERT INTO PA_PROJ_ELEM_VER_SCHEDULE(
4388: pev_schedule_id
4389: ,element_version_id
4390: ,project_id
4391: ,proj_element_id

Line 4405: pa_proj_elem_ver_schedule_s.nextval

4401: ,source_object_type
4402: )
4403: VALUES
4404: (
4405: pa_proj_elem_ver_schedule_s.nextval
4406: ,l_target_element_ver_id_tbl(i)
4407: ,p_target_project_id
4408: ,l_proj_element_id_tbl(i)
4409: ,SYSDATE