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 1897: pa_copy_dep_temp dt1,

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

Line 1898: pa_copy_dep_temp dt2

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

Line 1917: -- Note that pa_copy_dep_temp will not have all the tasks in the copy tasks context

1913:
1914: -- Bug 9247114
1915: -- Reverted to the old definition of get_dependency3 since the new definition added as part
1916: -- of bug 4947328 did not resolve the original issue, and also resulted in P1 bug 9247114
1917: -- Note that pa_copy_dep_temp will not have all the tasks in the copy tasks context
1918:
1919: cursor get_dependency3 is
1920: -- select all predecessor dependencies from the source task to other tasks in the project.
1921: select pcdt.dest_task_ver_id suc_ver_id, rel.object_id_to1 pred_ver_id

Line 1924: from pa_object_relationships rel, pa_copy_dep_temp pcdt

1920: -- select all predecessor dependencies from the source task to other tasks in the project.
1921: select pcdt.dest_task_ver_id suc_ver_id, rel.object_id_to1 pred_ver_id
1922: , rel.object_id_from2 suc_proj_id, rel.object_id_to2 pred_proj_id
1923: , rel.relationship_subtype sub_type, rel.lag_day lag_day, rel.comments comments
1924: from pa_object_relationships rel, pa_copy_dep_temp pcdt
1925: where rel.object_id_from1 = pcdt.src_task_ver_id
1926: and rel.relationship_type = 'D'
1927: and rel.object_id_from2 = rel.object_id_to2
1928: and object_type_from = 'PA_TASKS'

Line 1952: from pa_object_relationships rel, pa_copy_dep_temp pcdt

1948: -- select all successor dependencies from other tasks in the project to the source task.
1949: select rel.object_id_from1 suc_ver_id, pcdt.dest_task_ver_id pred_ver_id
1950: , rel.object_id_from2 suc_proj_id, rel.object_id_to2 pred_proj_id
1951: , rel.relationship_subtype sub_type, rel.lag_day lag_day, rel.comments comments
1952: from pa_object_relationships rel, pa_copy_dep_temp pcdt
1953: where rel.object_id_to1 = pcdt.src_task_ver_id
1954: and rel.relationship_type = 'D'
1955: and rel.object_id_from2 = rel.object_id_to2
1956: and object_type_from = 'PA_TASKS'

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

1981: -- select all predecessor dependencies from the source task to other tasks in the project.
1982: select pcdt.dest_task_ver_id suc_ver_id, pcdt2.dest_task_ver_id pred_ver_id
1983: , rel.object_id_from2 suc_proj_id, rel.object_id_to2 pred_proj_id
1984: , rel.relationship_subtype sub_type, rel.lag_day lag_day, rel.comments comments
1985: from pa_object_relationships rel, pa_copy_dep_temp pcdt, pa_copy_dep_temp pcdt2
1986: where rel.object_id_from1 = pcdt.src_task_ver_id
1987: and rel.relationship_type = 'D'
1988: and rel.object_id_to1 = pcdt2.src_task_ver_id
1989: and rel.object_id_from2 = rel.object_id_to2

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

2010: -- select all successor dependencies from other tasks in the project to the source task.
2011: select pcdt2.dest_task_ver_id suc_ver_id, pcdt.dest_task_ver_id pred_ver_id
2012: , rel.object_id_from2 suc_proj_id, rel.object_id_to2 pred_proj_id
2013: , rel.relationship_subtype sub_type, rel.lag_day lag_day, rel.comments comments
2014: from pa_object_relationships rel, pa_copy_dep_temp pcdt, pa_copy_dep_temp pcdt2
2015: where rel.object_id_to1 = pcdt.src_task_ver_id
2016: and rel.relationship_type = 'D'
2017: and rel.object_id_from1 = pcdt2.src_task_ver_id
2018: and rel.object_id_from2 = rel.object_id_to2

Line 2050: from pa_copy_dep_temp pcdt);

2046: from pa_proj_element_versions ppev2
2047: where ppev2.element_version_id = c_task_ver_id)
2048: and ppev.object_type = 'PA_TASKS'
2049: and ppev.element_version_id not in (select pcdt.src_task_ver_id
2050: from pa_copy_dep_temp pcdt);
2051:
2052: l_count_all_tasks NUMBER := null;
2053:
2054: -- End Bug # 4354217 : 15-AUG-2005.

Line 2060: Delete from PA_COPY_DEP_TEMP; --Bug#8842950

2056: -- End fix for Bug # 4354217.
2057:
2058: l_debug_mode VARCHAR2(1); --debug messages added while fixing bug 5067296
2059: BEGIN
2060: Delete from PA_COPY_DEP_TEMP; --Bug#8842950
2061:
2062: --debug messages added while fixing bug 5067296
2063: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
2064:

Line 2083: 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);

2079: --bug 4153377
2080: --insert mapping ids
2081: --debug messages added while fixing bug 5067296
2082: IF (l_debug_mode = 'Y') THEN
2083: 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);
2084: END IF;
2085: --debug messages added while fixing bug 5067296
2086: Forall i IN 1..P_Source_Ver_Tbl.Count
2087: INSERT INTO PA_COPY_DEP_TEMP(SRC_TASK_VER_ID, DEST_TASK_VER_ID)

Line 2087: INSERT INTO PA_COPY_DEP_TEMP(SRC_TASK_VER_ID, DEST_TASK_VER_ID)

2083: 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);
2084: END IF;
2085: --debug messages added while fixing bug 5067296
2086: Forall i IN 1..P_Source_Ver_Tbl.Count
2087: INSERT INTO PA_COPY_DEP_TEMP(SRC_TASK_VER_ID, DEST_TASK_VER_ID)
2088: VALUES(p_source_ver_tbl(i), p_destin_ver_tbl(i));
2089:
2090: -- Begin fix for Bug # 4354217.
2091: