APPS.AMW_AP_APPROVAL_PVT SQL Statements

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

Line: 68

         SELECT audit_procedure_id, NAME, creation_date, requestor_id
           FROM amw_audit_procedures_vl
          WHERE audit_procedure_rev_id = p_ap_rev_id;

Line: 234

         SELECT audit_procedure_id, NAME, creation_date,
                requestor_id                             -- --s hould be a name
           FROM amw_audit_procedures_vl
          WHERE audit_procedure_rev_id = p_ap_rev_id;

Line: 311

      SELECT SYSDATE
        INTO l_approval_date
        FROM DUAL;

Line: 401

         SELECT audit_procedure_id, NAME, creation_date, requestor_id
           FROM amw_audit_procedures_vl
          WHERE audit_procedure_rev_id = p_ap_rev_id;

Line: 567

         SELECT audit_procedure_id, NAME, creation_date,
                requestor_id                            -- needs to be the name
           FROM amw_audit_procedures_vl
          WHERE audit_procedure_rev_id = p_ap_rev_id;

Line: 746

         SELECT audit_procedure_id, NAME,
                creation_date requestor_id              -- needs to be the name
           FROM amw_audit_procedures_vl
          WHERE audit_procedure_rev_id = p_ap_rev_id;

Line: 936

         SELECT audit_procedure_id, NAME, creation_date
           FROM amw_audit_procedures_vl
          WHERE audit_procedure_rev_id = p_ap_rev_id;

Line: 1085

   PROCEDURE update_ap_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_AP_Status';

Line: 1099

      l_update_status           VARCHAR2 (12);

Line: 1111

         SELECT ap2.audit_procedure_rev_id
           FROM amw_audit_procedures_b ap1, amw_audit_procedures_b ap2
          WHERE ap1.audit_procedure_id = ap2.audit_procedure_id
            AND ap1.audit_procedure_rev_id = p_ap_rev_id
            AND ap2.curr_approved_flag = 'Y'
            AND ap2.latest_revision_flag = 'N';

Line: 1118

      SAVEPOINT update_ap_status;

Line: 1124

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

Line: 1159

         IF (l_update_status = 'APPROVED') THEN
            -- Update the status of the AP object to 'A' -- Approved
            l_approval_date := SYSDATE;

Line: 1162

            UPDATE amw_audit_procedures_b
               SET approval_status = 'A',
                   object_version_number = object_version_number + 1,
                   curr_approved_flag = 'Y',
                   latest_revision_flag = 'Y',
                   approval_date = l_approval_date
             WHERE audit_procedure_rev_id = l_ap_rev_id
               AND object_version_number = l_object_version_number;

Line: 1171

               UPDATE amw_audit_procedures_b
                  SET object_version_number = object_version_number + 1,
                      curr_approved_flag = 'N',
                      latest_revision_flag = 'N',
                      end_date = l_approval_date
                WHERE audit_procedure_rev_id = l_old_appr_ap_rev_id;

Line: 1179

            select audit_procedure_id into l_ap_id
            from amw_audit_procedures_b
            where audit_procedure_rev_id = l_ap_rev_id;

Line: 1182

            update amw_ap_associations
                set approval_date = l_approval_date
                where audit_procedure_id = l_ap_id
                 and object_type = 'CTRL'
                 and approval_date is null;

Line: 1188

                update amw_ap_associations
                set deletion_approval_date = l_approval_date
                where audit_procedure_id = l_ap_id
                 and object_type = 'CTRL'
                 and deletion_date is not null
                 and deletion_approval_date is null;

Line: 1194

         ELSIF (l_update_status = 'REJECTED') THEN
            -- Update the status of the AP object to 'R' -- Rejected
             IF l_old_appr_ap_rev_id IS NOT NULL THEN
               UPDATE amw_audit_procedures_b
                  SET object_version_number = object_version_number + 1,
                      latest_revision_flag = 'Y'
                WHERE audit_procedure_rev_id = l_old_appr_ap_rev_id;

Line: 1201

               UPDATE amw_audit_procedures_b
                  SET approval_status = 'R',
                      object_version_number = object_version_number + 1,
                      curr_approved_flag = 'N',
                      latest_revision_flag = 'N',
                      end_date = SYSDATE
                WHERE audit_procedure_rev_id = l_ap_rev_id
                  AND object_version_number = l_object_version_number;

Line: 1210

               UPDATE amw_audit_procedures_b
                  SET approval_status = 'R',
                      object_version_number = object_version_number + 1,
                      curr_approved_flag = 'N',
                      latest_revision_flag = 'Y',
                      end_date = SYSDATE
                WHERE audit_procedure_rev_id = l_ap_rev_id
                  AND object_version_number = l_object_version_number;

Line: 1221

            UPDATE amw_audit_procedures_b
               SET approval_status = 'D',
                   object_version_number = object_version_number + 1
             --curr_approved_flag   = 'N',
             --latest_revision_flag ='Y'
            WHERE  audit_procedure_rev_id = l_ap_rev_id
               AND object_version_number = l_object_version_number;

Line: 1234

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

Line: 1283

         ROLLBACK TO update_ap_status;

Line: 1299

   END update_ap_status;