APPS.CS_KB_VISIBILITIES_PKG dependencies on CS_KB_VISIBILITIES_B

Line 33: cursor C is select ROWID from CS_KB_VISIBILITIES_B

29: X_ATTRIBUTE13 in VARCHAR2,
30: X_ATTRIBUTE14 in VARCHAR2,
31: X_ATTRIBUTE15 in VARCHAR2
32: ) is
33: cursor C is select ROWID from CS_KB_VISIBILITIES_B
34: where VISIBILITY_ID = X_VISIBILITY_ID
35: ;
36: begin
37: insert into CS_KB_VISIBILITIES_B (

Line 37: insert into CS_KB_VISIBILITIES_B (

33: cursor C is select ROWID from CS_KB_VISIBILITIES_B
34: where VISIBILITY_ID = X_VISIBILITY_ID
35: ;
36: begin
37: insert into CS_KB_VISIBILITIES_B (
38: VISIBILITY_ID,
39: POSITION,
40: START_DATE_ACTIVE,
41: END_DATE_ACTIVE,

Line 175: from CS_KB_VISIBILITIES_B

171: ATTRIBUTE12,
172: ATTRIBUTE13,
173: ATTRIBUTE14,
174: ATTRIBUTE15
175: from CS_KB_VISIBILITIES_B
176: where VISIBILITY_ID = X_VISIBILITY_ID
177: for update of VISIBILITY_ID nowait;
178: recinfo c%rowtype;
179:

Line 285: update CS_KB_VISIBILITIES_B set

281: X_ATTRIBUTE14 in VARCHAR2,
282: X_ATTRIBUTE15 in VARCHAR2
283: ) is
284: begin
285: update CS_KB_VISIBILITIES_B set
286: POSITION = X_POSITION,
287: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
288: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
289: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 340: delete from CS_KB_VISIBILITIES_B

336: if (sql%notfound) then
337: raise no_data_found;
338: end if;
339:
340: delete from CS_KB_VISIBILITIES_B
341: where VISIBILITY_ID = X_VISIBILITY_ID;
342:
343: if (sql%notfound) then
344: raise no_data_found;

Line 354: from CS_KB_VISIBILITIES_B B

350: begin
351: delete from CS_KB_VISIBILITIES_TL T
352: where not exists
353: (select NULL
354: from CS_KB_VISIBILITIES_B B
355: where B.VISIBILITY_ID = T.VISIBILITY_ID
356: );
357:
358: update CS_KB_VISIBILITIES_TL T set (