APPS.AMW_CTRL_APPROVAL_PVT SQL Statements

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

Line: 74

         SELECT Control_id, name, creation_date,
                requestor_id
           FROM amw_Controls_all_vl
          WHERE control_rev_id = p_CTRL_rev_id;

Line: 255

         SELECT control_id, name, creation_date,
                requestor_id  -- --s hould be a name
           FROM amw_controls_all_vl
          WHERE control_rev_id = p_CTRL_rev_id;

Line: 347

      SELECT SYSDATE
      INTO l_approval_date
      FROM DUAL;

Line: 443

         SELECT control_id, name, creation_date, requestor_id
           FROM amw_controls_all_vl
          WHERE Control_rev_id = p_CTRL_rev_id;

Line: 630

         SELECT control_id, name, creation_date,
                requestor_id -- needs to be the name
           FROM amw_controls_all_vl
          WHERE control_rev_id = p_CTRL_rev_id;

Line: 818

         SELECT control_id, name, creation_date
                requestor_id -- needs to be the name
           FROM amw_controls_all_vl
          WHERE control_rev_id = p_CTRL_rev_id;

Line: 1021

         SELECT control_id, name, creation_date
           FROM amw_controls_all_vl
          WHERE control_rev_id = p_CTRL_rev_id;

Line: 1222

   PROCEDURE update_CTRL_status (
      itemtype    IN       VARCHAR2,
      itemkey     IN       VARCHAR2,
      actid       IN       NUMBER,
      funcmode    IN       VARCHAR2,
      resultout   OUT NOCOPY      VARCHAR2
   ) IS
      l_status_code             VARCHAR2 (30);

Line: 1233

      l_api_name       CONSTANT VARCHAR2 (30)               := 'Update_CTRL_Status';

Line: 1237

      l_update_status           VARCHAR2 (12);

Line: 1248

     SELECT CTRL2.Control_REV_ID
     FROM amw_controls_b CTRL1 , amw_controls_b CTRL2
     WHERE CTRL1.Control_id = CTRL2.control_id
     AND CTRL1.control_rev_id = p_CTRL_rev_id
     AND CTRL2.curr_approved_flag= 'Y' and CTRL2.latest_revision_flag = 'N' ;

Line: 1258

      SAVEPOINT update_CTRL_status ;

Line: 1262

         l_update_status            :=
               wf_engine.getitemattrtext (
                  itemtype=> itemtype,
                  itemkey=> itemkey,
                  aname => 'UPDATE_GEN_STATUS'
               );

Line: 1304

         IF ( l_update_status = 'APPROVED' )    THEN
           -- Update the status of the CTRL object to 'A' -- Approved
             update amw_controls_b
             set
             approval_status          = 'A',
             object_version_number  = object_version_number+1,
             curr_approved_flag   = 'Y',
             latest_revision_flag ='Y'          ,
             approval_date = SYSDATE
             where   control_rev_id            = l_CTRL_rev_id
             and   object_version_number   = l_object_version_number;

Line: 1319

               update amw_controls_b
               set
               object_version_number  = object_version_number+1,
               curr_approved_flag   = 'N',
               latest_revision_flag ='N'          ,
               end_date = SYSDATE
               where   control_rev_id            = l_old_appr_CTRL_rev_id;

Line: 1328

           ELSIF ( l_update_status = 'REJECTED' )   THEN
               -- Update the status of the CTRL object to 'R' -- Rejected
            IF l_old_appr_CTRL_rev_id IS NOT NULL THEN
               UPDATE amw_controls_b
                  SET object_version_number = object_version_number + 1,
                      latest_revision_flag = 'Y'
                WHERE control_rev_id = l_old_appr_CTRL_rev_id;

Line: 1336

               UPDATE amw_controls_b
                  SET approval_status = 'R',
                      object_version_number = object_version_number + 1,
                      curr_approved_flag = 'N',
                      latest_revision_flag = 'N',
                      end_date = SYSDATE
                WHERE control_rev_id = l_CTRL_rev_id
                  AND object_version_number = l_object_version_number;

Line: 1345

               UPDATE amw_controls_b
                  SET approval_status = 'R',
                      object_version_number = object_version_number + 1,
                      curr_approved_flag = 'N',
                      latest_revision_flag = 'Y',
                      end_date = SYSDATE
                WHERE control_rev_id = l_CTRL_rev_id
                  AND object_version_number = l_object_version_number;

Line: 1356

               update amw_controls_b
               set
               approval_status          = 'R',
               object_version_number  = object_version_number+1,
               curr_approved_flag   = 'N',
               latest_revision_flag ='N'          ,
               end_date = SYSDATE
               where   control_rev_id            = l_CTRL_rev_id
               and   object_version_number   = l_object_version_number ;

Line: 1367

             update amw_controls_b
             set
             object_version_number  = object_version_number+1,
             latest_revision_flag ='Y'
             where   control_rev_id    = l_old_appr_CTRL_rev_id;

Line: 1377

          update amw_controls_b
          set
          approval_status          = 'D',
          object_version_number  = object_version_number+1
          --curr_approved_flag   = 'N',
          --latest_revision_flag ='Y'
          where   control_rev_id            = l_CTRL_rev_id
          and   object_version_number   = l_object_version_number ;

Line: 1393

               amw_utility_pvt.debug_message(l_full_name || ' failed to update CTRL to status ' || l_status_code);

Line: 1447

      ROLLBACK TO update_CTRL_status ;

Line: 1463

   END update_CTRL_status;