APPS.RRS_TRADE_AREA_GROUPS_PKG dependencies on RRS_TRADE_AREA_GROUPS_B

Line 23: cursor C is select ROWID from RRS_TRADE_AREA_GROUPS_B

19: ) is
20:
21: L_GROUP_ID NUMBER;
22:
23: cursor C is select ROWID from RRS_TRADE_AREA_GROUPS_B
24: where GROUP_ID = L_GROUP_ID;
25:
26: begin
27:

Line 32: insert into RRS_TRADE_AREA_GROUPS_B (

28: select nvl(X_GROUP_ID ,RRS_TRADE_AREA_GROUPS_S.nextval)
29: into L_GROUP_ID
30: from dual;
31:
32: insert into RRS_TRADE_AREA_GROUPS_B (
33: GROUP_ID,
34: GROUP_TYPE_CODE,
35: NUM_OF_TRADE_AREAS,
36: STATUS_CODE,

Line 114: from RRS_TRADE_AREA_GROUPS_B

110: NUM_OF_TRADE_AREAS,
111: STATUS_CODE,
112: UNIT_OF_MEASURE_CODE,
113: OBJECT_VERSION_NUMBER
114: from RRS_TRADE_AREA_GROUPS_B
115: where GROUP_ID = X_GROUP_ID
116: for update of GROUP_ID nowait;
117: recinfo c%rowtype;
118:

Line 179: update RRS_TRADE_AREA_GROUPS_B set

175: X_LAST_UPDATED_BY in NUMBER,
176: X_LAST_UPDATE_LOGIN in NUMBER
177: ) is
178: begin
179: update RRS_TRADE_AREA_GROUPS_B set
180: GROUP_TYPE_CODE = X_GROUP_TYPE_CODE,
181: NUM_OF_TRADE_AREAS = X_NUM_OF_TRADE_AREAS,
182: STATUS_CODE = X_STATUS_CODE,
183: UNIT_OF_MEASURE_CODE = X_UNIT_OF_MEASURE_CODE,

Line 220: delete from RRS_TRADE_AREA_GROUPS_B

216: if (sql%notfound) then
217: raise no_data_found;
218: end if;
219:
220: delete from RRS_TRADE_AREA_GROUPS_B
221: where GROUP_ID = X_GROUP_ID;
222:
223: if (sql%notfound) then
224: raise no_data_found;

Line 234: from RRS_TRADE_AREA_GROUPS_B B

230: begin
231: delete from RRS_TRADE_AREA_GROUPS_TL T
232: where not exists
233: (select NULL
234: from RRS_TRADE_AREA_GROUPS_B B
235: where B.GROUP_ID = T.GROUP_ID
236: );
237:
238: update RRS_TRADE_AREA_GROUPS_TL T set (