APPS.HZ_PAYMENT_METHOD_PKG SQL Statements

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

Line: 4

  PROCEDURE Insert_Row(
    x_cust_receipt_method_id         IN OUT NOCOPY NUMBER,
    x_customer_id                    IN NUMBER,
    x_receipt_method_id              IN NUMBER,
    x_primary_flag                   IN VARCHAR2,
    x_site_use_id                    IN NUMBER,
    x_start_date                     IN DATE,
    x_end_date                       IN DATE,
    x_attribute_category             IN VARCHAR2,
    x_attribute1                     IN VARCHAR2,
    x_attribute2                     IN VARCHAR2,
    x_attribute3                     IN VARCHAR2,
    x_attribute4                     IN VARCHAR2,
    x_attribute5                     IN VARCHAR2,
    x_attribute6                     IN VARCHAR2,
    x_attribute7                     IN VARCHAR2,
    x_attribute8                     IN VARCHAR2,
    x_attribute9                     IN VARCHAR2,
    x_attribute10                    IN VARCHAR2,
    x_attribute11                    IN VARCHAR2,
    x_attribute12                    IN VARCHAR2,
    x_attribute13                    IN VARCHAR2,
    x_attribute14                    IN VARCHAR2,
    x_attribute15                    IN VARCHAR2
  ) IS
    l_success                               VARCHAR2(1) := 'N';

Line: 40

        INSERT INTO RA_CUST_RECEIPT_METHODS(
          cust_receipt_method_id,
          customer_id,
          receipt_method_id,
          primary_flag,
          site_use_id,
          start_date,
          end_date,
          attribute_category,
          attribute1,
          attribute2,
          attribute3,
          attribute4,
          attribute5,
          attribute6,
          attribute7,
          attribute8,
          attribute9,
          attribute10,
          attribute11,
          attribute12,
          attribute13,
          attribute14,
          attribute15,
          last_update_date,
          last_updated_by,
          creation_date,
          created_by,
          last_update_login,
          request_id,
          program_application_id,
          program_id,
          program_update_date
        ) VALUES (
          DECODE(x_cust_receipt_method_id, fnd_api.g_miss_num,
                 ra_cust_receipt_methods_s.NEXTVAL,
                 NULL, ra_cust_receipt_methods_s.NEXTVAL, x_cust_receipt_method_id),
          DECODE(x_customer_id, fnd_api.g_miss_num, NULL, x_customer_id),
          DECODE(x_receipt_method_id, fnd_api.g_miss_num, NULL, x_receipt_method_id),
          DECODE(x_primary_flag, fnd_api.g_miss_char, NULL, x_primary_flag),
          DECODE(x_site_use_id, fnd_api.g_miss_num, NULL, x_site_use_id),
          DECODE(x_start_date, fnd_api.g_miss_date, NULL, x_start_date),
          DECODE(x_end_date, fnd_api.g_miss_date, NULL, x_end_date),
          DECODE(x_attribute_category, fnd_api.g_miss_char, NULL, x_attribute_category),
          DECODE(x_attribute1, fnd_api.g_miss_char, NULL, x_attribute1),
          DECODE(x_attribute2, fnd_api.g_miss_char, NULL, x_attribute2),
          DECODE(x_attribute3, fnd_api.g_miss_char, NULL, x_attribute3),
          DECODE(x_attribute4, fnd_api.g_miss_char, NULL, x_attribute4),
          DECODE(x_attribute5, fnd_api.g_miss_char, NULL, x_attribute5),
          DECODE(x_attribute6, fnd_api.g_miss_char, NULL, x_attribute6),
          DECODE(x_attribute7, fnd_api.g_miss_char, NULL, x_attribute7),
          DECODE(x_attribute8, fnd_api.g_miss_char, NULL, x_attribute8),
          DECODE(x_attribute9, fnd_api.g_miss_char, NULL, x_attribute9),
          DECODE(x_attribute10, fnd_api.g_miss_char, NULL, x_attribute10),
          DECODE(x_attribute11, fnd_api.g_miss_char, NULL, x_attribute11),
          DECODE(x_attribute12, fnd_api.g_miss_char, NULL, x_attribute12),
          DECODE(x_attribute13, fnd_api.g_miss_char, NULL, x_attribute13),
          DECODE(x_attribute14, fnd_api.g_miss_char, NULL, x_attribute14),
          DECODE(x_attribute15, fnd_api.g_miss_char, NULL, x_attribute15),
          hz_utility_v2pub.last_update_date,
          hz_utility_v2pub.last_updated_by,
          hz_utility_v2pub.creation_date,
          hz_utility_v2pub.created_by,
          hz_utility_v2pub.last_update_login,
          hz_utility_v2pub.request_id,
          hz_utility_v2pub.program_application_id,
          hz_utility_v2pub.program_id,
          hz_utility_v2pub.program_update_date
       ) RETURNING
         cust_receipt_method_id
       INTO
         x_cust_receipt_method_id;

