eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_INTERFACE_VAL SQL Statements

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

Line: 12


      p_default_last_updated_by         IN    NUMBER,
      p_default_last_update_login       IN    NUMBER,
      p_global_attribute_category       IN    VARCHAR2,
      p_global_attribute1               IN    VARCHAR2,
      p_global_attribute2               IN    VARCHAR2,
      p_global_attribute3               IN    VARCHAR2,
      p_global_attribute4               IN    VARCHAR2,
      p_global_attribute5               IN    VARCHAR2,
      p_global_attribute6               IN    VARCHAR2,
      p_global_attribute7               IN    VARCHAR2,
      p_global_attribute8               IN    VARCHAR2,
      p_global_attribute9               IN    VARCHAR2,
      p_global_attribute10              IN    VARCHAR2,
      p_global_attribute11              IN    VARCHAR2,
      p_global_attribute12              IN    VARCHAR2,
      p_global_attribute13              IN    VARCHAR2,
      p_global_attribute14              IN    VARCHAR2,
      p_global_attribute15              IN    VARCHAR2,
      p_global_attribute16              IN    VARCHAR2,
      p_global_attribute17              IN    VARCHAR2,
      p_global_attribute18              IN    VARCHAR2,
      p_global_attribute19              IN    VARCHAR2,
      p_global_attribute20              IN    VARCHAR2,
      p_current_invoice_status          OUT NOCOPY   VARCHAR2,
      p_calling_sequence                IN    VARCHAR2) IS

    l_credit_exists		VARCHAR2(1);

Line: 80


          p_default_last_updated_by,
          p_default_last_update_login,
          p_global_attribute13,
          p_global_attribute14,
          p_global_attribute15,
          p_global_attribute16,
          p_global_attribute17,
          p_global_attribute18,
          p_global_attribute19,
          p_global_attribute20,
          l_current_invoice_status,
          p_calling_sequence);

Line: 99


          p_default_last_updated_by,
          p_default_last_update_login,
          p_global_attribute1,
          p_global_attribute2,
          p_global_attribute3,
          p_global_attribute4,
          p_global_attribute5,
          p_global_attribute6,
          p_global_attribute7,
          p_global_attribute8,
          p_global_attribute9,
          p_global_attribute10,
          p_global_attribute11,
          p_global_attribute12,
          p_global_attribute13,
          p_global_attribute14,
          p_global_attribute15,
          p_global_attribute16,
          p_global_attribute17,
          p_global_attribute18,
          p_global_attribute19,
          p_global_attribute20,
          l_current_invoice_status,
          p_calling_sequence);

Line: 131


          p_default_last_updated_by,
          p_default_last_update_login,
          p_global_attribute1,
          p_global_attribute2,
          p_global_attribute3,
          p_global_attribute4,
          p_global_attribute5,
          p_global_attribute6,
          p_global_attribute7,
          p_global_attribute8,
          p_global_attribute9,
          p_global_attribute10,
          p_global_attribute11,
          p_global_attribute12,
          p_global_attribute13,
          p_global_attribute14,
          p_global_attribute15,
          p_global_attribute16,
          p_global_attribute17,
          p_global_attribute18,
          p_global_attribute19,
          p_global_attribute20,
          l_current_invoice_status,
          p_calling_sequence);

Line: 162


          p_default_last_updated_by,
          p_default_last_update_login,
          p_global_attribute1,
          p_global_attribute2,
          p_global_attribute3,
          p_global_attribute4,
          p_global_attribute5,
          p_global_attribute6,
          p_global_attribute7,
          p_global_attribute8,
          p_global_attribute9,
          p_global_attribute10,
          p_global_attribute11,
          p_global_attribute12,
          p_global_attribute13,
          p_global_attribute14,
          p_global_attribute15,
          p_global_attribute16,
          p_global_attribute17,
          p_global_attribute18,
          p_global_attribute19,
          p_global_attribute20,
          l_current_invoice_status,
          p_calling_sequence);

