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.HZ_HIERARCHY_PUB dependencies on HZ_RELATIONSHIPS

Line 1902: FROM HZ_RELATIONSHIPS a

1898: )
1899: IS
1900: CURSOR c1 IS
1901: SELECT a.ROWID row_id, a.*
1902: FROM HZ_RELATIONSHIPS a
1903: WHERE RELATIONSHIP_TYPE = p_rel_type
1904: ORDER BY RELATIONSHIP_ID;
1905:
1906: CURSOR c2 (p_rel_type VARCHAR2,

Line 1926: FROM HZ_RELATIONSHIPS

1922: IS
1923: SELECT SUBJECT_ID,
1924: SUBJECT_TABLE_NAME,
1925: SUBJECT_TYPE
1926: FROM HZ_RELATIONSHIPS
1927: WHERE OBJECT_ID = p_child_id
1928: AND OBJECT_TABLE_NAME = p_child_table_name
1929: AND OBJECT_TYPE = p_child_object_type
1930: AND RELATIONSHIP_TYPE = p_rel_type

Line 2005: FROM HZ_RELATIONSHIPS

2001:
2002: IF p_multi_parent_allowed = 'N' THEN
2003: BEGIN
2004: SELECT 1 INTO l_count
2005: FROM HZ_RELATIONSHIPS
2006: WHERE OBJECT_ID = l_child_id
2007: AND OBJECT_TABLE_NAME = l_child_table_name
2008: AND OBJECT_TYPE = l_child_object_type
2009: AND RELATIONSHIP_TYPE = r1.relationship_type

Line 2111: UPDATE HZ_RELATIONSHIPS SET DIRECTION_CODE = 'P' WHERE ROWID = r1.row_id;

2107:
2108: CLOSE c2;
2109:
2110: IF r2.direction_code = 'P' THEN
2111: UPDATE HZ_RELATIONSHIPS SET DIRECTION_CODE = 'P' WHERE ROWID = r1.row_id;
2112: ELSE
2113: UPDATE HZ_RELATIONSHIPS SET DIRECTION_CODE = 'C' WHERE ROWID = r1.row_id;
2114: END IF;
2115:

Line 2113: UPDATE HZ_RELATIONSHIPS SET DIRECTION_CODE = 'C' WHERE ROWID = r1.row_id;

2109:
2110: IF r2.direction_code = 'P' THEN
2111: UPDATE HZ_RELATIONSHIPS SET DIRECTION_CODE = 'P' WHERE ROWID = r1.row_id;
2112: ELSE
2113: UPDATE HZ_RELATIONSHIPS SET DIRECTION_CODE = 'C' WHERE ROWID = r1.row_id;
2114: END IF;
2115:
2116: -- one call is to by-pass the second record which is identical but reverse one.
2117: FETCH c1 INTO r1;

Line 2119: UPDATE HZ_RELATIONSHIPS SET DIRECTION_CODE = 'C' WHERE ROWID = r1.row_id;

2115:
2116: -- one call is to by-pass the second record which is identical but reverse one.
2117: FETCH c1 INTO r1;
2118: IF r2.direction_code = 'P' THEN
2119: UPDATE HZ_RELATIONSHIPS SET DIRECTION_CODE = 'C' WHERE ROWID = r1.row_id;
2120: ELSE
2121: UPDATE HZ_RELATIONSHIPS SET DIRECTION_CODE = 'P' WHERE ROWID = r1.row_id;
2122: END IF;
2123:

Line 2121: UPDATE HZ_RELATIONSHIPS SET DIRECTION_CODE = 'P' WHERE ROWID = r1.row_id;

2117: FETCH c1 INTO r1;
2118: IF r2.direction_code = 'P' THEN
2119: UPDATE HZ_RELATIONSHIPS SET DIRECTION_CODE = 'C' WHERE ROWID = r1.row_id;
2120: ELSE
2121: UPDATE HZ_RELATIONSHIPS SET DIRECTION_CODE = 'P' WHERE ROWID = r1.row_id;
2122: END IF;
2123:
2124: FETCH c1 INTO r1;
2125: