APPS.IEB_SERVICE_LEVELS_PKG dependencies on IEB_SERVICE_LEVELS_B

Line 26: cursor C is select ROWID from IEB_SERVICE_LEVELS_B

22: X_LAST_UPDATE_DATE in DATE,
23: X_LAST_UPDATED_BY in NUMBER,
24: X_LAST_UPDATE_LOGIN in NUMBER
25: ) is
26: cursor C is select ROWID from IEB_SERVICE_LEVELS_B
27: where SERVICE_LEVEL_ID = X_SERVICE_LEVEL_ID;
28: begin
29: insert into IEB_SERVICE_LEVELS_B (
30: SERVICE_LEVEL_ID,

Line 29: insert into IEB_SERVICE_LEVELS_B (

25: ) is
26: cursor C is select ROWID from IEB_SERVICE_LEVELS_B
27: where SERVICE_LEVEL_ID = X_SERVICE_LEVEL_ID;
28: begin
29: insert into IEB_SERVICE_LEVELS_B (
30: SERVICE_LEVEL_ID,
31: DIRECTION,
32: MANDATORY_FLAG,
33: HOURLY_QUOTA,

Line 140: from IEB_SERVICE_LEVELS_B

136: REROUTE_TIME,
137: REROUTE_WARNING_TIME,
138: OBJECT_VERSION_NUMBER,
139: SECURITY_GROUP_ID
140: from IEB_SERVICE_LEVELS_B
141: where SERVICE_LEVEL_ID = X_SERVICE_LEVEL_ID
142: and SERVICE_LEVEL_ID = X_SERVICE_LEVEL_ID
143: for update of SERVICE_LEVEL_ID nowait;
144: recinfo c%rowtype;

Line 228: update IEB_SERVICE_LEVELS_B set

224: X_LAST_UPDATED_BY in NUMBER,
225: X_LAST_UPDATE_LOGIN in NUMBER
226: ) is
227: begin
228: update IEB_SERVICE_LEVELS_B set
229: DIRECTION = X_DIRECTION,
230: MANDATORY_FLAG = X_MANDATORY_FLAG,
231: HOURLY_QUOTA = X_HOURLY_QUOTA,
232: MIN_AGENTS = X_MIN_AGENTS,

Line 277: delete from IEB_SERVICE_LEVELS_B

273: if (sql%notfound) then
274: raise no_data_found;
275: end if;
276:
277: delete from IEB_SERVICE_LEVELS_B
278: where SERVICE_LEVEL_ID = X_SERVICE_LEVEL_ID;
279:
280: if (sql%notfound) then
281: raise no_data_found;

Line 433: from IEB_SERVICE_LEVELS_B B

429: begin
430: delete from IEB_SERVICE_LEVELS_TL T
431: where not exists
432: (select NULL
433: from IEB_SERVICE_LEVELS_B B
434: where B.SERVICE_LEVEL_ID = T.SERVICE_LEVEL_ID
435: and B.SERVICE_LEVEL_ID = T.SERVICE_LEVEL_ID
436: );
437: