APPS.RRS_SITE_GROUPS_PKG dependencies on RRS_SITE_GROUPS_B

Line 22: cursor C is select ROWID from RRS_SITE_GROUPS_B

18: ) is
19:
20: L_SITE_GROUP_ID NUMBER;
21:
22: cursor C is select ROWID from RRS_SITE_GROUPS_B
23: where SITE_GROUP_ID = L_SITE_GROUP_ID;
24:
25: begin
26:

Line 31: insert into RRS_SITE_GROUPS_B (

27: select nvl(X_SITE_GROUP_ID ,RRS_SITE_GROUPS_S.nextval)
28: into L_SITE_GROUP_ID
29: from dual;
30:
31: insert into RRS_SITE_GROUPS_B (
32: SITE_GROUP_ID,
33: SITE_GROUP_TYPE_CODE,
34: START_DATE,
35: END_DATE,

Line 109: from RRS_SITE_GROUPS_B

105: SITE_GROUP_TYPE_CODE,
106: START_DATE,
107: END_DATE,
108: OBJECT_VERSION_NUMBER
109: from RRS_SITE_GROUPS_B
110: where SITE_GROUP_ID = X_SITE_GROUP_ID
111: for update of SITE_GROUP_ID nowait;
112: recinfo c%rowtype;
113:

Line 173: update RRS_SITE_GROUPS_B set

169: X_LAST_UPDATED_BY in NUMBER,
170: X_LAST_UPDATE_LOGIN in NUMBER
171: ) is
172: begin
173: update RRS_SITE_GROUPS_B set
174: SITE_GROUP_TYPE_CODE = X_SITE_GROUP_TYPE_CODE,
175: START_DATE = X_START_DATE,
176: END_DATE = X_END_DATE,
177: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 213: delete from RRS_SITE_GROUPS_B

209: if (sql%notfound) then
210: raise no_data_found;
211: end if;
212:
213: delete from RRS_SITE_GROUPS_B
214: where SITE_GROUP_ID = X_SITE_GROUP_ID;
215:
216: if (sql%notfound) then
217: raise no_data_found;

Line 227: from RRS_SITE_GROUPS_B B

223: begin
224: delete from RRS_SITE_GROUPS_TL T
225: where not exists
226: (select NULL
227: from RRS_SITE_GROUPS_B B
228: where B.SITE_GROUP_ID = T.SITE_GROUP_ID
229: );
230:
231: update RRS_SITE_GROUPS_TL T set (