APPS.CSK_SETUP_UTILITY_PKG dependencies on CS_KB_VISIBILITIES_B

Line 159: insert into CS_KB_VISIBILITIES_B (

155: --Create visibility
156: PROCEDURE Create_Visibility (P_ID NUMBER, P_NAME VARCHAR2, P_POSN NUMBER)
157: IS
158: BEGIN
159: insert into CS_KB_VISIBILITIES_B (
160: VISIBILITY_ID,
161: POSITION,
162: CREATION_DATE,
163: CREATED_BY,

Line 263: FROM CS_KB_VISIBILITIES_B

259: -------------------------------------------------------------
260: -- Create Seeded Visibilities
261: -------------------------------------------------------------
262: SELECT MAX(Position) INTO l_max
263: FROM CS_KB_VISIBILITIES_B
264: WHERE Visibility_id > 1;
265:
266: DELETE FROM CS_KB_VISIBILITIES_B WHERE Visibility_ID = VISIBILITY_RESTRICTED_API_TEST;
267: DELETE FROM CS_KB_VISIBILITIES_TL WHERE Visibility_ID = VISIBILITY_RESTRICTED_API_TEST;

Line 266: DELETE FROM CS_KB_VISIBILITIES_B WHERE Visibility_ID = VISIBILITY_RESTRICTED_API_TEST;

262: SELECT MAX(Position) INTO l_max
263: FROM CS_KB_VISIBILITIES_B
264: WHERE Visibility_id > 1;
265:
266: DELETE FROM CS_KB_VISIBILITIES_B WHERE Visibility_ID = VISIBILITY_RESTRICTED_API_TEST;
267: DELETE FROM CS_KB_VISIBILITIES_TL WHERE Visibility_ID = VISIBILITY_RESTRICTED_API_TEST;
268: Create_Visibility(P_ID => VISIBILITY_RESTRICTED_API_TEST, P_NAME => 'Restricted_API_TEST', P_POSN => l_max+1);
269: UPDATE CS_KB_CAT_GROUP_DENORM SET VISIBILITY_POSITION = l_max+1
270: WHERE VISIBILITY_ID = VISIBILITY_RESTRICTED_API_TEST;

Line 272: DELETE FROM CS_KB_VISIBILITIES_B WHERE Visibility_ID = VISIBILITY_INTERNAL_API_TEST;

268: Create_Visibility(P_ID => VISIBILITY_RESTRICTED_API_TEST, P_NAME => 'Restricted_API_TEST', P_POSN => l_max+1);
269: UPDATE CS_KB_CAT_GROUP_DENORM SET VISIBILITY_POSITION = l_max+1
270: WHERE VISIBILITY_ID = VISIBILITY_RESTRICTED_API_TEST;
271:
272: DELETE FROM CS_KB_VISIBILITIES_B WHERE Visibility_ID = VISIBILITY_INTERNAL_API_TEST;
273: DELETE FROM CS_KB_VISIBILITIES_TL WHERE Visibility_ID = VISIBILITY_INTERNAL_API_TEST;
274: Create_Visibility(P_ID => VISIBILITY_INTERNAL_API_TEST, P_NAME => 'Internal_API_TEST', P_POSN => l_max+2);
275: UPDATE CS_KB_CAT_GROUP_DENORM SET VISIBILITY_POSITION = l_max+2
276: WHERE VISIBILITY_ID = VISIBILITY_INTERNAL_API_TEST;

Line 278: DELETE FROM CS_KB_VISIBILITIES_B WHERE Visibility_ID = VISIBILITY_LIMITED_API_TEST;

274: Create_Visibility(P_ID => VISIBILITY_INTERNAL_API_TEST, P_NAME => 'Internal_API_TEST', P_POSN => l_max+2);
275: UPDATE CS_KB_CAT_GROUP_DENORM SET VISIBILITY_POSITION = l_max+2
276: WHERE VISIBILITY_ID = VISIBILITY_INTERNAL_API_TEST;
277:
278: DELETE FROM CS_KB_VISIBILITIES_B WHERE Visibility_ID = VISIBILITY_LIMITED_API_TEST;
279: DELETE FROM CS_KB_VISIBILITIES_TL WHERE Visibility_ID = VISIBILITY_LIMITED_API_TEST;
280: Create_Visibility(P_ID => VISIBILITY_LIMITED_API_TEST, P_NAME => 'Limited_API_TEST', P_POSN => l_max+3);
281: UPDATE CS_KB_CAT_GROUP_DENORM SET VISIBILITY_POSITION = l_max+3
282: WHERE VISIBILITY_ID = VISIBILITY_LIMITED_API_TEST;

Line 284: DELETE FROM CS_KB_VISIBILITIES_B WHERE Visibility_ID = VISIBILITY_EXTERNAL_API_TEST;

280: Create_Visibility(P_ID => VISIBILITY_LIMITED_API_TEST, P_NAME => 'Limited_API_TEST', P_POSN => l_max+3);
281: UPDATE CS_KB_CAT_GROUP_DENORM SET VISIBILITY_POSITION = l_max+3
282: WHERE VISIBILITY_ID = VISIBILITY_LIMITED_API_TEST;
283:
284: DELETE FROM CS_KB_VISIBILITIES_B WHERE Visibility_ID = VISIBILITY_EXTERNAL_API_TEST;
285: DELETE FROM CS_KB_VISIBILITIES_TL WHERE Visibility_ID = VISIBILITY_EXTERNAL_API_TEST;
286: Create_Visibility(P_ID => VISIBILITY_EXTERNAL_API_TEST, P_NAME => 'External_API_TEST', P_POSN => l_max+4);
287: UPDATE CS_KB_CAT_GROUP_DENORM SET VISIBILITY_POSITION = l_max+4
288: WHERE VISIBILITY_ID = VISIBILITY_EXTERNAL_API_TEST;

Line 376: FROM CS_KB_VISIBILITIES_B

372: IS
373:
374: CURSOR Get_Posn IS
375: SELECT Position
376: FROM CS_KB_VISIBILITIES_B
377: WHERE VISIBILITY_ID = P_VISIBILITY_ID;
378: l_posn NUMBER;
379:
380: BEGIN