APPS.AMS_PROD_TEMP_RESP_PKG SQL Statements

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

Line: 21

  select object_version_number
  from    AMS_TEMPL_RESPONSIBILITY
  where  TEMPL_RESPONSIBILITY_ID =  X_TEMPL_RESPONSIBILITY_ID;

Line: 26

  select 'x'
  from   AMS_TEMPL_RESPONSIBILITY
  where  TEMPL_RESPONSIBILITY_ID =  X_TEMPL_RESPONSIBILITY_ID;

Line: 31

   select AMS_TEMPL_RESPONSIBILITY_S.nextval
   from dual;

Line: 35

  select last_updated_by, nvl(object_version_number,1)
  from    AMS_TEMPL_RESPONSIBILITY
  where  TEMPL_RESPONSIBILITY_ID =  X_TEMPL_RESPONSIBILITY_ID;

Line: 67

    INSERT INTO AMS_TEMPL_RESPONSIBILITY(
           TEMPL_RESPONSIBILITY_ID,
           template_id,
           RESPONSIBILITY_ID,
           last_update_date,
           last_updated_by,
           creation_date,
           created_by,
           object_version_number,
           last_update_login
     ) VALUES (
            L_TEMPL_RESPONSIBILITY_ID
            ,x_template_id
	    ,x_RESPONSIBILITY_ID
           ,SYSDATE
           ,l_user_id
           ,SYSDATE
           ,l_user_id
           ,1
           ,0);

Line: 96

         Update AMS_TEMPL_RESPONSIBILITY
         SET  last_update_date = sysdate,
           last_updated_by = l_user_id,
           object_version_number = l_obj_verno +1,
           last_update_login = 0,
	   template_id = x_template_id,
           RESPONSIBILITY_ID = x_RESPONSIBILITY_ID
        WHERE TEMPL_RESPONSIBILITY_ID =  X_TEMPL_RESPONSIBILITY_ID
        AND   object_version_number = l_obj_verno;