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_OBJECT_RELATIONSHIPS

Line 76: l_id_from pa_object_relationships.object_id_from1%TYPE;

72: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
73: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
74: )
75: IS
76: l_id_from pa_object_relationships.object_id_from1%TYPE;
77: l_id_to pa_object_relationships.object_id_to1%TYPE;
78: l_type_from pa_object_relationships.object_type_from%TYPE;
79: l_type_to pa_object_relationships.object_type_to%TYPE;
80: l_weighting_percentage pa_object_relationships.weighting_percentage%TYPE;

Line 77: l_id_to pa_object_relationships.object_id_to1%TYPE;

73: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
74: )
75: IS
76: l_id_from pa_object_relationships.object_id_from1%TYPE;
77: l_id_to pa_object_relationships.object_id_to1%TYPE;
78: l_type_from pa_object_relationships.object_type_from%TYPE;
79: l_type_to pa_object_relationships.object_type_to%TYPE;
80: l_weighting_percentage pa_object_relationships.weighting_percentage%TYPE;
81:

Line 78: l_type_from pa_object_relationships.object_type_from%TYPE;

74: )
75: IS
76: l_id_from pa_object_relationships.object_id_from1%TYPE;
77: l_id_to pa_object_relationships.object_id_to1%TYPE;
78: l_type_from pa_object_relationships.object_type_from%TYPE;
79: l_type_to pa_object_relationships.object_type_to%TYPE;
80: l_weighting_percentage pa_object_relationships.weighting_percentage%TYPE;
81:
82: l_dummy varchar2(1);

Line 79: l_type_to pa_object_relationships.object_type_to%TYPE;

75: IS
76: l_id_from pa_object_relationships.object_id_from1%TYPE;
77: l_id_to pa_object_relationships.object_id_to1%TYPE;
78: l_type_from pa_object_relationships.object_type_from%TYPE;
79: l_type_to pa_object_relationships.object_type_to%TYPE;
80: l_weighting_percentage pa_object_relationships.weighting_percentage%TYPE;
81:
82: l_dummy varchar2(1);
83: l_msg_count NUMBER;

Line 80: l_weighting_percentage pa_object_relationships.weighting_percentage%TYPE;

76: l_id_from pa_object_relationships.object_id_from1%TYPE;
77: l_id_to pa_object_relationships.object_id_to1%TYPE;
78: l_type_from pa_object_relationships.object_type_from%TYPE;
79: l_type_to pa_object_relationships.object_type_to%TYPE;
80: l_weighting_percentage pa_object_relationships.weighting_percentage%TYPE;
81:
82: l_dummy varchar2(1);
83: l_msg_count NUMBER;
84: l_msg_data VARCHAR2(250);

Line 112: pa_object_relationships rel

108: CURSOR Get_Top_Task_ID(c_project_id NUMBER, c_structure_id NUMBER) IS
109: select pev.proj_element_id
110: from pa_proj_element_versions pev,
111: pa_proj_element_versions pev2,
112: pa_object_relationships rel
113: where pev2.project_id = c_project_id
114: and pev2.object_type = 'PA_STRUCTURES'
115: and pev2.proj_element_id = c_structure_id
116: and pev2.element_version_id = rel.object_id_from1

Line 158: l_lag_day pa_object_relationships.lag_day%TYPE;

154: l_object_type VARCHAR2(30);
155: l_element_id NUMBER;
156:
157: -- Bug 2955589. Local variables introduced to handle miss char and miss num.
158: l_lag_day pa_object_relationships.lag_day%TYPE;
159: l_priority pa_object_relationships.priority%TYPE;
160:
161: BEGIN
162: IF (p_debug_mode = 'Y') THEN

Line 159: l_priority pa_object_relationships.priority%TYPE;

155: l_element_id NUMBER;
156:
157: -- Bug 2955589. Local variables introduced to handle miss char and miss num.
158: l_lag_day pa_object_relationships.lag_day%TYPE;
159: l_priority pa_object_relationships.priority%TYPE;
160:
161: BEGIN
162: IF (p_debug_mode = 'Y') THEN
163: pa_debug.debug('PA_RELATIONSHIP_PVT.CREATE_RELATIONSHIP begin');

Line 478: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

474: --Assign new task as the linking object
475: l_id_from := l_task_version_id;
476: l_type_from := 'PA_TASKS';
477:
478: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
479: p_user_id => FND_GLOBAL.USER_ID
480: ,p_object_type_from => l_type_from
481: ,p_object_id_from1 => l_id_from
482: ,p_object_id_from2 => NULL

Line 549: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

545: ELSE
546: l_weighting_percentage := p_weighting_percentage;
547: END IF;
548:
549: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
550: p_user_id => FND_GLOBAL.USER_ID
551: ,p_object_type_from => l_type_from
552: ,p_object_id_from1 => l_id_from
553: ,p_object_id_from2 => NULL

Line 604: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

600: IF (p_task_version_id_to IS NOT NULL) THEN
601: l_id_to := p_task_version_id_to;
602: l_type_to := 'PA_TASKS';
603: END IF;
604: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
605: p_user_id => FND_GLOBAL.USER_ID
606: , p_object_type_from => l_type_from
607: , p_object_id_from1 => l_id_from
608: , p_object_id_from2 => NULL

Line 734: l_id_from pa_object_relationships.object_id_from1%TYPE;

730: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
731: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
732: )
733: IS
734: l_id_from pa_object_relationships.object_id_from1%TYPE;
735: l_id_to pa_object_relationships.object_id_to1%TYPE;
736: l_type_from pa_object_relationships.object_type_from%TYPE;
737: l_type_to pa_object_relationships.object_type_to%TYPE;
738: l_or_id pa_object_relationships.object_relationship_id%TYPE;

