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 1251: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

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

Line 1356: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

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

Line 1503: FROM pa_object_relationships

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

Line 1541: PA_OBJECT_RELATIONSHIPS_PKG.UPDATE_ROW

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

Line 1667: FROM pa_object_relationships por1,

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

Line 1668: pa_object_relationships por2

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

Line 1685: FROM pa_object_relationships por,

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

Line 1719: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW (

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

Line 1835: pa_object_relationships r

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

Line 1853: select * from pa_object_relationships

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

Line 1873: from pa_object_relationships

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

Line 1894: from pa_object_relationships rel,

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

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

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

Line 1935: from pa_object_relationships por

1931: connect by prior por.object_id_from1 = por.object_id_to1
1932: and prior por.relationship_type = por.relationship_type
1933: union
1934: select por.object_id_to1
1935: from pa_object_relationships por
1936: where por.relationship_type = 'S'
1937: and por.object_type_to = 'PA_TASKS'
1938: start with por.object_id_from1 = pcdt.dest_task_ver_id
1939: connect by prior por.object_id_to1 = por.object_id_from1

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

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

Line 1963: from pa_object_relationships por

1959: connect by prior por.object_id_from1 = por.object_id_to1
1960: and prior por.relationship_type = por.relationship_type
1961: union
1962: select por.object_id_to1
1963: from pa_object_relationships por
1964: where por.relationship_type = 'S'
1965: and por.object_type_to = 'PA_TASKS'
1966: start with por.object_id_from1 = pcdt.dest_task_ver_id
1967: connect by prior por.object_id_to1 = por.object_id_from1

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

1984: and object_type_to = 'PA_TASKS'
1985: -- This condition prevents the creation of intra-project dependencies between a task and any of
1986: -- its sub-tasks.
1987: and pcdt2.dest_task_ver_id not in (select por.object_id_from1
1988: from pa_object_relationships por
1989: where por.relationship_type = 'S'
1990: and por.object_type_from = 'PA_TASKS'
1991: start with por.object_id_to1 = pcdt.dest_task_ver_id
1992: connect by prior por.object_id_from1 = por.object_id_to1

Line 1996: from pa_object_relationships por

1992: connect by prior por.object_id_from1 = por.object_id_to1
1993: and prior por.relationship_type = por.relationship_type
1994: union
1995: select por.object_id_to1
1996: from pa_object_relationships por
1997: where por.relationship_type = 'S'
1998: and por.object_type_to = 'PA_TASKS'
1999: start with por.object_id_from1 = pcdt.dest_task_ver_id
2000: connect by prior por.object_id_to1 = por.object_id_from1

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

2013: and object_type_to = 'PA_TASKS'
2014: -- This condition prevents the creation of intra-project dependencies between a task and any of
2015: -- its sub-tasks.
2016: and pcdt2.dest_task_ver_id not in (select por.object_id_from1
2017: from pa_object_relationships por
2018: where por.relationship_type = 'S'
2019: and por.object_type_from = 'PA_TASKS'
2020: start with por.object_id_to1 = pcdt.dest_task_ver_id
2021: connect by prior por.object_id_from1 = por.object_id_to1

Line 2025: from pa_object_relationships por

2021: connect by prior por.object_id_from1 = por.object_id_to1
2022: and prior por.relationship_type = por.relationship_type
2023: union
2024: select por.object_id_to1
2025: from pa_object_relationships por
2026: where por.relationship_type = 'S'
2027: and por.object_type_to = 'PA_TASKS'
2028: start with por.object_id_from1 = pcdt.dest_task_ver_id
2029: connect by prior por.object_id_to1 = por.object_id_from1

Line 2207: --bulk insert into pa_object_relationships table

2203: END LOOP;
2204:
2205: END IF;
2206:
2207: --bulk insert into pa_object_relationships table
2208: --debug messages added while fixing bug 5067296
2209: IF (l_debug_mode = 'Y') THEN
2210: 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);
2211: END IF;

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

2206:
2207: --bulk insert into pa_object_relationships table
2208: --debug messages added while fixing bug 5067296
2209: IF (l_debug_mode = 'Y') THEN
2210: 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);
2211: END IF;
2212: --debug messages added while fixing bug 5067296
2213:
2214: FORALL i IN 1..l_suc_ver_id_tbl.COUNT

Line 2215: INSERT INTO PA_OBJECT_RELATIONSHIPS(

2211: END IF;
2212: --debug messages added while fixing bug 5067296
2213:
2214: FORALL i IN 1..l_suc_ver_id_tbl.COUNT
2215: INSERT INTO PA_OBJECT_RELATIONSHIPS(
2216: OBJECT_RELATIONSHIP_ID
2217: ,CREATED_BY
2218: ,CREATION_DATE
2219: ,LAST_UPDATED_BY

Line 2235: pa_object_relationships_s.nextval

2231: ,COMMENTS
2232: ,RECORD_VERSION_NUMBER
2233: )
2234: VALUES (
2235: pa_object_relationships_s.nextval
2236: ,FND_GLOBAL.USER_ID
2237: ,sysdate
2238: ,FND_GLOBAL.USER_ID
2239: ,sysdate

Line 2431: From PA_Object_Relationships

2427: Relationship_SubType, Lag_Day, Comments
2428: INTO l_Found_Flag, l_Object_Task_ID,
2429: l_src_proj_id, l_src_task_ver_id, l_dest_proj_id, l_dest_task_ver_id,
2430: l_Type, l_lag_days, l_comments
2431: From PA_Object_Relationships
2432: Where RELATIONSHIP_TYPE = 'D'
2433: And OBJECT_ID_TO2 <> OBJECT_ID_FROM2
2434: And OBJECT_ID_FROM1 = P_Source_Ver_Tbl(i);
2435: Exception When No_Data_Found then NULL;

Line 2508: From PA_Object_Relationships

2504: l_error_msg_code VARCHAR2(250);
2505: --
2506: CURSOR get_dependency(c_suc_ver_id NUMBER) IS
2507: select *
2508: From PA_Object_Relationships
2509: Where RELATIONSHIP_TYPE = 'D'
2510: and object_type_from = 'PA_TASKS'
2511: and object_type_to = 'PA_TASKS'
2512: And OBJECT_ID_TO2 <> OBJECT_ID_FROM2

Line 2595: From pa_object_relationships rel,

2591: )IS
2592:
2593: CURSOR Check_Prev_Ver_Exists IS
2594: Select rel.object_relationship_id, rel.Record_Version_Number
2595: From pa_object_relationships rel,
2596: pa_proj_element_versions ppev1
2597: Where rel.relationship_type = 'D'
2598: and rel.object_id_from1 = ppev1.element_version_id
2599: and rel.object_id_to2 <> rel.object_id_from2

Line 2603: From pa_object_relationships rel,

2599: and rel.object_id_to2 <> rel.object_id_from2
2600: and ppev1.parent_structure_version_id = P_Previous_Pub_Struc_Ver_ID;
2601: /* --bug 3970398
2602: Select rel.object_relationship_id, rel.Record_Version_Number
2603: From pa_object_relationships rel,
2604: pa_proj_element_versions ppev1,
2605: pa_proj_element_versions ppev2
2606: Where rel.relationship_type = 'D'
2607: and rel.object_id_from1 = ppev1.element_version_id

Line 2614: From pa_object_relationships rel2,

2610: and ppev1.parent_structure_version_id = P_Previous_Pub_Struc_Ver_ID
2611: --
2612: and Not Exists (
2613: Select 1
2614: From pa_object_relationships rel2,
2615: pa_proj_element_versions ppev3,
2616: pa_proj_element_versions ppev4
2617: where rel2.relationship_type = 'D'
2618: and rel2.object_id_to2 <> rel2.object_id_from2

Line 2633: from pa_object_relationships rel1,

2629: CURSOR Create_Proj_Depend (c_Version_ID NUMBER)IS
2630: select ppev2.element_version_id, ppev2.project_id,
2631: rel1.object_id_to1, rel1.object_id_to2, rel1.lag_day, rel1.comments,
2632: rel1.relationship_subtype
2633: from pa_object_relationships rel1,
2634: pa_proj_element_versions ppev,
2635: pa_proj_element_versions ppev2
2636: where rel1.relationship_type = 'D'
2637: and rel1.object_id_to2 <> rel1.object_id_from2

Line 2654: from pa_object_relationships rel1,

2650: , ppev2.element_version_id, ppev2.project_id
2651: ,rel1.lag_day, rel1.comments, rel1.relationship_subtype
2652: -- , rel1.object_relationship_id -- Fix for Bug # 4349093.
2653: , rel1.record_version_number
2654: from pa_object_relationships rel1,
2655: pa_proj_element_versions ppev,
2656: pa_proj_element_versions ppev2
2657: where rel1.relationship_type = 'D'
2658: and rel1.object_id_to2 <> rel1.object_id_from2

Line 2671: from pa_object_relationships rel1,

2667: Select rel1.object_id_from1, rel1.object_id_from2,
2668: rel1.object_id_to1, rel1.object_id_to2,
2669: ppev2.element_version_id,
2670: ppev2.project_id, rel1.lag_day, rel1.comments, rel1.relationship_subtype
2671: from pa_object_relationships rel1,
2672: pa_proj_element_versions ppev,
2673: pa_proj_element_versions ppev2
2674: where rel1.relationship_type = 'D'
2675: and rel1.object_id_to2 <> rel1.object_id_from2

Line 2688: from pa_object_relationships rel,

2684: -- For Update successors dependencies:
2685: -- If published version is NULL, use this SQL
2686: CURSOR Delete_Publ_Ver IS
2687: select rel.object_relationship_id, rel.Record_Version_Number
2688: from pa_object_relationships rel,
2689: pa_proj_element_versions ppev
2690: where rel.relationship_type = 'D'
2691: and rel.object_id_from1 = ppev.element_version_id
2692: and ppev.parent_structure_version_id = P_Previous_Pub_Struc_Ver_ID

Line 2697: from pa_object_relationships rel,

2693: --
2694: and rel.object_id_from2 <> rel.object_id_to2
2695: UNION
2696: select rel.object_relationship_id, rel.Record_Version_Number
2697: from pa_object_relationships rel,
2698: pa_proj_element_versions ppev
2699: where rel.relationship_type = 'D'
2700: and rel.object_id_to1 = ppev.element_version_id
2701: and ppev.parent_structure_version_id = P_Previous_Pub_Struc_Ver_ID

Line 2792: PA_Object_Relationships_PKG.Insert_Row(

2788: l_Lag_Days, l_Comments, l_Sub_Type;
2789: EXIT when Create_Proj_Depend%NOTFOUND;
2790:
2791: l_object_relationship_id := NULL;
2792: PA_Object_Relationships_PKG.Insert_Row(
2793: p_user_id => FND_GLOBAL.USER_ID
2794: ,p_object_type_from => 'PA_TASKS'
2795: ,p_object_id_from1 => l_src_task_ver_id
2796: ,p_object_id_from2 => l_src_proj_id

Line 2871: PA_Object_Relationships_PKG.Insert_Row(

2867: l_dest_proj_id := l_Obj_ID_To2;
2868: End IF;
2869: */
2870: l_object_relationship_id := NULL;
2871: PA_Object_Relationships_PKG.Insert_Row(
2872: p_user_id => FND_GLOBAL.USER_ID
2873: ,p_object_type_from => 'PA_TASKS'
2874: ,p_object_id_from1 => l_obj_id_from1
2875: ,p_object_id_from2 => l_obj_id_from2

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

3107: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Src Structure Elem Id=> '||p_src_task_elem_ver_id);
3108: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3109: END IF;
3110: --
3111: /* Creating linking task in the pa_proj_element_versions and pa_object_relationships table */
3112: /* This API call create task in pa_proj_element_versions and creates relationship between */
3113: /* linking task and its parent task in the pa_object_relationships table */
3114: PA_TASK_PUB1.CREATE_TASK_VERSION
3115: ( p_validate_only => FND_API.G_FALSE

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

3109: END IF;
3110: --
3111: /* Creating linking task in the pa_proj_element_versions and pa_object_relationships table */
3112: /* This API call create task in pa_proj_element_versions and creates relationship between */
3113: /* linking task and its parent task in the pa_object_relationships table */
3114: PA_TASK_PUB1.CREATE_TASK_VERSION
3115: ( p_validate_only => FND_API.G_FALSE
3116: ,p_validation_level => 0
3117: ,p_ref_task_version_id => p_src_task_elem_ver_id

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

3231: END IF;
3232: --
3233: IF (p_debug_mode = 'Y') THEN
3234: pa_debug.debug('After Call To PA_TASK_PUB1.Create_Schedule_Version Return Status => '||x_return_status);
3235: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Linking Task Elem Ver Id => '||x_lnk_task_elem_ver_id);
3236: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Src Proj Id=> '||p_src_proj_id);
3237: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Struc Elem Ver Id=> '||p_dest_struc_elem_ver_id);
3238: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Proj Id=> '||p_dest_proj_id);
3239: END IF;

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

3232: --
3233: IF (p_debug_mode = 'Y') THEN
3234: pa_debug.debug('After Call To PA_TASK_PUB1.Create_Schedule_Version Return Status => '||x_return_status);
3235: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Linking Task Elem Ver Id => '||x_lnk_task_elem_ver_id);
3236: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Src Proj Id=> '||p_src_proj_id);
3237: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Struc Elem Ver Id=> '||p_dest_struc_elem_ver_id);
3238: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Proj Id=> '||p_dest_proj_id);
3239: END IF;
3240: --

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

3233: IF (p_debug_mode = 'Y') THEN
3234: pa_debug.debug('After Call To PA_TASK_PUB1.Create_Schedule_Version Return Status => '||x_return_status);
3235: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Linking Task Elem Ver Id => '||x_lnk_task_elem_ver_id);
3236: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Src Proj Id=> '||p_src_proj_id);
3237: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Struc Elem Ver Id=> '||p_dest_struc_elem_ver_id);
3238: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Proj Id=> '||p_dest_proj_id);
3239: END IF;
3240: --
3241: /* This API call create relationship between linking task and destination structure vesion */

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

3234: pa_debug.debug('After Call To PA_TASK_PUB1.Create_Schedule_Version Return Status => '||x_return_status);
3235: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Linking Task Elem Ver Id => '||x_lnk_task_elem_ver_id);
3236: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Src Proj Id=> '||p_src_proj_id);
3237: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Struc Elem Ver Id=> '||p_dest_struc_elem_ver_id);
3238: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Proj Id=> '||p_dest_proj_id);
3239: END IF;
3240: --
3241: /* This API call create relationship between linking task and destination structure vesion */
3242: /* in the pa_object_relationships table */

Line 3242: /* in the pa_object_relationships table */

3238: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Proj Id=> '||p_dest_proj_id);
3239: END IF;
3240: --
3241: /* This API call create relationship between linking task and destination structure vesion */
3242: /* in the pa_object_relationships table */
3243: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
3244: p_user_id => FND_GLOBAL.USER_ID
3245: ,p_object_type_from => 'PA_TASKS'
3246: ,p_object_id_from1 => x_lnk_task_elem_ver_id

Line 3243: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

3239: END IF;
3240: --
3241: /* This API call create relationship between linking task and destination structure vesion */
3242: /* in the pa_object_relationships table */
3243: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
3244: p_user_id => FND_GLOBAL.USER_ID
3245: ,p_object_type_from => 'PA_TASKS'
3246: ,p_object_id_from1 => x_lnk_task_elem_ver_id
3247: ,p_object_id_from2 => p_src_proj_id

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

3370: RAISE FND_API.G_EXC_ERROR;
3371: END;
3372: --
3373: IF (p_debug_mode = 'Y') THEN
3374: pa_debug.debug('After Call To PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Return Status => '||x_return_status);
3375: END IF;
3376: --
3377: x_return_status := FND_API.G_RET_STS_SUCCESS;
3378: --

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

3434: -- p_src_proj_id IN pa_projects_all.project_id%type
3435: -- p_task_ver_id IN pa_proj_element_versions.element_version_id%type
3436: -- p_dest_proj_id IN pa_projects_all.project_id%type
3437: -- p_dest_proj_name IN pa_projects_all.name%type
3438: -- p_comment IN pa_object_relationships.comments%type
3439: -- x_return_status OUT VARCHAR2
3440: -- x_msg_count OUT NUMBER
3441: -- x_msg_data OUT VARCHAR2
3442: --

Line 3466: p_comment IN pa_object_relationships.comments%type,

3462: p_src_proj_id IN pa_projects_all.project_id%type,
3463: p_task_ver_id IN pa_proj_element_versions.element_version_id%type,
3464: p_dest_proj_id IN pa_projects_all.project_id%type,
3465: p_dest_proj_name IN pa_projects_all.name%type,
3466: p_comment IN pa_object_relationships.comments%type,
3467: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3468: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3469: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3470: IS

Line 3498: x_object_relationship_id pa_object_relationships.object_relationship_id%type;

3494: l_msg_count NUMBER;
3495: l_msg_data varchar2(250);
3496: l_data VARCHAR2(2000);
3497: l_msg_index_out NUMBER;
3498: x_object_relationship_id pa_object_relationships.object_relationship_id%type;
3499:
3500: l_time_phase1 VARCHAR2(1);
3501: l_time_phase2 VARCHAR2(1);
3502:

Line 4314: from pa_object_relationships por1, pa_object_relationships por2

4310: -- Bug # 5072032.
4311:
4312: cursor l_cur_obj_rel_id(c_object_relationship_id NUMBER) is
4313: select por2.object_relationship_id, por2.record_version_number
4314: from pa_object_relationships por1, pa_object_relationships por2
4315: , pa_object_relationships por3, pa_object_relationships por4
4316: where por1.object_id_to1 = por2.object_id_from1
4317: and por1.relationship_type = 'S'
4318: and por3.object_id_to1 = por4.object_id_from1

Line 4315: , pa_object_relationships por3, pa_object_relationships por4

4311:
4312: cursor l_cur_obj_rel_id(c_object_relationship_id NUMBER) is
4313: select por2.object_relationship_id, por2.record_version_number
4314: from pa_object_relationships por1, pa_object_relationships por2
4315: , pa_object_relationships por3, pa_object_relationships por4
4316: where por1.object_id_to1 = por2.object_id_from1
4317: and por1.relationship_type = 'S'
4318: and por3.object_id_to1 = por4.object_id_from1
4319: and por3.relationship_type = 'S'

Line 4352: UPDATE pa_object_relationships

4348: -- Bug # 5072032.
4349:
4350: for l_cur_obj_rel_rec in l_cur_obj_rel_id(p_object_relationship_id)
4351: loop
4352: UPDATE pa_object_relationships
4353: SET comments = p_comment
4354: ,record_version_number = (l_cur_obj_rel_rec.record_version_number+1) -- p_record_version_number + 1
4355: WHERE object_relationship_id = l_cur_obj_rel_rec.object_relationship_id -- p_object_relationship_id
4356: and record_version_number = l_cur_obj_rel_rec.record_version_number;

Line 4459: FROM pa_object_relationships

4455: SELECT object_id_from1, --src_lnk_task_ver_id
4456: object_id_to1, --dest_str_ver_id
4457: object_id_from2, --src proj_id
4458: object_id_to2 --dest_proj_id
4459: FROM pa_object_relationships
4460: WHERE object_relationship_id = cp_object_relationships_id
4461: AND relationship_type IN ('LW','LF');
4462: get_lnk_obj_rel_attr_rec get_lnk_obj_rel_attr%ROWTYPE;
4463: --

Line 4472: FROM pa_object_relationships

4468: get_rec_ver_num_rec get_rec_ver_num%ROWTYPE;
4469:
4470: CURSOR get_src_task_ver_id(cp_src_lnk_task_ver_id NUMBER) IS
4471: SELECT object_id_from1 --src_task_ver_id
4472: FROM pa_object_relationships
4473: WHERE object_id_to1 = cp_src_lnk_task_ver_id
4474: AND relationship_type = 'S';
4475: get_src_task_ver_id_rec get_src_task_ver_id%ROWTYPE;
4476: --

Line 4486: pa_object_relationships pora,

4482: porb.object_relationship_id lnk_obj_rel_id,
4483: porb.object_id_to1 lnk_dest_str_ver_id
4484: , porb.record_version_number lnk_record_ver_number -- Bug # 5072032.
4485: FROM pa_proj_element_versions ppev,
4486: pa_object_relationships pora,
4487: pa_object_relationships porb,
4488: pa_proj_elements ppe
4489: WHERE pora.relationship_type = 'S'
4490: AND ppev.project_id = cp_src_project_id

Line 4487: pa_object_relationships porb,

4483: porb.object_id_to1 lnk_dest_str_ver_id
4484: , porb.record_version_number lnk_record_ver_number -- Bug # 5072032.
4485: FROM pa_proj_element_versions ppev,
4486: pa_object_relationships pora,
4487: pa_object_relationships porb,
4488: pa_proj_elements ppe
4489: WHERE pora.relationship_type = 'S'
4490: AND ppev.project_id = cp_src_project_id
4491: AND pora.OBJECT_ID_FROM1 = cp_src_Task_ver_id

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

4540: IF (p_debug_mode = 'Y') THEN
4541: pa_debug.debug('Deleting the object_relationships_id => '||p_object_relationships_id);
4542: END IF;
4543: --
4544: -- Get the details for passed object relationship id from pa_object_relationships
4545: OPEN get_lnk_obj_rel_attr(p_object_relationships_id);
4546: FETCH get_lnk_obj_rel_attr INTO get_lnk_obj_rel_attr_rec;
4547: IF get_lnk_obj_rel_attr%NOTFOUND THEN
4548: CLOSE get_lnk_obj_rel_attr;

Line 4642: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(

4638: END;
4639: --
4640:
4641: --PA_RELATIONSHIP_PUB.Delete_Relationship(porb.object_relationship_id);--table handler
4642: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(
4643: p_object_relationship_id => get_lnk_info_rec.lnk_obj_rel_id
4644: ,p_object_type_from => NULL
4645: ,p_object_id_from1 => NULL
4646: ,p_object_id_from2 => NULL

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

4673: raise FND_API.G_EXC_ERROR;
4674: END IF;
4675: --
4676: IF (p_debug_mode = 'Y') THEN
4677: pa_debug.debug('Return status after call to PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW=> '||x_return_status);
4678: END IF;
4679: --
4680: -- PA_TASK_PVT1.Delete_Task_Version(pora.object_id_to1);
4681: OPEN get_rec_ver_num(get_lnk_info_rec.lnk_task_ver_id);

Line 4906: FROM pa_object_relationships por

4902: por.relationship_type,
4903: por.record_version_number,
4904: por.object_type_to,
4905: por.object_type_from
4906: FROM pa_object_relationships por
4907: WHERE por.relationship_type in ('LW','LF')
4908: AND por.OBJECT_ID_FROM1 = cp_src_Task_ver_id
4909: AND por.object_type_from = 'PA_TASKS'
4910: AND por.object_type_to = 'PA_STRUCTURES'

Line 4980: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

4976: FETCH get_new_pub_lnk_task_ver_id INTO l_new_pub_lnk_task_ver_id;
4977: CLOSE get_new_pub_lnk_task_ver_id;
4978:
4979: IF (l_new_pub_lnk_task_ver_id IS NOT NULL) THEN
4980: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
4981: p_user_id => FND_GLOBAL.USER_ID
4982: ,p_object_type_from => 'PA_TASKS'
4983: ,p_object_id_from1 => l_new_pub_lnk_task_ver_id
4984: ,p_object_id_from2 => get_going_out_lnk_info_rec.object_id_from2

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

5013:
5014: IF (p_debug_mode = 'Y') THEN
5015: pa_debug.debug('Value of x_object_relationship_id=> '||l_object_relationship_id);
5016: pa_debug.debug('Value of l_new_pub_lnk_task_ver_id=> '||l_new_pub_lnk_task_ver_id);
5017: pa_debug.debug('Value of x_return_status after call to PA_OBJECT_RELATIONSHIPS_PKG INSERT_ROW=> '||x_return_status);
5018: END IF;
5019: --
5020: --Bug No 3450684
5021: BEGIN

Line 5134: FROM pa_object_relationships pora,

5130: porb.object_id_to2,
5131: porb.object_id_from2,
5132: porb.relationship_type,
5133: porb.record_version_number
5134: FROM pa_object_relationships pora,
5135: pa_object_relationships porb
5136: WHERE pora.relationship_type = 'S'
5137: AND pora.object_type_from = 'PA_TASKS'
5138: AND pora.object_id_to1 = porb.object_id_from1

Line 5135: pa_object_relationships porb

5131: porb.object_id_from2,
5132: porb.relationship_type,
5133: porb.record_version_number
5134: FROM pa_object_relationships pora,
5135: pa_object_relationships porb
5136: WHERE pora.relationship_type = 'S'
5137: AND pora.object_type_from = 'PA_TASKS'
5138: AND pora.object_id_to1 = porb.object_id_from1
5139: AND pora.object_type_to = porb.object_type_from

Line 5231: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

5227: END IF;
5228: --For Task
5229: IF l_move_link_fl='Y' THEN
5230: x_object_relationship_id := NULL;
5231: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
5232: p_user_id => FND_GLOBAL.USER_ID
5233: ,p_object_type_from => 'PA_TASKS'
5234: ,p_object_id_from1 => get_coming_in_lnk_info_rec.object_id_from1
5235: ,p_object_id_from2 => get_coming_in_lnk_info_rec.object_id_from2

Line 5334: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(

5330: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));
5331: RAISE FND_API.G_EXC_ERROR;
5332: END;
5333: --
5334: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(
5335: p_object_relationship_id => get_coming_in_lnk_info_rec.object_relationship_id
5336: ,p_object_type_from => NULL
5337: ,p_object_id_from1 => NULL
5338: ,p_object_id_from2 => NULL

Line 5562: FROM pa_object_relationships

5558:
5559: CURSOR cur_obj_rel
5560: IS
5561: SELECT *
5562: FROM pa_object_relationships
5563: WHERE object_id_to2 = p_project_id
5564: AND object_id_to1 = p_structure_version_id
5565: AND relationship_type = 'LW'; --Financial links should not be specified here bcoz Process WBS updates can be run only for workplan structures.
5566: BEGIN