[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: URGENT HELP



3 answers:

1.  Look in the PeopleSoft-provided SQCs prcsdef.sqc and prcsapi.sqc .  These are the 2 main places where Process Scheduler activities are handled.

2.  Any PeopleSoft SQR documentation covers this at length - the SQL/SQR Training Course manual (4 day class), the PeopleTools books (and PeopleBooks) and a white paper available on the PeopleSoft web site (Process Scheduler Answer Book by Tushar Chury).  

3.  I hope you are not trying to write PeopleSoft Process Scheduler API-aware programs without training or documentation.  That is scary.   It is hard enough to understand with documentation since it could be described as a big "hack job" to start with.  Even the PeopleSoft-provided SQR's don't always follow their own standards so you cannot always look at their code for *good* examples.  

So, in summary, get some help, quick, please.

Don



>>> Srinivasan S <srinivasan.seetharaman@DB.COM> 07/10 1:54 AM >>>
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.