APPS.RRS_SITE_GROUP_NODES_PKG dependencies on RRS_SITE_GROUP_NODES_B

Line 19: cursor C is select ROWID from RRS_SITE_GROUP_NODES_B

15: ) is
16:
17: L_SITE_GROUP_NODE_ID NUMBER;
18:
19: cursor C is select ROWID from RRS_SITE_GROUP_NODES_B
20: where SITE_GROUP_NODE_ID = L_SITE_GROUP_NODE_ID;
21:
22: begin
23:

Line 28: insert into RRS_SITE_GROUP_NODES_B (

24: select nvl(X_SITE_GROUP_NODE_ID ,RRS_SITES_S.nextval)
25: into L_SITE_GROUP_NODE_ID
26: from dual;
27:
28: insert into RRS_SITE_GROUP_NODES_B (
29: SITE_GROUP_NODE_ID,
30: OBJECT_VERSION_NUMBER,
31: CREATION_DATE,
32: CREATED_BY,

Line 94: from RRS_SITE_GROUP_NODES_B

90: X_DESCRIPTION in VARCHAR2
91: ) is
92: cursor c is select
93: OBJECT_VERSION_NUMBER
94: from RRS_SITE_GROUP_NODES_B
95: where SITE_GROUP_NODE_ID = X_SITE_GROUP_NODE_ID
96: for update of SITE_GROUP_NODE_ID nowait;
97: recinfo c%rowtype;
98:

Line 151: update RRS_SITE_GROUP_NODES_B set

147: X_LAST_UPDATED_BY in NUMBER,
148: X_LAST_UPDATE_LOGIN in NUMBER
149: ) is
150: begin
151: update RRS_SITE_GROUP_NODES_B set
152: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
153: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
154: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
155: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 188: delete from RRS_SITE_GROUP_NODES_B

184: if (sql%notfound) then
185: raise no_data_found;
186: end if;
187:
188: delete from RRS_SITE_GROUP_NODES_B
189: where SITE_GROUP_NODE_ID = X_SITE_GROUP_NODE_ID;
190:
191: if (sql%notfound) then
192: raise no_data_found;

Line 202: from RRS_SITE_GROUP_NODES_B B

198: begin
199: delete from RRS_SITE_GROUP_NODES_TL T
200: where not exists
201: (select NULL
202: from RRS_SITE_GROUP_NODES_B B
203: where B.SITE_GROUP_NODE_ID = T.SITE_GROUP_NODE_ID
204: );
205:
206: update RRS_SITE_GROUP_NODES_TL T set (