APPS.RRS_HIERARCHY_CRUD_PKG dependencies on RRS_SITE_GROUPS_TL

Line 81: FROM RRS_SITE_GROUPS_TL

77:
78: IF p_new_name IS NOT NULL THEN
79: SELECT count(*)
80: INTO v_count
81: FROM RRS_SITE_GROUPS_TL
82: WHERE NAME = p_new_name
83: AND SITE_GROUP_ID <> v_hier_id;
84: IF v_count <> 0 THEN
85: --RRS_HIER_EXISTS

Line 154: UPDATE RRS_SITE_GROUPS_TL RSGT

150: RSGB.END_DATE = DECODE(p_nullify_flag, FND_API.G_TRUE, p_end_date, NVL(p_end_date, RSGB.END_DATE)),
151: RSGB.GROUP_PURPOSE_CODE = DECODE(p_nullify_flag, FND_API.G_TRUE, p_purpose_code, NVL(p_purpose_code, RSGB.GROUP_PURPOSE_CODE))
152: WHERE RSGB.SITE_GROUP_ID = v_hier_id;
153:
154: UPDATE RRS_SITE_GROUPS_TL RSGT
155: SET RSGT.DESCRIPTION = DECODE(p_nullify_flag, FND_API.G_TRUE, p_description, NVL(p_description, RSGT.DESCRIPTION)),
156: RSGT.NAME = NVL(p_new_name, RSGT.NAME),
157: RSGT.SOURCE_LANG = userenv('LANG')
158: WHERE RSGT.SITE_GROUP_ID = v_hier_id

Line 511: FROM RRS_SITE_GROUPS_TL

507:
508: --check if the hierarchy already exists
509: SELECT COUNT(*)
510: INTO v_count
511: FROM RRS_SITE_GROUPS_TL
512: WHERE NAME = p_hier_name;
513:
514: IF v_count <> 0 THEN
515: --RRS_HIER_EXISTS

Line 571: --insert new row into RRS_SITE_GROUPS_TL table

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
573: (
574: SITE_GROUP_ID,
575: LANGUAGE,

Line 572: INSERT INTO RRS_SITE_GROUPS_TL

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
573: (
574: SITE_GROUP_ID,
575: LANGUAGE,
576: SOURCE_LANG,