Refactor existance check for npm packages

What does this MR do and why?

Refactor existance check for npm packages

Do not rely on package_type column when doing existance check for npm packages.

References

Foundation: Prepare application code to read fr... (#548761 - closed)

Screenshots or screen recordings

No.

How to set up and validate locally

The publishing of npm package is working as expected docs.

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.