DBA Data[Home] [Help]

APPS.JG_GLOBE_FLEX_VAL SQL Statements

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

Line: 74

      SELECT fc.descriptive_flex_context_code
      FROM fnd_descr_flex_contexts fc
      WHERE fc.application_id = 7003
      AND fc.descriptive_flex_context_code = p_context_code
      AND fc.descriptive_flexfield_name = p_flexfield_name
      AND fc.enabled_flag = 'Y';
Line: 810

           TO_NUMBER(p_core_prod_arg5), -- Default Last Updated By
           TO_NUMBER(p_core_prod_arg6), -- Default Last Update Login
	   TO_NUMBER(p_core_prod_arg8), -- Vendor Site ID -For DK EDI
	   p_core_prod_arg9,		-- payment curency code - FOR DK EDI
           p_core_prod_arg10,           -- Item Type Lookup Code - FOR BR
           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,
           p_current_status,
           p_core_prod_arg7);          -- Current Calling Sequence
Line: 862

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

     l_credit_exists            VARCHAR2(1);
Line: 916

           p_default_last_updated_by,
           p_default_last_update_login,
           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_invoice_status1,
           l_curr_calling_sequence);          -- Current Calling Sequence
Line: 959

           p_default_last_updated_by,
           p_default_last_update_login,
      	   p_inv_vendor_site_id,
           p_inv_payment_currency_code,
           p_line_type_lookup_code,
           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_invoice_status2,
           l_curr_calling_sequence);          -- Current Calling Sequence
Line: 1005

                    ||', Last Updated By = '||to_char(p_default_last_updated_by)
                    ||', Last Update Login = '||to_char(p_default_last_update_login)
                    ||', 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: 1041

         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_current_invoice_status1       VARCHAR2(1);
Line: 1086

           p_default_last_updated_by,
           p_default_last_update_login,
           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_invoice_status1,
           l_curr_calling_sequence);          -- Current Calling Sequence
Line: 1119

           p_default_last_updated_by,
           p_default_last_update_login,
           p_global_attribute_category,
           l_current_invoice_status2,
           l_curr_calling_sequence);          -- Current Calling Sequence
Line: 1138

         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_debug_loc                     VARCHAR2(30);
Line: 1197

      jg_globe_flex_val_shared.insert_rejections(p_parent_table,
                        p_parent_id,
                        'GLOBAL_ATTR_VALUE_FOUND',
                        p_default_last_updated_by,
                        p_default_last_update_login,
                        p_calling_sequence);
Line: 1215

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

     l_debug_loc                     VARCHAR2(30);
Line: 1237

        jg_globe_flex_val_shared.insert_rejections(p_parent_table,
                          p_parent_id,
                          'INVALID_GLOBAL_CONTEXT',
                          p_default_last_updated_by,
                          p_default_last_update_login,
                          p_calling_sequence);
Line: 1263

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

     l_credit_exists VARCHAR2(1);
Line: 1385

      p_default_last_updated_by,
      p_default_last_update_login,
      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,
      p_current_invoice_status,
      p_calling_sequence);
Line: 1451

      p_default_last_updated_by,
      p_default_last_update_login,
      p_inv_vendor_site_id,
      p_inv_payment_currency_code,
      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,
      p_current_invoice_status,
      p_calling_sequence);
Line: 1492

      p_default_last_updated_by,
      p_default_last_update_login,
      p_line_type_lookup_code,
      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,
      p_current_invoice_status,
      p_calling_sequence);
Line: 1531

                    ||', Last Updated By = '||to_char(p_default_last_updated_by)
                    ||', Last Update Login = '||to_char(p_default_last_update_login)
                    ||', 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: 1572

                              p_last_update_login  IN   NUMBER,
                              p_int_table_name     IN   VARCHAR2
  ) IS

  l_current_status            VARCHAR2(1);
Line: 1601

    SELECT  i.customer_name, i.customer_number, i.jgzz_fiscal_code,
            i.orig_system_customer_ref,i.insert_update_flag,
            i.cust_tax_reference,
            i.global_attribute_category,i.global_attribute1,
            i.global_attribute2,i.global_attribute3,i.global_attribute4,
            i.global_attribute5,i.global_attribute6,i.global_attribute7,
            i.global_attribute8,i.global_attribute9,i.global_attribute10,
            i.global_attribute11,i.global_attribute12,i.global_attribute13,
            i.global_attribute14,i.global_attribute15,i.global_attribute16,
            i.global_attribute17,i.global_attribute18,i.global_attribute19,
            i.global_attribute20,
            i.gdf_address_attr_cat,i.gdf_address_attribute1,
            i.gdf_address_attribute2,i.gdf_address_attribute3,i.gdf_address_attribute4,
            i.gdf_address_attribute5,i.gdf_address_attribute6,i.gdf_address_attribute7,
            i.gdf_address_attribute8,i.gdf_address_attribute9,i.gdf_address_attribute10,
            i.gdf_address_attribute11,i.gdf_address_attribute12,i.gdf_address_attribute13,
            i.gdf_address_attribute14,i.gdf_address_attribute15,i.gdf_address_attribute16,
            i.gdf_address_attribute17,i.gdf_address_attribute18,i.gdf_address_attribute19,
            i.gdf_address_attribute20,
            i.gdf_site_use_attr_cat,i.gdf_site_use_attribute1,
            i.gdf_site_use_attribute2,i.gdf_site_use_attribute3,i.gdf_site_use_attribute4,
            i.gdf_site_use_attribute5,i.gdf_site_use_attribute6,i.gdf_site_use_attribute7,
            i.gdf_site_use_attribute8,i.gdf_site_use_attribute9,i.gdf_site_use_attribute10,
            i.gdf_site_use_attribute11,i.gdf_site_use_attribute12,i.gdf_site_use_attribute13,
            i.gdf_site_use_attribute14,i.gdf_site_use_attribute15,i.gdf_site_use_attribute16,
            i.gdf_site_use_attribute17,i.gdf_site_use_attribute18,i.gdf_site_use_attribute19,
            i.gdf_site_use_attribute20,
            i.rowid
    FROM    ra_customers_interface i
    WHERE   i.request_id = p_request_id
    AND     nvl(i.validated_flag,'N') <> 'Y';
