Search Results is_project_template

Overview

APPS.GMS_COMMON_PKG is a shared utility package within the Oracle Grants Management (GMS) module of Oracle E-Business Suite. It provides common helper routines, constants, and PL/SQL collection types used by multiple Grants Management components, including Award Management and the GMS-SSP (Self Service Purchasing) integration. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking schema rather than the definer, which is consistent with its role as a general-purpose library routine that must adapt to the caller's context.

The package header dates to the early 11c-era codebase (per the embedded $Header comment) and remains present in EBS 12.1.1 and 12.2.2 as a stable, low-level dependency for Grants functionality. Its responsibilities span lightweight data validation (numeric and template string checks), session-level setup of project options, retrieval of award numbering sequences, and the definition of a record/table type pair used to pass purchasing requisition distribution data between Grant Management and Oracle Purchasing.

Key Procedures and Functions

• ISNUMBER — A validation function that determines whether an input string represents a valid number. It returns a character indicator (typically Y/N). Its purity is asserted through PRAGMA RESTRICT_REFERENCES with WNDS, RNDS, WNPS, and RNPS, confirming that it neither writes database state nor package state. This makes it safe for use inside SQL statements and other restricted contexts.
• SET_PROJECT_OPTION — A procedure that accepts a template identifier and establishes a project-related option at the session or package level. It is used to configure behavior for subsequent Grants operations within the same session.
• IS_PROJECT_TEMPLATE — A function returning a numeric value that indicates whether a given string corresponds to a valid project template. This is the routine most directly associated with the user search term "is_project_template." Its purity is constrained by PRAGMA RESTRICT_REFERENCES with WNDS and WNPS, ensuring it does not modify database or package state and may be called safely from SQL.
• GETMAX_AWARD_NUMBER — A function returning the maximum award number currently in use, supporting award numbering and next-value determination logic within Grants Management.

Tables Accessed

The package references the GMS_AWARDS table (accessed through an APPS synonym to the underlying GMS_AWARDS base table). This table is the primary Grants Management table for award records. GETMAX_AWARD_NUMBER queries it to derive the highest existing award number, while functions such as IS_PROJECT_TEMPLATE rely on the awards and related project structure to validate template values.

Usage Notes

As a common utility, GMS_COMMON_PKG is typically invoked from Grants Management forms, concurrent programs, and other PL/SQL packages rather than called directly by end users. It is referenced by at least one other package in the EBS codebase, confirming its role as a shared dependency. Because ISNUMBER and IS_PROJECT_TEMPLATE carry PRAGMA RESTRICT_REFERENCES declarations, they are safe to invoke from SQL and from within database triggers or constrained PL/SQL scopes. The po_req_dist_rec record and po_req_dist_tab collection types are specifically identified in the source as additions for GMS-SSP Integration, indicating that this package also supports the flow of requisition distribution data between Grants and Purchasing self-service. The AUTHID CURRENT_USER declaration means custom code invoking this package must ensure the calling schema has appropriate grants on GMS_AWARDS and related objects.