Search Results set_tolerance_level
Overview
APPS.OZF_RESALE_WF_PVT is a private PL/SQL package within the Oracle Trade Management (formerly Oracle Price Protection / Resale) module of Oracle E-Business Suite. Its identifier, OZF_RESALE_WF_PVT, indicates that it is an internal helper package dedicated to resale batch processing driven by Oracle Workflow. The package was created in February 2004 (header ozfvrwfs.pls 120.4) and is owned by APPS, with a declared AUTHID CURRENT_USER pragma. It is classified as a private (PVT) API, meaning it is not intended for direct invocation by external callers; it is consumed internally by the resale workflow infrastructure.
The package encapsulates the business rules that govern batch lifecycle transitions for resale, chargeback, special pricing, and tracing transactions. It uses a large set of package-level constants to standardize Workflow item attribute names (for example, OZF_RESALE_BATCH_ID, OZF_BATCH_NUMBER, OZF_ERROR_MESSAGE, and OZF_RESALE_BATCH_STATUS) and lookup codes for batch sources such as UI, WEBADI, and XML, as well as status values PENDING_PAYMENT, PROCESSING, ERROR, and SUCCESS. These constants ensure that attribute names and status codes are applied consistently whether a batch originates from a web form, Web ADI upload, or XML import.
Key Procedures and Functions
ETRM documents twenty-six procedures and functions in this package. The principal entry points include PROCESS_RESALE, PROCESS_CHARGEBACK, PROCESS_SPECIAL_PRICING, and PROCESS_TRACING, which drive the respective transaction workflows. Payment handling is provided by INITIATE_PAYMENT and its specialized variants INITIATE_PAYMENT_CHARGEBACK, INITIATE_PAYMENT_SPP, and INITIATE_PAYMENT_TRACING.
Batch validation and integrity are handled by CHECK_DUPLICATES, VALIDATE_BATCH, and VALIDATE_ORDER. State management utilities include INIT_ATTRIBUTES, RESET_STATUS, SET_BATCH_STATUS, and SET_PAYMENT_PENDING, supported by the accessor functions GET_BATCH_STATUS, GET_BATCH_TYPE, GET_BATCH_CALLER, and GET_AUTO_ACCRUAL_FLAG. SET_TOLERANCE_LEVEL governs tolerance thresholds applied during processing. Together these routines form the private engine that a developer or support analyst would encounter when tracing the processing path of a resale batch attribute such as tracing or chargeback status.
Tables Accessed
The package operates against several documented tables through APPS synonyms. OZF_RESALE_BATCHES_ALL is the primary batch entity table and is queried (via the g_batch_type_csr cursor) and updated to persist batch status. OZF_SYS_PARAMETERS supplies configuration values such as auto-accrual and tolerance settings. OZF_CUST_TRD_PRFLS provides customer trade profile data used during validation and accrual determination. JTF_RS_RESOURCE_EXTNS supplies resource (sales representative) information. Workflow integration is achieved through WF_ITEM_ATTRIBUTE_VALUES and WF_PARAMETER_LIST_T, which store and retrieve Workflow item attribute values that carry batch context between activities.
Usage Notes
Because this is a PVT package, it is invoked indirectly. It is called from the resale batch concurrent programs, Oracle Forms-based batch entry screens, and the Workflow background engine when a resale, chargeback, special pricing, or tracing batch is submitted. The package is referenced by one other package, reflecting its role as a shared private utility rather than a public API surface.
When investigating process_tracing issues, support personnel should note that PROCESS_TRACING, INITIATE_PAYMENT_TRACING, and the tracing lookup constant G_WF_LKUP_TRACING are the relevant internal artifacts; any diagnostics should be performed by logging or wrapping calls rather than altering the package directly, as upgrades may overwrite it.