APPS.GL_CONS_BATCHES_PKG SQL Statements

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

Line: 8

  FUNCTION Insert_Consolidation_Batches(
	X_Batch_Query_Options_Flag VARCHAR2,
        X_Consolidation_Id        NUMBER,
        X_Consolidation_Run_Id    NUMBER,
        X_Last_Updated_By         NUMBER,
        X_From_Ledger_Id          NUMBER,
        X_To_Ledger_Id            NUMBER,
	X_Default_Period_Name     VARCHAR2,
	X_Currency_Code           VARCHAR2) RETURN BOOLEAN IS

   CURSOR batches is
   SELECT consolidation_run_id
     FROM GL_CONS_BATCHES glcb
    WHERE  glcb.consolidation_run_id = X_Consolidation_run_Id;

Line: 28

      INSERT INTO GL_CONS_BATCHES
        (consolidation_id, consolidation_run_id, je_batch_id,
         last_update_date, last_updated_by)
      SELECT DISTINCT X_Consolidation_Id, X_Consolidation_Run_Id,
         h.je_batch_id, sysdate, X_Last_Updated_By
      FROM   GL_JE_HEADERS h
      WHERE h.status = 'P'
      AND   h.ACTUAL_FLAG = 'A'
      AND   h.period_name = X_Default_Period_Name
      AND   h.ledger_id = X_From_Ledger_Id
      AND  NOT EXISTS
          (select 'X'
           from   gl_cons_batches cb, gl_consolidation c,
                  gl_consolidation_history ch
           where  c.consolidation_id = cb.consolidation_id
           and    c.to_ledger_id = X_To_Ledger_Id
           and    cb.je_batch_id = h.je_batch_id
           and    ch.consolidation_run_id = cb.consolidation_run_id
           and    ch.to_currency_code = X_Currency_Code
	   and    c.consolidation_id = X_Consolidation_Id);

Line: 50

      INSERT INTO GL_CONS_BATCHES
        (consolidation_id, consolidation_run_id, je_batch_id,
         last_update_date, last_updated_by)
      SELECT DISTINCT
         X_Consolidation_Id, X_Consolidation_Run_Id, h.je_batch_id,
         sysdate, X_Last_Updated_By
      FROM   GL_JE_HEADERS h
      WHERE  status = 'P'
      AND    ACTUAL_FLAG = 'A'
      AND    period_name = X_Default_Period_Name
      AND    h.ledger_id = X_From_Ledger_Id
      AND  EXISTS
          (select 'X'
           from   gl_cons_batches cb, gl_consolidation c,
                  gl_consolidation_history ch
           where  c.consolidation_id = cb.consolidation_id
           and    c.to_ledger_id = X_To_Ledger_Id
           and    cb.je_batch_id = h.je_batch_id
           and    ch.consolidation_run_id = cb.consolidation_run_id
           and    ch.to_currency_code = X_Currency_Code
	   and    c.consolidation_id = X_Consolidation_Id);

Line: 72

       INSERT INTO GL_CONS_BATCHES
        (consolidation_id, consolidation_run_id, je_batch_id,
         last_update_date, last_updated_by)
      SELECT DISTINCT
         X_Consolidation_Id, X_Consolidation_Run_Id, h.je_batch_id,
         sysdate, X_Last_Updated_By
      FROM   GL_JE_HEADERS h
      WHERE  status = 'P'
      AND    ACTUAL_FLAG = 'A'
      AND    period_name = X_Default_Period_Name
      AND    h.ledger_id = X_From_Ledger_Id;

Line: 97

  END Insert_Consolidation_Batches;

Line: 105

  PROCEDURE Insert_Cons_Batch(
        X_Consolidation_Id        NUMBER,
        X_Consolidation_Run_Id    NUMBER,
	X_Je_Batch_Id		  NUMBER,
        X_User_Id                 NUMBER) IS

  BEGIN

    INSERT INTO gl_cons_batches
      (consolidation_id, consolidation_run_id, je_batch_id,
       last_update_date, last_updated_by) values
      (X_Consolidation_Id, X_Consolidation_Run_Id, X_Je_Batch_Id,
       sysdate, X_User_Id);

Line: 119

  END Insert_Cons_Batch;

Line: 127

  PROCEDURE Delete_Cons_Batch( X_Je_Batch_Id  NUMBER) IS

  BEGIN

    DELETE FROM gl_cons_batches
      where je_batch_id = X_Je_Batch_Id;

Line: 135

  END Delete_Cons_Batch;

Line: 145

    DELETE FROM gl_cons_batches cb
    WHERE cb.consolidation_run_id = p_consolidation_run_id;