Line: 193


          p_default_last_updated_by,
          p_default_last_update_login,
          p_global_attribute1,
          p_global_attribute2,
          p_global_attribute3,
          p_global_attribute4,
          p_global_attribute5,
          p_global_attribute6,
          p_global_attribute7,
          p_global_attribute8,
          p_global_attribute9,
          p_global_attribute10,
          p_global_attribute11,
          p_global_attribute12,
          p_global_attribute13,
          p_global_attribute14,
          p_global_attribute15,
          p_global_attribute16,
          p_global_attribute17,
          p_global_attribute18,
          p_global_attribute19,
          p_global_attribute20,
          l_current_invoice_status,
          p_calling_sequence);

Line: 223


          p_default_last_updated_by,
          p_default_last_update_login,
          p_global_attribute1,
          p_global_attribute2,
          p_global_attribute9,
          p_global_attribute10,
          p_global_attribute11,
          p_global_attribute12,
          p_global_attribute13,
          p_global_attribute14,
          p_global_attribute15,
          p_global_attribute16,
          p_global_attribute17,
          p_global_attribute18,
          p_global_attribute19,
          p_global_attribute20,
          l_current_invoice_status,
          p_calling_sequence);

Line: 249


         p_default_last_updated_by,
         p_default_last_update_login,
         p_global_attribute1,
         p_global_attribute4,
         p_global_attribute5,
         p_global_attribute6,
         p_global_attribute7,
         p_global_attribute8,
         p_global_attribute9,
         p_global_attribute10,
         p_global_attribute11,
         p_global_attribute12,
         p_global_attribute13,
         p_global_attribute14,
         p_global_attribute15,
         p_global_attribute16,
         p_global_attribute17,
         p_global_attribute18,
         p_global_attribute19,
         p_global_attribute20,
         l_current_invoice_status,
         p_calling_sequence);

Line: 283


          p_default_last_updated_by           IN     NUMBER,
          p_default_last_update_login         IN     NUMBER,
          p_global_attribute13                IN     VARCHAR2,
          p_global_attribute14                IN     VARCHAR2,
          p_global_attribute15                IN     VARCHAR2,
          p_global_attribute16                IN     VARCHAR2,
          p_global_attribute17                IN     VARCHAR2,
          p_global_attribute18                IN     VARCHAR2,
          p_global_attribute19                IN     VARCHAR2,
          p_global_attribute20                IN     VARCHAR2,
          p_current_invoice_status            OUT NOCOPY    VARCHAR2,
          p_calling_sequence                  IN     VARCHAR2) IS

  BEGIN
      null;

Line: 308


      p_default_last_updated_by         IN    NUMBER,
      p_default_last_update_login       IN    NUMBER,
      p_global_attribute1               IN    VARCHAR2,
      p_global_attribute2               IN    VARCHAR2,
      p_global_attribute3               IN    VARCHAR2,
      p_global_attribute4               IN    VARCHAR2,
      p_global_attribute5               IN    VARCHAR2,
      p_global_attribute6               IN    VARCHAR2,
      p_global_attribute7               IN    VARCHAR2,
      p_global_attribute8               IN    VARCHAR2,
      p_global_attribute9               IN    VARCHAR2,
      p_global_attribute10              IN    VARCHAR2,
      p_global_attribute11              IN    VARCHAR2,
      p_global_attribute12              IN    VARCHAR2,
      p_global_attribute13              IN    VARCHAR2,
      p_global_attribute14              IN    VARCHAR2,
      p_global_attribute15              IN    VARCHAR2,
      p_global_attribute16              IN    VARCHAR2,
      p_global_attribute17              IN    VARCHAR2,
      p_global_attribute18              IN    VARCHAR2,
      p_global_attribute19              IN    VARCHAR2,
      p_global_attribute20              IN    VARCHAR2,
      p_current_invoice_status          OUT NOCOPY   VARCHAR2,
      p_calling_sequence                IN    VARCHAR2) IS

  BEGIN
    null;

