APPS.RRS_TRADE_AREAS_EXT_PKG dependencies on RRS_TRADE_AREAS_EXT_B

Line 157: insert into RRS_TRADE_AREAS_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_TRADE_AREAS_EXT_B (
158: EXTENSION_ID,
159: TRADE_AREA_ID,
160: GROUP_ID,
161: ATTR_GROUP_ID,

Line 715: from RRS_TRADE_AREAS_EXT_B

711: UOM_EXT_ATTR10,
712: UOM_EXT_ATTR11,
713: UOM_EXT_ATTR12,
714: UOM_EXT_ATTR13
715: from RRS_TRADE_AREAS_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_TRADE_AREAS_EXT_B set

1197: X_LAST_UPDATED_BY in NUMBER,
1198: X_LAST_UPDATE_LOGIN in NUMBER
1199: ) is
1200: begin
1201: update RRS_TRADE_AREAS_EXT_B set
1202: UOM_EXT_ATTR14 = X_UOM_EXT_ATTR14,
1203: UOM_EXT_ATTR15 = X_UOM_EXT_ATTR15,
1204: UOM_EXT_ATTR16 = X_UOM_EXT_ATTR16,
1205: UOM_EXT_ATTR17 = X_UOM_EXT_ATTR17,

Line 1369: delete from RRS_TRADE_AREAS_EXT_B

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

Line 1383: from RRS_TRADE_AREAS_EXT_B B

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