Search Results get_total_percent

Overview

PA_PROJ_TEMPLATE_SETUP_UTILS is a utility PL/SQL package owned by the APPS schema within Oracle E-Business Suite, classified under the ETRM "OTHER" API category. Its documented purpose is to support the setup, validation, and configuration logic associated with Oracle Projects project templates. Project templates in Oracle Projects allow organizations to predefine reusable project attributes, options, and defaulting rules that are applied when new projects are created, thereby enforcing consistency across project numbering, header options, classification, and customer/key member associations.

The package exposes a mixture of procedural and functional utilities that retrieve option metadata (names, function names, sort order, and web HTML call details), determine whether header options are enabled, resolve limiting value meanings, validate template and project attributes, and compute aggregate values such as total percentages. The package is declared AUTHID CURRENT_USER, so it executes with the privileges of the calling user rather than the definer, which is significant when it is invoked from forms, concurrent programs, or custom code operating against APPS synonyms.

The header comment identifies source version 120.2.12010000.5 (2009), indicating the object is stable and has been maintained across the 12.1.1 and 12.2.2 release lines with minimal structural change.

Key Procedures and Functions

Fourteen documented procedures and functions make up the public interface. The principal entries include:

• GET_OPTION_DETAILS — Retrieves the descriptive metadata for a given option code, returning the option name, the associated function name, a sort order, and the web HTML call string used to render the option in the UI.
• GET_PROJ_NUM_OPTION — Returns the project numbering mode, documented values being 'AUTOMATIC' or 'MANUAL'.
• HEADER_OPTION — Returns 'Y' or 'N' to indicate whether a specified header option is enabled.
• GET_LIMITING_VALUE_MEANING — Resolves a limiting value into its display meaning, returning the customer or key member meaning, or the category code in the case of a classification field.
• CHECK_TEMPLATE_ATTR_REQ — Validates required template attributes (project number, name, type, and organization) and returns a status along with an error message code.
• GET_PROJECT_TYPE_DEFAULTS — Resolves default attribute values defined for a project type.
• GET_FIELD_NAME and GET_LIMITING_VALUE — Support field and limiting value resolution for template options.
• CHECK_TEMPLATE_NAME_OR_ID, CHECK_PROJECT_NAME_OR_ID, and CHECK_PROJ_TMPL_NAME_OR_ID — Perform existence and uniqueness validation for template and project identifiers.
• GET_OPTION_ENABLED — Determines whether a specific option is active.
• GET_PROJ_NUM_TYPE — Returns the project number type used in template setup.
• GET_TOTAL_PERCENT — Computes the aggregate percentage across template distribution or allocation lines.

Tables Accessed

The package reads from and writes to several Oracle Projects and Oracle Application Object Library tables through APPS synonyms:

• PA_OPTIONS, PA_PROJECT_OPTIONS, and PA_IMPLEMENTATIONS — supply the option definitions and implementation-level settings consumed by the option-related functions.
• FND_FORM_FUNCTIONS — provides the function name and web HTML call information returned by GET_OPTION_DETAILS.
• PA_PROJECT_TYPES — supplies project type defaults and classification context.
• PA_CLASS_CATEGORIES — supports classification limiting value resolution.
• PA_PROJECTS and PA_PROJECTS_ALL — used for project and template name/id validation checks.

Usage Notes

PA_PROJ_TEMPLATE_SETUP_UTILS is typically invoked from Oracle Projects setup forms and from other PL/SQL packages rather than being called directly by end users. The ETRM metadata records that the package is referenced by five other packages, confirming its role as a shared internal utility layer. Customizations that require template option resolution, validation of template or project identifiers, or computation of distribution percentages should call these APIs rather than querying PA_OPTIONS or PA_PROJECT_OPTIONS directly, preserving compatibility across 12.1.1 and 12.2.2. Because the package is AUTHID CURRENT_USER, callers must possess appropriate grants on the referenced APPS objects.