APPS.RRS_HIERARCHY_CRUD_PKG dependencies on RRS_SITE_GROUPS_B

Line 110: FROM RRS_SITE_GROUPS_B

106: ELSE
107: IF p_start_date IS NULL THEN
108: SELECT START_DATE
109: INTO v_start_date
110: FROM RRS_SITE_GROUPS_B
111: WHERE SITE_GROUP_ID = v_hier_id;
112: ELSE
113: v_start_date := p_start_date;
114: END IF;

Line 118: FROM RRS_SITE_GROUPS_B

114: END IF;
115: IF p_end_date IS NULL THEN
116: SELECT END_DATE
117: INTO v_end_date
118: FROM RRS_SITE_GROUPS_B
119: WHERE SITE_GROUP_ID = v_hier_id;
120: ELSE
121: v_end_date := p_end_date;
122: END IF;

Line 148: UPDATE RRS_SITE_GROUPS_B RSGB

144: END IF;
145:
146: --dbms_output.put_line('before update site group');
147:
148: UPDATE RRS_SITE_GROUPS_B RSGB
149: SET RSGB.START_DATE = DECODE(p_nullify_flag, FND_API.G_TRUE, p_start_date, NVL(p_start_date, RSGB.START_DATE)),
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;

Line 603: --insert new row into RRS_SITE_GROUPS_B table

599: IF SQL%NOTFOUND THEN
600: RAISE e_insert_failed;
601: END IF;*/
602:
603: --insert new row into RRS_SITE_GROUPS_B table
604: INSERT INTO RRS_SITE_GROUPS_B
605: (
606: SITE_GROUP_ID,
607: SITE_GROUP_TYPE_CODE,

Line 604: INSERT INTO RRS_SITE_GROUPS_B

600: RAISE e_insert_failed;
601: END IF;*/
602:
603: --insert new row into RRS_SITE_GROUPS_B table
604: INSERT INTO RRS_SITE_GROUPS_B
605: (
606: SITE_GROUP_ID,
607: SITE_GROUP_TYPE_CODE,
608: START_DATE,

Line 1649: FROM RRS_SITE_GROUPS_B RSGB

1645: --default the purpose code when nuulify flag is false and purpose code is not specified
1646: IF NOT FND_API.To_Boolean(p_nullify_flag) AND p_hier_purpose_code IS NULL THEN
1647: SELECT GROUP_PURPOSE_CODE
1648: INTO v_purpose_code
1649: FROM RRS_SITE_GROUPS_B RSGB
1650: WHERE RSGB.SITE_GROUP_ID = v_hier_id;
1651: ELSE
1652: v_purpose_code := p_hier_purpose_code;
1653: END IF;