Search Results insert_history_record

Overview

CE_BASIG_WF is the Oracle Workflow callback package that implements the bank account signatory approval process within the Cash Management (CE) module. In Oracle E-Business Suite 12.1.1 and 12.2.2, bank account signatory maintenance can require one or more approvers before a signatory assignment becomes effective. CE_BASIG_WF supplies the PL/SQL logic behind the associated workflow item type, providing the activity functions that drive the workflow forward, evaluate routing decisions, and persist the outcome of the approval cycle to the signatory history tables. The package is defined with AUTHID CURRENT_USER, so all unqualified object references resolve through the calling user's schema, which in practice means the APPS synonyms for the CE and FND tables it touches.

The presence of REJECT_SIGNATORY and the related history-update routines makes the package particularly relevant to rejection handling. When a user searches for "reject_signatory," the object of interest is the activity function that terminates the approval workflow with a rejection result and records that outcome in the signatory history.

Key Procedures and Functions

• SELECT_NEXT_APPROVER — Determines and returns the next approver in the signatory approval chain, driving the routing decision at that workflow activity.
• UPDATE_SIGNATORY_HISTORY_APPR — Records the approval outcome against the signatory history for the signatory being processed.
• UPDATE_SIGNATORY_HISTORY_REJ — Records the rejection outcome in the signatory history, complementing the approval-side update.
• APPROVE_SIGNATORY — Workflow activity function invoked when a signatory assignment is approved; it applies the approval result and advances the process.
• REJECT_SIGNATORY — Workflow activity function invoked when a signatory assignment is rejected, terminating the approval path and triggering rejection-side history maintenance.
• SELECTOR — Standard workflow selector routine used to choose the next activity or branch based on the current command and process state.
• STARTIT — Initialization entry point keyed by an identifier, used to launch the signatory approval workflow.
• INITIALIZE — Sets up the workflow context using the application identifier, transaction identifier, and an optional transaction type.
• INIT_ALL — Master callback that dispatches to the appropriate initialization logic for an item type, item key, activity, and command.
• INSERT_HISTORY_RECORD — Inserts a history record reflecting the supplied action, providing the common write path for approval and rejection history entries.

Tables Accessed

• CE_BANK_ACCOUNTS — The bank account header being processed; provides account context for the signatory approval.
• CE_BA_SIGNATORIES — The current signatory assignments, read to identify who is being approved or rejected and written when an outcome is applied.
• CE_BA_SIGNATORY_HIST_H — The signatory history table, where approval and rejection records are inserted via INSERT_HISTORY_RECORD and the history-update procedures.
• FND_CURRENCIES — Currency reference data, referenced when account information requires currency context.
• FND_USER — Resolves approver and signatory identities to application users.

Usage Notes

CE_BASIG_WF is not intended for direct invocation by end users or custom code. It is invoked by the Oracle Workflow engine as the activity callback for the signatory approval item type, with Oracle Forms serving as the user interface that submits signatory assignments into the process. Each procedure conforms to the standard Workflow callback signature so that the engine can pass item type, item key, activity, and function mode, and receive the result code that determines subsequent processing. Because the package is not referenced by any other documented package, integration points are limited to the workflow framework itself. Customizations should extend the workflow definition rather than call CE_BASIG_WF procedures directly, and any custom reads of the history tables should account for the AUTHID CURRENT_USER resolution and the APPS synonym layer.