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.RRS_HIERARCHY_CRUD_PKG dependencies on RRS_SITE_GROUP_NODES_VL

Line 233: FROM RRS_SITE_GROUP_NODES_VL RSGNV

229:
230: BEGIN
231: SELECT SITE_GROUP_NODE_ID, NODE_PURPOSE_CODE
232: INTO v_id, v_purpose_code
233: FROM RRS_SITE_GROUP_NODES_VL RSGNV
234: WHERE RSGNV.NODE_IDENTIFICATION_NUMBER = p_number;
235: EXCEPTION
236: WHEN NO_DATA_FOUND THEN
237: --RRS_NO_NODE_FOUND

Line 351: FROM RRS_SITE_GROUP_NODES_VL RSGNV

347: END IF;
348:
349: SELECT count(*)
350: INTO v_count
351: FROM RRS_SITE_GROUP_NODES_VL RSGNV
352: WHERE RSGNV.NODE_IDENTIFICATION_NUMBER = p_number;
353:
354: IF v_count <> 0 THEN
355: --RRS_NODE_EXISTS

Line 937: FROM RRS_SITE_GROUP_NODES_VL

933: AND CHILD_ID IS NULL
934: AND CHILD_NUMBER IS NOT NULL
935: AND CHILD_NUMBER NOT IN (
936: SELECT NODE_IDENTIFICATION_NUMBER
937: FROM RRS_SITE_GROUP_NODES_VL
938: WHERE NODE_IDENTIFICATION_NUMBER IS NOT NULL);
939:
940: CURSOR update_nodes_cursor IS
941: SELECT *

Line 958: AND (PARENT_ID, PARENT_NUMBER) NOT IN (SELECT SITE_GROUP_NODE_ID, NODE_IDENTIFICATION_NUMBER FROM RRS_SITE_GROUP_NODES_VL));

954: SELECT PARENT_ID, PARENT_NUMBER
955: FROM RRS_SITE_GROUP_MEMBERS_TEMP
956: WHERE (PARENT_ID IS NOT NULL AND PARENT_NUMBER IS NOT NULL)
957: AND ((PARENT_ID, PARENT_NUMBER) NOT IN (SELECT SITE_ID, SITE_IDENTIFICATION_NUMBER FROM RRS_SITES_VL)
958: AND (PARENT_ID, PARENT_NUMBER) NOT IN (SELECT SITE_GROUP_NODE_ID, NODE_IDENTIFICATION_NUMBER FROM RRS_SITE_GROUP_NODES_VL));
959:
960: CURSOR validate_c_id_num_cursor IS
961: SELECT CHILD_ID, CHILD_NUMBER
962: FROM RRS_SITE_GROUP_MEMBERS_TEMP

Line 965: AND (CHILD_ID, CHILD_NUMBER) NOT IN (SELECT SITE_GROUP_NODE_ID, NODE_IDENTIFICATION_NUMBER FROM RRS_SITE_GROUP_NODES_VL));

961: SELECT CHILD_ID, CHILD_NUMBER
962: FROM RRS_SITE_GROUP_MEMBERS_TEMP
963: WHERE (CHILD_ID IS NOT NULL AND CHILD_NUMBER IS NOT NULL)
964: AND ((CHILD_ID, CHILD_NUMBER) NOT IN (SELECT SITE_ID, SITE_IDENTIFICATION_NUMBER FROM RRS_SITES_VL)
965: AND (CHILD_ID, CHILD_NUMBER) NOT IN (SELECT SITE_GROUP_NODE_ID, NODE_IDENTIFICATION_NUMBER FROM RRS_SITE_GROUP_NODES_VL));
966:
967: CURSOR validate_p_id_cursor IS
968: SELECT PARENT_TYPE, PARENT_ID, PARENT_NUMBER
969: FROM RRS_SITE_GROUP_MEMBERS_TEMP RSGMT

Line 1018: FROM RRS_SITE_GROUP_MEMBERS_TEMP RSGMT, RRS_SITE_GROUP_NODES_VL RSGNV

1014: AND IS_TEMPLATE_FLAG = 'Y';
1015:
1016: CURSOR validate_node_name_cursor IS
1017: SELECT RSGNV.NAME
1018: FROM RRS_SITE_GROUP_MEMBERS_TEMP RSGMT, RRS_SITE_GROUP_NODES_VL RSGNV
1019: WHERE RSGMT.CHILD_ID = RSGNV.SITE_GROUP_NODE_ID
1020: GROUP BY RSGMT.PARENT_ID, RSGNV.NAME
1021: HAVING COUNT(*) > 1;
1022:

Line 1166: FROM RRS_SITE_GROUP_NODES_VL

