APPS.GME_TEXT_DBL SQL Statements

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

Line: 5

   FUNCTION insert_header_row (
      p_header   IN              gme_text_header%ROWTYPE
     ,x_header   IN OUT NOCOPY   gme_text_header%ROWTYPE)
      RETURN BOOLEAN
   IS
      l_api_name   CONSTANT VARCHAR2 (30) := 'GET_ITEM_NO';

Line: 12

      INSERT INTO gme_text_header
                  (text_code, created_by
                  ,creation_date, last_updated_by
                  ,last_update_date)
           VALUES (gem5_text_code_s.NEXTVAL, gme_common_pvt.g_user_ident
                  ,gme_common_pvt.g_timestamp, gme_common_pvt.g_user_ident
                  ,gme_common_pvt.g_timestamp)
        RETURNING text_code
             INTO x_header.text_code;

Line: 28

   END insert_header_row;

Line: 30

   FUNCTION insert_text_row (
      p_text_row   IN              gme_text_table%ROWTYPE
     ,x_text_row   IN OUT NOCOPY   gme_text_table%ROWTYPE)
      RETURN BOOLEAN
   IS
      l_rowid               VARCHAR2 (40);

Line: 36

      l_api_name   CONSTANT VARCHAR2 (30) := 'insert_text_row';

Line: 38

      gma_gme_text_tbl_pkg.insert_row
                           (x_rowid                  => l_rowid
                           ,x_text_code              => p_text_row.text_code
                           ,x_lang_code              => p_text_row.lang_code
                           ,x_paragraph_code         => p_text_row.paragraph_code
                           ,x_sub_paracode           => p_text_row.sub_paracode
                           ,x_line_no                => p_text_row.line_no
                           ,x_text                   => p_text_row.text
                           ,x_creation_date          => gme_common_pvt.g_timestamp
                           ,x_created_by             => gme_common_pvt.g_user_ident
                           ,x_last_updated_by        => gme_common_pvt.g_user_ident
                           ,x_last_update_date       => gme_common_pvt.g_timestamp
                           ,x_last_update_login      => gme_common_pvt.g_login_id);

Line: 58

   END insert_text_row;