APPS.RRS_HIERARCHY_CRUD_PKG dependencies on DUAL

Line 395: From dual;

391: END IF;
392:
393: SELECT RRS_SITES_S.NEXTVAL
394: INTO v_id
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

Line 568: From dual;

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);
571: --insert new row into RRS_SITE_GROUPS_TL table
572: INSERT INTO RRS_SITE_GROUPS_TL

Line 637: From dual;

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);
640: --insert new row into RRS_SITE_GROUP_VERSIONS table
641: INSERT INTO RRS_SITE_GROUP_VERSIONS

Line 674: From dual;

670: --creat new root node
671: --retrieve new node id from the sequence
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: (