glints.public

Parameters

Name	Type	Mode
userId	uuid	IN
vjobOrderId	uuid	IN

Definition

DECLARE
      "var_mergedTalentProfileId" UUID;
      "var_candidacyId" UUID;
      "var_inboundApplicationId" UUID;
      "var_candidacyUnsuitedId" UUID;
      "var_candidacySourcedId" UUID;
    BEGIN
      SELECT ITPGU."MergedTalentProfileId", C.id, C."inboundApplicationId", CU.id, CS.id
          INTO "var_mergedTalentProfileId", "var_candidacyId", "var_inboundApplicationId", "var_candidacyUnsuitedId", "var_candidacySourcedId"
        FROM public."InternalTalentProfileGlintsUsers" ITPGU
          INNER JOIN superpowered."Candidacies" C ON ITPGU."MergedTalentProfileId" = C."mergedTalentProfileId"
          INNER JOIN superpowered."CandidacyUnsuiteds" CU ON C.id = CU."candidacyId"
          LEFT JOIN superpowered."CandidacySourceds" CS ON C.id = CS."candidacyId"
        WHERE ITPGU."sourceProfileId" = "userId" AND C."jobOrderId" = "vjobOrderId" LIMIT 1;

      RAISE NOTICE 'MergedTalentProfileId: %', "var_mergedTalentProfileId";
      RAISE NOTICE 'CandidacyId: %', "var_candidacyId";
      RAISE NOTICE 'InboundApplicationId: %', "var_inboundApplicationId";
      RAISE NOTICE 'CandidacyUnsuitedId: %', "var_candidacyUnsuitedId";
      RAISE NOTICE 'CandidacySourcedId: %', "var_candidacySourcedId";

      IF "var_candidacyId" IS NULL THEN
        RAISE EXCEPTION 'Candidacy rejection not found for userId and jobOrderId: (%, %)', "userId", "vjobOrderId";
      END IF;

      IF "var_inboundApplicationId" IS NULL OR "var_candidacySourcedId" IS NOT NULL THEN
        RAISE NOTICE 'REVERTING Candidacy Rejection';
        DELETE FROM superpowered."CandidacyUnsuiteds" CU WHERE CU."candidacyId" = "var_candidacyId";
      ELSE
        RAISE NOTICE 'REVERTING InboundApplication Rejection';
        DELETE FROM superpowered."Candidacies" C WHERE C."candidacyId" = "var_candidacyId";
      END IF;

      RAISE NOTICE 'SUCCESS';
    END

revertSPWDRejection(IN "userId" uuid, IN "vjobOrderId" uuid)

Parameters

Definition