This appendix describes the client extensions
This appendix covers the following topics:
Oracle Grants Accounting provides three client extensions that you can use to extend the functionality of Oracle Grants Accounting. This section provides information about these extensions:
Allow Internal Requisitions Extension
Override Installment Date Validation Extension
Award Security Feature
You use PL/SQL to modify procedures within the extensions. Oracle Grants Accounting calls these procedures during specific points in the standard processing.
The procedures that you write are extensions, not customizations. Extensions are supported features within the product and are easily upgraded between product releases. Customizations are changes to the base product which are not supported and are not easily upgraded.
For information about implementing client extensions, see Overview of Client Extensions, Oracle Projects APIs, Client Extensions, and Open Interfaces Reference.
The allow internal requisitions extension enables you to determine whether to allow users to charge internal requisitions to Oracle Grants Accounting. Oracle iProcurement uses the function ALLOW_INTERNAL_REQ to determine whether to display the Award field when users enter distributions for internal requisitions.
The extension is identified by the following items:
| Item | Name |
|---|---|
| Body Template | GMSPOCEB.pls |
| Specification template | GMSPOCES.pls |
| Package | GMS_CLIENT_EXTN_PO |
| Function | ALLOW_INTERNAL_REQ |
The ALLOW_INTERNAL_REQ function returns a VARCHAR2 value that determines whether Oracle iProcurement displays the Award field. You can customize the procedure to return a value of Y. The default value is N. This procedure has no parameters.
Important: Oracle Grants Accounting does not support the full flow for internal requisitions. If you have customizations in place to reduce the encumbrances that internal requisitions create and to import the costs into Oracle Grants Accounting from Oracle Inventory, then you can modify the function ALLOW_INTERNAL_REQ return a value of Y. Otherwise, do not modify the function.
This procedure enables you to override the award budget validation that does not allow users to enter budget amounts outside the installment date range.
The extension is identified by the following items:
| Item | Name |
|---|---|
| Body Template | GMSBCECB.pls |
| Specification template | GMSBCECS.pls |
| Package | GMS_CLIENT_EXTN_BUDGET |
| Procedure | OVERRIDE_INST_DATE_VALIDATION |
The OVERRIDE_INST_DATE_VALIDATION procedure returns a VARCHAR2 value that determines whether to override the installment date validation. You can customize the procedure to enable users to enter award budget lines outside the date range of the installments that fund the project. You must specify the business logic to determine which budget lines can bypass the installment date validation.
You can view the parameters for this procedure in the Oracle Integration Repository.
Award security is a feature that allows users to access or update award information. Award security protects data ownership and sensitivity relative to a given award or award template.
By default, Grants Accounting allows all users to perform the following tasks:
query award related information
update award related information and perform tasks on an award
Grants Accounting provides users with a client extension, GMS_SECURITY_EXTN, that enables users to override the default award security or to add additional award security criteria by implementing customized award security business rules.
Examples of award security business rules are the following:
Only personnel listed on the award can access award information.
Only key members, such as the Award Manager and the Principal Investigator, can update award information.
A key member is an employee who is assigned a role on an award. Key members are typically given permission to view and update award information and expenditure details for any award to which they are assigned.
The extension is identified by the following items:
| Item | Name |
|---|---|
| Body Template | GMSSEEXB.pls. |
| Specification template | GMSSEEXS.pls |
| Package | GMS_SECURITY_EXTN |
| Procedure | CHECK_AWARD_ACCESS |
Grants Accounting provides a template package that contains the procedure that users can modify to implement the award security extension. Before writing an award security client extension, print out and review the body template and specification template files that are located in the $GMS_TOP/admin/sql directory.
The file named GMSSEEXB.pls. is the Award Security Extension Package Body Template. This file contains the procedure that the user modifies to implement the award security extension. The user can define as many procedures as desired within this package or within the predefined procedure.
The file named GMSSEEXS.pls. is the Award Security Extension Package Specification Template. If the user creates procedures outside the predefined procedure within the GMS_SECURITY_EXTN package, the user must also modify this file to include those new procedures.
Note: After writing the procedure, do not forget to compile it and store it in the database. For information on storing procedures, see Compiling and Storing Your Procedures, Oracle Projects APIs, Client Extensions, and Open Interfaces Guide.
You can view the parameters for this client extension in the Oracle Integration Repository.
The table below shows the Grants Accounting windows that access award security and indicates whether they allow the user to query or update award information.
| Oracle Grants Accounting Window | Query | Update |
|---|---|---|
| Award Management | X | X |
| Award Budgets | X | X |
| Revenue Review | X | X |
| Invoice Review | X | X |
| Funding Inquiry | X | |
| Award Status Inquiry | X |
Related Topics
PL/SQL User's Guide and Reference Manual
Oracle eBusiness Suite Electronic Technical Reference Manual