Allow destruction of records in archived pending_delete Projects

See merge request gitlab-org/gitlab!73863

This change stops the prevent-destroy permission from applying to records within
projects that are `pending_delete: true`. The purpose of the `prevent` is to
make "archived" projects reliably read-only, but this obviously shouldn't be the
case if someone is deleting a project.

This hasn't been an issue before since we relied on FK constraints to remove the
associated records after a project is deleted. But with the FKs going away in
the database decomposition effort, so too must our cascading destroys.

Changelog: fixed

Convert blob editor tabs to Pajamas

See merge request gitlab-org/gitlab!73993

Fixed minor typo in k8s management section

See merge request gitlab-org/gitlab!74297

Convert group explore tabs to Pajamas

See merge request gitlab-org/gitlab!73959

Fix help links for merge request approvals

See merge request gitlab-org/gitlab!74216

Resolve "Add a test for Partitioning.sync_partitions_ignore_db_error"

See merge request gitlab-org/gitlab!74234

Merge branch '334874-convert-table-in-admin-applications-and-admin-deploy-keys-table-to-pajamas-css' into 'master'

Update admin deploy keys table to comply with Pajamas design system

See merge request gitlab-org/gitlab!73860

Remove group created during test

See merge request gitlab-org/gitlab!74251

Pin dependency @graphql-eslint/eslint-plugin to 2.3.0

See merge request gitlab-org/gitlab!74101

Quarantine NPM package spec

See merge request gitlab-org/gitlab!73469

Upgrade GitLab Pages to 1.47.0

See merge request gitlab-org/gitlab!74280

Fix flaky specs due to rate limiter change

See merge request gitlab-org/gitlab!74264

Move srcs to module of ContentSecurityPolicy::Directives

See merge request gitlab-org/gitlab!73943

Track the continuous onboarding iteration 2 experiment

See merge request gitlab-org/gitlab!72836

Decouple group's storage table from feature flag

See merge request gitlab-org/gitlab!73237

Add version history to integrations response body

See merge request gitlab-org/gitlab!74254

Remove Apollo error suppression feature flag

See merge request gitlab-org/gitlab!74291

Convert markdown field tabs to pajamas

See merge request gitlab-org/gitlab!73987

Convert search tabs to Pajamas

See merge request gitlab-org/gitlab!73983

E2E: Create project with push rules for import spec

See merge request gitlab-org/gitlab!74289

Add ApplicationWorker.with_status for checking job status

See merge request gitlab-org/gitlab!73556

Rename vulnerability report empty state components

See merge request gitlab-org/gitlab!73745

Changelog: other
EE: true

Fix packager reported by Gemnasium for Gradle and Pipenv projects

See merge request gitlab-org/gitlab!74057

Clarify code comment for StripAttribute

See merge request gitlab-org/gitlab!74246

Add with_highest_role_minimal_access to statistics

See merge request gitlab-org/gitlab!73651

Changelog: other

Enable dependency proxy manifest lists

See merge request gitlab-org/gitlab!73821

Mark strings in GitLab's Slack app edit page for translation

See merge request gitlab-org/gitlab!74265

Add user README to users profile

See merge request gitlab-org/gitlab!73726

Release Infrastructure as Code (IaC) Scanning

See merge request gitlab-org/gitlab!73268

Update GlTab helpers

See merge request gitlab-org/gitlab!74181

Add support for includes:rules:exists in CI configs

See merge request gitlab-org/gitlab!71745