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.JE_INTERFACE_VAL SQL Statements

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

Line: 10


      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_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_current_invoice_status    VARCHAR2(1)  := 'Y';

Line: 55


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


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


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


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


                    ||', 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: 230


      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_def_exp_acc_exists	VARCHAR2(1);

Line: 266


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


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


      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   (
    -- bug 1579266 this country uses global attribute 5,6,7
       -- (p_global_attribute5  IS NOT NULL) OR
       -- (p_global_attribute6  IS NOT NULL) OR
       -- (p_global_attribute7  IS NOT NULL) OR
       --   (p_global_attribute2  IS NOT NULL) OR
          (p_global_attribute8  IS NOT NULL) OR
          (p_global_attribute9  IS NOT NULL) OR
          (p_global_attribute10 IS NOT NULL) OR
          (p_global_attribute11 IS NOT NULL) OR
          (p_global_attribute12 IS NOT NULL) OR
          (p_global_attribute13 IS NOT NULL) OR
          (p_global_attribute14 IS NOT NULL) OR
          (p_global_attribute15 IS NOT NULL) OR
          (p_global_attribute16 IS NOT NULL) OR
          (p_global_attribute17 IS NOT NULL) OR
          (p_global_attribute18 IS NOT NULL) OR
          (p_global_attribute19 IS NOT NULL) OR
          (p_global_attribute20 IS NOT NULL))
    THEN

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


      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_attribute2 IS NOT NULL AND
	    p_global_attribute2 NOT IN ('Y','N'))  OR
       (p_global_attribute2 IS NULL) THEN

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


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


      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_stat_code_exists  VARCHAR2(1);

Line: 490


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


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


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


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

Line: 616


    SELECT 1
    INTO dummy_code
    FROM fnd_lookups
    WHERE lookup_code=p_glob_attr_set1.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: 636


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

Line: 662


    SELECT 1
    INTO dummy_code
    FROM fnd_lookups
    WHERE lookup_code=p_glob_attr_set3.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: 682


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