APPS.AD_MANUAL_STEP_OBJECT SQL Statements

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

Line: 14

      select count(0) into hist_count
         from ad_manual_step_history
         where step_key = p_step_key and
         step_version = p_step_version and
         status = p_status;

Line: 55

         select step_key
            into l_step_key
            from ad_manual_step_history
            where step_key = p_step_key and
            step_version = p_step_version;

Line: 61

         update ad_manual_step_history
            set status = p_status,
            patch_number = p_patch_number
            where step_key = p_step_key and
            step_version = p_step_version;

Line: 69

            insert into ad_manual_step_history
               (history_id, step_key, step_version,step_text, cond_code,
                patch_number, status, updated_by)
               values
               (ad_manual_step_history_s.nextval, p_step_key, p_step_version,
                p_step_text, p_cond_code, p_patch_number,
                p_status, p_username);

Line: 81

      procedure update_step_as_completed(p_patch_number varchar2) is
      begin
         update ad_manual_step_history
            set status = 'Y'
            where
            status='D' and patch_number=p_patch_number;