DBA Data[Home] [Help]

APPS.JL_INTERFACE_VAL SQL Statements

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

Line: 14

      p_default_last_updated_by         IN    NUMBER,
      p_default_last_update_login       IN    NUMBER,
      p_line_type_lookup_code           IN    VARCHAR2,
      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: 91

      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: 119

      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: 149

      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: 182

      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: 215

      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: 249

      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: 279

    p_default_last_updated_by,
    p_default_last_update_login,
    l_current_invoice_status,
    p_calling_sequence);
Line: 293

      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: 332

    SELECT org_id into l_ou_id FROM fnd_concurrent_requests
    WHERE request_id = fnd_global.conc_request_id ;
Line: 351

        SELECT invoice_id
          INTO invo_id
          FROM ap_invoice_lines_interface
         WHERE invoice_line_id = P_parent_id;
Line: 360

        SELECT nvl(liability_post_lookup_code, 'NONE')
        INTO   l_liability_post_lookup_code
        FROM   ap_system_parameters;
Line: 401

               jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                             invo_id,
                            'MULTIPLE BAL SEG FOUND',
                             p_default_last_updated_by,
                             p_default_last_update_login,
                             p_calling_sequence);
Line: 426

                    ||', Last Updated By = '||to_char(p_default_last_updated_by)
                    ||', Last Update Login = '||to_char(p_default_last_update_login)
                    ||', Line Type Lookup Code = '||p_line_type_lookup_code
                    ||', Global Attribute Category = '||p_global_attribute_category
                    ||', Global Attribute1 = '||p_global_attribute1
                    ||', Global Attribute2 = '||p_global_attribute2
                    ||', Global Attribute3 = '||p_global_attribute3
                    ||', Global Attribute4 = '||p_global_attribute4
                    ||', Global Attribute5 = '||p_global_attribute5
                    ||', Global Attribute6 = '||p_global_attribute6
                    ||', Global Attribute7 = '||p_global_attribute7
                    ||', Global Attribute8 = '||p_global_attribute8
                    ||', Global Attribute9 = '||p_global_attribute9
                    ||', Global Attribute10 = '||p_global_attribute10
                    ||', Global Attribute11 = '||p_global_attribute11
                    ||', Global Attribute12 = '||p_global_attribute12
                    ||', Global Attribute13 = '||p_global_attribute13
                    ||', Global Attribute14 = '||p_global_attribute14
                    ||', Global Attribute15 = '||p_global_attribute15
                    ||', Global Attribute16 = '||p_global_attribute16
                    ||', Global Attribute17 = '||p_global_attribute17
                    ||', Global Attribute18 = '||p_global_attribute18
                    ||', Global Attribute19 = '||p_global_attribute19
                    ||', Global Attribute20 = '||p_global_attribute20);
Line: 480

        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

    value_exists   VARCHAR2(1);
Line: 516

        SELECT 'X'
        INTO value_exists
        FROM fnd_lookups
        WHERE  lookup_type =  'JLAR_LEGAL_TRX_CATEGORY'
        AND  lookup_code = p_global_attribute11
        AND  nvl(start_date_active,sysdate) <= sysdate
        AND  nvl(end_date_active,sysdate) >= sysdate
        AND  enabled_flag = 'Y';
Line: 526

          jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                                     p_parent_id,
                                                     'INVALID_GLOBAL_ATTR11',
                                                     p_default_last_updated_by,
                                                     p_default_last_update_login,
                                                     p_calling_sequence);
Line: 536

      jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                                 p_parent_id,
                                                 'INVALID_GLOBAL_ATTR11',
                                                 p_default_last_updated_by,
                                                 p_default_last_update_login,
                                                 p_calling_sequence);
