APPS.GL_IMPORT_REFERENCES_PKG SQL Statements

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

Line: 3

  PROCEDURE delete_line(X_header_id NUMBER, X_line_num NUMBER )  IS
       /*    It deletes a line in gl_import_references
             when a corresponding line is deleted in je_lines  */
  BEGIN
          DELETE FROM GL_IMPORT_REFERENCES
          WHERE  je_header_id = X_header_id
          AND je_line_num = X_line_num;

Line: 14

  END delete_line;

Line: 16

  PROCEDURE delete_lines(X_header_id NUMBER )  IS
       /*    It deletes all lines in gl_import_references
             when a corresponding line is deleted in je_lines  */

  BEGIN
          DELETE FROM GL_IMPORT_REFERENCES
          WHERE  je_header_id = X_header_id;

Line: 27

  END delete_lines;

Line: 29

  PROCEDURE delete_header(X_header_id NUMBER ) IS
    /*   It Deletes a header in gl_import_references while a header
         is deleted gl_je_headers     */
  BEGIN
            DELETE FROM GL_IMPORT_REFERENCES
            WHERE  je_header_id = X_header_id;

Line: 39

  END delete_header;

Line: 41

  PROCEDURE delete_batch(X_batch_id NUMBER ) IS
      /*  It deletes a batch in gl_import_references while a batch
          is deleted in gl_je_batches*/
  BEGIN
            DELETE FROM GL_IMPORT_REFERENCES
            WHERE  je_header_id IN
	    (select je_header_id FROM gl_je_headers WHERE je_batch_id = X_batch_id );

Line: 52

  END delete_batch;