This content has been marked as final. Show 8 replies
PYUGEN is based on C or Pro*C code.
But sometimes internally it would call pl/sql packages based on the type of parameters.
For GB Pensions Automatic Enrolment Process
The Process Name parameter has a value 'ARCHIVE'
So, the data is stored in PAY_ACTION_INFORMATION.
And Report Type = 'GB_ENROLL_PEN'
And you can find the code in -
If you see the columns RANGE_CODE, ARCHIVE_CODE etc.. you will find the main package is pay_gb_enroll_pension
select * from pay_report_format_mappings_f where report_type = 'GB_ENROLL_PEN';
Each procedure in the package is called in a sequential order.
And the main logic would be in the Archive_code - pay_gb_enroll_pension.archive_code
Hope that helps,
There is execution method for each concurrent program (CP) .
If CP is of exe.method = PL/SQL Stored procedure then you can see the source code thru tool like Toad or using the table name : all_source .
If CP is of exe.method = oracle report, then review it using oracle report builder.
Also, visit following link for more info.
How to find the source code (package/function..) of a concurrent Program
How to open the Spawned Concurrent program files?..
I would not say it is impossible, but its a tedious job to replicate it using PYUGEN.
There is so much metadata you need to seed into tables like pay_report_format_mappings_f, pay_report_format_parameters etc..
And you need to make sure the concurrent program is defined in a particular way.
So, I wouldn't go that way..
But all the logic is in the package pay_gb_enroll_pension
So you can have a custom one based on it(not be PYUGEN based)
Thanks for your valuable info.
i have seen the package "pay_gb_enroll_pension" and yes all logic lies in the package.
i want to have a plsql based custom one for this standard package.
can you guide me me with the steps which i need to follow to create the custom program.
my doubts are
the standard concurrent program is having 16 parameters,
the package ' pay_gb_enroll_pension' none of the procedure in that package is having all the parametres.
i think program is having executable_type 'pyugen'(spawned) in which it is calling the package.
can you guide on this.
Thanks in advance
You dont have to use all the parameters.
Some parameters are used by PYUGEN to identify metadata.
So you can base your Pl/Sql on your actual requirement with the necessary parameters.
Just curious to know - Why do you want to replicate the Pensions process ?
Does the standard funcationality not work ?