Search Results pmt_raise_event

Overview

APPS.CN_PAYMENT_SECURITY_PVT is a private PL/SQL package within the Oracle E-Business Suite Incentive Compensation (CN) module. Its role is to centralize the security, authorization, and audit logic that governs payment worksheets, pay runs, and the approval workflow associated with sales compensation disbursement. Because it is classified as a PVT (private) API rather than a public API, it is not intended to be called directly by customer extensions; instead it is consumed internally by the public payment-processing packages of the CN schema.

The package abstracts the rules that determine whether a given user is entitled to view, modify, approve, or submit a payment transaction. This includes superuser overrides, managerial hierarchy checks, sales-group level access, and the "pay by" mode that controls whether payment is driven at the resource or group level. It also raises workflow events so that the Oracle Workflow engine can advance approval flows in step with security decisions.

Key Procedures and Functions

The ETRM metadata documents eleven callable units. They fall into four functional clusters:

• Privilege evaluation: IS_SUPERUSER and IS_MANAGER return whether the current user holds elevated privileges or manages other resources, respectively. GET_SECURITY_ACCESS resolves the concrete access rights of a user against the payment records in scope.
• Auditing: WORKSHEET_AUDIT, PAYRUN_AUDIT, and PAID_PAYRUN_AUDIT record audit-trail entries for worksheet and pay-run activity, including the distinct case of a pay run that has already been paid.
• Action processing: WORKSHEET_ACTION and PAYRUN_ACTION perform the security-checked state transitions on worksheets and pay runs.
• Configuration and eventing: GET_PAY_BY_MODE returns the effective payment mode; UPDPAYSHTACCESS updates payment-sheet access records; PMT_RAISE_EVENT raises the workflow event that notifies downstream approvers.

Parameter lists are deliberately not reproduced here; callers should obtain signatures from the deployed package specification.

Tables Accessed

The package reads and writes a focused set of APPS-synonym tables:

• CN_PAYMENT_WORKSHEETS and CN_PAYRUNS — the transactional payment entities whose access is being validated and audited.
• CN_PAY_APPROVAL_FLOW and CN_PERIOD_STATUSES — approval routing and period-open checks that constrain whether an action is permitted.
• JTF_RS_GROUP_USAGES, JTF_RS_REP_MANAGERS, JTF_RS_RESOURCE_EXTNS — the resource-model tables used to resolve managerial hierarchy and group membership for the IS_MANAGER and GET_SECURITY_ACCESS logic.
• WF_PARAMETER_LIST_T — the Oracle Workflow parameter list populated when PMT_RAISE_EVENT is invoked.
• DUAL and PLITBLM — supporting constructs used for scalar evaluation and bulk PL/SQL table handling.

Usage Notes

The package is referenced by four sibling packages in the CN schema: CN_PAYMENT_SECURITY_PVT (its own recursive reference), CN_PAYMENT_WORKSHEET_PVT, CN_PAYRUN_PVT, and CN_PAY_APPROVAL_FLOW_PVT, with a further reference from CN_PMT_TRANS_PVT noted in the ETRM dependency section. These callers invoke it during worksheet creation, pay-run submission, and approval-flow progression, and it in turn depends on FND_API for the standard EBS API error-handling and message conventions.

Because CN_PAYMENT_SECURITY_PVT is a private package, customizations should call the corresponding public APIs rather than this object directly. In Oracle EBS 12.1.1 and 12.2.2 the package is deployed under the APPS schema and is marked VALID. Any customer code that does reference it must be re-validated after patching, since private CN packages are routinely replaced during adop-based online patching in 12.2.2 and during standard patching in 12.1.1.