Search Results get_gl_ccid

Overview

APPS.PSP_PSPLSODL_XMLP_PKG is a PL/SQL package associated with an Oracle EBS XML Publisher (BI Publisher) concurrent program report in the Oracle Grants / Project Portfolio Management (PSP) product family — the naming convention "PSPLSODL" indicates a Project Status / Project List Sourced Operating Detail Listing report. The package follows the standard XML Publisher report package pattern: it declares global report parameters, contains formula functions invoked directly from the report template (the "CF_" prefix denotes "column formula"), and implements the standard report lifecycle hooks BEFOREREPORT, AFTERREPORT, BEFOREPFORM, and AFTERPFORM that are called automatically by the XML Publisher engine during report execution.

Its business purpose is to supply descriptive lookups, formatting logic, and date handling for a Grants-oriented operational detail listing. The package converts internally stored foreign key values (organization IDs, GL code combination IDs, project IDs, task IDs, award IDs, assignment numbers, person IDs, and element type IDs) into human-readable descriptions for display in the printed report output.

Key Procedures and Functions

The package exposes 41 documented procedures and functions:

• CF_ORGANIZATION_NAMEFORMULA — returns the display name of an organization from its ID.
• CF_GL_ACCOUNTFORMULA — accepts a GL_CODE_COMBINATION_ID and returns the formatted GL account string, the function most directly relevant to a "get_gl_ccid" style lookup. This is the entry point a report user would exercise to resolve a code combination ID.
• CF_PROJECT_NAMEFORMULA — returns project name from project ID.
• CF_EXP_ORG_NAMEFORMULA — returns expenditure organization name.
• CF_TASK_NAMEFORMULA — returns task name from task and project IDs.
• CF_AWARD_NAMEFORMULA — returns award name from award ID.
• CF_ASSIGNMENT_NUMBERFORMULA / CF_PERSON_NAMEFORMULA / CF_EMPLOYEE_IDFORMULA — resolve assignment, person name, and employee number attributes from person and assignment identifiers.
• CF_EARNINGS_ELEMENTFORMULA — returns earnings element description from an element type ID.
• CF_NUMBER_WORKING_DAYSFORMULA — calculates working days between a schedule begin and end date.
• CF_TIME_PERIOD_STARTFORMULA / CF_TIME_PERIOD_ENDFORMULA / CF_DATE_FORMATFORMULA / CF_DATE_RUNFORMULA / CF_DEFAULT_BEGIN_DATEFORMULA / CF_DEFAULT_END_DATEFORMULA — format and derive report date ranges using a supplied date format mask.
• CF_INSTITUTION_NAMEFORMULA — returns the institution name for report headers.
• BEFOREREPORT / AFTERREPORT / BEFOREPFORM / AFTERPFORM — standard lifecycle hooks that initialize or clean up report context before and after the report and the parameter form.

Tables Accessed

The package references four documented APPS synonyms: GMS_AWARDS_ALL (award information), GMS_IMPLEMENTATIONS (Grants implementation setup), HR_ALL_ORGANIZATION_UNITS_TL (organization names and translations), and PAY_ELEMENT_TYPES_F (earnings element definitions). These support the name-resolution formulas described above.

Usage Notes

The package is invoked by the XML Publisher engine when the associated concurrent program or report is run; it is referenced by zero other packages and is not intended as a public API. The report parameters (batch ID, business group, set of books, org template, begin and end date, and concurrent request ID) are populated by the XML Publisher parameter form and consumed by the formula functions during output generation.