APPS.RRS_HIERARCHY_CRUD_PKG dependencies on RRS_SITE_GROUP_NODES_B

Line 296: UPDATE RRS_SITE_GROUP_NODES_B RSGNB

292: IF SQL%NOTFOUND THEN
293: RAISE e_update_failed;
294: END IF; */
295:
296: UPDATE RRS_SITE_GROUP_NODES_B RSGNB
297: SET RSGNB.NODE_PURPOSE_CODE = DECODE(p_nullify_flag, FND_API.G_TRUE, p_purpose_code, NVL(p_purpose_code, RSGNB.NODE_PURPOSE_CODE))
298: WHERE RSGNB.SITE_GROUP_NODE_ID = v_id;
299:
300: /*

Line 432: INSERT INTO RRS_SITE_GROUP_NODES_B

428: END IF;*/
429:
430: --dbms_output.put_line(v_id || ' ' || p_purpose_code || ' ' || p_number);
431:
432: INSERT INTO RRS_SITE_GROUP_NODES_B
433: (
434: SITE_GROUP_NODE_ID,
435: OBJECT_VERSION_NUMBER,
436: CREATED_BY,

Line 707: --insert new row into RRS_SITE_GROUP_NODES_B table

703: IF SQL%NOTFOUND THEN
704: RAISE e_insert_failed;
705: END IF;*/
706:
707: --insert new row into RRS_SITE_GROUP_NODES_B table
708: INSERT INTO RRS_SITE_GROUP_NODES_B
709: (
710: SITE_GROUP_NODE_ID,
711: OBJECT_VERSION_NUMBER,

Line 708: INSERT INTO RRS_SITE_GROUP_NODES_B

704: RAISE e_insert_failed;
705: END IF;*/
706:
707: --insert new row into RRS_SITE_GROUP_NODES_B table
708: INSERT INTO RRS_SITE_GROUP_NODES_B
709: (
710: SITE_GROUP_NODE_ID,
711: OBJECT_VERSION_NUMBER,
712: CREATED_BY,

Line 979: FROM RRS_SITE_GROUP_NODES_B

975: WHERE SITE_ID = RSGMT.PARENT_ID))
976: OR (PARENT_TYPE = 'NODE'
977: AND NOT EXISTS (
978: SELECT SITE_GROUP_NODE_ID
979: FROM RRS_SITE_GROUP_NODES_B
980: WHERE SITE_GROUP_NODE_ID = RSGMT.PARENT_ID)));
981:
982: CURSOR validate_c_id_cursor IS
983: SELECT CHILD_TYPE, CHILD_ID, CHILD_NUMBER

Line 994: FROM RRS_SITE_GROUP_NODES_B

990: WHERE SITE_ID = RSGMT.CHILD_ID))
991: OR (CHILD_TYPE = 'NODE'
992: AND NOT EXISTS (
993: SELECT SITE_GROUP_NODE_ID
994: FROM RRS_SITE_GROUP_NODES_B
995: WHERE SITE_GROUP_NODE_ID = RSGMT.CHILD_ID)));
996:
997: CURSOR validate_dup_number_cursor IS
998: SELECT CHILD_TYPE, CHILD_NUMBER

Line 1180: UPDATE RRS_SITE_GROUP_NODES_B

1176: RAISE FND_API.G_EXC_ERROR;
1177: END IF;
1178:
1179: --update the root node number
1180: UPDATE RRS_SITE_GROUP_NODES_B
1181: SET NODE_IDENTIFICATION_NUMBER = v_root_number
1182: WHERE SITE_GROUP_NODE_ID = p_root_id;
1183: END IF;
1184: