APPS.CS_KB_SETS_AUDIT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

 |              1. Add logic in create_set and update_set to validate   |
 |                 solution_type.                                       |
 |  24-Jan-2003 MKETTLE   added Submit_Solution and Update_Solution     |
 |  17-Mar-2003 MKETTLE  Performance fix on Is_Status_Valid Bug 2852868 |
 |  18-Jul-2003 MKETTLE  Added new 11.5.10 Secuirty columns             |
 |  12-Aug-2003 MKETTLE  Added Get_User_Soln_Access                     |
 |  13-Aug-2003 MKETTLE  Added CheckOut_Solution                        |
 |  28-Aug-2003 MKETTLE   11.5.10 Code Cleanup -> Private Solution apis |
 |                        moved to CS_KB_SOLUTION_PVT. Table Handlers   |
 |                        moved to CS_KB_SETS_PKG                       |
 +======================================================================*/


 FUNCTION Get_Published_Set_Id(
   P_SET_NUMBER IN VARCHAR2 )
 RETURN NUMBER
 IS
   l_count NUMBER;

Line: 32

  SELECT MAX(set_id)
  INTO l_published_set_id
  FROM CS_KB_SETS_B
  WHERE set_number = p_set_number
  AND status = 'PUB';