Line: 550

        SELECT  'X'
        INTO  value_exists
        FROM  fnd_lookups
        WHERE  lookup_type = 'JLAR_DOCUMENT_LETTER'
        AND  lookup_code = p_global_attribute12
        AND  nvl(start_date_active,sysdate) <= sysdate
        AND  nvl(end_date_active,sysdate) >= sysdate
        AND  enabled_flag = 'Y' ;
Line: 560

          jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                                     p_parent_id,
                                                     'INVALID_GLOBAL_ATTR12',
                                                     p_default_last_updated_by,
                                                     p_default_last_update_login,
                                                     p_calling_sequence);
Line: 570

      jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                                   p_parent_id,
                                                   'INVALID_GLOBAL_ATTR12',
                                                   p_default_last_updated_by,
                                                   p_default_last_update_login,
                                                   p_calling_sequence);
Line: 583

        SELECT 'X'
        INTO value_exists
        FROM jl_ar_ap_trx_dgi_codes
        WHERE trx_category =  p_global_attribute11
        and trx_letter = p_global_attribute12;
Line: 590

          jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                                       p_parent_id,
                                                       'INVALID_GLOBAL_ATTR13',
                                                       p_default_last_updated_by,
                                                       p_default_last_update_login,
                                                       p_calling_sequence);
Line: 600

      jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                                   p_parent_id,
                                                   'INVALID_GLOBAL_ATTR13',
                                                   p_default_last_updated_by,
                                                   p_default_last_update_login,
                                                   p_calling_sequence);
Line: 626

          jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                    p_parent_id,
                                    'INVALID_GLOBAL_ATTR15',
                                    p_default_last_updated_by,
                                    p_default_last_update_login,
                                    p_calling_sequence);
Line: 640

          jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                         p_parent_id,
                                        'INVALID_GLOBAL_ATTR15',
                                        p_default_last_updated_by,
                                        p_default_last_update_login,
                                        p_calling_sequence);
Line: 651

        jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                  p_parent_id,
                                  'INVALID_GLOBAL_ATTR15',
                                  p_default_last_updated_by,
                                  p_default_last_update_login,
                                  p_calling_sequence);
Line: 670

        jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                p_parent_id,
                                'INVALID_GLOBAL_ATTR16',
                                p_default_last_updated_by,
                                p_default_last_update_login,
                                p_calling_sequence);
Line: 685

        SELECT 'X'
        INTO value_exists
        FROM fnd_lookups
        WHERE  lookup_type = 'YES_NO'
        AND  lookup_code = p_global_attribute17
        AND  nvl(start_date_active,sysdate) <= sysdate
        AND  nvl(end_date_active,sysdate) >= sysdate
        AND  enabled_flag = 'Y' ;
Line: 696

          jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                 p_parent_id,
                                 'INVALID_GLOBAL_ATTR17',
                                 p_default_last_updated_by,
                                  p_default_last_update_login,
                                 p_calling_sequence);
Line: 706

      jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                 p_parent_id,
                                 'INVALID_GLOBAL_ATTR17',
                                 p_default_last_updated_by,
                                 p_default_last_update_login,
                                 p_calling_sequence);
Line: 732

        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: 753

      SELECT nvl(liability_post_lookup_code, 'NONE')
      INTO   l_liability_post_lookup_code
      FROM   ap_system_parameters;
Line: 793

          jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                          p_parent_id,
                          'MULTIPLE BAL SEG FOUND',
                          p_default_last_updated_by,
                          p_default_last_update_login,
                          p_calling_sequence);
Line: 826

      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

  value_exists   VARCHAR2(1);
Line: 857

         SELECT 'X'
           INTO value_exists
           FROM HR_Locations_all
          WHERE Location_id = p_global_attribute3
            AND  sysdate < nvl(inactive_date, sysdate+1); -- Bug 3463869
Line: 865

        jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
                             p_parent_id,
                              'INVALID_GLOBAL_ATTR3',
                              p_default_last_updated_by,
                              p_default_last_update_login,
                              p_calling_sequence);