Line: 132

             SELECT max(cust_receipt_method_id) INTO l_max_crm_id
             FROM RA_CUST_RECEIPT_METHODS;

Line: 135

               SELECT RA_CUST_RECEIPT_METHODS_S.NEXTVAL
               INTO l_temp_crm_id FROM dual;

Line: 144

  End Insert_Row;

Line: 146

  PROCEDURE Update_Row(
    x_rowid                          IN OUT NOCOPY VARCHAR2,
    x_cust_receipt_method_id         IN NUMBER,
    x_customer_id                    IN NUMBER,
    x_receipt_method_id              IN NUMBER,
    x_primary_flag                   IN VARCHAR2,
    x_site_use_id                    IN NUMBER,
    x_start_date                     IN DATE,
    x_end_date                       IN DATE,
    x_attribute_category             IN VARCHAR2,
    x_attribute1                     IN VARCHAR2,
    x_attribute2                     IN VARCHAR2,
    x_attribute3                     IN VARCHAR2,
    x_attribute4                     IN VARCHAR2,
    x_attribute5                     IN VARCHAR2,
    x_attribute6                     IN VARCHAR2,
    x_attribute7                     IN VARCHAR2,
    x_attribute8                     IN VARCHAR2,
    x_attribute9                     IN VARCHAR2,
    x_attribute10                    IN VARCHAR2,
    x_attribute11                    IN VARCHAR2,
    x_attribute12                    IN VARCHAR2,
    x_attribute13                    IN VARCHAR2,
    x_attribute14                    IN VARCHAR2,
    x_attribute15                    IN VARCHAR2
  ) IS

  BEGIN

    UPDATE ra_cust_receipt_methods
    SET   cust_receipt_method_id = DECODE(x_cust_receipt_method_id, NULL,
                            cust_receipt_method_id, fnd_api.g_miss_num, NULL,
                            x_cust_receipt_method_id),
          customer_id = DECODE(x_customer_id, NULL, customer_id, fnd_api.g_miss_num,
                            NULL, x_customer_id),
          receipt_method_id = DECODE(x_receipt_method_id, NULL, receipt_method_id,
                            fnd_api.g_miss_num, NULL, x_receipt_method_id),
          primary_flag = DECODE(x_primary_flag, NULL, primary_flag,
                            fnd_api.g_miss_char, NULL, x_primary_flag),
          site_use_id = DECODE(x_site_use_id, NULL, site_use_id,
                            fnd_api.g_miss_num, NULL, x_site_use_id),
          start_date = DECODE(x_start_date, NULL, start_date,
                            fnd_api.g_miss_date, NULL, x_start_date),
          end_date = DECODE(x_end_date, NULL, end_date,
                            fnd_api.g_miss_date, NULL, x_end_date),
          attribute_category = DECODE(x_attribute_category, NULL, attribute_category,
                            fnd_api.g_miss_char, NULL, x_attribute_category),
          attribute1 = DECODE(x_attribute1, NULL, attribute1, fnd_api.g_miss_char,
                              NULL, x_attribute1),
          attribute2 = DECODE(x_attribute2, NULL, attribute2, fnd_api.g_miss_char,
                              NULL, x_attribute2),
          attribute3 = DECODE(x_attribute3, NULL, attribute3, fnd_api.g_miss_char,
                              NULL, x_attribute3),
          attribute4 = DECODE(x_attribute4, NULL, attribute4, fnd_api.g_miss_char,
                              NULL, x_attribute4),
          attribute5 = DECODE(x_attribute5, NULL, attribute5, fnd_api.g_miss_char,
                              NULL, x_attribute5),
          attribute6 = DECODE(x_attribute6, NULL, attribute6, fnd_api.g_miss_char,
                              NULL, x_attribute6),
          attribute7 = DECODE(x_attribute7, NULL, attribute7, fnd_api.g_miss_char,
                              NULL, x_attribute7),
          attribute8 = DECODE(x_attribute8, NULL, attribute8, fnd_api.g_miss_char,
                              NULL, x_attribute8),
          attribute9 = DECODE(x_attribute9, NULL, attribute9, fnd_api.g_miss_char,
                              NULL, x_attribute9),
          attribute10 = DECODE(x_attribute10, NULL, attribute10, fnd_api.g_miss_char,
                              NULL, x_attribute10),
          last_update_date = hz_utility_v2pub.last_update_date,
          last_updated_by = hz_utility_v2pub.last_updated_by,
          creation_date = creation_date,
          created_by = created_by,
          last_update_login = hz_utility_v2pub.last_update_login,
          request_id = hz_utility_v2pub.request_id,
          program_application_id = hz_utility_v2pub.program_application_id,
          program_id = hz_utility_v2pub.program_id,
          program_update_date = hz_utility_v2pub.program_update_date
    WHERE rowid = x_rowid;