1162:
1163: IF p_root_number IS NULL AND v_root_number IS NOT NULL THEN
1164: SELECT COUNT(*)
1165: INTO v_count
1166: FROM RRS_SITE_GROUP_NODES_VL
1167: WHERE NODE_IDENTIFICATION_NUMBER = v_root_number
1168: AND SITE_GROUP_NODE_ID <> p_root_id;
1169:
1170: IF v_count <> 0 THEN

Line 1320: FROM RRS_SITES_VL RSV, RRS_SITE_GROUP_NODES_VL RSGNV, RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2

1316: --dbms_output.put_line('before case3 update parent id/num');
1317: UPDATE RRS_SITE_GROUP_MEMBERS_TEMP RSGMT
1318: SET PARENT_ID = (
1319: SELECT DECODE(PARENT_TYPE,'SITE', SITE_ID, SITE_GROUP_NODE_ID)
1320: FROM RRS_SITES_VL RSV, RRS_SITE_GROUP_NODES_VL RSGNV, RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2
1321: WHERE RSGMT2.PARENT_NUMBER = RSV.SITE_IDENTIFICATION_NUMBER(+)
1322: AND RSGMT2.PARENT_NUMBER = RSGNV.NODE_IDENTIFICATION_NUMBER(+)
1323: AND RSGMT.ROWID = RSGMT2.ROWID)
1324: WHERE PARENT_ID IS NULL;

Line 1329: FROM RRS_SITES_VL RSV, RRS_SITE_GROUP_NODES_VL RSGNV, RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2

1325: --set the parent_number
1326: UPDATE RRS_SITE_GROUP_MEMBERS_TEMP RSGMT
1327: SET PARENT_NUMBER = (
1328: SELECT DECODE(PARENT_TYPE,'SITE', SITE_IDENTIFICATION_NUMBER, NODE_IDENTIFICATION_NUMBER)
1329: FROM RRS_SITES_VL RSV, RRS_SITE_GROUP_NODES_VL RSGNV, RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2
1330: WHERE RSGMT2.PARENT_ID = RSV.SITE_ID(+)
1331: AND RSGMT2.PARENT_ID = RSGNV.SITE_GROUP_NODE_ID(+)
1332: AND RSGMT.ROWID = RSGMT2.ROWID)
1333: WHERE PARENT_NUMBER IS NULL;

Line 1339: FROM RRS_SITES_VL RSV, RRS_SITE_GROUP_NODES_VL RSGNV, RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2

1335: --dbms_output.put_line('before case3 update child id/num');
1336: UPDATE RRS_SITE_GROUP_MEMBERS_TEMP RSGMT
1337: SET CHILD_ID = (
1338: SELECT DECODE(CHILD_TYPE,'SITE', SITE_ID, SITE_GROUP_NODE_ID)
1339: FROM RRS_SITES_VL RSV, RRS_SITE_GROUP_NODES_VL RSGNV, RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2
1340: WHERE RSGMT2.CHILD_NUMBER = RSV.SITE_IDENTIFICATION_NUMBER(+)
1341: AND RSGMT2.CHILD_NUMBER = RSGNV.NODE_IDENTIFICATION_NUMBER(+)
1342: AND RSGMT.ROWID = RSGMT2.ROWID)
1343: WHERE CHILD_ID IS NULL;

Line 1348: FROM RRS_SITES_VL RSV, RRS_SITE_GROUP_NODES_VL RSGNV, RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2

1344: --set the child_number
1345: UPDATE RRS_SITE_GROUP_MEMBERS_TEMP RSGMT
1346: SET CHILD_NUMBER = (
1347: SELECT DECODE(CHILD_TYPE,'SITE', SITE_IDENTIFICATION_NUMBER, NODE_IDENTIFICATION_NUMBER)
1348: FROM RRS_SITES_VL RSV, RRS_SITE_GROUP_NODES_VL RSGNV, RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2
1349: WHERE RSGMT2.CHILD_ID = RSV.SITE_ID(+)
1350: AND RSGMT2.CHILD_ID = RSGNV.SITE_GROUP_NODE_ID(+)
1351: AND RSGMT.ROWID = RSGMT2.ROWID)
1352: WHERE CHILD_NUMBER IS NULL;

Line 1482: FROM RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2, RRS_SITE_USES RSU, RRS_SITE_GROUP_NODES_VL RSGNV