Line: 352


      p_default_last_updated_by         IN    NUMBER,
      p_default_last_update_login       IN    NUMBER,
      p_global_attribute1               IN    VARCHAR2,
      p_global_attribute2               IN    VARCHAR2,
      p_global_attribute3               IN    VARCHAR2,
      p_global_attribute4               IN    VARCHAR2,
      p_global_attribute5               IN    VARCHAR2,
      p_global_attribute6               IN    VARCHAR2,
      p_global_attribute7               IN    VARCHAR2,
      p_global_attribute8               IN    VARCHAR2,
      p_global_attribute9               IN    VARCHAR2,
      p_global_attribute10              IN    VARCHAR2,
      p_global_attribute11              IN    VARCHAR2,
      p_global_attribute12              IN    VARCHAR2,
      p_global_attribute13              IN    VARCHAR2,
      p_global_attribute14              IN    VARCHAR2,
      p_global_attribute15              IN    VARCHAR2,
      p_global_attribute16              IN    VARCHAR2,
      p_global_attribute17              IN    VARCHAR2,
      p_global_attribute18              IN    VARCHAR2,
      p_global_attribute19              IN    VARCHAR2,
      p_global_attribute20              IN    VARCHAR2,
      p_current_invoice_status          OUT NOCOPY   VARCHAR2,
      p_calling_sequence                IN    VARCHAR2) IS

      l_tax_acct_per_exists    VARCHAR2(1);

Line: 388


         SELECT fnd_date.canonical_to_date(p_global_attribute2)
           INTO l_tax_inv_date
         FROM dual;

Line: 393


                   jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                     p_parent_id,
                                     'INVALID_GLOBAL_ATTR2',
                                     p_default_last_updated_by,
                                     p_default_last_update_login,
                                     p_calling_sequence);

Line: 406


                   jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                     p_parent_id,
                                     'INVALID_GLOBAL_ATTR3',
                                     p_default_last_updated_by,
                                     p_default_last_update_login,
                                     p_calling_sequence);

Line: 416


                   jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                     p_parent_id,
                                     'INVALID_GLOBAL_ATTR4',
                                     p_default_last_updated_by,
                                     p_default_last_update_login,
                                     p_calling_sequence);

Line: 433


           SELECT NULL
             INTO l_tax_acct_per_exists
           FROM dual
           WHERE p_global_attribute4 in
               (select period_name
                from gl_period_statuses
                where application_id=200
                and set_of_books_id = p_set_of_books_id
                and closing_status in ('O','F')
                and adjustment_period_flag = 'N'
                and end_date >= fnd_date.canonical_to_date(p_global_attribute2));

Line: 446


                   jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                     p_parent_id,
                                     'INVALID_GLOBAL_ATTR4',
                                     p_default_last_updated_by,
                                     p_default_last_update_login,
                                     p_calling_sequence);

Line: 477


                  jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                    p_parent_id,
                                    'GLOBAL_ATTR_VALUE_FOUND',
                                    p_default_last_updated_by,
                                    p_default_last_update_login,
                                    p_calling_sequence);

Line: 500


      p_default_last_updated_by         IN    NUMBER,
      p_default_last_update_login       IN    NUMBER,
      p_global_attribute1               IN    VARCHAR2,
      p_global_attribute2               IN    VARCHAR2,
      p_global_attribute3               IN    VARCHAR2,
      p_global_attribute4               IN    VARCHAR2,
      p_global_attribute5               IN    VARCHAR2,
      p_global_attribute6               IN    VARCHAR2,
      p_global_attribute7               IN    VARCHAR2,
      p_global_attribute8               IN    VARCHAR2,
      p_global_attribute9               IN    VARCHAR2,
      p_global_attribute10              IN    VARCHAR2,
      p_global_attribute11              IN    VARCHAR2,
      p_global_attribute12              IN    VARCHAR2,
      p_global_attribute13              IN    VARCHAR2,
      p_global_attribute14              IN    VARCHAR2,
      p_global_attribute15              IN    VARCHAR2,
      p_global_attribute16              IN    VARCHAR2,
      p_global_attribute17              IN    VARCHAR2,
      p_global_attribute18              IN    VARCHAR2,
      p_global_attribute19              IN    VARCHAR2,
      p_global_attribute20              IN    VARCHAR2,
      p_current_invoice_status          OUT NOCOPY   VARCHAR2,
      p_calling_sequence                IN    VARCHAR2) IS

  BEGIN
      IF (p_global_attribute1 NOT IN ('21','22','23','24','25','26','27','28')) THEN
                  jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                    p_parent_id,
                                    'INVALID_GLOBAL_ATTR1',
                                    p_default_last_updated_by,
                                    p_default_last_update_login,
                                    p_calling_sequence);

