Procedure Definition#

Procedures are special functions that invoke other functions. They are defined on the Define User Procedures IMPC form.

Each procedure consists of a procedure header and procedure steps. The step information has some overflow information below.


Procedure Header#

Procedure Name
This field is a code that uniquely identifies the procedure (e.g. NEWHIRE). Procedure Name is a mandatory 30 character alphanumeric field assigned by you. Procedure Names should not contain any spaces or special characters such as !, @, #, $, %, ^, &, *, ?, /, \, etc. Dashes (-) and underscores (_) are allowed.
Description
This field describes the purpose of the procedure. Description is an optional 50 character alphanumeric field assigned by you.
Product
This field identifies the module that the procedure belongs to (e.g. CM, HR, AT, BE,PR, ...). Product is a mandatory field based on the P2K_AM_PRODUCTS table.
Subject Table
This field identifies the main context of the procedure. This field is not currently functional.
e.g. P2K_HR_IDENTITIES indicates that the procedure is related to a person. Subject Table is an optional field based on the P2K_AM_TABLE_DETAILS table.
Procedure Name is a mandatory 30 character alphanumeric field assigned by you.

Procedure Steps#

Seq #
This field is used to order the procedure steps. Step_Sequence is an optional 5 digit number assigned by you. The value does not matter; it is the order that counts. It is advisable to increment the step sequences by 10 to allow for insertion of new steps.
Function Name
This field identifies the function that the procedure step invokes. e.g. IEID Function Name is a mandatory field based on the P2K_AM_FUNCTIONS table.
Description
This field describes the function that the procedure step invokes. e.g. Maintain Identity Information
Description is an optional field based on the P2K_AM_FUNCTIONS table. It defaults from the Function Name that is entered.
Mandatory
This field is a toggle that indicates whether the procedure step is mandatory.
Create Allowed
This field is a toggle that indicates whether the procedure step can insert records.
Retrieve Allowed
This field is a toggle that indicates whether the procedure step can display records.
Update Allowed
This field is a toggle that indicates whether the procedure step can update records.
Delete Allowed
This field is a toggle that indicates whether the procedure step can delete records.
Command
This field contains special commands that get executed as part of the procedure. Procedure_Command is an optional 2000 alphanumeric character field.