I want to see the source code for one of the standard concurrent program. can anyone help me out. how to see the source code
standard concurrent program name : GB Pensions Automatic Enrolment Process
Executable Name : PYUGEN
Executable Method : Spawned
can anyone help me out how to see the source code.
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 -
select * from pay_report_format_mappings_f
where report_type = 'GB_ENROLL_PEN';
If you see the columns RANGE_CODE, ARCHIVE_CODE etc.. you will find the main package is pay_gb_enroll_pension
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,
I have a requirment , where i need to create the replica of the standard concurrent program 'GB Pensions Automatic Enrolment Process" and make it custom conc program and do some amendments in to .
can you plz me out with the steps , which i need to follow to do the same.
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 ?