Line: 876

     jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
                          p_parent_id,
                          'INVALID_GLOBAL_ATTR3',
                          p_default_last_updated_by,
                          p_default_last_update_login,
                          p_calling_sequence);
Line: 888

       jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
                          p_parent_id,
                           'INVALID_GLOBAL_ATTR4',
                           p_default_last_updated_by,
                           p_default_last_update_login,
                           p_calling_sequence);
Line: 920

      jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
                                           p_parent_id,
                                         'GLOBAL_ATTR_VALUE_FOUND',
                                         p_default_last_updated_by,
                                       p_default_last_update_login,
                                          p_calling_sequence);
Line: 945

        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

    value_exists   VARCHAR2(1);
Line: 978

          SELECT 'X'
            INTO value_exists
            FROM HR_Locations_all
           WHERE Location_id = p_global_attribute18
	     AND sysdate < nvl(inactive_date, sysdate+1); -- Bug 3463869
Line: 986

             jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                  p_parent_id,
                                 'INVALID_GLOBAL_ATTR18',
                                 p_default_last_updated_by,
                                 p_default_last_update_login,
                                  p_calling_sequence);
Line: 1018

       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: 1048

      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

  value_exists   VARCHAR2(1);
Line: 1081

          SELECT 'X'
            INTO value_exists
            FROM PO_Vendors

             WHERE segment1 = p_global_attribute2;
Line: 1090

        jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
                                  p_parent_id,
                                  'INVALID_GLOBAL_ATTR2',
                                  p_default_last_updated_by,
                                  p_default_last_update_login,
                                  p_calling_sequence);
Line: 1106

          SELECT 'X'
            INTO value_exists
            FROM HR_Locations_all
           WHERE Location_id = p_global_attribute3
	     AND sysdate < nvl(inactive_date, sysdate+1); -- Bug 3463869
Line: 1115

        jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
                                  p_parent_id,
                                 'INVALID_GLOBAL_ATTR3',
                                 p_default_last_updated_by,
                                 p_default_last_update_login,
                                  p_calling_sequence);
Line: 1125

       jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
                           p_parent_id,
                           'INVALID_GLOBAL_ATTR3',
                           p_default_last_updated_by,
                           p_default_last_update_login,
                           p_calling_sequence);
Line: 1155

       jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
                            p_parent_id,
                           'GLOBAL_ATTR_VALUE_FOUND',
                           p_default_last_updated_by,
                           p_default_last_update_login,
                           p_calling_sequence);
Line: 1179

      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


     l_current_record_status       VARCHAR2(1) := 'S';
Line: 1242

                p_insert_update_flag,
                p_request_id,
                p_global_attribute_category,
                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_record_status);
Line: 1280

                p_insert_update_flag,
                p_request_id,
                p_global_attribute_category,
                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_record_status);
Line: 1318

                p_insert_update_flag,
                p_request_id,
                p_global_attribute_category,
                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_record_status);
Line: 1390

    SELECT org_id into l_ou_id FROM fnd_concurrent_requests
    WHERE request_id = fnd_global.conc_request_id ;
Line: 1441

    SELECT org_id into l_ou_id FROM fnd_concurrent_requests
    WHERE request_id = fnd_global.conc_request_id ;
Line: 1602

     jg_globe_flex_val_shared.update_interface_status (l_row_id,
           'RA_CUSTOMERS_INTERFACE',
           l_mesg_code,
           l_record_status);
Line: 1636

     jg_globe_flex_val_shared.update_interface_status (l_row_id,
           'RA_CUSTOMERS_INTERFACE',
           l_taxid_mesg_code,
           l_taxid_record_status);
Line: 1641

     jg_globe_flex_val_shared.update_interface_status (l_row_id,
           'RA_CUSTOMERS_INTERFACE',
           l_taxid_mesg_code,
           l_taxid_record_status);