Line 735: l_id_to pa_object_relationships.object_id_to1%TYPE;

731: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
732: )
733: IS
734: l_id_from pa_object_relationships.object_id_from1%TYPE;
735: l_id_to pa_object_relationships.object_id_to1%TYPE;
736: l_type_from pa_object_relationships.object_type_from%TYPE;
737: l_type_to pa_object_relationships.object_type_to%TYPE;
738: l_or_id pa_object_relationships.object_relationship_id%TYPE;
739: l_weighting_percentage pa_object_relationships.weighting_percentage%TYPE;

Line 736: l_type_from pa_object_relationships.object_type_from%TYPE;

732: )
733: IS
734: l_id_from pa_object_relationships.object_id_from1%TYPE;
735: l_id_to pa_object_relationships.object_id_to1%TYPE;
736: l_type_from pa_object_relationships.object_type_from%TYPE;
737: l_type_to pa_object_relationships.object_type_to%TYPE;
738: l_or_id pa_object_relationships.object_relationship_id%TYPE;
739: l_weighting_percentage pa_object_relationships.weighting_percentage%TYPE;
740: BEGIN

Line 737: l_type_to pa_object_relationships.object_type_to%TYPE;

733: IS
734: l_id_from pa_object_relationships.object_id_from1%TYPE;
735: l_id_to pa_object_relationships.object_id_to1%TYPE;
736: l_type_from pa_object_relationships.object_type_from%TYPE;
737: l_type_to pa_object_relationships.object_type_to%TYPE;
738: l_or_id pa_object_relationships.object_relationship_id%TYPE;
739: l_weighting_percentage pa_object_relationships.weighting_percentage%TYPE;
740: BEGIN
741: IF (p_debug_mode = 'Y') THEN

Line 738: l_or_id pa_object_relationships.object_relationship_id%TYPE;

734: l_id_from pa_object_relationships.object_id_from1%TYPE;
735: l_id_to pa_object_relationships.object_id_to1%TYPE;
736: l_type_from pa_object_relationships.object_type_from%TYPE;
737: l_type_to pa_object_relationships.object_type_to%TYPE;
738: l_or_id pa_object_relationships.object_relationship_id%TYPE;
739: l_weighting_percentage pa_object_relationships.weighting_percentage%TYPE;
740: BEGIN
741: IF (p_debug_mode = 'Y') THEN
742: pa_debug.debug('PA_RELATIONSHIP_PVT.UPDATE_RELATIONSHIP begin');

Line 739: l_weighting_percentage pa_object_relationships.weighting_percentage%TYPE;

735: l_id_to pa_object_relationships.object_id_to1%TYPE;
736: l_type_from pa_object_relationships.object_type_from%TYPE;
737: l_type_to pa_object_relationships.object_type_to%TYPE;
738: l_or_id pa_object_relationships.object_relationship_id%TYPE;
739: l_weighting_percentage pa_object_relationships.weighting_percentage%TYPE;
740: BEGIN
741: IF (p_debug_mode = 'Y') THEN
742: pa_debug.debug('PA_RELATIONSHIP_PVT.UPDATE_RELATIONSHIP begin');
743: END IF;

