This page (revision-4) was last changed on 26-Nov-2021 10:22 by khiggs

This page was created on 26-Nov-2021 10:22 by khiggs

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
4 26-Nov-2021 10:22 5 KB khiggs to previous
3 26-Nov-2021 10:22 4 KB khiggs to previous | to last
2 26-Nov-2021 10:22 7 KB khiggs to previous | to last
1 26-Nov-2021 10:22 7 KB khiggs to last

Page References

Incoming links Outgoing links
PTS_CHCK_ROUTINE(System_Preference)
PTS_CHCK_ROUTINE(System_Preference)

Version management

Difference between version and

At line 1 changed one line
PL/SQL validation routine can be called to replace the default "submit" function on a timesheet. When a timesheet is submitted, if the timesheet does not meet the criteria of the validation routine, a customer-defined message will appear as a pop-up dialog and the timesheet will not change status.
PL/SQL validation routine can be called to replace the default "submit" function on a timesheet. When a timesheet is submitted, if the timesheet does not meet the criteria of the validation routine, a customer defined message will appear as a pop up dialog and the timesheet will not change status.
At line 6 changed one line
A user-defined system message must be created on IMMS. The message should be prefixed with PTSV_######
A user defined system message must be created on IMMS. The message should be prefixed with PTSV_######
At line 8 changed 3 lines
The message will be text and will need to be a predefined hardcoded value built into the MESSAGE_TEXT field.
!Function Definition (PL/SQL)
The function must be defined in the database as a PL/SQL function.
!Function Definition
The function must be defined in the data base as a PL/SQL function.
At line 12 changed one line
*The function must return either a NULL or the number portion of a code name of a user-defined message defined in the IMMS screen.
*The function must return either a NULL or the number portion of a code name of a user defined message defined in the IMMS screen.
At line 17 changed one line
** If you are going to have many conditions that will require validation, you may find it advantageous to create a package with your customer prefix, and then include all the different validation routines as separate functions within that package. This keeps all your work together in one place.
** If you are going to have many conditions that will require validation, you may find it advantageous to create a package with your customer prefix, and then include all the different validation routines as seperate functions within that package. This keeps all your work together in one place.
At line 22 changed one line
Once the function and system message have been established, all the functions that will use the routine must be set up. There are two steps required on each function in which the routine is to be called
Once the function and system message has been established, all the functions that will use the routine must be set up. There are two steps required on each function in which the routine is to be called
At line 24 changed one line
2) On the Form Layout tab, add the PTS.ACT_VALIDATE_SUBMIT_TIME_SHEET_NO_DLG to the form. If the form is "Pre-Loaded" use object security to remove the default PTS.ACT_SUBMIT_TIME_SHEET option (If custom, the PTS.ACT_SUBMIT_TIME_SHEET can be deleted from the form).
2) On the Form Layout tab, add the PTS.ACT_VALIDATE_SUBMIT_TIME_SHEET_NO_DLG to the form. If the form is "Pre-Loaded" use object security to remove the default PTS.ACT_SUBMIT_TIME_SHEET option (If custom, the PTS.ACT_SUBMIT_TIME_SHEET can be delete from the form).
At line 30 changed one line
*If the total number of hours in the timesheet is less than the number 40, the function will return the number "0001".
*If the total number of hours in the timesheet is less than the number defined on the IEAS, the function will return the number "0001".
At line 32 removed one line
*Built into this function is a requirement for a TIME_CODE_SET set up on [IDTCS] called "TIME_SHEET_TOTALS"
This page (revision-4) was last changed on 26-Nov-2021 10:22 by khiggsTop