APPS.PN_LEASE_DETAILS_SEND_UPD SQL Statements

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

Line: 11

PROCEDURE update_lease_se (
   errbuf            OUT NOCOPY     VARCHAR2,
   retcode           OUT NOCOPY     VARCHAR2,
   p_lease_class     IN      VARCHAR2,
   p_lease_num_from  IN      VARCHAR2,
   p_lease_num_to    IN      VARCHAR2)
IS
   v_getleaseid                   pn_leases.lease_id%TYPE;

Line: 23

   l_lastupdatedate               DATE   :=SYSDATE;

Line: 24

   l_lastupdatedby                NUMBER :=fnd_global.user_id;

Line: 25

   l_lastupdatelogin              NUMBER :=fnd_global.login_id;

Line: 28

      SELECT l.lease_id                        lleaseid,
             l.lease_class_code,
             l.name,
             l.lease_num,
             d.lease_detail_id,
             d.lease_change_id,
             d.lease_id,
             d.responsible_user                dresponsibleeuserid,
             d.expense_account_id,
             d.lease_commencement_date,
             d.lease_termination_date,
             d.lease_execution_date,
             d.last_update_date,
             d.last_updated_by,
             d.creation_date,
             d.created_by,
             d.last_update_login,
             d.attribute_category,
             d.attribute1,
             d.attribute2,
             d.attribute3,
             d.attribute4,
             d.attribute5,
             d.attribute6,
             d.attribute7,
             d.attribute8,
             d.attribute9,
             d.attribute10,
             d.attribute11,
             d.attribute12,
             d.attribute13,
             d.attribute14,
             d.attribute15,
             d.accrual_account_id,
             d.receivable_account_id,
             d.term_template_id
      FROM   pn_leases l, pn_lease_details_all d
      WHERE  l.lease_id = d.lease_id
      AND    lease_num BETWEEN NVL(p_lease_num_from,lease_num) AND
                               NVL(p_lease_num_to,lease_num)
      AND    lease_class_code = NVL(p_lease_class,lease_class_code)
      AND    l.status        = 'F'
      AND    d.send_entries  = 'Y';

Line: 72

   pnp_debug_pkg.debug('PN_LEASE_DETAILS_SEND_UPD.UPDATE_LEASE_SE (+)');

Line: 82

      pn_lease_details_pkg.update_row
      (
        x_lease_detail_id          => v_lease.lease_detail_id
       ,x_lease_change_id          => 0
       ,x_lease_id                 => v_lease.lease_id
       ,x_responsible_user         => v_lease.dresponsibleeuserid
       ,x_expense_account_id       => v_lease.expense_account_id
       ,x_lease_commencement_date  => v_lease.lease_commencement_date
       ,x_lease_termination_date   => v_lease.lease_termination_date
       ,x_lease_execution_date     => v_lease.lease_execution_date
       ,x_last_update_date         => l_lastUpdateDate
       ,x_last_updated_by          => l_lastupdatedby
       ,x_last_update_login        => l_lastupdatelogin
       ,x_accrual_account_id       => v_lease.accrual_account_id
       ,x_receivable_account_id    => v_lease.receivable_account_id
       ,x_attribute_category       => v_lease.attribute_category
       ,x_attribute1               => v_lease.attribute1
       ,x_attribute2               => v_lease.attribute2
       ,x_attribute3               => v_lease.attribute3
       ,x_attribute4               => v_lease.attribute4
       ,x_attribute5               => v_lease.attribute5
       ,x_attribute6               => v_lease.attribute6
       ,x_attribute7               => v_lease.attribute7
       ,x_attribute8               => v_lease.attribute8
       ,x_attribute9               => v_lease.attribute9
       ,x_attribute10              => v_lease.attribute10
       ,x_attribute11              => v_lease.attribute11
       ,x_attribute12              => v_lease.attribute12
       ,x_attribute13              => v_lease.attribute13
       ,x_attribute14              => v_lease.attribute14
       ,x_attribute15              => v_lease.attribute15
       ,x_term_template_id         => v_lease.term_template_id
      );

Line: 141

   pnp_debug_pkg.debug('PN_LEASE_DETAILS_SEND_UPD.update_lease_se (-)');

Line: 147

END update_lease_se;