DBA Data[Home] [Help]

APPS.CSK_SETUP_UTILITY_PKG dependencies on CS_KB_VISIBILITIES_TL

Line 176: insert into CS_KB_VISIBILITIES_TL (

172: sysdate,
173: -1351,
174: -1351 );
175:
176: insert into CS_KB_VISIBILITIES_TL (
177: VISIBILITY_ID,
178: NAME,
179: DESCRIPTION,
180: CREATION_DATE,

Line 202: from CS_KB_VISIBILITIES_TL T

198: from FND_LANGUAGES L
199: where L.INSTALLED_FLAG in ('I', 'B')
200: and not exists
201: (select NULL
202: from CS_KB_VISIBILITIES_TL T
203: where T.VISIBILITY_ID = P_ID
204: and T.LANGUAGE = L.LANGUAGE_CODE);
205: END Create_Visibility;
206:

Line 267: DELETE FROM CS_KB_VISIBILITIES_TL WHERE Visibility_ID = VISIBILITY_RESTRICTED_API_TEST;

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;
271:

Line 273: DELETE FROM CS_KB_VISIBILITIES_TL WHERE Visibility_ID = VISIBILITY_INTERNAL_API_TEST;

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;
277:

Line 279: DELETE FROM CS_KB_VISIBILITIES_TL WHERE Visibility_ID = VISIBILITY_LIMITED_API_TEST;

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;
283:

Line 285: DELETE FROM CS_KB_VISIBILITIES_TL WHERE Visibility_ID = VISIBILITY_EXTERNAL_API_TEST;

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;
289: