APPS.PN_AM_WF SQL Statements

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

Line: 32

         SELECT pn_wf_item_s.NEXTVAL
           FROM DUAL;

Line: 75

      l_parameter_list.DELETE;

Line: 182

                                       aname         => 'API_INSERTION',
                                       avalue        => l_approver_rec.api_insertion
                                      );

Line: 258

   PROCEDURE update_status (
      itemtype    IN              VARCHAR2,
      itemkey     IN              VARCHAR2,
      actid       IN              NUMBER,
      funcmode    IN              VARCHAR2,
      resultout   OUT NOCOPY      VARCHAR2
   )
   IS
      l_result                   VARCHAR2 (20);

Line: 271

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

Line: 291

         SELECT plda.lease_commencement_date, pla.lease_status
           INTO l_commencement_date, l_lease_status
           FROM pn_leases_all pla, pn_lease_details_all plda
          WHERE pla.lease_id = plda.lease_id
            AND pla.lease_id = l_transaction_id
            AND pla.org_id = plda.org_id;

Line: 300

            UPDATE pn_leases_all
               SET status = 'F'
             WHERE lease_id = l_transaction_id;

Line: 326

            UPDATE pn_leases_all
               SET status = 'D'
             WHERE lease_id = l_transaction_id;

Line: 332

         UPDATE ame_temp_old_approver_lists
            SET approval_status = NULL
          WHERE transaction_id = l_transaction_id;

Line: 367

                          'UPDATE_STATUS',
                          itemtype,
                          itemkey,
                          actid,
                          funcmode
                         );

Line: 374

   END update_status;

Line: 404

         SELECT pn_wf_item_s.NEXTVAL
           FROM DUAL;

Line: 409

         SELECT application_id
           FROM fnd_application
          WHERE application_short_name = 'PN';

Line: 415

      SELECT transaction_type_id
        INTO l_trx_type
        FROM ame_calling_apps
       WHERE application_name = 'PN approval workflow';

Line: 420

      SELECT f.user_name, pla.lease_num, plda.lease_commencement_date,
             plda.lease_termination_date
        INTO l_requester, l_lease_number, l_commencement_date,
             l_termination_date
        FROM pn_leases_all pla, pn_lease_details_all plda, fnd_user f
       WHERE pla.lease_id = plda.lease_id
         AND pla.lease_id = p_lease_id
         AND pla.last_updated_by = f.user_id
         AND pla.org_id = plda.org_id;

Line: 596

         l_approver_rec.api_insertion :=
            wf_engine.getitemattrtext (itemtype      => itemtype,
                                       itemkey       => itemkey,
                                       aname         => 'API_INSERTION'
                                      );

Line: 606

         ame_api.updateapprovalstatus (applicationidin        => l_app_id,
                                       transactionidin        => l_transaction_id,
                                       approverin             => l_approver_rec,
                                       transactiontypein      => l_trx_type
                                      );

Line: 740

         SELECT NAME, display_name
           FROM wf_roles
          WHERE orig_system_id = c_emp_id AND orig_system = c_system;

Line: 746

         SELECT user_name, description, employee_id
           FROM fnd_user
          WHERE user_id = c_user_id;

Line: 861

         SELECT COUNT (*)
           FROM ame_calling_apps
          WHERE transaction_type_id = c_trx_type;