1478: --dbms_output.put_line('before defaulting parent purpose code');
1479: UPDATE RRS_SITE_GROUP_MEMBERS_TEMP RSGMT
1480: SET PARENT_PURPOSE_CODE = (
1481: SELECT NVL(RSU.SITE_USE_TYPE_CODE, RSGNV.NODE_PURPOSE_CODE)
1482: FROM RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2, RRS_SITE_USES RSU, RRS_SITE_GROUP_NODES_VL RSGNV
1483: WHERE RSGMT2.PARENT_ID = RSU.SITE_ID(+)
1484: AND RSU.IS_PRIMARY_FLAG(+) = 'Y'
1485: AND RSGMT2.PARENT_ID = RSGNV.SITE_GROUP_NODE_ID(+)
1486: AND RSGMT.ROWID = RSGMT2.ROWID);

Line 1493: FROM RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2, RRS_SITE_USES RSU, RRS_SITE_GROUP_NODES_VL RSGNV

1489: --dbms_output.put_line('before defaulting child purpose code');
1490: UPDATE RRS_SITE_GROUP_MEMBERS_TEMP RSGMT
1491: SET CHILD_PURPOSE_CODE = (
1492: SELECT NVL(RSU.SITE_USE_TYPE_CODE, RSGNV.NODE_PURPOSE_CODE)
1493: FROM RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2, RRS_SITE_USES RSU, RRS_SITE_GROUP_NODES_VL RSGNV
1494: WHERE RSGMT2.CHILD_ID = RSU.SITE_ID(+)
1495: AND RSU.IS_PRIMARY_FLAG(+) = 'Y'
1496: AND RSGMT2.CHILD_ID = RSGNV.SITE_GROUP_NODE_ID(+)
1497: AND RSU.IS_PRIMARY_FLAG(+) = 'Y'

Line 1616: FROM RRS_SITE_GROUP_MEMBERS RSGM, RRS_SITE_GROUP_NODES_VL RSGNV

1612:
1613: BEGIN
1614: SELECT RSGM.CHILD_MEMBER_ID, RSGNV.NODE_IDENTIFICATION_NUMBER
1615: INTO v_root_id, v_root_number
1616: FROM RRS_SITE_GROUP_MEMBERS RSGM, RRS_SITE_GROUP_NODES_VL RSGNV
1617: WHERE RSGM.SITE_GROUP_ID = v_hier_id
1618: AND RSGM.PARENT_MEMBER_ID = -1
1619: AND RSGM.CHILD_MEMBER_ID = RSGNV.SITE_GROUP_NODE_ID
1620: AND RSGNV.NODE_PURPOSE_CODE = 'ROOT';

Line 1765: RRS_SITE_GROUP_NODES_VL RSGNV,

1761: NVL(RSV2.SITE_IDENTIFICATION_NUMBER, RSGNV2.NODE_IDENTIFICATION_NUMBER) AS C_NUMBER,
1762: DECODE(RSV2.SITE_ID, NULL, RSGNV2.NODE_PURPOSE_CODE, RSU2.SITE_USE_TYPE_CODE) AS C_PURPOSE_CODE,
1763: RSGM.SEQUENCE_NUMBER AS C_SEQ_NUMBER
1764: FROM RRS_SITE_GROUP_MEMBERS RSGM,
1765: RRS_SITE_GROUP_NODES_VL RSGNV,
1766: RRS_SITES_VL RSV, RRS_SITE_USES RSU,
1767: RRS_SITE_GROUP_NODES_VL RSGNV2,
1768: RRS_SITES_VL RSV2,
1769: RRS_SITE_USES RSU2

Line 1767: RRS_SITE_GROUP_NODES_VL RSGNV2,

1763: RSGM.SEQUENCE_NUMBER AS C_SEQ_NUMBER
1764: FROM RRS_SITE_GROUP_MEMBERS RSGM,
1765: RRS_SITE_GROUP_NODES_VL RSGNV,
1766: RRS_SITES_VL RSV, RRS_SITE_USES RSU,
1767: RRS_SITE_GROUP_NODES_VL RSGNV2,
1768: RRS_SITES_VL RSV2,
1769: RRS_SITE_USES RSU2
1770: WHERE RSGM.PARENT_MEMBER_ID = RSV.SITE_ID(+)
1771: AND RSGM.PARENT_MEMBER_ID = RSU.SITE_ID(+)

Line 1856: FROM RRS_SITE_GROUP_NODES_VL

1852: IF p_hier_members_rec.child_object_type = 'NODE' THEN
1853: BEGIN
1854: SELECT SITE_GROUP_NODE_ID, NODE_PURPOSE_CODE, NAME
1855: INTO v_child_id, v_child_purpose_code, v_child_name
1856: FROM RRS_SITE_GROUP_NODES_VL
1857: WHERE NODE_IDENTIFICATION_NUMBER = p_hier_members_rec.child_id_number;
1858: EXCEPTION
1859: WHEN NO_DATA_FOUND THEN
1860: --RRS_NO_NODE_FOUND

Line 1930: FROM RRS_SITE_GROUP_NODES_VL RSGNV, RRS_SITE_GROUP_MEMBERS RSGM

1926: IF p_hier_members_rec.dest_parent_object_type = 'NODE' THEN
1927: BEGIN
1928: SELECT SITE_GROUP_NODE_ID, NODE_PURPOSE_CODE
1929: INTO v_dest_parent_id, v_dest_parent_purpose_code
1930: FROM RRS_SITE_GROUP_NODES_VL RSGNV, RRS_SITE_GROUP_MEMBERS RSGM
1931: WHERE RSGNV.NODE_IDENTIFICATION_NUMBER = p_hier_members_rec.dest_parent_id_number
1932: AND RSGNV.SITE_GROUP_NODE_ID = RSGM.CHILD_MEMBER_ID
1933: AND RSGM.SITE_GROUP_ID = v_dest_hier_id;
1934: EXCEPTION

Line 2190: FROM RRS_SITE_GROUP_MEMBERS RSGM, RRS_SITE_GROUP_NODES_VL RSGNV

2186: IF p_hier_members_rec.child_object_type = 'NODE' THEN
2187: --dbms_output.put_line('before check duplicated node name');
2188: SELECT COUNT(*)
2189: INTO v_count
2190: FROM RRS_SITE_GROUP_MEMBERS RSGM, RRS_SITE_GROUP_NODES_VL RSGNV
2191: WHERE RSGM.SITE_GROUP_ID = v_dest_hier_id
2192: AND RSGM.PARENT_MEMBER_ID = v_dest_parent_id
2193: AND RSGM.CHILD_MEMBER_ID = RSGNV.SITE_GROUP_NODE_ID
2194: AND RSGNV.NAME = v_child_name;

Line 2382: RRS_SITE_GROUP_NODES_VL RSGNV,

2378: NVL(RSV2.SITE_IDENTIFICATION_NUMBER, RSGNV2.NODE_IDENTIFICATION_NUMBER) AS C_NUMBER,
2379: DECODE(RSV2.SITE_ID, NULL, RSGNV2.NODE_PURPOSE_CODE, RSU2.SITE_USE_TYPE_CODE) AS C_PURPOSE_CODE,
2380: RSGM.SEQUENCE_NUMBER AS C_SEQ_NUMBER
2381: FROM RRS_SITE_GROUP_MEMBERS RSGM,
2382: RRS_SITE_GROUP_NODES_VL RSGNV,
2383: RRS_SITES_VL RSV, RRS_SITE_USES RSU,
2384: RRS_SITE_GROUP_NODES_VL RSGNV2,
2385: RRS_SITES_VL RSV2,
2386: RRS_SITE_USES RSU2

Line 2384: RRS_SITE_GROUP_NODES_VL RSGNV2,

2380: RSGM.SEQUENCE_NUMBER AS C_SEQ_NUMBER
2381: FROM RRS_SITE_GROUP_MEMBERS RSGM,
2382: RRS_SITE_GROUP_NODES_VL RSGNV,
2383: RRS_SITES_VL RSV, RRS_SITE_USES RSU,
2384: RRS_SITE_GROUP_NODES_VL RSGNV2,
2385: RRS_SITES_VL RSV2,
2386: RRS_SITE_USES RSU2
2387: WHERE RSGM.PARENT_MEMBER_ID = RSV.SITE_ID(+)
2388: AND RSGM.PARENT_MEMBER_ID = RSU.SITE_ID(+)

Line 2545: FROM RRS_SITE_GROUP_NODES_VL

2541: ELSIF p_parent_object_type = 'NODE' THEN
2542: BEGIN
2543: SELECT NODE_IDENTIFICATION_NUMBER, NODE_PURPOSE_CODE
2544: INTO v_parent_id_number, v_parent_purpose_code
2545: FROM RRS_SITE_GROUP_NODES_VL
2546: WHERE SITE_GROUP_NODE_ID = p_parent_id;
2547: EXCEPTION
2548: WHEN NO_DATA_FOUND THEN
2549: --RRS_NO_NODE_FOUND

Line 2583: FROM RRS_SITE_GROUP_NODES_VL

2579: ELSIF p_child_object_type = 'NODE' THEN
2580: BEGIN
2581: SELECT NODE_IDENTIFICATION_NUMBER, NODE_PURPOSE_CODE
2582: INTO v_child_id_number, v_child_purpose_code
2583: FROM RRS_SITE_GROUP_NODES_VL
2584: WHERE SITE_GROUP_NODE_ID = p_child_id;
2585: EXCEPTION
2586: WHEN NO_DATA_FOUND THEN
2587: --RRS_NO_NODE_FOUND