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 the PL/SQL package body that supports the Oracle Purchasing XML Publisher report POXPOMPAR (Purchasing Activity / Procurement Activity Report) in Oracle E-Business Suite 12.1.1 and 12.2.2. The package is owned by APPS and is classified as AUTHID CURRENT_USER, meaning all unqualified object references execute under the privileges of the invoking session. Its primary responsibility is to drive report-level business logic that cannot be expressed declaratively in the XML Publisher (BI Publisher) data template: parameter defaulting, dynamic WHERE-clause construction, lookup-meaning translation, currency rounding, and conditional display logic for government-versus-commercial report layouts.
The package is not a general-purpose API. It is a report-controller package, invoked exclusively by the Oracle Reports/XML Publisher runtime during execution of the POXPOMPAR report. It is referenced by zero other packages, confirming its narrow, purpose-built role. Because the report supports organization-specific variations in layout and content, the package exposes flags that control whether government-specific or core fields are rendered.
Key Procedures and Functions
- SET_DISPLAY_FOR_GOV — Documented as a function returning BOOLEAN. This is the object most frequently located by users searching "set_display_for_gov." It evaluates configuration and parameter conditions to determine whether the government-specific layout variant of the report should be displayed, gating the visibility of government-oriented columns and totals.
- SET_DISPLAY_FOR_CORE — The companion function to SET_DISPLAY_FOR_GOV. Returns BOOLEAN and controls whether the core (standard commercial) report layout elements are displayed.
- COMPANY — Returns the formatted company name used in headers.
- COST_CENTER — Returns the formatted cost center value for report presentation.
- GET_PRECISION — Resolves the currency quantity precision applied to numeric report columns.
- ORDERBY_CLAUSEFORMULA — Builds the dynamic ORDER BY clause based on the P_ORDERBY parameter.
- BEFOREREPORT — Standard XML Publisher/Reports before-report trigger; initializes report state.
- AFTERREPORT — Standard after-report trigger; performs cleanup.
- AFTERPFORM — Executes after parameter form submission; typically used to derive dependent parameters such as P_ORDERBY_DISPLAYED.
- GET_LOOKUP_MEANING — Translates a lookup code into its display meaning for a given lookup type.
- GET_BOILER_PLATES — Populates boilerplate text blocks used in report headers/footers.
- ROUND_AMOUNT_LIST_SUBTOTAL_REP — Rounds open-invoice subtotal amounts to the appropriate currency precision.
- C_INDUSTRY_CODE_P and C_COMPANY_TITLE_P — Accessor functions exposing the C_industry_code and C_company_title package variables.
Tables Accessed
- FINANCIALS_SYSTEM_PARAMETERS — Read to derive ledger and currency precision information that feeds GET_PRECISION and rounding logic.
- FND_SEGMENT_ATTRIBUTE_VALUES — Read to determine descriptive-flexfield segment attributes, supporting the company and cost center display functions.
Both tables are accessed through APPS synonyms.
Usage Notes
PO_POXPOPAR_XMLP_PKG is invoked implicitly by the XML Publisher engine when the POXPOMPAR concurrent program runs. Developers rarely call it directly; instead, they extend it when customizing the government or core layout variants. Because the package uses AUTHID CURRENT_USER, customizations must ensure the executing user has appropriate grants. In 12.2.2 the object remains unchanged from its 12.1.1 form (header version 120.2). Any change to SET_DISPLAY_FOR_GOV directly alters which columns render in the output, making it the primary extension point for jurisdiction-specific reporting requirements.
-
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.1.1
APPS.PER_ORG_MANAGER_V·↳ FND_DATE·↳ FND_SESSIONS·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER 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 →
-
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.
-
Holds details of Projection Calculations
-
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
-
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.2.2
Interface table for Report eXchange reports
-
Table: FA_CAP_REP_ITF 12.1.1
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 →
-
Retrofitted
APPS.AP_WEB_SIGNING_LIMITS_V·↳ AP_LOOKUP_CODES·↳ AP_WEB_DB_HR_INT_PKG·↳ AP_WEB_SIGNING_LIMITS·Explore AP module →
-
Accounting information for credit card transactions
-
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 →
-
This view has the details of all the resources whose category='SUPPLIER_CONTACT'
APPS.JTF_RS_SUPPLIER_DTLS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·Explore JTF module →
-
This view has the details of all the resources whose category='SUPPLIER_CONTACT'
APPS.JTF_RS_SUPPLIER_DTLS_VL·↳ JTF_RS_RESOURCE_EXTNS_VL·Explore JTF module →
-
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 →