1. Extensibility Guide
  2. Customize Database Objects
  3. Developer’s Tips

4.12 Developer’s Tips

Suppose the account number generation needs to be customized different from what OFSLL generates. Requirement is to replace the baseline format with its own format (like ACC-NNNNNNN).

Locate the procedure that generates the account number.
  • Procedure set_acc_nbr from program aaiacc_en_111_01.pkb generates account number in YYYYMMNNNNNNND format.
Identify the exit point package having the set_acc_nbr_xxx procedures where xxx is bfr – before, afr - after and rep – replace.
  • aaiprc_ex_111_01.pks and aaiprc_ex_111_01.pkb
  • Create new package with name as xyzaaiacc_en_111_01.pkb. Add procedure to create account number in new format.
  • Copy “aaiprc_ex_111_01.pks” to “xyzaaiprc_ex_111_01.pks”
  • Modify “xyzaaiprc_ex_111_01.pks”, change constant 3CV_SET_ACC_NBR_REP CONSTANT VARCHAR2(30) := cmncon_cl_000_01.NOT_CUSTOMIZED;

Parent topic: Customize Database Objects