APPS.AMW_RISK_APPROVAL_PVT SQL Statements

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

Line: 68

         SELECT risk_id, NAME, creation_date, requestor_id
           FROM amw_risks_all_vl
          WHERE risk_rev_id = p_risk_rev_id;

Line: 235

         SELECT risk_id, NAME, creation_date,
                requestor_id                             -- --s hould be a name
           FROM amw_risks_all_vl
          WHERE risk_rev_id = p_risk_rev_id;

Line: 312

      SELECT SYSDATE
        INTO l_approval_date
        FROM DUAL;

Line: 402

         SELECT risk_id, NAME, creation_date, requestor_id
           FROM amw_risks_all_vl
          WHERE risk_rev_id = p_risk_rev_id;

Line: 567

         SELECT risk_id, NAME, creation_date,
                requestor_id                            -- needs to be the name
           FROM amw_risks_all_vl
          WHERE risk_rev_id = p_risk_rev_id;

Line: 746

         SELECT risk_id, NAME,
                creation_date requestor_id              -- needs to be the name
           FROM amw_risks_all_vl
          WHERE risk_rev_id = p_risk_rev_id;

Line: 936

         SELECT risk_id, NAME, creation_date
           FROM amw_risks_all_vl
          WHERE risk_rev_id = p_risk_rev_id;

Line: 1085

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

Line: 1096

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

Line: 1099

      l_update_status           VARCHAR2 (12);

Line: 1109

         SELECT risk2.risk_rev_id
           FROM amw_risks_b risk1, amw_risks_b risk2
          WHERE risk1.risk_id = risk2.risk_id
            AND risk1.risk_rev_id = p_risk_rev_id
            AND risk2.curr_approved_flag = 'Y'
            AND risk2.latest_revision_flag = 'N';

Line: 1116

      SAVEPOINT update_risk_status;

Line: 1120

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

Line: 1154

         IF (l_update_status = 'APPROVED') THEN
            -- Update the status of the Risk object to 'A' -- Approved
            UPDATE amw_risks_b
               SET approval_status = 'A',
                   object_version_number = object_version_number + 1,
                   curr_approved_flag = 'Y',
                   latest_revision_flag = 'Y',
                   approval_date = SYSDATE
             WHERE risk_rev_id = l_risk_rev_id
               AND object_version_number = l_object_version_number;

Line: 1165

               UPDATE amw_risks_b
                  SET object_version_number = object_version_number + 1,
                      curr_approved_flag = 'N',
                      latest_revision_flag = 'N',
                      end_date = SYSDATE
                WHERE risk_rev_id = l_old_appr_risk_rev_id;

Line: 1172

         ELSIF (l_update_status = 'REJECTED') THEN

                     -- Update the status of the CTRL object to 'R' -- Rejected
            IF l_old_appr_risk_rev_id IS NOT NULL THEN
               UPDATE amw_risks_b
                  SET object_version_number = object_version_number + 1,
                      latest_revision_flag = 'Y'
                WHERE risk_rev_id = l_old_appr_risk_rev_id;

Line: 1180

               UPDATE amw_risks_b
                  SET approval_status = 'R',
                      object_version_number = object_version_number + 1,
                      curr_approved_flag = 'N',
                      latest_revision_flag = 'N',
                      end_date = SYSDATE
                WHERE risk_rev_id = l_risk_rev_id
                  AND object_version_number = l_object_version_number;

Line: 1189

               UPDATE amw_risks_b
                  SET approval_status = 'R',
                      object_version_number = object_version_number + 1,
                      curr_approved_flag = 'N',
                      latest_revision_flag = 'Y',
                      end_date = SYSDATE
                WHERE risk_rev_id = l_risk_rev_id
                  AND object_version_number = l_object_version_number;

Line: 1200

            UPDATE amw_risks_b
               SET approval_status = 'D',
                   object_version_number = object_version_number + 1
             --curr_approved_flag   = 'N',
             --latest_revision_flag ='Y'
            WHERE  risk_rev_id = l_risk_rev_id
               AND object_version_number = l_object_version_number;

Line: 1213

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

Line: 1262

         ROLLBACK TO update_risk_status;

Line: 1278

   END update_risk_status;