DBA Data[Home] [Help]

APPS.PRP_MIGRATION_PVT SQL Statements

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

Line: 31

   p_last_updated_by                IN NUMBER,
   p_last_update_date               IN DATE,
   p_last_update_login              IN NUMBER
  )
IS
  PRAGMA AUTONOMOUS_TRANSACTION;
Line: 39

  INSERT INTO prp_migration_logs
    (
    migration_log_id,
    object_version_number,
    module_name,
    log_level,
    message_text,
    migration_code,
    created_by,
    creation_date,
    last_updated_by,
    last_update_date,
    last_update_login
    )
    VALUES
    (
    prp_migration_logs_s1.nextval,
    1,
    p_module_name,
    p_log_level,
    p_message_text,
    p_migration_code,
    p_created_by,
    p_creation_date,
    p_last_updated_by,
    p_last_update_date,
    p_last_update_login
    );