Peoplesoft

peoplecode action in application engine program

Hi,

The below once is my code in application engine program.My requirement is to calculate the values based on salary and print in my state record after running using runcontroll page.

[code]
/*using state record in sql action in step 1*/

%Select (BANK_ID,BANK_SAL,BANK_HRA,BANK_TA,BANK_TOT)
SELECT *
FROM PS_RUN_CNTL_AETPC
WHERE OPRID=%OperatorId
AND RUN_CNTL_ID=%RUNCONTROL;
/* using peoplecode action in step 2*/
Local number &SAL, &HR, &TA, &TOT;

&SAL = EXO_AEAET.BANK_SAL.Value;
If RUN_CNTL_AETPC.RUN_CNTL_ID.Value = %OperatorId Then

If &SAL > 1000 Then

give 1 example on peoplecode action in application engine program

Hi,

I need an example regarding peoplecode action in application engine program.

Thanks,
Deepa.

To print number in string

Hi all,

I have a SQL query with me which gives o/p in word if any digit is entered directly in oracle DB.

select to_char(to_date(1234567,'J'), 'JSP') as text_number from dua

Output:

TEXT_NUMBER
---------------------------------------------------------------------
ONE MILLION TWO HUNDRED THIRTY-FOUR THOUSAND FIVE HUNDRED SIXTY-SEVEN

Now,i have 1 field in Amount in a record..and i want to popup a message whenever a number is enter in this field...
I had tried with sql exec
like
&Amount=recname.fieldname.value;

running CI program using peoplecode

hi,
How can i run CI program using peoplecode.

Thanks,
Deepa.

Implementing 2D line chart in peoplesoft

Hi,
I have a dynamic view record on the page, On the same page i have to implement a chart (2D line) retrieving values from that table. How to go about regarding the code ? The plot has to be X axis( Labels) and Y axis( Percentage Levels).

PeopleSoft Trace

i found some info here in doing a trace: -trace 7 -toolstracepc 4044 (if you know the app engine pgm)
what if i'm trying to determine the app engine programs involved in DELETE USER PROFILE, or even all the programs.
I did some traces and i get the record people code involved but not finding whats doing all the deletes.

ISCRIPT

Hi all,

I want to learn IScript.I had gone through peoplebooks but endedup in learning HTML are only.Anybody who has practically implemented may please share their vies or documents so that im able to learn the exact use of Iscript and can practically implement them in my future tasks......

Thanks in advance.....
regards,

Paritosh

PeopleSoft XMLP, RTF template does not print well as PDF

We developed a new XML report. Setup for Report Defn for the template is RTF, and it runs thru the Financial Gateway (as part of ACH payment processing). The RTF template is landscape, as it has many columns of data. Template looks good, even with the many columns that it has.
Process runs just fine, but the output file of the PDF looks much different. The columns are all pushed together, and it looks terrible.
Is there some setting or trick to get the PDF output to look as nice as the RTF template?
Any suggestions are greatly apprepriated.

CI TO CI

Hi Need,

I want to transfer data from 1 CI TO CI ...The condition is like that...
if user clik on save button then data shoul flow to ci2 with validation and if user choose pending data should restricted within ci 1...
any help would be beneficial

How to upload Preventive Maintenance Data

I am trying to upload the preventive maintenance data from Passport (Different Software , 3rd party) to Peoplesoft environment. Do any one know any process for doing this task. like excel to CI or any ?