Results for “cost_center”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PO_POXPOPAR_XMLP_PKG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. It is the generated runtime implementation behind the Oracle Reports executable associated with the POXPOPAR report, one of the standard purchasing reports in the Oracle Purchasing module. The naming convention follows the Oracle XML Publisher / Oracle Reports integration pattern in which a report definition generates a supporting PL/SQL package containing an AFTERPFORM, BEFOREREPORT, and AFTERREPORT trigger along with a set of data-fetch and formatting helper functions. This package therefore provides the report grouping, lookup decoding, currency rounding, and system-parameter resolution logic that drives the printed output, including corporate identity, cost center labeling, and precision handling for monetary values. In EBS 12.1.1 and 12.2.2 the package is a standard, VALID database object and is classified as OTHER under the API classification scheme, reflecting its status as report infrastructure rather than a published business API.
Key Procedures and Functions
The documented package exposes fourteen procedures and functions:
- COMPANY — Returns the company or legal entity name used as the report header or organizational identity.
- COST_CENTER — Resolves and returns the cost center value displayed for the report's operating unit or inventory organization context.
- GET_PRECISION — Determines the currency precision (decimal places) applied to monetary columns.
- ORDERBY_CLAUSEFORMULA — Supplies the ordering clause applied to the report's result set, allowing runtime control of sort sequence.
- BEFOREREPORT — The report-level before-trigger; establishes session context, initializes parameters, and prepares lookups prior to data retrieval.
- AFTERREPORT — The report-level after-trigger; performs cleanup or final formatting actions once report execution completes.
- GET_LOOKUP_MEANING — Wraps lookup resolution to translate stored lookup codes into their user-facing meanings.
- GET_BOILER_PLATES — Retrieves boilerplate text such as standard legal, regulatory, or organizational statements.
- SET_DISPLAY_FOR_GOV — Toggles display behavior for government-oriented report variants.
- SET_DISPLAY_FOR_CORE — Toggles display behavior for the core (non-government) report variant.
- ROUND_AMOUNT_LIST_SUBTOTAL_REP — Applies currency rounding to reported subtotal amounts in the report list section.
- AFTERPFORM — The parameter form after-trigger; validates or transforms user-entered report parameters.
- C_INDUSTRY_CODE_P — Package-level constant or function supplying the industry code parameter.
- C_COMPANY_TITLE_P — Package-level constant or function supplying the company title parameter.
Tables Accessed
Per the recorded metadata, the package reads the following tables through APPS synonyms:
- FINANCIALS_SYSTEM_PARAMETERS — Used to derive the ledger, currency, and accounting setup governing rounding and precision behavior.
- FND_SEGMENT_ATTRIBUTE_VALUES — Used to determine which key flexfield segments are enabled and displayed, supporting cost center and company resolution.
Additional dependencies recorded in the object metadata include FINANCIALS_SYSTEM_PARAMETERS, FND_INSTALLATION, FND_LOOKUPS, FND_SEGMENT_ATTRIBUTE_VALUES, GL_SETS_OF_BOOKS, PO_COMMON_XMLP_PKG, and PO_LOOKUP_CODES. PO_COMMON_XMLP_PKG is of particular note as a shared purchasing report utility package from which common report logic is inherited.
Usage Notes
This package is not a callable business API; it is invoked indirectly when the associated Oracle Purchasing report is run from the Submit Requests form or the concurrent manager. It is not referenced by any other database object, so custom code should not depend on it. In 12.1.1 and 12.2.2 the package body is regenerated when the underlying report definition is compiled or re-uploaded, so any direct modification is unsupported and will be overwritten. Organizations customizing purchasing report output should extend via XML Publisher templates or custom concurrent programs rather than editing this generated package. Troubleshooting typically involves confirming the package body is VALID and that dependent objects such as PO_COMMON_XMLP_PKG and the lookup tables remain accessible.
-
View: HRI_CL_ORG_CC_V 12.1.1
APPS.HRI_CL_ORG_CC_V·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore HRI module →
-
View: PA_UBR_UER_ACCT_V 12.1.1
This view is being used for reporting purpose in UBR and UER.This is UBR UER Accounting summary view
APPS.PA_UBR_UER_ACCT_V·↳ GL_PERIOD_STATUSES·↳ PA_CURRENCY·↳ PA_IMPLEMENTATIONS_ALL·Explore PA module →
-
View: PER_ORG_MANAGER_V 12.2.2
APPS.PER_ORG_MANAGER_V·↳ FND_DATE·↳ FND_SESSIONS·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →
-
View: PER_ORG_MANAGER_V 12.1.1
APPS.PER_ORG_MANAGER_V·↳ FND_DATE·↳ FND_SESSIONS·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →
-
Tracks signing limit authority for Self-Service Expenses-entered expense reports
-
Tracks signing limit authority for Self-Service Expenses-entered expense reports
-
Retrofitted
APPS.AP_WEB_SIGNING_LIMITS_V·↳ AP_LOOKUP_CODES·↳ AP_WEB_DB_HR_INT_PKG·↳ AP_WEB_SIGNING_LIMITS·Explore AP module →
-
View: PA_UBR_UER_ACCT_DTLS_V 12.1.1
This view is being used for reporting purpose in UBR and UER.This is UBR UER Accounting summary detail view
APPS.PA_UBR_UER_ACCT_DTLS_V·↳ GL_JE_BATCHES·↳ GL_JE_HEADERS·↳ GL_JE_LINES·Explore PA module →
-
View: PA_UBR_UER_ACCT_V 12.2.2
This view is being used for reporting purpose in UBR and UER.This is UBR UER Accounting summary view
APPS.PA_UBR_UER_ACCT_V·↳ GL_PERIOD_STATUSES·↳ PA_CURRENCY·↳ PA_IMPLEMENTATIONS_ALL·Explore PA module →
-
View: HXT_SUM_HOURS_WORKED_D 12.2.2
APPS.HXT_SUM_HOURS_WORKED_D·↳ FND_PROFILE·↳ FND_USER_VIEW·↳ HR_API·Explore HXT module →
-
View: APBV_EXP_REPORT_DISTS 12.2.2
APPS.APBV_EXP_REPORT_DISTS·↳ AP_EXP_REPORT_DISTS_ALL·Explore AP module →
-
APPS.PAY_KR_SEPL_LIAB_SUMMARY_V·↳ FND_SEGMENT_ATTRIBUTE_VALUES·↳ GL_SETS_OF_BOOKS·↳ HR_GENERAL·Explore PAY module →
-
View: APBV_EXP_REPORT_DISTS 12.1.1
APPS.APBV_EXP_REPORT_DISTS·↳ AP_EXP_REPORT_DISTS_ALL·Explore AP module →
-
Table: JA_CN_ERROR_ACCOUNTS 12.2.2
JA_CN_ERROR_ACCOUNTS stores error accounts, which have abnormal balances. The XML data template 'Account Balance Export Exception Report' will read this table to export the error accounts if any.
-
Table: FA_PROJECT_REP_ITF 12.2.2
Interface table for Report eXchange reports
-
Table: FA_PROJECT_REP_ITF 12.1.1
Interface table for Report eXchange reports
-
Holds details of Projection Calculations
-
View: PA_UBR_UER_PROJ_V 12.2.2
This view is being used for reporting purpose in UBR and UER.This is UBR UER Project summary view
APPS.PA_UBR_UER_PROJ_V·↳ GL_PERIOD_STATUSES·↳ PA_CURRENCY·↳ PA_IMPLEMENTATIONS_ALL·Explore PA module →
-
View: JTF_RS_PARTY_DTLS_VL 12.1.1
This view has the details of all the resources whose category='PARTY'
APPS.JTF_RS_PARTY_DTLS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·Explore JTF module →
-
Table: FA_COSTCLEAR_REP_ITF 12.1.1
Interface table for Report eXchange reports
-
Table: FA_PROPTAX_REP_ITF 12.1.1
Interface table for Report eXchange reports
-
View: ICX_PO_REQS_BY_USERS_V 12.2.2
Requisitions by Users View
APPS.ICX_PO_REQS_BY_USERS_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·↳ FND_USER·Explore ICX module →
-
View: ICX_PO_LIST_USERS_V 12.2.2
List of Users view
APPS.ICX_PO_LIST_USERS_V·↳ FND_USER·↳ HR_GENERAL·↳ HR_LOCATIONS·Explore ICX module →
-
View: POS_PO_LIST_USERS_V 12.2.2
APPS.POS_PO_LIST_USERS_V·↳ FND_USER·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·Explore PO module →
-
View: ICX_PO_LIST_USERS_V 12.1.1
List of Users view
APPS.ICX_PO_LIST_USERS_V·↳ FND_USER·↳ HR_GENERAL·↳ HR_LOCATIONS·Explore ICX module →
-
View: ICX_PO_REQS_BY_USERS_V 12.1.1
Requisitions by Users View
APPS.ICX_PO_REQS_BY_USERS_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ FND_CURRENCY·↳ FND_USER·Explore ICX module →
-
Table: FA_CAP_REP_ITF 12.1.1
Interface table for Report eXchange reports
-
Retrofitted
APPS.AP_WEB_SIGNING_LIMITS_V·↳ AP_LOOKUP_CODES·↳ AP_WEB_DB_HR_INT_PKG·↳ AP_WEB_SIGNING_LIMITS·Explore AP module →
-
Table: FA_CAP_REP_ITF 12.2.2
Interface table for Report eXchange reports
-
Asset Identification and Distribution
APPS.FA_ASSET_DISTRIBUTION_V·↳ FA_ADDITIONS·↳ FA_BOOKS·↳ FA_BOOK_CONTROLS·Explore OFA module →
-
JA_CN_ACCOUNT_BALANCES_GT is a session level global temporary table which stores combined account balances before they are exported to flat file.
-
APPS.PAY_KR_SEP_LIAB_DETAIL_V·↳ FND_SEGMENT_ATTRIBUTE_VALUES·↳ GL_SETS_OF_BOOKS·↳ HR_GENERAL·Explore PAY module →
-
APPS.PAY_KR_SEP_LIAB_DETAIL_V·↳ FND_SEGMENT_ATTRIBUTE_VALUES·↳ GL_SETS_OF_BOOKS·↳ HR_GENERAL·Explore PAY module →
-
APPS.PAY_KR_SEPL_LIAB_SUMMARY_V·↳ FND_SEGMENT_ATTRIBUTE_VALUES·↳ GL_SETS_OF_BOOKS·↳ HR_GENERAL·Explore PAY module →
-
Accounting information for credit card transactions
-
View: JTF_RS_PARTY_DTLS_VL 12.2.2
This view has the details of all the resources whose category='PARTY'
APPS.JTF_RS_PARTY_DTLS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·Explore JTF module →
-
View: PA_UBR_UER_PROJ_DTLS_V 12.2.2
This view is being used for reporting purpose in UBR and UER.This is UBR UER Project summary details view
APPS.PA_UBR_UER_PROJ_DTLS_V·↳ PA_CURRENCY·↳ PA_DRAFT_INVOICES_ALL·↳ PA_DRAFT_INVOICE_ITEMS·Explore PA module →
-
View: JTF_RS_VENUE_DTLS_VL 12.2.2
This view has the details of all the resources whose category='VENUE'
APPS.JTF_RS_VENUE_DTLS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·Explore JTF module →
-
View: JTF_RS_OTHER_DTLS_VL 12.2.2
This view has the details of all the resources whose category='OTHER'
APPS.JTF_RS_OTHER_DTLS_VL·↳ HR_GENERAL·↳ HR_SECURITY·↳ JTF_RS_RESOURCE_EXTNS_VL·Explore JTF module →
-
View: PA_UBR_UER_PROJ_DTLS_V 12.1.1
This view is being used for reporting purpose in UBR and UER.This is UBR UER Project summary details view
APPS.PA_UBR_UER_PROJ_DTLS_V·↳ PA_CURRENCY·↳ PA_DRAFT_INVOICES_ALL·↳ PA_DRAFT_INVOICE_ITEMS·Explore PA module →
-
Interface table for Report eXchange reports
-
View: JTF_RS_PARTNER_DTLS_VL 12.2.2
This view has the details of all the resources whose category='PARTNER'
APPS.JTF_RS_PARTNER_DTLS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·Explore JTF module →