Results for “get_wf_preferences”
10 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PON_PROFILE_UTIL_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under API classification OTHER. It provides the shared utility layer that Oracle Purchasing and iProcurement use to manage supplier and trading-partner profile data held in the TCA (Trading Community Architecture) model. Although the package name carries the PON prefix (Purchasing), its logic operates almost entirely against the HZ_ tables that store party, location, contact, and organization profile information.
The package addresses two related concerns. First, it maintains synchronization of date and status attributes across party records and their dependent locations and contacts. Second, it manages the supplier preference values — the subset of configurable options such as payment methods, credit card types, payment terms, carrier, freight terms, and FOB — that are surfaced to Java-based user interfaces. The declared refCurTyp strongly suggests the package is designed to pass result sets out to Java layers rather than to be consumed solely by PL/SQL callers. The header identifies application ID 396 as the owning application identifier for the HZ_CODE_ASSIGNMENTS rows the package manages.
Key Procedures and Functions
- UPDATE_ORGANIZATION_START_DATE — updates the start date associated with an organization party.
- GET_UPDATE_DATE_FROM_PARTY, GET_UPDATE_DATE_FROM_LOCATION, GET_UPDATE_DATE_FROM_CONTACT — return the last update timestamp from the respective party, location, or contact record, enabling callers to detect staleness.
- UPDATE_INS_PARTY_PREF_COVER, UPDATE_OR_INSERT_PARTY_PREF, DELETE_PARTY_PREF, RETRIEVE_PARTY_PREF_COVER, RETRIEVE_PARTY_PREFERENCE — the preference maintenance group, providing insert, update, delete, and retrieval operations against party preference values.
- GET_PARTY_URL, GET_PARTY_SLOGAN, GET_PARTY_PORT — retrieve descriptive party-level attributes maintained in the organization profile.
- SET_WF_LANGUAGE / GET_WF_LANGUAGE, SET_WF_TERRITORY / GET_WF_TERRITORY, SET_WF_PREFERENCES / GET_WF_PREFERENCES — paired setters and getters that manage the working-context preferences used during workflow and document generation.
- GET_STRING — a lookup helper resolving message or reference strings from the message tables.
- SET_PRINT_OPTIONS — establishes print-related preference values for the current session context.
The package also declares the exception HZ_FAIL_EXCEPTION and a set of constants (OWNER_TABLE_NAME, PON_CLASSIFICATION, TRADING_PARTNER, TRADING_PARTNER_USER, PRIMARY_FLAG, CONTENT_SOURCE_TYPE, APPLICATION_ID, CREATED_BY_MODULE, OBJECT_VERSION_NUMBER, ACTIVE_STATUS) used when writing classification rows into HZ_CODE_ASSIGNMENTS.
Tables Accessed
- HZ_PARTIES, HZ_ORGANIZATION_PROFILES, HZ_RELATIONSHIPS — the core party and profile records the package reads and updates.
- HZ_CODE_ASSIGNMENTS — classification assignments, including the PON_CLASSIFICATION and TRADING_PARTNER designations.
- HZ_CONTACT_POINTS, HZ_LOCATIONS — contact point and address data used by the update-date and URL retrieval functions.
- PON_PARTY_PREFERENCES — the Purchasing-specific preference store written and read by the preference procedures.
- FND_APPLICATION, FND_LANGUAGES, FND_NEW_MESSAGES, FND_TERRITORIES, FND_USER — reference and lookup tables supporting language, territory, and message resolution.
Usage Notes
Because the package is declared AUTHID CURRENT_USER refining security to the calling schema, it is normally invoked from within the APPS runtime rather than by external tools. It is referenced by fourteen other packages, indicating it functions as a dependency for higher-level supplier profile and iProcurement APIs. Typical invocation points include Oracle Forms supplier setup screens, Java-based iProcurement pages that require preference and slogan data, and concurrent programs that refresh organization start dates or synchronize party preferences. Custom code should treat the documented procedures as the supported interface and should not manipulate PON_PARTY_PREFERENCES or HZ_CODE_ASSIGNMENTS directly, since the package enforces the constants, object version, and content source values required for data integrity.