eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RRS_HIERARCHY_CRUD_PKG dependencies on RRS_SITE_GROUP_VERSIONS

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

Line 640: --insert new row into RRS_SITE_GROUP_VERSIONS table

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: (
643: SITE_GROUP_VERSION_ID,
644: SITE_GROUP_ID,

Line 641: INSERT INTO RRS_SITE_GROUP_VERSIONS

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: (
643: SITE_GROUP_VERSION_ID,
644: SITE_GROUP_ID,
645: VERSION_NUMBER,

Line 1633: FROM RRS_SITE_GROUP_VERSIONS

1629:
1630: BEGIN
1631: SELECT SITE_GROUP_VERSION_ID
1632: INTO v_hier_version_id
1633: FROM RRS_SITE_GROUP_VERSIONS
1634: WHERE SITE_GROUP_ID = v_hier_id;
1635: EXCEPTION
1636: WHEN NO_DATA_FOUND THEN
1637: --RRS_NO_HIER_VERSION_FOUND

Line 1826: FROM RRS_SITE_GROUP_VERSIONS

1822: --dbms_output.put_line('before get dest hier version id');
1823: BEGIN
1824: SELECT SITE_GROUP_VERSION_ID
1825: INTO v_dest_hier_version_id
1826: FROM RRS_SITE_GROUP_VERSIONS
1827: WHERE SITE_GROUP_ID = v_dest_hier_id;
1828: EXCEPTION
1829: WHEN NO_DATA_FOUND THEN
1830: --RRS_NO_HIER_VERSION_FOUND