APPS.RRS_HIERARCHY_INFO dependencies on RRS_SITE_GROUP_VERSIONS

Line 31: FROM RRS_SITE_GROUP_VERSIONS RSGV, RRS_SITE_GROUPS_B RSGB, RRS_SITE_GROUPS_TL RSGT, RRS_LOOKUPS_V LKUP

27: RSGT.DESCRIPTION,
28: RSGB.START_DATE,
29: RSGB.END_DATE)
30: INTO x_hier_header_rec
31: FROM RRS_SITE_GROUP_VERSIONS RSGV, RRS_SITE_GROUPS_B RSGB, RRS_SITE_GROUPS_TL RSGT, RRS_LOOKUPS_V LKUP
32: WHERE RSGT.LANGUAGE = userenv('LANG')
33: AND RSGV.SITE_GROUP_VERSION_ID = p_hier_version_id
34: AND RSGB.SITE_GROUP_ID = RSGV.SITE_GROUP_ID
35: AND RSGT.SITE_GROUP_ID = RSGB.SITE_GROUP_ID

Line 75: FROM RRS_SITE_GROUP_VERSIONS

71: --if user does not provide version number, api will pick up the latest version number
72: IF l_hier_version_number IS NULL THEN
73: SELECT MAX(VERSION_NUMBER)
74: INTO l_hier_version_number
75: FROM RRS_SITE_GROUP_VERSIONS
76: WHERE SITE_GROUP_ID = p_hier_id;
77: END IF;
78:
79: SELECT SITE_GROUP_VERSION_ID

Line 81: FROM RRS_SITE_GROUP_VERSIONS

77: END IF;
78:
79: SELECT SITE_GROUP_VERSION_ID
80: INTO l_hier_version_id
81: FROM RRS_SITE_GROUP_VERSIONS
82: WHERE SITE_GROUP_ID = p_hier_id
83: AND VERSION_NUMBER = l_hier_version_number;
84:
85: Get_Hierarchy_Header(p_api_version => p_api_version

Line 168: l_site_group_version_id rrs_site_group_versions.site_group_version_id%TYPE;

164: ,x_msg_data OUT NOCOPY varchar2
165: ) is
166:
167: l_site_group_id rrs_site_groups_b.site_group_id%TYPE;
168: l_site_group_version_id rrs_site_group_versions.site_group_version_id%TYPE;
169: l_parent_id rrs_site_group_members.parent_member_id%TYPE;
170:
171: x_hier_header_rec rrs_hier_header_rec;
172:

Line 183: FROM RRS_SITE_GROUP_VERSIONS

179: -- query the site group id from version id
180: -- For Bug Fix 9011360 - jijiao 10/13/2009
181: SELECT SITE_GROUP_ID
182: INTO l_site_group_id
183: FROM RRS_SITE_GROUP_VERSIONS
184: WHERE SITE_GROUP_VERSION_ID = p_hier_version_id;
185:
186:
187: --query the members in the whole hierarchy

Line 346: FROM RRS_SITE_GROUP_VERSIONS

342: if user does not provide version number, we return the latest version*/
343:
344: SELECT SITE_GROUP_VERSION_ID
345: INTO l_hier_version_id
346: FROM RRS_SITE_GROUP_VERSIONS
347: WHERE SITE_GROUP_ID = p_hier_id
348: AND VERSION_NUMBER = DECODE(p_hier_version_number, NULL, (SELECT MAX(VERSION_NUMBER)
349: FROM RRS_SITE_GROUP_VERSIONS
350: WHERE SITE_GROUP_ID = p_hier_id),

Line 349: FROM RRS_SITE_GROUP_VERSIONS

345: INTO l_hier_version_id
346: FROM RRS_SITE_GROUP_VERSIONS
347: WHERE SITE_GROUP_ID = p_hier_id
348: AND VERSION_NUMBER = DECODE(p_hier_version_number, NULL, (SELECT MAX(VERSION_NUMBER)
349: FROM RRS_SITE_GROUP_VERSIONS
350: WHERE SITE_GROUP_ID = p_hier_id),
351: p_hier_version_number);
352:
353:

Line 551: FROM RRS_SITE_GROUPS_VL RSG, RRS_SITE_GROUP_VERSIONS RSGV

547: /* get site_group_id*/
548: BEGIN
549: SELECT RSG.SITE_GROUP_ID, RSG.GROUP_PURPOSE_CODE
550: INTO l_site_group_id, l_group_purpose_code
551: FROM RRS_SITE_GROUPS_VL RSG, RRS_SITE_GROUP_VERSIONS RSGV
552: WHERE RSG.SITE_GROUP_ID = RSGV.SITE_GROUP_ID
553: AND RSGV.SITE_GROUP_VERSION_ID = p_hier_version_id;
554: EXCEPTION
555: WHEN NO_DATA_FOUND THEN

Line 757: FROM RRS_SITE_GROUP_VERSIONS

753: if user does not provide version number, we return the latest version*/
754:
755: SELECT SITE_GROUP_VERSION_ID
756: INTO l_hier_version_id
757: FROM RRS_SITE_GROUP_VERSIONS
758: WHERE SITE_GROUP_ID = p_hier_id
759: AND VERSION_NUMBER = DECODE(p_hier_version_number, NULL, (SELECT MAX(VERSION_NUMBER)
760: FROM RRS_SITE_GROUP_VERSIONS
761: WHERE SITE_GROUP_ID = p_hier_id),

Line 760: FROM RRS_SITE_GROUP_VERSIONS

756: INTO l_hier_version_id
757: FROM RRS_SITE_GROUP_VERSIONS
758: WHERE SITE_GROUP_ID = p_hier_id
759: AND VERSION_NUMBER = DECODE(p_hier_version_number, NULL, (SELECT MAX(VERSION_NUMBER)
760: FROM RRS_SITE_GROUP_VERSIONS
761: WHERE SITE_GROUP_ID = p_hier_id),
762: p_hier_version_number);
763:
764: Get_Hierarchy_Attributes(p_api_version => p_api_version