Line: 1644

    SELECT  i.global_attribute_category,i.global_attribute1,
            i.global_attribute2,i.global_attribute3,i.global_attribute4,
            i.global_attribute5,i.global_attribute6,i.global_attribute7,
            i.global_attribute8,i.global_attribute9,i.global_attribute10,
            i.global_attribute11,i.global_attribute12,i.global_attribute13,
            i.global_attribute14,i.global_attribute15,i.global_attribute16,
            i.global_attribute17,i.global_attribute18,i.global_attribute19,
            i.global_attribute20,
            i.gdf_cust_prof_attr_cat,i.gdf_cust_prof_attribute1,
            i.gdf_cust_prof_attribute2,i.gdf_cust_prof_attribute3,i.gdf_cust_prof_attribute4,
            i.gdf_cust_prof_attribute5,i.gdf_cust_prof_attribute6,i.gdf_cust_prof_attribute7,
            i.gdf_cust_prof_attribute8,i.gdf_cust_prof_attribute9,i.gdf_cust_prof_attribute10,
            i.gdf_cust_prof_attribute11,i.gdf_cust_prof_attribute12,i.gdf_cust_prof_attribute13,
            i.gdf_cust_prof_attribute14,i.gdf_cust_prof_attribute15,i.gdf_cust_prof_attribute16,
            i.gdf_cust_prof_attribute17,i.gdf_cust_prof_attribute18,i.gdf_cust_prof_attribute19,
            i.gdf_cust_prof_attribute20,
            i.rowid
    FROM    ra_customer_profiles_interface i
    WHERE   i.request_id = p_request_id
    AND     nvl(i.validated_flag,'N') <> 'Y';
Line: 1676

    SELECT s.generate_customer_number
    FROM   ar_system_parameters s
    WHERE  s.set_of_books_id  = p_sob_id;
Line: 1786

         gdf_general_rec.core_prod_arg8  := idx_cur.insert_update_flag;
Line: 2093

          JG_GLOBE_FLEX_VAL_SHARED.UPDATE_RA_CUSTOMERS_INTERFACE(
                                l_errcode,
                                p_glob_attr_general.core_prod_arg2,
                                'E');
Line: 2131

      JG_GLOBE_FLEX_VAL_SHARED.UPDATE_INTERFACE_STATUS(
                                p_glob_attr_general.core_prod_arg2,
                                'RA_CUSTOMER_PROFILES_INTERFACE',
                                l_errcode,
                                'E');
Line: 2176

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

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

    SELECT org_id into l_org_id FROM fnd_concurrent_requests
    WHERE request_id = fnd_global.conc_request_id ;
Line: 2377

PROCEDURE insert_jg_zz_invoice_info
     (p_invoice_id                      IN     NUMBER,
      p_global_attribute_category       IN OUT NOCOPY VARCHAR2,
      p_global_attribute1               IN OUT NOCOPY VARCHAR2,
      p_global_attribute2               IN OUT NOCOPY VARCHAR2,
      p_global_attribute3               IN OUT NOCOPY VARCHAR2,
      p_global_attribute4               IN OUT NOCOPY VARCHAR2,
      p_global_attribute5               IN OUT NOCOPY VARCHAR2,
      p_global_attribute6               IN OUT NOCOPY VARCHAR2,
      p_global_attribute7               IN OUT NOCOPY VARCHAR2,
      p_global_attribute8               IN OUT NOCOPY VARCHAR2,
      p_global_attribute9               IN OUT NOCOPY VARCHAR2,
      p_global_attribute10              IN OUT NOCOPY VARCHAR2,
      p_global_attribute11              IN OUT NOCOPY VARCHAR2,
      p_global_attribute12              IN OUT NOCOPY VARCHAR2,
      p_global_attribute13              IN OUT NOCOPY VARCHAR2,
      p_global_attribute14              IN OUT NOCOPY VARCHAR2,
      p_global_attribute15              IN OUT NOCOPY VARCHAR2,
      p_global_attribute16              IN OUT NOCOPY VARCHAR2,
      p_global_attribute17              IN OUT NOCOPY VARCHAR2,
      p_global_attribute18              IN OUT NOCOPY VARCHAR2,
      p_global_attribute19              IN OUT NOCOPY VARCHAR2,
      p_global_attribute20              IN OUT NOCOPY VARCHAR2,
      p_last_updated_by                 IN     NUMBER,
      p_last_update_date                IN     DATE,
      p_last_update_login               IN     NUMBER,
      p_created_by                      IN     NUMBER,
      p_creation_date                   IN     DATE,
      p_calling_sequence                IN     VARCHAR2) IS

        l_debug_loc                     VARCHAR2(30);
Line: 2520

  PROCEDURE insert_global_tables
     (p_table_name        IN VARCHAR2,
      p_key_column1       IN VARCHAR2,
      p_key_column2       IN VARCHAR2,
      p_key_column3       IN VARCHAR2,
      p_key_column4       IN VARCHAR2,
      p_key_column5       IN VARCHAR2,
      p_key_column6       IN VARCHAR2) IS

    l_product_code  VARCHAR2(2);
Line: 2554

      arp_standard.debug('Exception calling JG_GLOBE_FLEX_VAL.insert_global_tabl
es');