APPS.HZ_PAYMENT_METHOD_PUB SQL Statements

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

Line: 69

     p_create_update_flag        => 'C'
    ,p_payment_method_rec        => l_pm_rec
    ,x_return_status             => x_return_status );

Line: 79

  HZ_PAYMENT_METHOD_PKG.Insert_Row (
     x_cust_receipt_method_id    => l_pm_rec.cust_receipt_method_id,
     x_customer_id               => l_pm_rec.cust_account_id,
     x_receipt_method_id         => l_pm_rec.receipt_method_id,
     x_primary_flag              => l_pm_rec.primary_flag,
     x_site_use_id               => l_pm_rec.site_use_id,
     x_start_date                => l_pm_rec.start_date,
     x_end_date                  => l_pm_rec.end_date,
     x_attribute_category        => l_pm_rec.attribute_category,
     x_attribute1                => l_pm_rec.attribute1,
     x_attribute2                => l_pm_rec.attribute2,
     x_attribute3                => l_pm_rec.attribute3,
     x_attribute4                => l_pm_rec.attribute4,
     x_attribute5                => l_pm_rec.attribute5,
     x_attribute6                => l_pm_rec.attribute6,
     x_attribute7                => l_pm_rec.attribute7,
     x_attribute8                => l_pm_rec.attribute8,
     x_attribute9                => l_pm_rec.attribute9,
     x_attribute10               => l_pm_rec.attribute10,
     x_attribute11               => l_pm_rec.attribute11,
     x_attribute12               => l_pm_rec.attribute12,
     x_attribute13               => l_pm_rec.attribute13,
     x_attribute14               => l_pm_rec.attribute14,
     x_attribute15               => l_pm_rec.attribute15
  );

Line: 188

PROCEDURE update_payment_method (
  p_init_msg_list             IN            VARCHAR2 :=  FND_API.G_FALSE,
  p_payment_method_rec        IN payment_method_rec_type,
  px_last_update_date         IN OUT NOCOPY DATE,
  x_return_status             OUT NOCOPY    VARCHAR2,
  x_msg_count                 OUT NOCOPY    NUMBER,
  x_msg_data                  OUT NOCOPY    VARCHAR2
) IS
  l_last_update_date          DATE;

Line: 201

  SAVEPOINT update_pm_pub;

Line: 205

    hz_utility_v2pub.debug(p_message=>'update_payment_method(+)',
                           p_prefix=>l_debug_prefix,
                           p_msg_level=>fnd_log.level_procedure);

Line: 222

    SELECT ROWID, LAST_UPDATE_DATE
    INTO l_rowid, l_last_update_date
    FROM RA_CUST_RECEIPT_METHODS
    WHERE cust_receipt_method_id = l_pm_id
    FOR UPDATE NOWAIT;

Line: 229

      ( px_last_update_date IS NULL AND l_last_update_date IS NULL ) OR
      ( px_last_update_date IS NOT NULL AND
        l_last_update_date IS NOT NULL AND
        px_last_update_date = l_last_update_date ) )
    THEN
      FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );

Line: 250

     p_create_update_flag        => 'U'
    ,p_payment_method_rec        => p_payment_method_rec
    ,x_return_status             => x_return_status );

Line: 260

  HZ_PAYMENT_METHOD_PKG.Update_Row(
    x_rowid                  => l_rowid,
    x_cust_receipt_method_id => p_payment_method_rec.cust_receipt_method_id,
    x_customer_id            => p_payment_method_rec.cust_account_id,
    x_receipt_method_id      => p_payment_method_rec.receipt_method_id,
    x_primary_flag           => p_payment_method_rec.primary_flag,
    x_site_use_id            => p_payment_method_rec.site_use_id,
    x_start_date             => p_payment_method_rec.start_date,
    x_end_date               => p_payment_method_rec.end_date,
    x_attribute_category     => p_payment_method_rec.attribute_category,
    x_attribute1             => p_payment_method_rec.attribute1,
    x_attribute2             => p_payment_method_rec.attribute2,
    x_attribute3             => p_payment_method_rec.attribute3,
    x_attribute4             => p_payment_method_rec.attribute4,
    x_attribute5             => p_payment_method_rec.attribute5,
    x_attribute6             => p_payment_method_rec.attribute6,
    x_attribute7             => p_payment_method_rec.attribute7,
    x_attribute8             => p_payment_method_rec.attribute8,
    x_attribute9             => p_payment_method_rec.attribute9,
    x_attribute10            => p_payment_method_rec.attribute10,
    x_attribute11            => p_payment_method_rec.attribute11,
    x_attribute12            => p_payment_method_rec.attribute12,
    x_attribute13            => p_payment_method_rec.attribute13,
    x_attribute14            => p_payment_method_rec.attribute14,
    x_attribute15            => p_payment_method_rec.attribute15
  );

Line: 287

  px_last_update_date := l_last_update_date;

Line: 310

    hz_utility_v2pub.debug(p_message=>'update_payment_method(-)',
                           p_prefix=>l_debug_prefix,
                           p_msg_level=>fnd_log.level_procedure);

Line: 317

    ROLLBACK TO update_pm_pub;

Line: 325

    ROLLBACK TO update_pm_pub;

Line: 333

    ROLLBACK TO update_pm_pub;

Line: 342

END update_payment_method;

Line: 402

   p_create_update_flag        IN VARCHAR2,
   p_payment_method_rec        IN payment_method_rec_type,
   x_return_status             IN OUT NOCOPY VARCHAR2
) IS
   l_dummy                     VARCHAR2(1);

Line: 409

   select 'X'
   from HZ_CUST_ACCOUNTS
   where cust_account_id = l_ca_id;

Line: 414

   SELECT 'X'
   FROM HZ_CUST_SITE_USES_ALL casu, HZ_CUST_ACCT_SITES cas
   WHERE casu.cust_acct_site_id = cas.cust_acct_site_id
   AND cas.cust_account_id = l_ca_id
   AND casu.site_use_id = l_casu_id;

Line: 421

   SELECT 'X'
   FROM AR_RECEIPT_METHODS
   WHERE receipt_method_id = l_rm_id
   AND sysdate between start_date and nvl(end_date, sysdate);