Line: 227

  END Update_Row;

Line: 254

    x_last_update_date               IN DATE,
    x_last_updated_by                IN NUMBER,
    x_creation_date                  IN DATE,
    x_created_by                     IN NUMBER,
    x_last_update_login              IN NUMBER,
    x_request_id                     IN NUMBER,
    x_program_application_id         IN NUMBER,
    x_program_id                     IN NUMBER,
    x_program_update_date            IN DATE
  ) IS

    CURSOR c IS
      SELECT *
      FROM   ra_cust_receipt_methods
      WHERE  ROWID = x_rowid
      FOR UPDATE NOWAIT;

Line: 277

      fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 351

        AND ((recinfo.last_update_date = x_last_update_date)
             OR ((recinfo.last_update_date IS NULL)
                 AND (x_last_update_date IS NULL)))
        AND ((recinfo.last_updated_by = x_last_updated_by)
             OR ((recinfo.last_updated_by IS NULL)
                 AND (x_last_updated_by IS NULL)))
        AND ((recinfo.creation_date = x_creation_date)
             OR ((recinfo.creation_date IS NULL)
                 AND (x_creation_date IS NULL)))
        AND ((recinfo.created_by = x_created_by)
             OR ((recinfo.created_by IS NULL)
                 AND (x_created_by IS NULL)))
        AND ((recinfo.last_update_login = x_last_update_login)
             OR ((recinfo.last_update_login IS NULL)
                 AND (x_last_update_login IS NULL)))
        AND ((recinfo.request_id = x_request_id)
             OR ((recinfo.request_id IS NULL)
                 AND (x_request_id IS NULL)))
        AND ((recinfo.program_application_id = x_program_application_id)
             OR ((recinfo.program_application_id IS NULL)
                 AND (x_program_application_id IS NULL)))
        AND ((recinfo.program_id = x_program_id)
             OR ((recinfo.program_id IS NULL)
                 AND (x_program_id IS NULL)))
        AND ((recinfo.program_update_date = x_program_update_date)
             OR ((recinfo.program_update_date IS NULL)
                 AND (x_program_update_date IS NULL)))
    )
    THEN
      RETURN;

Line: 382

      fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 388

  PROCEDURE delete_row (x_cust_receipt_method_id IN NUMBER) IS
  BEGIN
    DELETE FROM ra_cust_receipt_methods
    WHERE cust_receipt_method_id = x_cust_receipt_method_id;

Line: 396

  END delete_row;