Line: 1749

     jg_globe_flex_val_shared.update_interface_status (l_row_id,
           'RA_CUSTOMERS_INTERFACE',
           l_mesg_code,
           l_record_status);
Line: 1781

     jg_globe_flex_val_shared.update_interface_status (l_row_id,
           'RA_CUSTOMERS_INTERFACE',
           l_taxid_mesg_code,
           l_taxid_record_status);
Line: 1787

     jg_globe_flex_val_shared.update_interface_status (l_row_id,
           'RA_CUSTOMERS_INTERFACE',
           l_taxid_mesg_code,
           l_taxid_record_status);
Line: 1850

    SELECT 'x'
    INTO l_lookup_code
    FROM dual
    WHERE exists (select lookup_code
                  from fnd_lookups
                  where lookup_type = 'JLAR_TAXID_TYPE'
                  and lookup_code = p_glob_attr_set1.global_attribute10);
Line: 1915

     jg_globe_flex_val_shared.update_interface_status (l_row_id,
           'RA_CUSTOMERS_INTERFACE',
           l_mesg_code,
           l_record_status);
Line: 1946

     jg_globe_flex_val_shared.update_interface_status (l_row_id,
           'RA_CUSTOMERS_INTERFACE',
           l_taxid_mesg_code,
           l_taxid_record_status);
Line: 1951

     jg_globe_flex_val_shared.update_interface_status (l_row_id,
           'RA_CUSTOMERS_INTERFACE',
           l_taxid_mesg_code,
           l_taxid_record_status);
Line: 1979

                p_insert_update_flag            IN VARCHAR2,
                p_request_id                    IN NUMBER,
                p_global_attribute_category     IN VARCHAR2,
                p_global_attribute9             IN VARCHAR2,
                p_global_attribute10            IN VARCHAR2,
                p_global_attribute12            IN VARCHAR2,
                p_taxid_mesg_code              OUT NOCOPY VARCHAR2,
                p_taxid_record_status          OUT NOCOPY VARCHAR2) IS

    l_return_ar             VARCHAR2(10):=NULL;
Line: 2078

  IF (p_insert_update_flag = 'U') THEN

   BEGIN

     SELECT rc.cust_account_id INTO l_customer_id
     FROM hz_cust_accounts rc
     WHERE rc.orig_system_reference = p_orig_system_customer_ref;
Line: 2089

        arp_util_tax.debug('jl_zz_taxid_customers: ' || 'No data found in hz_cust_accounts table for Update');
Line: 2294

        UPDATE ra_customers_interface
        SET customer_number = p_jgzz_fiscal_code||'-'||p_global_attribute12
        WHERE rowid = p_row_id;
Line: 2298

        UPDATE ra_customers_interface
        SET customer_number = p_jgzz_fiscal_code
        WHERE rowid = p_row_id;
Line: 2307

        UPDATE ra_customers_interface
        SET customer_number = p_jgzz_fiscal_code||'-'||p_global_attribute12
        WHERE rowid = p_row_id;
Line: 2311

        UPDATE ra_customers_interface
        SET customer_number = p_jgzz_fiscal_code
        WHERE rowid = p_row_id;
Line: 2350

      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

  value_exists   VARCHAR2(1);
Line: 2384

           SELECT 'X'
             INTO value_exists
             FROM fnd_lookups
            WHERE  lookup_type =  'YES_NO'
              AND  lookup_code = p_global_attribute1
              AND  nvl(start_date_active,sysdate) <= sysdate
              AND  nvl(end_date_active,sysdate) >= sysdate
              AND  enabled_flag = 'Y';
Line: 2395

             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: 2405

        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: 2419

          SELECT  'X'
            INTO  value_exists
            FROM  jl_br_ap_operations
             WHERE  cfo_code = p_global_attribute2;
