eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_FLXDU_COLUMNS_PKG SQL Statements

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

Line: 25


            pqp_flxdu_columns_pkg.update_row
                  (x_flxdu_column_id            => x_flxdu_column_id
                  ,x_flxdu_column_name          => x_flxdu_column_name
                  ,x_flxdu_column_xml_tag       => x_flxdu_column_xml_tag
                  ,x_flxdu_column_data_type     => x_flxdu_column_data_type
                  ,x_flxdu_column_data_length   => x_flxdu_column_data_length
                  ,x_flxdu_seq_num              => x_flxdu_seq_num
                  ,x_flxdu_group_name           => x_flxdu_group_name
                  ,x_entity_type                => x_entity_type
                  ,x_required_flag              => x_required_flag
                  ,x_display_flag               => x_display_flag
                  ,x_description                => x_description
                  ,x_flxdu_column_xml_data      => x_flxdu_column_xml_data
                  ,x_object_version_number      => x_object_version_number
                  ,x_created_by                 => 1
                  ,x_creation_date              => sysdate
                  ,x_last_update_date           => sysdate
                  ,x_last_updated_by            => 1
                  ,x_last_update_login          => 0 );

Line: 47


                pqp_flxdu_columns_pkg.insert_row
                   (x_flxdu_column_id            => x_flxdu_column_id
                   ,x_flxdu_column_name          => x_flxdu_column_name
                   ,x_flxdu_column_xml_tag       => x_flxdu_column_xml_tag
                   ,x_flxdu_column_data_type     => x_flxdu_column_data_type
                   ,x_flxdu_column_data_length   => x_flxdu_column_data_length
                   ,x_flxdu_seq_num              => x_flxdu_seq_num
                   ,x_flxdu_group_name           => x_flxdu_group_name
                   ,x_entity_type                => x_entity_type
                   ,x_required_flag              => x_required_flag
                   ,x_display_flag               => x_display_flag
                   ,x_description                => x_description
                   ,x_flxdu_column_xml_data      => x_flxdu_column_xml_data
                   ,x_object_version_number      => x_object_version_number
                   ,x_created_by                 => 1
                   ,x_creation_date              => sysdate
                   ,x_last_update_date           => sysdate
                   ,x_last_updated_by            => 1
                   ,x_last_update_login          => 0 );

Line: 73


PROCEDURE insert_row
          (x_flxdu_column_id          IN NUMBER
          ,x_flxdu_column_name        IN VARCHAR2
          ,x_flxdu_column_xml_tag     IN VARCHAR2
          ,x_flxdu_column_data_type   IN VARCHAR2
          ,x_flxdu_column_data_length IN VARCHAR2
          ,x_flxdu_seq_num            IN NUMBER
          ,x_flxdu_group_name         IN VARCHAR2
          ,x_entity_type              IN VARCHAR2
          ,x_required_flag            IN VARCHAR2
          ,x_display_flag             IN VARCHAR2
          ,x_description              IN VARCHAR2
          ,x_flxdu_column_xml_data    IN VARCHAR2
          ,x_object_version_number    IN NUMBER
          ,x_created_by               IN NUMBER
          ,x_creation_date            IN DATE
          ,x_last_update_date         IN DATE
          ,x_last_updated_by          IN NUMBER
          ,x_last_update_login        IN NUMBER) is

           -- cursor to find no of rows being inserted
           CURSOR cur_flxdu_columns IS
           SELECT rowid
           FROM   pqp_flxdu_columns;

Line: 102


             INSERT INTO pqp_flxdu_columns
                     (flxdu_column_id
                     ,flxdu_column_name
                     ,flxdu_column_xml_tag
                     ,flxdu_column_data_type
                     ,flxdu_column_data_length
                     ,flxdu_seq_num
                     ,flxdu_group_name
                     ,entity_type
                     ,required_flag
                     ,display_flag
                     ,description
                     ,flxdu_column_xml_data
                     ,object_version_number
                     ,created_by
                     ,creation_date
                     ,last_update_date
                     ,last_updated_by
                     ,last_update_login)
                VALUES
                     (x_flxdu_column_id
                     ,x_flxdu_column_name
                     ,x_flxdu_column_xml_tag
                     ,x_flxdu_column_data_type
                     ,x_flxdu_column_data_length
                     ,x_flxdu_seq_num
                     ,x_flxdu_group_name
                     ,x_entity_type
                     ,x_required_flag
                     ,x_display_flag
                     ,x_description
                     ,x_flxdu_column_xml_data
                     ,x_object_version_number
                     ,x_created_by
                     ,x_creation_date
                     ,x_last_update_date
                     ,x_last_updated_by
                     ,x_last_update_login);

Line: 149


END insert_row;

Line: 155


PROCEDURE update_row
               (x_flxdu_column_id          IN NUMBER
               ,x_flxdu_column_name        IN VARCHAR2
               ,x_flxdu_column_xml_tag     IN VARCHAR2
               ,x_flxdu_column_data_type   IN VARCHAR2
               ,x_flxdu_column_data_length IN VARCHAR2
               ,x_flxdu_seq_num            IN NUMBER
               ,x_flxdu_group_name         IN VARCHAR2
               ,x_entity_type              IN VARCHAR2
               ,x_required_flag            IN VARCHAR2
               ,x_display_flag             IN VARCHAR2
               ,x_description              IN VARCHAR2
               ,x_flxdu_column_xml_data    IN VARCHAR2
               ,x_object_version_number    IN NUMBER
               ,x_created_by               IN NUMBER
               ,x_creation_date            IN DATE
               ,x_last_update_date         IN DATE
               ,x_last_updated_by          IN NUMBER
               ,x_last_update_login        IN NUMBER) IS
BEGIN
      -- update table pqp_flxdu_columns
      UPDATE pqp_flxdu_columns
      SET    flxdu_column_id             = x_flxdu_column_id
            ,flxdu_column_name           = x_flxdu_column_name
            ,flxdu_column_xml_tag        = x_flxdu_column_xml_tag
            ,flxdu_column_data_type      = x_flxdu_column_data_type
            ,flxdu_column_data_length    = x_flxdu_column_data_length
            ,flxdu_seq_num               = x_flxdu_seq_num
            ,flxdu_group_name            = x_flxdu_group_name
            ,entity_type                 = x_entity_type
            ,required_flag               = x_required_flag
            ,display_flag                = x_display_flag
            ,description                 = x_description
            ,flxdu_column_xml_data       = x_flxdu_column_xml_data
            ,object_version_number       = x_object_version_number
            ,created_by                  = x_created_by
            ,creation_date               = x_creation_date
            ,last_update_date            = x_last_update_date
            ,last_updated_by             = x_last_updated_by
            ,last_update_login           = x_last_update_login
      WHERE  flxdu_column_id = x_flxdu_column_id;

Line: 200


END update_row;