Search Results po_ga_pvt
Overview
APPS.PO_GA_PVT is the private implementation package body for Global Agreement (GA) processing in Oracle Purchasing. It encapsulates the core business logic that governs whether a purchasing document functions as a Global Agreement and whether it may be used across operating units within an Oracle E-Business Suite 12.1.1 or 12.2.2 environment. Because it is classified as a PVT (private) package, it is not intended as a public integration entry point; rather, it is invoked internally by Purchasing forms, public APIs, and dependent packages to enforce organizational eligibility, date validity, item validity, and approval state rules. The package body is documented as VALID in the APPS schema and carries extensive dependencies spanning Purchasing core entities, financials system parameters, and attachment infrastructure. It is referenced by 24 other packages and references no callers upward, confirming its role as a low-level utility used throughout the Global Agreement stack.
Key Procedures and Functions
The ETRM metadata documents 33 procedures and functions, of which the following are explicitly named. Each performs a discrete validation or retrieval task:
- GET_ORG_ID / GET_CURRENT_ORG / GET_ORG_NAME — resolve operating unit context and return the associated organization identifier or descriptive name.
- IS_OWNING_ORG / IS_ENABLED / ENABLED_ORGS_EXIST — determine whether a given organization owns or participates in a Global Agreement, and whether any enabled organizations exist for that agreement.
- IS_GLOBAL_AGREEMENT / IS_REFERENCED / IS_EXPIRED / IS_APPROVED / IS_GA_VALID — Boolean-style checks evaluating the document's classification, reference status, effective dates, approval state, and overall Global Agreement validity.
- IS_DATE_VALID / VALIDATE_ITEM / IS_SHIP_TO_ORG_VALID — validate user-supplied dates, item eligibility (against master items and revisions), and ship-to organization eligibility.
- GET_GA_VALUES / GET_VENDOR_SITE_ID / GET_CURRENCY_INFO / RATE_EXISTS — retrieve agreement attributes, vendor site identifiers, currency details, and confirm whether a conversion rate is available.
- SYNC_GA_LINE_ATTACHMENTS / REFERENCE_ATTACHMENTS — manage attachment propagation and referencing between Global Agreement lines and related documents.
Parameter lists are intentionally not reproduced here; the reader should consult the deployed package specification for exact signatures.
Tables Accessed
The package reads and writes a focused set of Purchasing, financials, and foundation tables:
- PO_GA_ORG_ASSIGNMENTS — the central table mapping organizations to Global Agreements, used by the org and enablement checks.
- PO_HEADERS, PO_HEADERS_ALL, PO_LINES_ALL, PO_LINES_DRAFT_ALL, PO_LINE_LOCATIONS_ALL — read to confirm document type, approval status, line and shipment details, and draft line changes.
- PO_SYSTEM_PARAMETERS, FINANCIALS_SYSTEM_PARAMETERS, FINANCIALS_SYSTEM_PARAMS_ALL — provide operating-unit-level purchasing and financials configuration.
- FND_ATTACHED_DOCUMENTS, FND_ATTACHED_DOCUMENTS_S, FND_DOCUMENTS — support the attachment synchronization procedures.
- HR_ALL_ORGANIZATION_UNITS_TL — supplies translated organization names for GET_ORG_NAME.
- MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_B, MTL_ITEM_REVISIONS_B, MTL_UNITS_OF_MEASURE_TL — used by item and unit-of-measure validation logic.
Usage Notes
PO_GA_PVT is not a public API. It is invoked indirectly by Oracle Purchasing forms during Global Agreement entry and approval, by concurrent programs that process or validate agreements, and by the 24 dependent packages identified in the ETRM dependency listing. Custom code requiring Global Agreement validation should prefer public APIs such as PO_CORE_S; however, developers performing advanced or diagnostic work may call PO_GA_PVT procedures directly, provided they respect the current operating unit context, initialize FND_MSG_PUB and FND_API structures as required, and enable PO_DEBUG when troubleshooting. Because the package depends on financials and purchasing system parameters, behavior differs across operating units. Any direct invocation should be treated as unsupported customization.
-
PACKAGE BODY: APPS.PO_GA_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_GA_PVT, status:VALID,
-
PACKAGE BODY: APPS.PO_GA_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_GA_PVT, status:VALID,
-
PACKAGE: APPS.PO_GA_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_GA_PVT, status:VALID,
-
PACKAGE: APPS.PO_GA_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PO_GA_PVT, status:VALID,
-
SYNONYM: APPS.PO_GA_ORG_ASSIGNMENTS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PO_GA_ORG_ASSIGNMENTS, status:VALID,
-
SYNONYM: APPS.PO_GA_ORG_ASSIGNMENTS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_GA_ORG_ASSIGNMENTS, status:VALID,
-
PACKAGE BODY: APPS.PO_GA_COMMON_GRP
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_GA_COMMON_GRP, status:VALID,
-
PACKAGE BODY: APPS.PO_GA_COMMON_GRP
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_GA_COMMON_GRP, status:VALID,
-
PACKAGE BODY: APPS.PO_TAX_SUMMARY_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_TAX_SUMMARY_PKG, status:VALID,
-
SYNONYM: APPS.PO_LINES_DRAFT_ALL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PO_LINES_DRAFT_ALL, status:VALID,
-
PACKAGE BODY: APPS.PO_DRAFTS_GRP
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_DRAFTS_GRP, status:VALID,
-
PACKAGE BODY: APPS.PO_LINES_SV4
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_LINES_SV4, status:VALID,
-
PACKAGE BODY: APPS.PO_LINES_SV4
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_LINES_SV4, status:VALID,
-
PACKAGE BODY: APPS.PO_INTERFACE_S2
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_INTERFACE_S2, status:VALID,
-
PACKAGE BODY: APPS.PO_TAX_SUMMARY_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_TAX_SUMMARY_PKG, status:VALID,
-
PACKAGE BODY: APPS.PO_COPYDOC_S3
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_COPYDOC_S3, status:VALID,
-
PACKAGE BODY: APPS.PO_COPYDOC_S3
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_COPYDOC_S3, status:VALID,
-
PACKAGE BODY: APPS.PO_SOURCING_RULES_SV
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_SOURCING_RULES_SV, status:VALID,
-
PACKAGE BODY: APPS.PO_INTERFACE_S2
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_INTERFACE_S2, status:VALID,
-
PACKAGE BODY: APPS.PO_SOURCING_RULES_SV
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_SOURCING_RULES_SV, status:VALID,
-
PACKAGE BODY: APPS.PO_DRAFTS_GRP
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_DRAFTS_GRP, status:VALID,
-
PACKAGE BODY: APPS.PO_SOURCING2_SV
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_SOURCING2_SV, status:VALID,
-
PACKAGE BODY: APPS.PO_DOCUMENT_REVISION_GRP
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_DOCUMENT_REVISION_GRP, status:VALID,
-
PACKAGE BODY: APPS.PO_SHIPMENTS_SV10
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_SHIPMENTS_SV10, status:VALID,
-
PACKAGE BODY: APPS.POS_CLM_UTIL_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:POS_CLM_UTIL_PKG, status:VALID,
-
PACKAGE BODY: APPS.PO_SHIPMENTS_SV10
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_SHIPMENTS_SV10, status:VALID,
-
SYNONYM: APPS.PO_SYSTEM_PARAMETERS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_SYSTEM_PARAMETERS, status:VALID,
-
PACKAGE BODY: APPS.PO_APPROVED_SUPPLIER_LIST_SV
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_APPROVED_SUPPLIER_LIST_SV, status:VALID,
-
PACKAGE BODY: APPS.PO_PRICE_BREAK_GRP
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_PRICE_BREAK_GRP, status:VALID,
-
PACKAGE BODY: APPS.PO_SOURCING2_SV
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_SOURCING2_SV, status:VALID,
-
PACKAGE BODY: APPS.PO_DOCUMENT_REVISION_GRP
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_DOCUMENT_REVISION_GRP, status:VALID,
-
PACKAGE BODY: APPS.PO_WF_PO_CHARGE_ACC
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_WF_PO_CHARGE_ACC, status:VALID,
-
PACKAGE BODY: APPS.PO_APPROVED_SUPPLIER_LIST_SV
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_APPROVED_SUPPLIER_LIST_SV, status:VALID,
-
PACKAGE BODY: APPS.PO_DOCUMENT_CHECKS_GRP
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_DOCUMENT_CHECKS_GRP, status:VALID,
-
PACKAGE BODY: APPS.PO_DOCUMENT_CHECKS_GRP
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_DOCUMENT_CHECKS_GRP, status:VALID,
-
PACKAGE BODY: APPS.PO_PRICE_BREAK_GRP
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_PRICE_BREAK_GRP, status:VALID,
-
PACKAGE BODY: APPS.PO_INQ_SV
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_INQ_SV, status:VALID,
-
PACKAGE BODY: APPS.PO_SHARED_PROC_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_SHARED_PROC_PVT, status:VALID,
-
PACKAGE BODY: APPS.PO_SHARED_PROC_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_SHARED_PROC_PVT, status:VALID,
-
SYNONYM: APPS.PO_SYSTEM_PARAMETERS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PO_SYSTEM_PARAMETERS, status:VALID,
-
PACKAGE BODY: APPS.PO_NEGOTIATIONS4_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_NEGOTIATIONS4_PVT, status:VALID,
-
PACKAGE BODY: APPS.PO_SOURCING_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_SOURCING_PVT, status:VALID,
-
PACKAGE BODY: APPS.PO_WF_PO_CHARGE_ACC
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_WF_PO_CHARGE_ACC, status:VALID,
-
PACKAGE BODY: APPS.PO_NEGOTIATIONS4_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_NEGOTIATIONS4_PVT, status:VALID,
-
PACKAGE BODY: APPS.PO_AUTOSOURCE_SV
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_AUTOSOURCE_SV, status:VALID,
-
PACKAGE BODY: APPS.PO_INQ_SV
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_INQ_SV, status:VALID,
-
PACKAGE BODY: APPS.PO_AUTOSOURCE_SV
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_AUTOSOURCE_SV, status:VALID,
-
PACKAGE BODY: APPS.PO_SOURCING_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_SOURCING_PVT, status:VALID,
-
PACKAGE BODY: APPS.PO_RETROACTIVE_PRICING_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_RETROACTIVE_PRICING_PVT, status:VALID,
-
SYNONYM: APPS.FND_ATTACHED_DOCUMENTS_S
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_ATTACHED_DOCUMENTS_S, status:VALID,