APPS.PV_GE_HIST_LOG_PKG SQL Statements

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

Line: 38

PROCEDURE Insert_Row(
        px_entity_history_log_id   IN OUT NOCOPY NUMBER,
        px_object_version_number   IN OUT NOCOPY NUMBER,
        p_arc_history_for_entity_code    VARCHAR2,
        p_history_for_entity_id    NUMBER,
        p_message_code    VARCHAR2,
        p_history_category_code    VARCHAR2,
        p_created_by    NUMBER,
        p_creation_date    DATE,
        p_last_updated_by    NUMBER,
        p_last_update_date    DATE,
        p_last_update_login    NUMBER,
        p_partner_id    NUMBER,
        p_access_level_flag    VARCHAR2,
        p_interaction_level    NUMBER,
        p_COMMENTS    VARCHAR2
)

IS
 x_rowid    VARCHAR2(30);

Line: 66

 INSERT INTO pv_ge_history_log_b(
         entity_history_log_id,
         object_version_number,
         arc_history_for_entity_code,
         history_for_entity_id,
         message_code,
         history_category_code,
         created_by,
         creation_date,
         last_updated_by,
         last_update_date,
         last_update_login,
         partner_id,
         access_level_flag,
         interaction_level
 ) VALUES (
         DECODE( px_entity_history_log_id, FND_API.G_MISS_NUM, NULL, px_entity_history_log_id),
         DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
         DECODE( p_arc_history_for_entity_code, FND_API.g_miss_char, NULL, p_arc_history_for_entity_code),
         DECODE( p_history_for_entity_id, FND_API.G_MISS_NUM, NULL, p_history_for_entity_id),
         DECODE( p_message_code, FND_API.g_miss_char, NULL, p_message_code),
         DECODE( p_history_category_code, FND_API.g_miss_char, NULL, p_history_category_code),
         DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
         DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
         DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
         DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
         DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
         DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
         DECODE( p_access_level_flag, FND_API.g_miss_char, NULL, p_access_level_flag),
         DECODE( p_interaction_level, FND_API.G_MISS_NUM, NULL, p_interaction_level));

Line: 97

 INSERT INTO pv_ge_history_log_tl(
         entity_history_log_id ,
         language ,
         last_update_date ,
         last_updated_by ,
         creation_date ,
         created_by ,
         last_update_login ,
         source_lang ,
         COMMENTS
)
SELECT
         DECODE( px_entity_history_log_id, FND_API.G_MISS_NUM, NULL, px_entity_history_log_id),
         l.language_code,
         DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
         DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
         DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
         DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
         DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
         USERENV('LANG'),
         DECODE( p_COMMENTS , FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
 FROM fnd_languages l
 WHERE l.installed_flag IN ('I','B')
 AND   NOT EXISTS(SELECT NULL FROM pv_ge_history_log_tl t
                  WHERE t.entity_history_log_id = DECODE( px_entity_history_log_id, FND_API.G_MISS_NUM, NULL, px_entity_history_log_id)
                  AND   t.language = l.language_code);

Line: 123

END Insert_Row;

Line: 140

PROCEDURE Update_Row(
        p_entity_history_log_id    NUMBER,
        p_object_version_number   IN NUMBER,
        p_arc_history_for_entity_code    VARCHAR2,
        p_history_for_entity_id    NUMBER,
        p_message_code    VARCHAR2,
        p_history_category_code    VARCHAR2,
        p_last_updated_by    NUMBER,
        p_last_update_date    DATE,
        p_last_update_login    NUMBER,
        p_partner_id    NUMBER,
        p_access_level_flag    VARCHAR2,
        p_interaction_level    NUMBER,
        p_COMMENTS    VARCHAR2
)

IS
BEGIN
  Update pv_ge_history_log_b
  SET
            entity_history_log_id = DECODE( p_entity_history_log_id, null, entity_history_log_id, FND_API.G_MISS_NUM, null, p_entity_history_log_id),
          object_version_number = nvl(p_object_version_number,0) + 1 ,
            arc_history_for_entity_code = DECODE( p_arc_history_for_entity_code, null, arc_history_for_entity_code, FND_API.g_miss_char, null, p_arc_history_for_entity_code),
            history_for_entity_id = DECODE( p_history_for_entity_id, null, history_for_entity_id, FND_API.G_MISS_NUM, null, p_history_for_entity_id),
            message_code = DECODE( p_message_code, null, message_code, FND_API.g_miss_char, null, p_message_code),
            history_category_code = DECODE( p_history_category_code, null, history_category_code, FND_API.g_miss_char, null, p_history_category_code),
            last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
            last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
            last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
            partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
            access_level_flag = DECODE( p_access_level_flag, null, access_level_flag, FND_API.g_miss_char, null, p_access_level_flag),
            interaction_level = DECODE( p_interaction_level, null, interaction_level, FND_API.G_MISS_NUM, null, p_interaction_level)
 WHERE entity_history_log_id = p_entity_history_log_id
 AND   object_version_number = p_object_version_number;

Line: 175

 UPDATE pv_ge_history_log_tl
 set COMMENTS   = DECODE( p_COMMENTS, null, COMMENTS, FND_API.g_miss_char, null, p_COMMENTS),
     last_update_date   = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
     last_updated_by   = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
     last_update_login   = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
     source_lang = USERENV('LANG')
 WHERE entity_history_log_id = p_entity_history_log_id
 AND USERENV('LANG') IN (language, source_lang);

Line: 189

END Update_Row;

Line: 206

PROCEDURE Delete_Row(
  p_entity_history_log_id  NUMBER,
  p_object_version_number  NUMBER)
IS
BEGIN
 DELETE FROM pv_ge_history_log_b
  WHERE entity_history_log_id = p_entity_history_log_id
  AND object_version_number = p_object_version_number;

Line: 217

END Delete_Row ;

Line: 240

      SELECT *
       FROM pv_ge_history_log_b
      WHERE entity_history_log_id =  p_entity_history_log_id
      AND object_version_number = p_object_version_number
      FOR UPDATE OF entity_history_log_id NOWAIT;

Line: 279

  INSERT /*+ append parallel(tt) */ INTO  pv_ge_history_log_tl tt
  (
     entity_history_log_id,
     creation_date,
     created_by,
     last_update_date,
     last_updated_by,
     last_update_login,
     comments,
     language,
     source_lang
  )
  SELECT /*+ parallel(v) parallel(t) use_nl(t)  */ v.*
  FROM
     (
        SELECT /*+ no_merge ordered parallel(b) */
        b.entity_history_log_id,
        b.creation_date,
        b.created_by,
        b.last_update_date,
        b.last_updated_by,
        b.last_update_login,
        b.comments,
        l.language_code,
        b.source_lang
        FROM   pv_ge_history_log_tl B , FND_LANGUAGES L
        WHERE L.INSTALLED_FLAG IN ( 'I','B' ) AND B.LANGUAGE = USERENV ( 'LANG' )
     ) v
     ,  pv_ge_history_log_tl t
  WHERE t.entity_history_log_id(+) = v.entity_history_log_id
  AND t.language(+) = v.language_code
  AND t.entity_history_log_id IS NULL ;