APPS.JG_ZZ_AR_AUTO_INVOICE SQL Statements

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

Line: 10

          SELECT 'YES' INTO l_exist
          FROM fnd_descr_flex_contexts
          WHERE application_id  = 7003
          AND descriptive_flexfield_name like 'JG_RA_CUSTOMER_TRX_LINES'
          AND descriptive_flex_context_code like '%ARXTWMAI.REGISTER_INFO%'
          AND substr(descriptive_flex_context_code, 4, 2) =  l_country_code;

Line: 45

         Select l.trx_number
               ,l.customer_trx_id
           From ra_customer_trx_all l
          Where l.request_id = x_request_id
            And l.complete_flag = 'Y'
            And l.customer_trx_id Is Not Null;

Line: 53

           SELECT substr(global_attribute2,1,4),
                  substr(global_attribute3,1,1),
                  auto_trx_numbering_flag,
		  global_attribute8,
                  global_attribute9
            FROM   ra_batch_sources_all
            WHERE  batch_source_id = l_batch_source_id;

Line: 99

         Select To_number(cr.argument3)
         Into l_batch_source_id
         From fnd_concurrent_requests cr
         Where request_id = p_request_id;

Line: 137

               Update ra_customer_trx_all
                  Set trx_number = trx_number(j)
                Where customer_trx_id = customer_trx_id(j)
                  and request_id = p_request_id;

Line: 150

         SELECT to_number(cr.argument3)
                INTO l_batch_source_id
                FROM fnd_concurrent_requests cr
                WHERE request_id = p_request_id;

Line: 160

             SELECT B.batch_source_id INTO temp1
                 FROM ra_customer_trx_all A, ra_customer_trx_all B
                 WHERE A.RECURRED_FROM_TRX_NUMBER = B.trx_number
                       AND A.trx_number = trx_number(1) AND B.ORG_ID = f_org_id and rownum =1;

Line: 166

                 SELECT GLOBAL_ATTRIBUTE1 INTO temp2
                       FROM RA_BATCH_SOURCES_ALL WHERE BATCH_SOURCE_ID = temp1;

Line: 209

               UPDATE ra_customer_trx_all
                  SET trx_number = trx_number(j),
		      global_attribute17 = l_cai_num,
		      global_attribute18 = l_cai_due_date
                WHERE customer_trx_id = customer_trx_id(j)
                  AND request_id = p_request_id;

Line: 226

         SELECT l.customer_trx_id
           FROM ra_customer_trx_all l
           WHERE l.request_id = p_request_id
            --And l.complete_flag = 'Y'
           AND l.customer_trx_id IS NOT NULL;

Line: 233

            SELECT A.customer_trx_line_id line_id, B.cust_trx_line_gl_dist_id dist_id
	      FROM ra_customer_trx_lines_all A ,ra_cust_trx_line_gl_dist_all B
              WHERE A.customer_trx_id = p_trx_id AND
                    A.customer_trx_line_id = B.customer_trx_line_id
		    AND ROWNUM = 1;

Line: 274

         SELECT TO_NUMBER(cr.argument3)
                INTO l_batch_source_id
             FROM fnd_concurrent_requests cr
             WHERE request_id = p_request_id;

Line: 279

	 SELECT name INTO l_batch_source_name
	     FROM RA_BATCH_SOURCES_ALL
	     WHERE batch_source_id = l_batch_source_id;

Line: 316

	     l_debug_loc := 'Inserting into Interface Error over limit transactions';

Line: 319

		      INSERT INTO ra_interface_errors(
                             interface_line_id,
                             interface_distribution_id,
                             message_text,
                             org_id)
                         VALUES(
                             C_Reject_Entry_Rec.line_id,
                             C_Reject_Entry_Rec.dist_id,
                             l_message_text,
                             l_org_id);