APPS.CCT_MIDDLEWARE_PARAM_PKG SQL Statements

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

Line: 69

   SELECT 1
   FROM CCT_MIDDLEWARE_PARAMS
   WHERE NAME= P_NAME
   and TYPE = P_TYPE
   and LENGTH = P_LENGTH
   and MIDDLEWARE_TYPE_ID = P_MIDDLEWARE_TYPE_ID
   and DOMAIN_LOOKUP_TYPE =P_DOMAIN_LOOKUP_TYPE
   and ORDERING_SEQUENCE = P_ORDERING_SEQUENCE;

Line: 80

   SELECT MIDDLEWARE_PARAM_ID
   FROM CCT_MIDDLEWARE_PARAMS
   WHERE NAME= P_NAME
   and MIDDLEWARE_TYPE_ID = P_MIDDLEWARE_TYPE_ID;

Line: 99

         INSERT INTO CCT_MIDDLEWARE_PARAMS
           (MIDDLEWARE_PARAM_ID, MIDDLEWARE_TYPE_ID, NAME, TYPE, LENGTH,ORDERING_SEQUENCE,DOMAIN_LOOKUP_TYPE,
            LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)
         select CCT_MIDDLEWARE_PARAMS_S.NEXTVAL+1000, P_MIDDLEWARE_TYPE_ID, P_NAME, P_TYPE, P_LENGTH,P_ORDERING_SEQUENCE,P_DOMAIN_LOOKUP_TYPE,sysdate, 1, sysdate, 1
         from dual where not exists (SELECT 1 FROM CCT_MIDDLEWARE_PARAMS WHERE NAME=P_NAME and MIDDLEWARE_TYPE_ID = P_MIDDLEWARE_TYPE_ID);

Line: 108

         dbms_output.put_line('Inside seed - Upgrade needed - Need to Update, l_param_id='||l_param_id);

Line: 109

         update CCT_MIDDLEWARE_PARAMS
         set MIDDLEWARE_TYPE_ID =P_MIDDLEWARE_TYPE_ID,
             NAME = P_NAME,
             TYPE = P_TYPE,
             LENGTH = P_LENGTH,
             ORDERING_SEQUENCE= P_ORDERING_SEQUENCE,
             DOMAIN_LOOKUP_TYPE= P_DOMAIN_LOOKUP_TYPE,
             LAST_UPDATE_DATE = sysdate,
             LAST_UPDATED_BY = 1,
             LAST_UPDATE_LOGIN =1
         where middleware_param_id = l_param_id;