APPS.GL_ENCUMBRANCE_TYPES_PKG SQL Statements

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

Line: 22

  PROCEDURE select_row( recinfo IN OUT NOCOPY gl_encumbrance_types%ROWTYPE )  IS
  BEGIN
    SELECT  *
    INTO    recinfo
    FROM    gl_encumbrance_types
    WHERE   encumbrance_type_id = recinfo.encumbrance_type_id;

Line: 36

                            'gl_encumbrance_types.select_row');

Line: 38

  END select_row;

Line: 48

      SELECT 'Duplicate'
      FROM   GL_ENCUMBRANCE_TYPES et
      WHERE  et.encumbrance_type = x_name
      AND    (   (x_row_id is null)
              OR (et.rowid <> x_row_id));

Line: 78

      SELECT 'Duplicate'
      FROM   GL_ENCUMBRANCE_TYPES et
      WHERE  et.encumbrance_type_id = x_etid
      AND    (   (x_row_id is null)
              OR (et.rowid <> x_row_id));

Line: 108

      SELECT gl_encumbrance_types_s.NEXTVAL
      FROM dual;

Line: 134

  PROCEDURE select_columns(
              x_encumbrance_type_id			NUMBER,
	      x_encumbrance_type		IN OUT NOCOPY  VARCHAR2 ) IS

    recinfo gl_encumbrance_types%ROWTYPE;

Line: 142

    select_row( recinfo );

Line: 153

                            'gl_encumbrance_types.select_columns');

Line: 155

  END select_columns;

Line: 160

      SELECT meaning
        FROM gl_lookups
       WHERE lookup_type = 'LITERAL' AND lookup_code = 'ALL';

Line: 188

  PROCEDURE insert_row(
              x_rowid                           IN OUT NOCOPY  VARCHAR2,
              x_encumbrance_type_id             IN OUT NOCOPY  NUMBER,
              x_encumbrance_type_key            IN OUT NOCOPY  VARCHAR2,
              x_encumbrance_type                IN  VARCHAR2,
              x_enabled_flag                    IN  VARCHAR2,
              x_last_update_date                IN  DATE,
              x_last_updated_by                 IN  NUMBER,
              x_creation_date                   IN  DATE,
              x_created_by                      IN  NUMBER,
              x_last_update_login               IN  NUMBER,
              x_description                     IN  VARCHAR2) IS

    CURSOR C IS SELECT rowid FROM gl_encumbrance_types
                WHERE  encumbrance_type = x_encumbrance_type;

Line: 207

      SELECT gl_encumbrance_types_s.nextval
      INTO   x_encumbrance_type_id
      FROM   dual;

Line: 216

    INSERT INTO gl_encumbrance_types(
            encumbrance_type_id,
            encumbrance_type_key,
            encumbrance_type,
            enabled_flag,
            last_update_date,
            last_updated_by,
            creation_date,
            created_by,
            last_update_login,
            description
           )
    VALUES(x_encumbrance_type_id,
           x_encumbrance_type_key,
           x_encumbrance_type,
           x_enabled_flag,
           x_last_update_date,
           x_last_updated_by,
           x_creation_date,
           x_created_by,
           x_last_update_login,
           x_description);

Line: 247

  END insert_row;

Line: 250

  PROCEDURE update_row(
              x_encumbrance_type_id             IN  NUMBER,
              x_encumbrance_type                IN  VARCHAR2,
              x_enabled_flag                    IN  VARCHAR2,
              x_last_update_date                IN  DATE,
              x_last_updated_by                 IN  NUMBER,
              x_last_update_login               IN  NUMBER,
              x_description                     IN  VARCHAR2) IS

  BEGIN
    UPDATE gl_encumbrance_types
    SET    encumbrance_type     =  x_encumbrance_type,
           enabled_flag         =  x_enabled_flag,
           last_update_date     =  x_last_update_date,
           last_updated_by      =  x_last_updated_by,
           last_update_login    =  x_last_update_login,
           description          =  x_description
    WHERE  encumbrance_type_id  =  x_encumbrance_type_id;

Line: 272

  END update_row;

Line: 305

      /* Update only if force_edits is 'Y' or it is seed data */
      IF ((y_force_edits = 'Y') OR (y_owner = 'SEED')) THEN

         SELECT encumbrance_type_id
         INTO l_encumbrance_type_id
         FROM gl_encumbrance_types
         WHERE encumbrance_type_key = l_encumbrance_type_key;

Line: 314

         GL_ENCUMBRANCE_TYPES_PKG.update_row(
           x_encumbrance_type_id =>  l_encumbrance_type_id,
           x_encumbrance_type    =>  y_encumbrance_type,
           x_enabled_flag        =>  y_enabled_flag,
           x_last_update_date    =>  sysdate,
           x_last_updated_by     =>  l_user_id,
           x_last_update_login   =>  0,
           x_description         =>  y_description);

Line: 325

      GL_ENCUMBRANCE_TYPES_PKG.insert_row(
           x_rowid               =>  l_rowid,
           x_encumbrance_type_id => l_encumbrance_type_id,
           x_encumbrance_type_key => l_encumbrance_type_key,
           x_encumbrance_type    =>  y_encumbrance_type,
           x_enabled_flag        =>  y_enabled_flag,
           x_last_update_date    =>  sysdate,
           x_last_updated_by     =>  l_user_id,
           x_creation_date       =>  sysdate,
           x_created_by          =>  l_user_id,
           x_last_update_login   =>  0,
           x_description         =>  y_description);

Line: 356

    /* Update only if force_edits is 'Y' or it is seed data */
    IF ((x_force_edits = 'Y') OR (x_owner = 'SEED')) THEN

       UPDATE GL_ENCUMBRANCE_TYPES
       SET    encumbrance_type     =  x_encumbrance_type,
              description          =  x_description,
              last_update_date     =  sysdate,
              last_updated_by      =  l_user_id,
              last_update_login    =  0
       WHERE  encumbrance_type_key =  x_encumbrance_type_key
       AND    userenv('LANG') =
              ( SELECT language_code
                FROM  FND_LANGUAGES
                WHERE  installed_flag = 'B' );