DBA Data[Home] [Help]

APPS.RRS_HIERARCHY_CRUD_PKG dependencies on RRS_SITE_GROUP_VERSIONS_S

Line 635: SELECT RRS_SITE_GROUP_VERSIONS_S.NEXTVAL

631: RAISE e_insert_failed;
632: END IF;*/
633:
634: --retrieve new version id from the sequence
635: SELECT RRS_SITE_GROUP_VERSIONS_S.NEXTVAL
636: INTO v_hier_version_id
637: From dual;
638: --v_hier_version_id := RRS_SITE_GROUP_VERSIONS_S.NEXTVAL;
639: --dbms_output.put_line(v_hier_version_id);

Line 638: --v_hier_version_id := RRS_SITE_GROUP_VERSIONS_S.NEXTVAL;

634: --retrieve new version id from the sequence
635: SELECT RRS_SITE_GROUP_VERSIONS_S.NEXTVAL
636: INTO v_hier_version_id
637: From dual;
638: --v_hier_version_id := RRS_SITE_GROUP_VERSIONS_S.NEXTVAL;
639: --dbms_output.put_line(v_hier_version_id);
640: --insert new row into RRS_SITE_GROUP_VERSIONS table
641: INSERT INTO RRS_SITE_GROUP_VERSIONS
642: (