APPS.GL_BUDGET_BATCHES_PKG SQL Statements

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

Line: 8

  PROCEDURE insert_budget(
  			x_budget_version_id	NUMBER,
			x_ledger_id             NUMBER,
			x_last_updated_by	NUMBER) IS

  BEGIN

    INSERT INTO GL_BUDGET_BATCHES
      (budget_version_id, recurring_batch_id,
       status, last_update_date, last_updated_by)
    SELECT
      x_budget_version_id, recurring_batch_id,
      'U', sysdate, x_last_updated_by
    FROM  gl_recurring_batches
    WHERE budget_flag = 'Y'
    AND   ledger_id = x_ledger_id;

Line: 33

                            'gl_budget_batches_pkg.insert_budget');

Line: 35

  END insert_budget;

Line: 39

  PROCEDURE insert_recurring(
                        x_recurring_batch_id    NUMBER,
                        x_last_updated_by       NUMBER) IS

  BEGIN

    INSERT INTO GL_BUDGET_BATCHES
      (budget_version_id, recurring_batch_id,
       status, last_update_date, last_updated_by)
    SELECT
      budget_version_id, x_recurring_batch_id,
      'U', sysdate, x_last_updated_by
    FROM  gl_budget_versions;

Line: 61

                            'gl_budget_batches_pkg.insert_recurring');

Line: 63

  END insert_recurring;

Line: 67

  PROCEDURE delete_recurring(
                        x_recurring_batch_id    NUMBER ) IS

  BEGIN

    DELETE
    FROM   gl_budget_batches
    WHERE  recurring_batch_id = x_recurring_batch_id;

Line: 84

                            'gl_budget_batches_pkg.delete_recurring');

Line: 86

  END delete_recurring;

Line: 90

  PROCEDURE select_row( recinfo IN OUT NOCOPY gl_budget_batches%ROWTYPE )  IS
  BEGIN
    SELECT  *
    INTO    recinfo
    FROM    gl_budget_batches
    WHERE   budget_version_id = recinfo.budget_version_id
    AND     recurring_batch_id = recinfo.recurring_batch_id;

Line: 105

                            'gl_budget_batches_pkg.select_row');

Line: 107

  END select_row;

Line: 111

  PROCEDURE select_columns(
    x_budget_version_id                 NUMBER,
    x_recurring_batch_id                NUMBER,
    x_last_executed_date                IN OUT NOCOPY  DATE,
    x_last_executed_start_period        IN OUT NOCOPY  VARCHAR2,
    x_last_executed_end_period          IN OUT NOCOPY  VARCHAR2,
    x_status                            IN OUT NOCOPY  VARCHAR2 )  IS

    recinfo gl_budget_batches%ROWTYPE;

Line: 124

    select_row( recinfo );

Line: 139

                            'gl_budget_batches_pkg.select_columns');

Line: 141

  END select_columns;