PeopleSoft Process Definition File Dependency
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* Process Sched Parameters */ | |
SELECT prcsinstance, | |
prcsfilename | |
FROM psprcsparms | |
ORDER BY prcsinstance DESC |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* Stored at Process Defn Level */ | |
SELECT prcsname, | |
prcsfilename | |
FROM ps_prcsdefn | |
WHERE prcsname LIKE 'TEST123' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* Stored at Run Control Level */ | |
SELECT a.prcsfilename, | |
a.* | |
FROM ps_prcsruncntldtl a | |
WHERE a.prcsname LIKE 'TEST123' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* Update Run Control to match current Process Definition */ | |
UPDATE ps_prcsruncntldtl a | |
SET a.prcsfilename = (SELECT c.prcsfilename | |
FROM ps_prcsdefn c | |
WHERE a.prcstype = c.prcstype | |
AND a.prcsname = c.prcsname) | |
WHERE a.prcstype = 'Application Engine' | |
AND a.prcsname = 'TEST123' | |
AND EXISTS (SELECT 'X' | |
FROM ps_prcsdefn b | |
WHERE a.prcstype = b.prcstype | |
AND a.prcsname = b.prcsname) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment