APPS.RRS_SITES_EXT_PKG dependencies on RRS_SITES_EXT_B

Line 147: cursor C is select ROWID from RRS_SITES_EXT_B

143: X_LAST_UPDATED_BY in NUMBER,
144: X_LAST_UPDATE_LOGIN in NUMBER
145: ) is
146: l_extension_id NUMBER;
147: cursor C is select ROWID from RRS_SITES_EXT_B
148: where EXTENSION_ID = l_extension_id
149: ;
150:
151: begin

Line 157: insert into RRS_SITES_EXT_B (

153: select nvl(X_EXTENSION_ID ,EGO_EXTFWK_S.nextval)
154: into l_extension_id
155: from dual;
156:
157: insert into RRS_SITES_EXT_B (
158: EXTENSION_ID,
159: SITE_ID,
160: SITE_USE_TYPE_CODE,
161: ATTR_GROUP_ID,

Line 715: from RRS_SITES_EXT_B

711: N_EXT_ATTR13,
712: N_EXT_ATTR14,
713: N_EXT_ATTR15,
714: N_EXT_ATTR16
715: from RRS_SITES_EXT_B
716: where EXTENSION_ID = X_EXTENSION_ID
717: for update of EXTENSION_ID nowait;
718: recinfo c%rowtype;
719:

Line 1201: update RRS_SITES_EXT_B set

1197: X_LAST_UPDATED_BY in NUMBER,
1198: X_LAST_UPDATE_LOGIN in NUMBER
1199: ) is
1200: begin
1201: update RRS_SITES_EXT_B set
1202: N_EXT_ATTR17 = X_N_EXT_ATTR17,
1203: N_EXT_ATTR18 = X_N_EXT_ATTR18,
1204: N_EXT_ATTR19 = X_N_EXT_ATTR19,
1205: N_EXT_ATTR20 = X_N_EXT_ATTR20,

Line 1369: delete from RRS_SITES_EXT_B

1365: if (sql%notfound) then
1366: raise no_data_found;
1367: end if;
1368:
1369: delete from RRS_SITES_EXT_B
1370: where EXTENSION_ID = X_EXTENSION_ID;
1371:
1372: if (sql%notfound) then
1373: raise no_data_found;

Line 1383: from RRS_SITES_EXT_B B

1379: begin
1380: delete from RRS_SITES_EXT_TL T
1381: where not exists
1382: (select NULL
1383: from RRS_SITES_EXT_B B
1384: where B.EXTENSION_ID = T.EXTENSION_ID
1385: );
1386:
1387: update RRS_SITES_EXT_TL T set (