eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSK_SETUP_UTILITY_PKG dependencies on CS_KB_CAT_GROUP_DENORM

Line 269: UPDATE CS_KB_CAT_GROUP_DENORM SET VISIBILITY_POSITION = l_max+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:
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;

Line 275: UPDATE CS_KB_CAT_GROUP_DENORM SET VISIBILITY_POSITION = l_max+2

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

Line 281: UPDATE CS_KB_CAT_GROUP_DENORM SET VISIBILITY_POSITION = l_max+3

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

Line 287: UPDATE CS_KB_CAT_GROUP_DENORM SET VISIBILITY_POSITION = l_max+4

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:
290: -------------------------------------------------------------
291: -- Create Seeded Flow

Line 443: UPDATE CS_KB_CAT_GROUP_DENORM

439: OPEN Get_Posn;
440: FETCH Get_Posn INTO l_posn;
441: CLOSE Get_Posn;
442:
443: UPDATE CS_KB_CAT_GROUP_DENORM
444: SET VISIBILITY_ID = P_VISIBILITY_ID,
445: VISIBILITY_POSITION = l_posn
446: WHERE CHILD_CATEGORY_ID = P_CATEGORY_ID;
447:

Line 508: DELETE FROM CS_KB_CAT_GROUP_DENORM

504: -- Removes Category from Members table if the Category Exists
505: DELETE FROM CS_KB_CAT_GROUP_MEMBERS
506: WHERE Category_Id = P_CATEGORY_ID;
507: -- Removes Category from Denorm table if the Category Exists
508: DELETE FROM CS_KB_CAT_GROUP_DENORM
509: WHERE Child_Category_Id = P_CATEGORY_ID;
510:
511: if fnd_api.to_boolean( p_commit ) then
512: commit;