APPS.RRS_HIERARCHY_CRUD_PKG dependencies on RRS_SITE_GROUPS_S

Line 566: SELECT RRS_SITE_GROUPS_S.NEXTVAL

562: RAISE FND_API.G_EXC_ERROR;
563: END IF;
564:
565: --retrieve new site group id from the sequence
566: SELECT RRS_SITE_GROUPS_S.NEXTVAL
567: INTO v_hier_id
568: From dual;
569: --v_hier_id := RRS_SITE_GROUPS_S.NEXTVAL;
570: --dbms_output.put_line('hier_id: '||v_hier_id);

Line 569: --v_hier_id := RRS_SITE_GROUPS_S.NEXTVAL;

565: --retrieve new site group id from the sequence
566: SELECT RRS_SITE_GROUPS_S.NEXTVAL
567: INTO v_hier_id
568: From dual;
569: --v_hier_id := RRS_SITE_GROUPS_S.NEXTVAL;
570: --dbms_output.put_line('hier_id: '||v_hier_id);
571: --insert new row into RRS_SITE_GROUPS_TL table
572: INSERT INTO RRS_SITE_GROUPS_TL
573: (