Line: 2425

            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: 2439

           SELECT 'X'
             INTO value_exists
             FROM fnd_lookups
            WHERE  lookup_type =  'JLBR_INVOICE_SERIES'
              AND  lookup_code = p_global_attribute3
              AND  nvl(start_date_active,sysdate) <= sysdate
              AND  nvl(end_date_active,sysdate) >= sysdate
              AND  enabled_flag = 'Y';
Line: 2450

             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: 2465

           SELECT 'X'
             INTO value_exists
             FROM fnd_lookups
            WHERE  lookup_type =  'JLBR_INVOICE_CLASS'
              AND  lookup_code = p_global_attribute4
              AND  nvl(start_date_active,sysdate) <= sysdate
              AND  nvl(end_date_active,sysdate) >= sysdate
              AND  enabled_flag = 'Y';
Line: 2476

             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: 2491

                  jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                    p_parent_id,
                                    'INVALID_GLOBAL_ATTR5',
                                    p_default_last_updated_by,
                                    p_default_last_update_login,
                                    p_calling_sequence);
Line: 2508

           SELECT invoice_date
             INTO p_val_date
             FROM ap_invoices_interface
            WHERE invoice_id = p_parent_id;
Line: 2518

           SELECT 'X'
             INTO value_exists
             FROM ap_tax_codes
            WHERE  tax_type =  'ICMS'
              AND  name = p_global_attribute6
              AND nvl(start_date,p_val_date) <= p_val_date
              AND nvl(inactive_date,p_val_date+1) > p_val_date
              AND nvl(enabled_flag,'Y') = 'Y';
Line: 2529

             jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                              p_parent_id,
                              'INVALID_GLOBAL_ATTR6',
                              p_default_last_updated_by,
                              p_default_last_update_login,
                              p_calling_sequence);
Line: 2544

                  jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                    p_parent_id,
                                    'INVALID_GLOBAL_ATTR7',
                                    p_default_last_updated_by,
                                    p_default_last_update_login,
                                    p_calling_sequence);
Line: 2557

                  jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                    p_parent_id,
                                    'INVALID_GLOBAL_ATTR8',
                                    p_default_last_updated_by,
                                    p_default_last_update_login,
                                    p_calling_sequence);
Line: 2570

                  jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                                    p_parent_id,
                                    'INVALID_GLOBAL_ATTR9',
                                    p_default_last_updated_by,
                                    p_default_last_update_login,
                                    p_calling_sequence);
Line: 2582

             jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                              p_parent_id,
                              'INVALID_GLOBAL_ATTR10',
                              p_default_last_updated_by,
                              p_default_last_update_login,
                              p_calling_sequence);
Line: 2606

        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: 2631

      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

  value_exists   VARCHAR2(1);
Line: 2663

           SELECT 'X'
             INTO value_exists
             FROM jl_br_ap_operations
            WHERE p_line_type_lookup_code = 'ITEM'
              AND CFO_CODE = p_global_attribute1;
Line: 2670

             jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
                             p_parent_id,
                              'INVALID_GLOBAL_ATTR1',
                              p_default_last_updated_by,
                              p_default_last_update_login,
                              p_calling_sequence);
Line: 2702

        jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
                                           p_parent_id,
                                         'GLOBAL_ATTR_VALUE_FOUND',
                                         p_default_last_updated_by,
                                       p_default_last_update_login,
                                          p_calling_sequence);
Line: 2717

      p_default_last_updated_by         IN    NUMBER,
      p_default_last_update_login       IN    NUMBER,
      p_current_invoice_status          OUT NOCOPY   VARCHAR2,
      p_calling_sequence                IN    VARCHAR2) IS

  l_invoice_id   NUMBER;
Line: 2730

      SELECT invoice_id,po_number
 INTO l_invoice_id,l_po_number
 FROM ap_invoice_lines_interface
       WHERE invoice_line_id = p_parent_id;
Line: 2740

  SELECT global_attribute2,global_attribute6,global_attribute7
    INTO l_cfo_code,l_icms_tax_name,l_icms_tax_amount
    FROM ap_invoices_interface
          WHERE invoice_id = l_invoice_id;
