This is version 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

Defining the Custom Function in the application#

1. Go to IMLN and identify the custom function in the X_UC_FUNCTIONS lexicon

• Saved Value is a unique 10 character code that is stored in the data base
• Displayed Value is the Function Name as declared in the data base
• Meaning is the product that the Function is intended to be used with

2. Invoke the custom function in your usercalc using an Operand Type of CF (Custom Function)

Defining the Custom Function in the data base#

1. The custom function must be named P2K_xxx_functionname where xxx is the customer code 2. Create the function in the data base as a data base function returning VARCHAR or NUMBER or BOOLEAN (true/false)

• No parameters may be defined in this function
• Variables can be passed, however, by setting their value prior to calling the custom function
  • Variables defined on the IMUC Variables tab are created in the usercalc as V_<variable name>
  • example: a Variable identified as Current Month FTE will be identified as V_CURRENT_MONTH_FTE in the SQL code
• If defining a PR usercalc you also have access to all the package variables that are used as part of the P2K_PMCALC package
• You also have access to the P2K_PMUCUTIL package variabls