APPS.RRS_HIERARCHY_CRUD_PKG dependencies on RRS_SITE_GROUP_NODES_TL

Line 174: UPDATE RRS_SITE_GROUP_NODES_TL RSGNT

170: AND PARENT_MEMBER_ID = -1;
171:
172: --dbms_output.put_line('before update node');
173:
174: UPDATE RRS_SITE_GROUP_NODES_TL RSGNT
175: SET RSGNT.NAME = NVL(p_new_name, RSGNT.NAME),
176: RSGNT.SOURCE_LANG = userenv('LANG')
177: WHERE RSGNT.SITE_GROUP_NODE_ID = v_root_id
178: AND RSGNT.LANGUAGE = userenv('LANG');

Line 284: UPDATE RRS_SITE_GROUP_NODES_TL RSGNT

280: --dbms_output.put_line('new name cannot be null');
281: RAISE FND_API.G_EXC_ERROR;
282: END IF;
283:
284: UPDATE RRS_SITE_GROUP_NODES_TL RSGNT
285: SET RSGNT.DESCRIPTION = DECODE(p_nullify_flag, FND_API.G_TRUE, p_description, NVL(p_description, RSGNT.DESCRIPTION)),
286: RSGNT.NAME = NVL(p_name, RSGNT.NAME),
287: RSGNT.SOURCE_LANG = userenv('LANG')
288: WHERE RSGNT.SITE_GROUP_NODE_ID = v_id

Line 399: INSERT INTO RRS_SITE_GROUP_NODES_TL

395: From dual;
396: --v_id := RRS_SITES_S.NEXTVAL;
397: --dbms_output.put_line(v_id);
398:
399: INSERT INTO RRS_SITE_GROUP_NODES_TL
400: (
401: SITE_GROUP_NODE_ID,
402: LANGUAGE,
403: SOURCE_LANG,

Line 676: --insert new row into RRS_SITE_GROUP_NODES_TL table

672: SELECT RRS_SITES_S.NEXTVAL
673: INTO v_root_id
674: From dual;
675: --v_root_id := RRS_SITES_S.NEXTVAL;
676: --insert new row into RRS_SITE_GROUP_NODES_TL table
677: INSERT INTO RRS_SITE_GROUP_NODES_TL
678: (
679: SITE_GROUP_NODE_ID,
680: LANGUAGE,

Line 677: INSERT INTO RRS_SITE_GROUP_NODES_TL

673: INTO v_root_id
674: From dual;
675: --v_root_id := RRS_SITES_S.NEXTVAL;
676: --insert new row into RRS_SITE_GROUP_NODES_TL table
677: INSERT INTO RRS_SITE_GROUP_NODES_TL
678: (
679: SITE_GROUP_NODE_ID,
680: LANGUAGE,
681: SOURCE_LANG,