Line: 2751

               SELECT DISTINCT 1
                 INTO l_exists
                 FROM ap_interface_rejections
                 WHERE parent_id=l_invoice_id
                   AND parent_table = 'AP_INVOICES_INTERFACE'
                   AND REJECT_LOOKUP_CODE = 'INVALID_GLOBAL_ATTR2';
Line: 2759

                jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                             l_invoice_id,
                              'INVALID_GLOBAL_ATTR2',
                              p_default_last_updated_by,
                              p_default_last_update_login,
                              p_calling_sequence);
Line: 2809

     select to_number(l_inscription_type)
     into   l_num_check
     from   dual;
Line: 2819

          select to_number(l_inscription_number)
          into   l_num_check
          from   dual;
Line: 2827

          select to_number(l_inscription_branch)
          into   l_num_check
          from   dual;
Line: 2835

          select to_number(l_inscription_digit)
          into   l_num_check
          from   dual;
Line: 2875

   jg_globe_flex_val_shared.update_interface_status
   (l_row_id,
    'RA_CUSTOMERS_INTERFACE',
    l_error_code,
    p_record_status);
Line: 2911

    SELECT 1
    INTO dummy_code
    FROM fnd_lookups
    WHERE lookup_code=p_glob_attr_set2.global_attribute1
    AND  lookup_type = 'YES_NO'
    AND NVL(START_DATE_ACTIVE,SYSDATE) <= SYSDATE
    AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE
    AND ENABLED_FLAG = 'Y';
Line: 2930

    SELECT 1
    INTO dummy_code
    FROM fnd_lookups
    WHERE lookup_code=p_glob_attr_set2.global_attribute2
    AND  lookup_type = 'YES_NO'
    AND NVL(START_DATE_ACTIVE,SYSDATE) <= SYSDATE
    AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE
    AND ENABLED_FLAG = 'Y';
Line: 2951

   jg_globe_flex_val_shared.update_interface_status
   (l_row_id,
    'RA_CUSTOMER_PROFILES_INTERFACE',
    l_error_code,
    p_record_status);
Line: 2984

    SELECT tax_method_code
    INTO   l_tax_method
    FROM   zx_product_options;
Line: 2988

    SELECT substr(global_attribute13,1,30)
    INTO   l_tax_rule_set
    FROM   ar_system_parameters;
Line: 3004

          SELECT count(*)
          INTO   l_dummy
          FROM   jl_zz_ar_tx_att_cls tac,
                 jl_zz_ar_tx_categ tc
          WHERE  tac.tax_attr_class_code = p_glob_attr_set2.global_attribute8
          AND    tac.tax_attr_class_type = 'CONTRIBUTOR_CLASS'
          AND    tac.enabled_flag = 'Y'
          AND    tac.tax_category_id = tc.tax_category_id
          AND    tc.tax_rule_set = l_tax_rule_set;
Line: 3046

     jg_globe_flex_val_shared.update_interface_status (l_row_id,
           'RA_CUSTOMERS_INTERFACE',
           l_error_code,
           p_record_status);
Line: 3069

      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

  value_exists   VARCHAR2(1);
Line: 3102

           SELECT 'X'
             INTO value_exists
             FROM fnd_lookups
            WHERE  lookup_type =  'JLCL_AP_DOCUMENT_TYPE'
              AND  lookup_code = p_global_attribute19
              AND  nvl(start_date_active,sysdate) <= sysdate
              AND  nvl(end_date_active,sysdate) >= sysdate
              AND  enabled_flag = 'Y';
Line: 3113

              jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
                              p_parent_id,
                              'INVALID_GLOBAL_ATTR19',
                              p_default_last_updated_by,
                              p_default_last_update_login,
                              p_calling_sequence);
Line: 3147

        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);