Re: URGENT HELP

[Ignacio Lulli <Ignacio_Lulli@PEOPLESOFT.COM>]

Michael,
The PRCSAPI.sqc receives the values that are sent by the Process Scheduler.
Navigate to Use - Process Types and choose "SQR report". There is a push
button that says something like SQR PARMS (sorry, I don't have it in front
of me).  In there, you will see that the OPRID of the user and his
RUN_CNTL_ID are sent as parameters to the SQR. Without these values, the
PRCSAPI.sqc would not be able to receive the proper values, and therefore
the SQR would not know what row to select from the run control record.

Your question was "where from do the variables *$prcs_oprid* and
*$prcs_run_cntl_id*  get these value from". The source is the Process Type
defined in the Process Scheduler. Hope it helps.
-IL





Michael Lee <MLee@AGCONSULT.COM> on 07/10/98 03:38:58 PM

Please respond to SQR-USERS@USA.NET

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Ignacio Lulli)
Subject:  Re: URGENT HELP




Ignacio,

I don't see how $prcs_oprid and $prcs_run_cntl_id are sent into the SQR
program as parameters from the Process Definition.

I think Paul hit it on the dot with:
The code you are looking for is in PRCSAPI.SQC.  The structure looks
something like this:
Your Program -> stdapi.sqc ->prcsapi.sqc -> Get-Run-Control-Parms
Hope this helps.
Paul


The process definition allows you to change run-time parameters... etc.

Nowhere in the process definition does it send oprid and run cntl id.  I
agree that Process Scheduler brings it in but the process definition does
not send the oprid and run control id.

Michael K. Lee
mlee@agconsult.com
Consultant
AG Consulting
http://www.agconsult.com






Ignacio_Lulli@PEOPLESOFT.COM on 07/10/98 06:22:12 AM

Please respond to SQR-USERS@USA.NET

To:   SQR-USERS@list.iex.net
cc:    (bcc: Michael Lee/Application Group)
Subject:  Re: URGENT HELP




The values for $prcs_oprid and $prcs_run_cntl_id are sent into the SQR
program as parameters from the PeopleSoft Process Definition. Navigate to
GO-PeopleTools-Process Scheduler and then Use-Process Definitions-Process
Definition Options. Here you will see the parameters that are sent. Hope
this helps.
-IL




Srinivasan S <srinivasan.seetharaman@DB.COM> on 07/09/98 10:54:11 PM
Please respond to SQR-USERS@USA.NET
To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Ignacio Lulli)
Subject:  URGENT HELP



Hi all,
     In the Init-Report procedure of the plain vanilla SQR , a call to the
procedure (SELECT-PARAMETERS) is made.This procedure is in the sqc(
hrrnctl1.sqc).
     There is a SQL statement in the procedure (SELECT-PARAMETERS) , which
selects the values from the runcontrol table for the entered operator id
and the runcontrol id.
My question is , where from do the variables *$prcs_oprid* and *
$prcs_run_cntl_id*  get these value from ,  for  entered operator id and
the runcontrol id. Could anyone also tell me as to how these variables get
the values.
I hope i have conveyed my problem correctly.
TIA,
Srini.