APPS.JE_ZZ_AUTO_INVOICE 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: 63

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

Line: 66

	 update ra_interface_lines_gt
	 set HEADER_GDF_ATTR_CATEGORY = 'JE.HU.ARXTWMAI.TAX_DATE'
	 ,   HEADER_GDF_ATTRIBUTE1    = fnd_date.date_to_canonical(GL_DATE)
	 where request_id = p_request_id ;

Line: 81

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

Line: 84

         update ra_interface_lines_gt
         set HEADER_GDF_ATTR_CATEGORY = 'JE.PL.ARXTWMAI.TAX_DATE'
         ,   HEADER_GDF_ATTRIBUTE1    = fnd_date.date_to_canonical(GL_DATE)
         where request_id = p_request_id ;

Line: 105

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

Line: 108

         update ra_interface_lines_gt
         set HEADER_GDF_ATTR_CATEGORY = 'JE.CZ.ARXTWMAI.TAX_DATE'
         ,   HEADER_GDF_ATTRIBUTE1    = fnd_date.date_to_canonical(GL_DATE)
         where request_id = p_request_id ;