Search Results p_org_template_id

Overview

The APPS.PSP_PSPLSODR_XMLP_PKG package body is an Oracle Reports XML Publisher (XMLP) PL/SQL library associated with a Public Sector Planning and Budgeting (PSP) report identified internally as PSPLSODR. Its overarching purpose is to supply the report with calculated "formula" columns and report lifecycle triggers. The package converts stored numeric identifiers — general ledger code combinations, project and task identifiers, award identifiers, and organization identifiers — into descriptive text values suitable for display in the report output.

The package belongs to the PSP (Public Sector/Service Procurement-related) product family, and its naming convention (_XMLP_PKG) is standard for Oracle E-Business Suite XML Publisher reports. The internal header comment ($Header: PSPLSODRB.pls 120.5 2008/01/30) indicates the source has been versioned since at least EBS Release 12.0 and remained unchanged through the 12.1.1 and 12.2.2 code lines.

Key Procedures and Functions

ETRM metadata documents 17 program units. The predominant pattern is a set of CF_*FORMULA functions, each returning a CHAR value consumed by the report's data model.

• CF_GL_DESCFORMULA — returns a concatenated GL account description. It uses the GL_SET_OF_BKS_ID profile option and calls PSP_GENERAL.GET_GL_VALUES; on failure it returns the literal "Invalid GL Code Combination".
• CF_TASK_NAMEFORMULA — converts a task identifier into its task number from PA_TASKS.
• CF_PROJECT_NUMBERFORMULA — resolves a project identifier to its displayed project number.
• CF_AWARD_NUMBERFORMULA — resolves an award identifier to an award number, falling back to the default distribution award number when no direct match is found.
• CF_ORG_NAMEFORMULA and CF_ORG_SCHEDULE_IDFORMULA — translate organization identifiers into organization names and schedule identifiers.
• CF_DATE_FORMATFORMULA — supplies the report-level date format mask.
• CF_SCH_BEGIN_DATE_DISPFORMULA, CF_SCH_END_DATE_DISPFORMULA, CF_PERIOD_START_DATEFORMULA, CF_PERIOD_END_DATE_DISPFORMULA, CF_BEGIN_DATE_DISPFORMULA, CF_END_DATE_DISPFORMULA — return formatted schedule, period, and range boundary dates for display.
• BEFOREREPORT, AFTERPFORM, AFTERREPORT — standard report triggers executed before the report, after each parameter form submission, and after report completion. These typically initialize session context, date-format globals, and clean-up logic.

The frequently referenced user search term p_org_template_id relates to organization template parameters such as CF_ORG_NAMEFORMULA and CF_ORG_SCHEDULE_IDFORMULA, which drive organization-specific report content.

Tables Accessed

The package queries the following objects through APPS synonyms:

• GMS_AWARDS_ALL and GMS_IMPLEMENTATIONS — award number lookup and default distribution award fallback.
• HR_ALL_ORGANIZATION_UNITS_TL — organization name translations used by the organization formulas.
• PA_PROJECTS_ALL and PA_TASKS — project number and task number resolution.
• PSP_MATRIX_DRIVER and PSP_REPORT_TEMPLATE_DETAILS — matrix/report template metadata used to drive parameterized report content, which is where organization template configuration (p_org_template_id) is typically sourced.

Usage Notes

This package is invoked exclusively by the associated Oracle Reports/XML Publisher concurrent program; it is referenced by zero other PL/SQL packages, confirming that its scope is confined to the report's formula columns and triggers. Users do not call it directly. Administrators and developers should note that changing organization template parameters — including the selection exposed as p_org_template_id — affects the values returned by the organization-related formulas and therefore the report output. Because GL and profile values are resolved at runtime, ensure the GL set of books profile and organization template setup are correct before running the report.