Line: 537


                  jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                    p_parent_id,
                                    'INVALID_GLOBAL_ATTR2',
                                    p_default_last_updated_by,
                                    p_default_last_update_login,
                                    p_calling_sequence);

Line: 547


                  jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                    p_parent_id,
                                    'INVALID_GLOBAL_ATTR3',
                                    p_default_last_updated_by,
                                    p_default_last_update_login,
                                    p_calling_sequence);

Line: 563


          jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                    p_parent_id,
                                    'INVALID_GLOBAL_ATTR4',
                                    p_default_last_updated_by,
                                    p_default_last_update_login,
                                    p_calling_sequence);

Line: 589


                  jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                    p_parent_id,
                                    'GLOBAL_ATTR_VALUE_FOUND',
                                    p_default_last_updated_by,
                                    p_default_last_update_login,
                                    p_calling_sequence);

Line: 610


      p_default_last_updated_by         IN    NUMBER,
      p_default_last_update_login       IN    NUMBER,
      p_global_attribute1               IN    VARCHAR2,
      p_global_attribute2               IN    VARCHAR2,
      p_global_attribute3               IN    VARCHAR2,
      p_global_attribute4               IN    VARCHAR2,
      p_global_attribute5               IN    VARCHAR2,
      p_global_attribute6               IN    VARCHAR2,
      p_global_attribute7               IN    VARCHAR2,
      p_global_attribute8               IN    VARCHAR2,
      p_global_attribute9               IN    VARCHAR2,
      p_global_attribute10              IN    VARCHAR2,
      p_global_attribute11              IN    VARCHAR2,
      p_global_attribute12              IN    VARCHAR2,
      p_global_attribute13              IN    VARCHAR2,
      p_global_attribute14              IN    VARCHAR2,
      p_global_attribute15              IN    VARCHAR2,
      p_global_attribute16              IN    VARCHAR2,
      p_global_attribute17              IN    VARCHAR2,
      p_global_attribute18              IN    VARCHAR2,
      p_global_attribute19              IN    VARCHAR2,
      p_global_attribute20              IN    VARCHAR2,
      p_current_invoice_status          OUT NOCOPY   VARCHAR2,
      p_calling_sequence                IN    VARCHAR2) IS

  BEGIN
    /* NONE - NUMBER(15),Numbers Only(0-9) */
    IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute1,'N',15,'','N','N','N','','')) THEN
                  jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                    p_parent_id,
                                    'INVALID_GLOBAL_ATTR1',
                                    p_default_last_updated_by,
                                    p_default_last_update_login,
                                    p_calling_sequence);

Line: 667


                  jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                    p_parent_id,
                                    'GLOBAL_ATTR_VALUE_FOUND',
                                    p_default_last_updated_by,
                                    p_default_last_update_login,
                                    p_calling_sequence);

