APPS.RRS_HIERARCHY_CRUD_PKG dependencies on RRS_SITES_S

Line 393: SELECT RRS_SITES_S.NEXTVAL

389: --dbms_output.put_line('null name');
390: RAISE FND_API.G_EXC_ERROR;
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);

Line 396: --v_id := RRS_SITES_S.NEXTVAL;

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
400: (

Line 672: SELECT RRS_SITES_S.NEXTVAL

668: END IF;*/
669:
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

Line 675: --v_root_id := RRS_SITES_S.NEXTVAL;

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: (
679: SITE_GROUP_NODE_ID,