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_RELATIONSHIP_PVT dependencies on PA_COPY_DEP_TEMP

Line 1895: pa_copy_dep_temp dt1,

1891: rel.object_id_from1, dt1.dest_task_ver_id DEST_FROM_ID,
1892: rel.object_id_to1, dt2.dest_task_ver_id DEST_TO_ID,
1893: rel.comments, rel.LAG_DAY, rel.RELATIONSHIP_SUBTYPE
1894: from pa_object_relationships rel,
1895: pa_copy_dep_temp dt1,
1896: pa_copy_dep_temp dt2
1897: where rel.relationship_type = 'D'
1898: and rel.object_id_from1 = dt1.src_task_ver_id
1899: and rel.object_id_to1 = dt2.src_task_ver_id

Line 1896: pa_copy_dep_temp dt2

1892: rel.object_id_to1, dt2.dest_task_ver_id DEST_TO_ID,
1893: rel.comments, rel.LAG_DAY, rel.RELATIONSHIP_SUBTYPE
1894: from pa_object_relationships rel,
1895: pa_copy_dep_temp dt1,
1896: pa_copy_dep_temp dt2
1897: where rel.relationship_type = 'D'
1898: and rel.object_id_from1 = dt1.src_task_ver_id
1899: and rel.object_id_to1 = dt2.src_task_ver_id
1900: and rel.object_id_from2 = object_id_to2

Line 1918: from pa_object_relationships rel, pa_copy_dep_temp pcdt

1914: -- select all predecessor dependencies from the source task to other tasks in the project.
1915: select pcdt.dest_task_ver_id suc_ver_id, rel.object_id_to1 pred_ver_id
1916: , rel.object_id_from2 suc_proj_id, rel.object_id_to2 pred_proj_id
1917: , rel.relationship_subtype sub_type, rel.lag_day lag_day, rel.comments comments
1918: from pa_object_relationships rel, pa_copy_dep_temp pcdt
1919: where rel.object_id_from1 = pcdt.src_task_ver_id
1920: and rel.relationship_type = 'D'
1921: and rel.object_id_from2 = rel.object_id_to2
1922: and object_type_from = 'PA_TASKS'

Line 1946: from pa_object_relationships rel, pa_copy_dep_temp pcdt

1942: -- select all successor dependencies from other tasks in the project to the source task.
1943: select rel.object_id_from1 suc_ver_id, pcdt.dest_task_ver_id pred_ver_id
1944: , rel.object_id_from2 suc_proj_id, rel.object_id_to2 pred_proj_id
1945: , rel.relationship_subtype sub_type, rel.lag_day lag_day, rel.comments comments
1946: from pa_object_relationships rel, pa_copy_dep_temp pcdt
1947: where rel.object_id_to1 = pcdt.src_task_ver_id
1948: and rel.relationship_type = 'D'
1949: and rel.object_id_from2 = rel.object_id_to2
1950: and object_type_from = 'PA_TASKS'

Line 1978: from pa_object_relationships rel, pa_copy_dep_temp pcdt, pa_copy_dep_temp pcdt2

1974: -- select all predecessor dependencies from the source task to other tasks in the project.
1975: select pcdt.dest_task_ver_id suc_ver_id, pcdt2.dest_task_ver_id pred_ver_id
1976: , rel.object_id_from2 suc_proj_id, rel.object_id_to2 pred_proj_id
1977: , rel.relationship_subtype sub_type, rel.lag_day lag_day, rel.comments comments
1978: from pa_object_relationships rel, pa_copy_dep_temp pcdt, pa_copy_dep_temp pcdt2
1979: where rel.object_id_from1 = pcdt.src_task_ver_id
1980: and rel.relationship_type = 'D'
1981: and rel.object_id_to1 = pcdt2.src_task_ver_id
1982: and rel.object_id_from2 = rel.object_id_to2

Line 2007: from pa_object_relationships rel, pa_copy_dep_temp pcdt, pa_copy_dep_temp pcdt2

2003: -- select all successor dependencies from other tasks in the project to the source task.
2004: select pcdt2.dest_task_ver_id suc_ver_id, pcdt.dest_task_ver_id pred_ver_id
2005: , rel.object_id_from2 suc_proj_id, rel.object_id_to2 pred_proj_id
2006: , rel.relationship_subtype sub_type, rel.lag_day lag_day, rel.comments comments
2007: from pa_object_relationships rel, pa_copy_dep_temp pcdt, pa_copy_dep_temp pcdt2
2008: where rel.object_id_to1 = pcdt.src_task_ver_id
2009: and rel.relationship_type = 'D'
2010: and rel.object_id_from1 = pcdt2.src_task_ver_id
2011: and rel.object_id_from2 = rel.object_id_to2

Line 2043: from pa_copy_dep_temp pcdt);

2039: from pa_proj_element_versions ppev2
2040: where ppev2.element_version_id = c_task_ver_id)
2041: and ppev.object_type = 'PA_TASKS'
2042: and ppev.element_version_id not in (select pcdt.src_task_ver_id
2043: from pa_copy_dep_temp pcdt);
2044:
2045: l_count_all_tasks NUMBER := null;
2046:
2047: -- End Bug # 4354217 : 15-AUG-2005.

Line 2075: pa_debug.write(x_Module=>'PA_RELATIONSHIP_PVT.COPY_INTRA_DEPENDENCY', x_Msg => 'Before BULK insert into PA_COPY_DEP_TEMP table', x_Log_Level=> 3);

2071: --bug 4153377
2072: --insert mapping ids
2073: --debug messages added while fixing bug 5067296
2074: IF (l_debug_mode = 'Y') THEN
2075: pa_debug.write(x_Module=>'PA_RELATIONSHIP_PVT.COPY_INTRA_DEPENDENCY', x_Msg => 'Before BULK insert into PA_COPY_DEP_TEMP table', x_Log_Level=> 3);
2076: END IF;
2077: --debug messages added while fixing bug 5067296
2078: Forall i IN 1..P_Source_Ver_Tbl.Count
2079: INSERT INTO PA_COPY_DEP_TEMP(SRC_TASK_VER_ID, DEST_TASK_VER_ID)

Line 2079: INSERT INTO PA_COPY_DEP_TEMP(SRC_TASK_VER_ID, DEST_TASK_VER_ID)

2075: pa_debug.write(x_Module=>'PA_RELATIONSHIP_PVT.COPY_INTRA_DEPENDENCY', x_Msg => 'Before BULK insert into PA_COPY_DEP_TEMP table', x_Log_Level=> 3);
2076: END IF;
2077: --debug messages added while fixing bug 5067296
2078: Forall i IN 1..P_Source_Ver_Tbl.Count
2079: INSERT INTO PA_COPY_DEP_TEMP(SRC_TASK_VER_ID, DEST_TASK_VER_ID)
2080: VALUES(p_source_ver_tbl(i), p_destin_ver_tbl(i));
2081:
2082: -- Begin fix for Bug # 4354217.
2083: