APPS.PA_VALUE_MAP_DEF_PKG SQL Statements

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

Line: 9

PROCEDURE update_row
      ( p_value_map_def_id                 IN NUMBER                               ,
        p_record_version_number            IN NUMBER                               ,
        x_return_status              OUT  NOCOPY VARCHAR2                          , --File.Sql.39 bug 4440895
        x_msg_count                  OUT  NOCOPY NUMBER                            , --File.Sql.39 bug 4440895
        x_msg_data                   OUT  NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

IS
  l_record_version_number NUMBER;

Line: 30

  UPDATE pa_value_map_defs
    SET
		    record_version_number   = DECODE(p_record_version_number, NULL, record_version_number, l_record_version_number)                             ,
        creation_date           = sysdate                      ,
        created_by              = fnd_global.user_id           ,
        last_update_date        = sysdate                      ,
        last_updated_by         = fnd_global.user_id           ,
        last_update_login       = fnd_global.login_id
        WHERE value_map_def_id  = p_value_map_def_id
        AND   nvl(p_record_version_number, record_version_number) = record_version_number;

Line: 69

                          p_procedure_name   => 'update_row');

Line: 72

END update_row;