Line 776: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(

772: ELSE
773: l_weighting_percentage := p_weighting_percentage;
774: END IF;
775:
776: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(
777: p_object_relationship_id => p_object_relationship_id
778: ,p_object_type_from => NULL
779: ,p_object_id_from1 => NULL
780: ,p_object_id_from2 => NULL

Line 803: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; -- To go to WHEN OTHERS Block
800: END IF;
801: -- End 4537865
802:
803: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
804: p_user_id => FND_GLOBAL.USER_ID
805: ,p_object_type_from => l_type_from
806: ,p_object_id_from1 => l_id_from
807: ,p_object_id_from2 => NULL

Line 907: from pa_object_relationships

903: )
904: IS
905: CURSOR get_link_task_ver_id IS
906: select object_id_from1, relationship_type
907: from pa_object_relationships
908: where object_relationship_id = p_object_relationship_id;
909: l_link_task_ver get_link_task_ver_id%ROWTYPE;
910: l_task_version_rvn NUMBER;
911:

Line 935: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(

931: OPEN get_link_task_ver_id;
932: FETCH get_link_task_ver_id into l_link_task_ver;
933: CLOSE get_link_task_ver_id;
934:
935: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(
936: p_object_relationship_id => p_object_relationship_id
937: ,p_object_type_from => NULL
938: ,p_object_id_from1 => NULL
939: ,p_object_id_from2 => NULL

Line 1138: FROM pa_object_relationships por

1134: cursor is_summary_task(c_task_ver_id number) IS
1135: SELECT count(1)
1136: FROM dual
1137: WHERE EXISTS ( SELECT 'x'
1138: FROM pa_object_relationships por
1139: WHERE por.object_id_from1 = c_task_ver_id
1140: AND por.object_type_from = 'PA_TASKS'
1141: AND por.relationship_type = 'S');
1142:

Line 1252: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

1248: END;
1249: END IF;
1250:
1251: --Create record in relationships table.
1252: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
1253: p_user_id => FND_GLOBAL.USER_ID
1254: ,p_object_type_from => 'PA_TASKS'
1255: ,p_object_id_from1 => p_src_task_ver_id
1256: ,p_object_id_from2 => p_src_proj_id

Line 1357: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

1353: END IF;
1354: END IF;
1355:
1356: --Create record in relationships table.
1357: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
1358: p_user_id => FND_GLOBAL.USER_ID
1359: ,p_object_type_from => 'PA_TASKS'
1360: ,p_object_id_from1 => p_src_task_ver_id
1361: ,p_object_id_from2 => p_src_proj_id

Line 1504: FROM pa_object_relationships

1500:
1501: CURSOR cur_obj_rel
1502: IS
1503: SELECT *
1504: FROM pa_object_relationships
1505: WHERE object_id_to1 = p_task_version_id
1506: AND object_id_from1 = p_src_task_version_id
1507: AND relationship_type = 'D';
1508: BEGIN

Line 1543: PA_OBJECT_RELATIONSHIPS_PKG.UPDATE_ROW

1539: l_comments := p_comments;
1540:
1541: --update record in object relationships table
1542:
1543: PA_OBJECT_RELATIONSHIPS_PKG.UPDATE_ROW
1544: ( p_user_id => FND_GLOBAL.USER_ID
1545: ,p_object_relationship_id => l_obj_rel_rec.object_relationship_id
1546: ,p_relationship_type => l_obj_rel_rec.relationship_type
1547: ,p_relationship_subtype => l_rel_subtype

Line 1669: FROM pa_object_relationships por1,

1665:
1666: CURSOR cur_obj_rel
1667: IS
1668: SELECT por2.object_relationship_id, por2.record_version_number
1669: FROM pa_object_relationships por1,
1670: pa_object_relationships por2
1671: WHERE por1.object_relationship_id = p_object_relationship_id
1672: AND por1.relationship_type = 'D'
1673: AND por1.object_id_from1 = por2.object_id_from1

Line 1670: pa_object_relationships por2

1666: CURSOR cur_obj_rel
1667: IS
1668: SELECT por2.object_relationship_id, por2.record_version_number
1669: FROM pa_object_relationships por1,
1670: pa_object_relationships por2
1671: WHERE por1.object_relationship_id = p_object_relationship_id
1672: AND por1.relationship_type = 'D'
1673: AND por1.object_id_from1 = por2.object_id_from1
1674: AND por2.object_id_to1 IN (

Line 1687: FROM pa_object_relationships por,

1683: --for the given relationship id
1684: CURSOR cur_get_struc_det(cp_object_relationship_id NUMBER)
1685: IS
1686: SELECT parent_structure_version_id,project_id
1687: FROM pa_object_relationships por,
1688: pa_proj_element_versions ppev
1689: WHERE por.object_relationship_id = cp_object_relationship_id
1690: AND ppev.element_version_id = por.object_id_from1;
1691: l_project_id NUMBER;

Line 1721: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW (

1717: RAISE FND_API.G_EXC_ERROR;
1718: END IF;
1719: END IF;
1720: --
1721: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW (
1722: p_object_relationship_id => cur_obj_rel_rec.object_relationship_id
1723: ,p_object_type_from => null
1724: ,p_object_id_from1 => null
1725: ,p_object_id_from2 => null

Line 1837: pa_object_relationships r

1833: from pa_proj_element_versions a,
1834: pa_proj_element_versions b,
1835: pa_proj_element_versions c,
1836: pa_proj_element_versions d,
1837: pa_object_relationships r
1838: where a.project_id = b.project_id
1839: and a.proj_element_id = b.proj_element_id
1840: and a.parent_structure_version_id = P_source_struc_ver_id
1841: and b.parent_structure_version_id = p_dest_struc_ver_id

Line 1855: select * from pa_object_relationships

1851: l_dep_struc_rec get_struc_dependency%ROWTYPE;
1852: --end bug 4019845
1853:
1854: CURSOR get_dependency(c_suc_ver_id NUMBER, c_pred_ver_id NUMBER) IS
1855: select * from pa_object_relationships
1856: where relationship_type = 'D'
1857: and object_id_from1 = c_suc_ver_id
1858: and object_id_to1 = c_pred_ver_id
1859: and object_id_from2 = object_id_to2

Line 1875: from pa_object_relationships

1871: l_project_id2 NUMBER;
1872:
1873: CURSOR check_intra_dep_exists(c_elem_ver_id NUMBER) IS
1874: select 1
1875: from pa_object_relationships
1876: where relationship_type = 'D'
1877: and object_id_from1 = c_elem_ver_id
1878: and object_id_from2 = object_id_to2
1879: and rownum = 1;

Line 1896: from pa_object_relationships rel,

1892: select /*+ leading(dt1) use_nl(dt1 rel) */ -- hint added per performance team recommendation for bug 5576900
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

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 1933: from pa_object_relationships por

1929: and object_type_to = 'PA_TASKS'
1930: -- This condition prevents the creation of intra-project dependencies between a task and any of
1931: -- its sub-tasks.
1932: and rel.object_id_to1 not in (select por.object_id_from1
1933: from pa_object_relationships por
1934: where por.relationship_type = 'S'
1935: and por.object_type_from = 'PA_TASKS'
1936: start with por.object_id_to1 = pcdt.dest_task_ver_id
1937: connect by prior por.object_id_from1 = por.object_id_to1

Line 1941: from pa_object_relationships por

1937: connect by prior por.object_id_from1 = por.object_id_to1
1938: and prior por.relationship_type = por.relationship_type
1939: union
1940: select por.object_id_to1
1941: from pa_object_relationships por
1942: where por.relationship_type = 'S'
1943: and por.object_type_to = 'PA_TASKS'
1944: start with por.object_id_from1 = pcdt.dest_task_ver_id
1945: connect by prior por.object_id_to1 = por.object_id_from1

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 1961: from pa_object_relationships por

1957: and object_type_to = 'PA_TASKS'
1958: -- This condition prevents the creation of intra-project dependencies between a task and any of \
1959: -- its sub-tasks.
1960: and rel.object_id_from1 not in (select por.object_id_from1
1961: from pa_object_relationships por
1962: where por.relationship_type = 'S'
1963: and por.object_type_from = 'PA_TASKS'
1964: start with por.object_id_to1 = pcdt.dest_task_ver_id
1965: connect by prior por.object_id_from1 = por.object_id_to1

Line 1969: from pa_object_relationships por

1965: connect by prior por.object_id_from1 = por.object_id_to1
1966: and prior por.relationship_type = por.relationship_type
1967: union
1968: select por.object_id_to1
1969: from pa_object_relationships por
1970: where por.relationship_type = 'S'
1971: and por.object_type_to = 'PA_TASKS'
1972: start with por.object_id_from1 = pcdt.dest_task_ver_id
1973: connect by prior por.object_id_to1 = por.object_id_from1

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 1995: from pa_object_relationships por

1991: and object_type_to = 'PA_TASKS'
1992: -- This condition prevents the creation of intra-project dependencies between a task and any of
1993: -- its sub-tasks.
1994: and pcdt2.dest_task_ver_id not in (select por.object_id_from1
1995: from pa_object_relationships por
1996: where por.relationship_type = 'S'
1997: and por.object_type_from = 'PA_TASKS'
1998: start with por.object_id_to1 = pcdt.dest_task_ver_id
1999: connect by prior por.object_id_from1 = por.object_id_to1

Line 2003: from pa_object_relationships por

1999: connect by prior por.object_id_from1 = por.object_id_to1
2000: and prior por.relationship_type = por.relationship_type
2001: union
2002: select por.object_id_to1
2003: from pa_object_relationships por
2004: where por.relationship_type = 'S'
2005: and por.object_type_to = 'PA_TASKS'
2006: start with por.object_id_from1 = pcdt.dest_task_ver_id
2007: connect by prior por.object_id_to1 = por.object_id_from1

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 2024: from pa_object_relationships por

2020: and object_type_to = 'PA_TASKS'
2021: -- This condition prevents the creation of intra-project dependencies between a task and any of
2022: -- its sub-tasks.
2023: and pcdt2.dest_task_ver_id not in (select por.object_id_from1
2024: from pa_object_relationships por
2025: where por.relationship_type = 'S'
2026: and por.object_type_from = 'PA_TASKS'
2027: start with por.object_id_to1 = pcdt.dest_task_ver_id
2028: connect by prior por.object_id_from1 = por.object_id_to1

Line 2032: from pa_object_relationships por

2028: connect by prior por.object_id_from1 = por.object_id_to1
2029: and prior por.relationship_type = por.relationship_type
2030: union
2031: select por.object_id_to1
2032: from pa_object_relationships por
2033: where por.relationship_type = 'S'
2034: and por.object_type_to = 'PA_TASKS'
2035: start with por.object_id_from1 = pcdt.dest_task_ver_id
2036: connect by prior por.object_id_to1 = por.object_id_from1

Line 2215: --bulk insert into pa_object_relationships table

2211: END LOOP;
2212:
2213: END IF;
2214:
2215: --bulk insert into pa_object_relationships table
2216: --debug messages added while fixing bug 5067296
2217: IF (l_debug_mode = 'Y') THEN
2218: pa_debug.write(x_Module=>'PA_RELATIONSHIP_PVT.COPY_INTRA_DEPENDENCY', x_Msg => 'Before BULK insert into PA_OBJECT_RELATIONSHIPS table', x_Log_Level=> 3);
2219: END IF;

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

2214:
2215: --bulk insert into pa_object_relationships table
2216: --debug messages added while fixing bug 5067296
2217: IF (l_debug_mode = 'Y') THEN
2218: pa_debug.write(x_Module=>'PA_RELATIONSHIP_PVT.COPY_INTRA_DEPENDENCY', x_Msg => 'Before BULK insert into PA_OBJECT_RELATIONSHIPS table', x_Log_Level=> 3);
2219: END IF;
2220: --debug messages added while fixing bug 5067296
2221:
2222: FORALL i IN 1..l_suc_ver_id_tbl.COUNT

Line 2223: INSERT INTO PA_OBJECT_RELATIONSHIPS(

2219: END IF;
2220: --debug messages added while fixing bug 5067296
2221:
2222: FORALL i IN 1..l_suc_ver_id_tbl.COUNT
2223: INSERT INTO PA_OBJECT_RELATIONSHIPS(
2224: OBJECT_RELATIONSHIP_ID
2225: ,CREATED_BY
2226: ,CREATION_DATE
2227: ,LAST_UPDATED_BY

Line 2243: pa_object_relationships_s.nextval

2239: ,COMMENTS
2240: ,RECORD_VERSION_NUMBER
2241: )
2242: VALUES (
2243: pa_object_relationships_s.nextval
2244: ,FND_GLOBAL.USER_ID
2245: ,sysdate
2246: ,FND_GLOBAL.USER_ID
2247: ,sysdate

Line 2439: From PA_Object_Relationships

2435: Relationship_SubType, Lag_Day, Comments
2436: INTO l_Found_Flag, l_Object_Task_ID,
2437: l_src_proj_id, l_src_task_ver_id, l_dest_proj_id, l_dest_task_ver_id,
2438: l_Type, l_lag_days, l_comments
2439: From PA_Object_Relationships
2440: Where RELATIONSHIP_TYPE = 'D'
2441: And OBJECT_ID_TO2 <> OBJECT_ID_FROM2
2442: And OBJECT_ID_FROM1 = P_Source_Ver_Tbl(i);
2443: Exception When No_Data_Found then NULL;

Line 2516: From PA_Object_Relationships

2512: l_error_msg_code VARCHAR2(250);
2513: --
2514: CURSOR get_dependency(c_suc_ver_id NUMBER) IS
2515: select *
2516: From PA_Object_Relationships
2517: Where RELATIONSHIP_TYPE = 'D'
2518: and object_type_from = 'PA_TASKS'
2519: and object_type_to = 'PA_TASKS'
2520: And OBJECT_ID_TO2 <> OBJECT_ID_FROM2

Line 2603: From pa_object_relationships rel,

2599: )IS
2600:
2601: CURSOR Check_Prev_Ver_Exists IS
2602: Select rel.object_relationship_id, rel.Record_Version_Number
2603: From pa_object_relationships rel,
2604: pa_proj_element_versions ppev1
2605: Where rel.relationship_type = 'D'
2606: and rel.object_id_from1 = ppev1.element_version_id
2607: and rel.object_id_to2 <> rel.object_id_from2

Line 2611: From pa_object_relationships rel,

2607: and rel.object_id_to2 <> rel.object_id_from2
2608: and ppev1.parent_structure_version_id = P_Previous_Pub_Struc_Ver_ID;
2609: /* --bug 3970398
2610: Select rel.object_relationship_id, rel.Record_Version_Number
2611: From pa_object_relationships rel,
2612: pa_proj_element_versions ppev1,
2613: pa_proj_element_versions ppev2
2614: Where rel.relationship_type = 'D'
2615: and rel.object_id_from1 = ppev1.element_version_id

Line 2622: From pa_object_relationships rel2,

2618: and ppev1.parent_structure_version_id = P_Previous_Pub_Struc_Ver_ID
2619: --
2620: and Not Exists (
2621: Select 1
2622: From pa_object_relationships rel2,
2623: pa_proj_element_versions ppev3,
2624: pa_proj_element_versions ppev4
2625: where rel2.relationship_type = 'D'
2626: and rel2.object_id_to2 <> rel2.object_id_from2

Line 2641: from pa_object_relationships rel1,

2637: CURSOR Create_Proj_Depend (c_Version_ID NUMBER)IS
2638: select ppev2.element_version_id, ppev2.project_id,
2639: rel1.object_id_to1, rel1.object_id_to2, rel1.lag_day, rel1.comments,
2640: rel1.relationship_subtype
2641: from pa_object_relationships rel1,
2642: pa_proj_element_versions ppev,
2643: pa_proj_element_versions ppev2
2644: where rel1.relationship_type = 'D'
2645: and rel1.object_id_to2 <> rel1.object_id_from2

Line 2663: from pa_object_relationships rel1,

2659: , ppev2.element_version_id, ppev2.project_id
2660: ,MAX(rel1.lag_day), MAX(rel1.comments), MAX(rel1.relationship_subtype)
2661: -- , rel1.object_relationship_id -- Fix for Bug # 4349093.
2662: -- , rel1.record_version_number
2663: from pa_object_relationships rel1,
2664: pa_proj_element_versions ppev,
2665: pa_proj_element_versions ppev2
2666: where rel1.relationship_type = 'D'
2667: and rel1.object_id_to2 <> rel1.object_id_from2

Line 2683: from pa_object_relationships rel1,

2679: Select rel1.object_id_from1, rel1.object_id_from2,
2680: rel1.object_id_to1, rel1.object_id_to2,
2681: ppev2.element_version_id,
2682: ppev2.project_id, rel1.lag_day, rel1.comments, rel1.relationship_subtype
2683: from pa_object_relationships rel1,
2684: pa_proj_element_versions ppev,
2685: pa_proj_element_versions ppev2
2686: where rel1.relationship_type = 'D'
2687: and rel1.object_id_to2 <> rel1.object_id_from2

Line 2700: from pa_object_relationships rel,

2696: -- For Update successors dependencies:
2697: -- If published version is NULL, use this SQL
2698: CURSOR Delete_Publ_Ver IS
2699: select rel.object_relationship_id, rel.Record_Version_Number
2700: from pa_object_relationships rel,
2701: pa_proj_element_versions ppev
2702: where rel.relationship_type = 'D'
2703: and rel.object_id_from1 = ppev.element_version_id
2704: and ppev.parent_structure_version_id = P_Previous_Pub_Struc_Ver_ID

Line 2709: from pa_object_relationships rel,

2705: --
2706: and rel.object_id_from2 <> rel.object_id_to2
2707: UNION
2708: select rel.object_relationship_id, rel.Record_Version_Number
2709: from pa_object_relationships rel,
2710: pa_proj_element_versions ppev
2711: where rel.relationship_type = 'D'
2712: and rel.object_id_to1 = ppev.element_version_id
2713: and ppev.parent_structure_version_id = P_Previous_Pub_Struc_Ver_ID

Line 2804: PA_Object_Relationships_PKG.Insert_Row(

2800: l_Lag_Days, l_Comments, l_Sub_Type;
2801: EXIT when Create_Proj_Depend%NOTFOUND;
2802:
2803: l_object_relationship_id := NULL;
2804: PA_Object_Relationships_PKG.Insert_Row(
2805: p_user_id => FND_GLOBAL.USER_ID
2806: ,p_object_type_from => 'PA_TASKS'
2807: ,p_object_id_from1 => l_src_task_ver_id
2808: ,p_object_id_from2 => l_src_proj_id

Line 2883: PA_Object_Relationships_PKG.Insert_Row(

2879: l_dest_proj_id := l_Obj_ID_To2;
2880: End IF;
2881: */
2882: l_object_relationship_id := NULL;
2883: PA_Object_Relationships_PKG.Insert_Row(
2884: p_user_id => FND_GLOBAL.USER_ID
2885: ,p_object_type_from => 'PA_TASKS'
2886: ,p_object_id_from1 => l_obj_id_from1
2887: ,p_object_id_from2 => l_obj_id_from2

Line 3124: /* Creating linking task in the pa_proj_element_versions and pa_object_relationships table */

3120: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Src Structure Elem Id=> '||p_src_task_elem_ver_id);
3121: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3122: END IF;
3123: --
3124: /* Creating linking task in the pa_proj_element_versions and pa_object_relationships table */
3125: /* This API call create task in pa_proj_element_versions and creates relationship between */
3126: /* linking task and its parent task in the pa_object_relationships table */
3127: PA_TASK_PUB1.CREATE_TASK_VERSION
3128: ( p_validate_only => FND_API.G_FALSE

Line 3126: /* linking task and its parent task in the pa_object_relationships table */

3122: END IF;
3123: --
3124: /* Creating linking task in the pa_proj_element_versions and pa_object_relationships table */
3125: /* This API call create task in pa_proj_element_versions and creates relationship between */
3126: /* linking task and its parent task in the pa_object_relationships table */
3127: PA_TASK_PUB1.CREATE_TASK_VERSION
3128: ( p_validate_only => FND_API.G_FALSE
3129: ,p_validation_level => 0
3130: ,p_ref_task_version_id => p_src_task_elem_ver_id

Line 3248: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Linking Task Elem Ver Id => '||x_lnk_task_elem_ver_id);

3244: END IF;
3245: --
3246: IF (p_debug_mode = 'Y') THEN
3247: pa_debug.debug('After Call To PA_TASK_PUB1.Create_Schedule_Version Return Status => '||x_return_status);
3248: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Linking Task Elem Ver Id => '||x_lnk_task_elem_ver_id);
3249: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Src Proj Id=> '||p_src_proj_id);
3250: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Struc Elem Ver Id=> '||p_dest_struc_elem_ver_id);
3251: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Proj Id=> '||p_dest_proj_id);
3252: END IF;

Line 3249: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Src Proj Id=> '||p_src_proj_id);

3245: --
3246: IF (p_debug_mode = 'Y') THEN
3247: pa_debug.debug('After Call To PA_TASK_PUB1.Create_Schedule_Version Return Status => '||x_return_status);
3248: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Linking Task Elem Ver Id => '||x_lnk_task_elem_ver_id);
3249: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Src Proj Id=> '||p_src_proj_id);
3250: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Struc Elem Ver Id=> '||p_dest_struc_elem_ver_id);
3251: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Proj Id=> '||p_dest_proj_id);
3252: END IF;
3253: --

Line 3250: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Struc Elem Ver Id=> '||p_dest_struc_elem_ver_id);

3246: IF (p_debug_mode = 'Y') THEN
3247: pa_debug.debug('After Call To PA_TASK_PUB1.Create_Schedule_Version Return Status => '||x_return_status);
3248: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Linking Task Elem Ver Id => '||x_lnk_task_elem_ver_id);
3249: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Src Proj Id=> '||p_src_proj_id);
3250: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Struc Elem Ver Id=> '||p_dest_struc_elem_ver_id);
3251: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Proj Id=> '||p_dest_proj_id);
3252: END IF;
3253: --
3254: /* This API call create relationship between linking task and destination structure vesion */

Line 3251: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Proj Id=> '||p_dest_proj_id);

3247: pa_debug.debug('After Call To PA_TASK_PUB1.Create_Schedule_Version Return Status => '||x_return_status);
3248: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Linking Task Elem Ver Id => '||x_lnk_task_elem_ver_id);
3249: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Src Proj Id=> '||p_src_proj_id);
3250: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Struc Elem Ver Id=> '||p_dest_struc_elem_ver_id);
3251: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Proj Id=> '||p_dest_proj_id);
3252: END IF;
3253: --
3254: /* This API call create relationship between linking task and destination structure vesion */
3255: /* in the pa_object_relationships table */

Line 3255: /* in the pa_object_relationships table */

3251: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Proj Id=> '||p_dest_proj_id);
3252: END IF;
3253: --
3254: /* This API call create relationship between linking task and destination structure vesion */
3255: /* in the pa_object_relationships table */
3256: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
3257: p_user_id => FND_GLOBAL.USER_ID
3258: ,p_object_type_from => 'PA_TASKS'
3259: ,p_object_id_from1 => x_lnk_task_elem_ver_id

Line 3256: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

3252: END IF;
3253: --
3254: /* This API call create relationship between linking task and destination structure vesion */
3255: /* in the pa_object_relationships table */
3256: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
3257: p_user_id => FND_GLOBAL.USER_ID
3258: ,p_object_type_from => 'PA_TASKS'
3259: ,p_object_id_from1 => x_lnk_task_elem_ver_id
3260: ,p_object_id_from2 => p_src_proj_id

Line 3387: pa_debug.debug('After Call To PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Return Status => '||x_return_status);

3383: RAISE FND_API.G_EXC_ERROR;
3384: END;
3385: --
3386: IF (p_debug_mode = 'Y') THEN
3387: pa_debug.debug('After Call To PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Return Status => '||x_return_status);
3388: END IF;
3389: --
3390: x_return_status := FND_API.G_RET_STS_SUCCESS;
3391: --

Line 3451: -- p_comment IN pa_object_relationships.comments%type

3447: -- p_src_proj_id IN pa_projects_all.project_id%type
3448: -- p_task_ver_id IN pa_proj_element_versions.element_version_id%type
3449: -- p_dest_proj_id IN pa_projects_all.project_id%type
3450: -- p_dest_proj_name IN pa_projects_all.name%type
3451: -- p_comment IN pa_object_relationships.comments%type
3452: -- x_return_status OUT VARCHAR2
3453: -- x_msg_count OUT NUMBER
3454: -- x_msg_data OUT VARCHAR2
3455: --

Line 3479: p_comment IN pa_object_relationships.comments%type,

3475: p_src_proj_id IN pa_projects_all.project_id%type,
3476: p_task_ver_id IN pa_proj_element_versions.element_version_id%type,
3477: p_dest_proj_id IN pa_projects_all.project_id%type,
3478: p_dest_proj_name IN pa_projects_all.name%type,
3479: p_comment IN pa_object_relationships.comments%type,
3480: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3481: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3482: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3483: IS

Line 3511: x_object_relationship_id pa_object_relationships.object_relationship_id%type;

3507: l_msg_count NUMBER;
3508: l_msg_data varchar2(250);
3509: l_data VARCHAR2(2000);
3510: l_msg_index_out NUMBER;
3511: x_object_relationship_id pa_object_relationships.object_relationship_id%type;
3512:
3513: l_time_phase1 VARCHAR2(1);
3514: l_time_phase2 VARCHAR2(1);
3515:

Line 4332: from pa_object_relationships por1, pa_object_relationships por2

4328: -- Bug # 5072032.
4329:
4330: cursor l_cur_obj_rel_id(c_object_relationship_id NUMBER) is
4331: select por2.object_relationship_id, por2.record_version_number
4332: from pa_object_relationships por1, pa_object_relationships por2
4333: , pa_object_relationships por3, pa_object_relationships por4
4334: where por1.object_id_to1 = por2.object_id_from1
4335: and por1.relationship_type = 'S'
4336: and por3.object_id_to1 = por4.object_id_from1

Line 4333: , pa_object_relationships por3, pa_object_relationships por4

4329:
4330: cursor l_cur_obj_rel_id(c_object_relationship_id NUMBER) is
4331: select por2.object_relationship_id, por2.record_version_number
4332: from pa_object_relationships por1, pa_object_relationships por2
4333: , pa_object_relationships por3, pa_object_relationships por4
4334: where por1.object_id_to1 = por2.object_id_from1
4335: and por1.relationship_type = 'S'
4336: and por3.object_id_to1 = por4.object_id_from1
4337: and por3.relationship_type = 'S'

Line 4370: UPDATE pa_object_relationships

4366: -- Bug # 5072032.
4367:
4368: for l_cur_obj_rel_rec in l_cur_obj_rel_id(p_object_relationship_id)
4369: loop
4370: UPDATE pa_object_relationships
4371: SET comments = p_comment
4372: ,record_version_number = (l_cur_obj_rel_rec.record_version_number+1) -- p_record_version_number + 1
4373: WHERE object_relationship_id = l_cur_obj_rel_rec.object_relationship_id -- p_object_relationship_id
4374: and record_version_number = l_cur_obj_rel_rec.record_version_number;

Line 4477: FROM pa_object_relationships

4473: SELECT object_id_from1, --src_lnk_task_ver_id
4474: object_id_to1, --dest_str_ver_id
4475: object_id_from2, --src proj_id
4476: object_id_to2 --dest_proj_id
4477: FROM pa_object_relationships
4478: WHERE object_relationship_id = cp_object_relationships_id
4479: AND relationship_type IN ('LW','LF');
4480: get_lnk_obj_rel_attr_rec get_lnk_obj_rel_attr%ROWTYPE;
4481: --

Line 4490: FROM pa_object_relationships

4486: get_rec_ver_num_rec get_rec_ver_num%ROWTYPE;
4487:
4488: CURSOR get_src_task_ver_id(cp_src_lnk_task_ver_id NUMBER) IS
4489: SELECT object_id_from1 --src_task_ver_id
4490: FROM pa_object_relationships
4491: WHERE object_id_to1 = cp_src_lnk_task_ver_id
4492: AND relationship_type = 'S';
4493: get_src_task_ver_id_rec get_src_task_ver_id%ROWTYPE;
4494: --

Line 4504: pa_object_relationships pora,

4500: porb.object_relationship_id lnk_obj_rel_id,
4501: porb.object_id_to1 lnk_dest_str_ver_id
4502: , porb.record_version_number lnk_record_ver_number -- Bug # 5072032.
4503: FROM pa_proj_element_versions ppev,
4504: pa_object_relationships pora,
4505: pa_object_relationships porb,
4506: pa_proj_elements ppe
4507: WHERE pora.relationship_type = 'S'
4508: AND ppev.project_id = cp_src_project_id

Line 4505: pa_object_relationships porb,

4501: porb.object_id_to1 lnk_dest_str_ver_id
4502: , porb.record_version_number lnk_record_ver_number -- Bug # 5072032.
4503: FROM pa_proj_element_versions ppev,
4504: pa_object_relationships pora,
4505: pa_object_relationships porb,
4506: pa_proj_elements ppe
4507: WHERE pora.relationship_type = 'S'
4508: AND ppev.project_id = cp_src_project_id
4509: AND pora.OBJECT_ID_FROM1 = cp_src_Task_ver_id

Line 4562: -- Get the details for passed object relationship id from pa_object_relationships

4558: IF (p_debug_mode = 'Y') THEN
4559: pa_debug.debug('Deleting the object_relationships_id => '||p_object_relationships_id);
4560: END IF;
4561: --
4562: -- Get the details for passed object relationship id from pa_object_relationships
4563: OPEN get_lnk_obj_rel_attr(p_object_relationships_id);
4564: FETCH get_lnk_obj_rel_attr INTO get_lnk_obj_rel_attr_rec;
4565: IF get_lnk_obj_rel_attr%NOTFOUND THEN
4566: CLOSE get_lnk_obj_rel_attr;

Line 4660: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(

4656: END;
4657: --
4658:
4659: --PA_RELATIONSHIP_PUB.Delete_Relationship(porb.object_relationship_id);--table handler
4660: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(
4661: p_object_relationship_id => get_lnk_info_rec.lnk_obj_rel_id
4662: ,p_object_type_from => NULL
4663: ,p_object_id_from1 => NULL
4664: ,p_object_id_from2 => NULL

Line 4695: pa_debug.debug('Return status after call to PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW=> '||x_return_status);

4691: raise FND_API.G_EXC_ERROR;
4692: END IF;
4693: --
4694: IF (p_debug_mode = 'Y') THEN
4695: pa_debug.debug('Return status after call to PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW=> '||x_return_status);
4696: END IF;
4697: --
4698: -- PA_TASK_PVT1.Delete_Task_Version(pora.object_id_to1);
4699: OPEN get_rec_ver_num(get_lnk_info_rec.lnk_task_ver_id);

Line 4928: FROM pa_object_relationships por

4924: por.relationship_type,
4925: por.record_version_number,
4926: por.object_type_to,
4927: por.object_type_from
4928: FROM pa_object_relationships por
4929: WHERE por.relationship_type in ('LW','LF')
4930: AND por.OBJECT_ID_FROM1 = cp_src_Task_ver_id
4931: AND por.object_type_from = 'PA_TASKS'
4932: AND por.object_type_to = 'PA_STRUCTURES'

Line 5002: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

4998: FETCH get_new_pub_lnk_task_ver_id INTO l_new_pub_lnk_task_ver_id;
4999: CLOSE get_new_pub_lnk_task_ver_id;
5000:
5001: IF (l_new_pub_lnk_task_ver_id IS NOT NULL) THEN
5002: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
5003: p_user_id => FND_GLOBAL.USER_ID
5004: ,p_object_type_from => 'PA_TASKS'
5005: ,p_object_id_from1 => l_new_pub_lnk_task_ver_id
5006: ,p_object_id_from2 => get_going_out_lnk_info_rec.object_id_from2

Line 5039: pa_debug.debug('Value of x_return_status after call to PA_OBJECT_RELATIONSHIPS_PKG INSERT_ROW=> '||x_return_status);

5035:
5036: IF (p_debug_mode = 'Y') THEN
5037: pa_debug.debug('Value of x_object_relationship_id=> '||l_object_relationship_id);
5038: pa_debug.debug('Value of l_new_pub_lnk_task_ver_id=> '||l_new_pub_lnk_task_ver_id);
5039: pa_debug.debug('Value of x_return_status after call to PA_OBJECT_RELATIONSHIPS_PKG INSERT_ROW=> '||x_return_status);
5040: END IF;
5041: --
5042: --Bug No 3450684
5043: BEGIN

Line 5156: FROM pa_object_relationships pora,

5152: porb.object_id_to2,
5153: porb.object_id_from2,
5154: porb.relationship_type,
5155: porb.record_version_number
5156: FROM pa_object_relationships pora,
5157: pa_object_relationships porb
5158: WHERE pora.relationship_type = 'S'
5159: AND pora.object_type_from = 'PA_TASKS'
5160: AND pora.object_id_to1 = porb.object_id_from1

Line 5157: pa_object_relationships porb

5153: porb.object_id_from2,
5154: porb.relationship_type,
5155: porb.record_version_number
5156: FROM pa_object_relationships pora,
5157: pa_object_relationships porb
5158: WHERE pora.relationship_type = 'S'
5159: AND pora.object_type_from = 'PA_TASKS'
5160: AND pora.object_id_to1 = porb.object_id_from1
5161: AND pora.object_type_to = porb.object_type_from

Line 5253: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

5249: END IF;
5250: --For Task
5251: IF l_move_link_fl='Y' THEN
5252: x_object_relationship_id := NULL;
5253: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
5254: p_user_id => FND_GLOBAL.USER_ID
5255: ,p_object_type_from => 'PA_TASKS'
5256: ,p_object_id_from1 => get_coming_in_lnk_info_rec.object_id_from1
5257: ,p_object_id_from2 => get_coming_in_lnk_info_rec.object_id_from2

Line 5356: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(

5352: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));
5353: RAISE FND_API.G_EXC_ERROR;
5354: END;
5355: --
5356: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(
5357: p_object_relationship_id => get_coming_in_lnk_info_rec.object_relationship_id
5358: ,p_object_type_from => NULL
5359: ,p_object_id_from1 => NULL
5360: ,p_object_id_from2 => NULL

Line 5584: FROM pa_object_relationships

5580:
5581: CURSOR cur_obj_rel
5582: IS
5583: SELECT *
5584: FROM pa_object_relationships
5585: WHERE object_id_to2 = p_project_id
5586: AND object_id_to1 = p_structure_version_id
5587: AND relationship_type = 'LW'; --Financial links should not be specified here bcoz Process WBS updates can be run only for workplan structures.
5588: BEGIN