APPS.JE_ZZ_INVOICE_CREATE SQL Statements

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

Line: 24

 |  use to insert the HU data we want and pass back to the JG package         |
 |  indicating that everything passes validation.                             |
 *----------------------------------------------------------------------------*/
  PG_DEBUG varchar2(1);

Line: 61

         	arp_standard.debug('validate_gdff: ' || '-- Inserting HU specific GDF data');

Line: 64

	 update ar_trx_header_gt
	 set GLOBAL_ATTRIBUTE_CATEGORY = 'JE.HU.ARXTWMAI.TAX_DATE'
	 ,GLOBAL_ATTRIBUTE1= fnd_date.date_to_canonical(GL_DATE)
	 where request_id = p_request_id ;

Line: 79

         	arp_standard.debug('validate_gdff: ' || '-- Inserting PL specific GDF data');

Line: 82

         update ar_trx_header_gt
         set GLOBAL_ATTRIBUTE_CATEGORY = 'JE.PL.ARXTWMAI.TAX_DATE'
         ,   GLOBAL_ATTRIBUTE1    = fnd_date.date_to_canonical(GL_DATE)
         where request_id = p_request_id ;

Line: 100

         	arp_standard.debug('validate_gdff: ' || '-- Inserting CZ specific GDF data');

Line: 103

         update ar_trx_header_gt
         set GLOBAL_ATTRIBUTE_CATEGORY = 'JE.CZ.ARXTWMAI.TAX_DATE'
         ,  GLOBAL_ATTRIBUTE1    = fnd_date.date_to_canonical(GL_DATE)
         where request_id = p_request_id ;