Modification of a Custom Package (CFP)

Hi,

I use a modification of the template and the package custom_obj_sys.

Here the preparation:

I created a new template_id SWWCustomLuPackageBody as a copy from CustomLuPackageBody. Btw: SWW is a shortcut for our company ;-). I modified the template like this:

Then I modified the package custom_obj_sys.gen_apy_code___ to use my template.

and at the end of the procedure I go to my own procedure Replace_Tag.

In Replace_Code__ the comment inside the template will be removed.

That’s all for the preparation.

And now the explanation what happens using an example:

I create a custom LU named AEBComplianceCheck and I want a validation check before insert. The name of the package is AEB_Compliance_Check_Clp.

Now I create a package named AEB_Compliance_Check_SWW_Clp and add a procedure Before_Insert___.

And now here is the clue.

If the custom LU will be recreated by using the procedure Custom_Obj_Sys.Gen_Apy_Code. But now it is using my template (with my modification) and the procedure Replace_Tag will check if there is a package similar named like the LU package but with ..SWW_Clp and lookup for a an equal procedure name. If the procedure exist in ...SWW_Clp the comment in the template will be removed and replaced with my own package_name. That’s it.

And now every new creation of the custom LU has no effect on my validation check.

I use it often and I use it for custom fields also (with another template of course ;-).

I hope my explanation is understandable ;-)

Regards,

Burkhard

Hi Callum,

this looks like a great idea without touching the core code as Execute Online SQL seems to accept anonymous PL/SQL blocks. Thank you!

regards,

Rafal