APPS.RRS_LOCATIONS_EXT_PKG dependencies on RRS_LOCATIONS_EXT_B

Line 147: cursor C is select ROWID from RRS_LOCATIONS_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_LOCATIONS_EXT_B
148: where EXTENSION_ID = l_extension_id
149: ;
150:
151: begin

Line 157: insert into RRS_LOCATIONS_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_LOCATIONS_EXT_B (
158: EXTENSION_ID,
159: LOCATION_ID,
160: COUNTRY,
161: ATTR_GROUP_ID,

Line 715: from RRS_LOCATIONS_EXT_B

711: C_EXT_ATTR9,
712: C_EXT_ATTR10,
713: C_EXT_ATTR11,
714: C_EXT_ATTR12
715: from RRS_LOCATIONS_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_LOCATIONS_EXT_B set

1197: X_LAST_UPDATED_BY in NUMBER,
1198: X_LAST_UPDATE_LOGIN in NUMBER
1199: ) is
1200: begin
1201: update RRS_LOCATIONS_EXT_B set
1202: C_EXT_ATTR13 = X_C_EXT_ATTR13,
1203: C_EXT_ATTR14 = X_C_EXT_ATTR14,
1204: C_EXT_ATTR15 = X_C_EXT_ATTR15,
1205: C_EXT_ATTR16 = X_C_EXT_ATTR16,

Line 1369: delete from RRS_LOCATIONS_EXT_B

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

Line 1383: from RRS_LOCATIONS_EXT_B B

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