Line: 687


      p_default_last_updated_by         IN    NUMBER,
      p_default_last_update_login       IN    NUMBER,
      p_global_attribute1               IN    VARCHAR2,
      p_global_attribute4               IN    VARCHAR2,
      p_global_attribute5               IN    VARCHAR2,
      p_global_attribute6               IN    VARCHAR2,
      p_global_attribute7               IN    VARCHAR2,
      p_global_attribute8               IN    VARCHAR2,
      p_global_attribute9               IN    VARCHAR2,
      p_global_attribute10              IN    VARCHAR2,
      p_global_attribute11              IN    VARCHAR2,
      p_global_attribute12              IN    VARCHAR2,
      p_global_attribute13              IN    VARCHAR2,
      p_global_attribute14              IN    VARCHAR2,
      p_global_attribute15              IN    VARCHAR2,
      p_global_attribute16              IN    VARCHAR2,
      p_global_attribute17              IN    VARCHAR2,
      p_global_attribute18              IN    VARCHAR2,
      p_global_attribute19              IN    VARCHAR2,
      p_global_attribute20              IN    VARCHAR2,
      p_current_invoice_status          OUT NOCOPY   VARCHAR2,
      p_calling_sequence                IN    VARCHAR2) IS

  BEGIN
    null;

Line: 722


      p_default_last_updated_by         IN    NUMBER,
      p_default_last_update_login       IN    NUMBER,
      p_global_attribute1               IN    VARCHAR2,
      p_global_attribute2               IN    VARCHAR2,
      p_global_attribute9               IN    VARCHAR2,
      p_global_attribute10              IN    VARCHAR2,
      p_global_attribute11              IN    VARCHAR2,
      p_global_attribute12              IN    VARCHAR2,
      p_global_attribute13              IN    VARCHAR2,
      p_global_attribute14              IN    VARCHAR2,
      p_global_attribute15              IN    VARCHAR2,
      p_global_attribute16              IN    VARCHAR2,
      p_global_attribute17              IN    VARCHAR2,
      p_global_attribute18              IN    VARCHAR2,
      p_global_attribute19              IN    VARCHAR2,
      p_global_attribute20              IN    VARCHAR2,
      p_current_invoice_status          OUT NOCOPY   VARCHAR2,
      p_calling_sequence                IN    VARCHAR2) IS

  BEGIN
      null;

Line: 757


      p_insert_update_flag              IN    VARCHAR2,
      p_request_id                      IN    NUMBER,
      p_global_attribute_category       IN    VARCHAR2,
      p_global_attribute1               IN    VARCHAR2,
      p_global_attribute2               IN    VARCHAR2,
      p_global_attribute3               IN    VARCHAR2,
      p_global_attribute4               IN    VARCHAR2,
      p_global_attribute5               IN    VARCHAR2,
      p_global_attribute6               IN    VARCHAR2,
      p_global_attribute7               IN    VARCHAR2,
      p_global_attribute8               IN    VARCHAR2,
      p_global_attribute9               IN    VARCHAR2,
      p_global_attribute10              IN    VARCHAR2,
      p_global_attribute11              IN    VARCHAR2,
      p_global_attribute12              IN    VARCHAR2,
      p_global_attribute13              IN    VARCHAR2,
      p_global_attribute14              IN    VARCHAR2,
      p_global_attribute15              IN    VARCHAR2,
      p_global_attribute16              IN    VARCHAR2,
      p_global_attribute17              IN    VARCHAR2,
      p_global_attribute18              IN    VARCHAR2,
      p_global_attribute19              IN    VARCHAR2,
      p_global_attribute20              IN    VARCHAR2,
      p_current_record_status           OUT NOCOPY   VARCHAR2) IS

BEGIN

      p_current_record_status := 'S';

Line: 830


  l_insert_update_flag          VARCHAR(1);

Line: 847


  l_insert_update_flag          := p_misc_prod_arg.core_prod_arg8;

Line: 869


  IF (l_insert_update_flag = 'U') THEN
    BEGIN
      SELECT
             rc.customer_id
        INTO
             l_customer_id
        FROM
             ra_customers rc
       WHERE
             rc.orig_system_reference = l_orig_system_customer_ref;

Line: 881


      arp_standard.debug('No data found in RA_CUSTOMERS table for Update');

Line: 1001


    jg_globe_flex_val_shared.update_interface_status(
                             l_rowid,
                             l_table_name,
                             l_mesg_code,
                             'E');