Search Results g_name

Overview

CE_BASIG_WF is a PL/SQL package body owned by the APPS schema in Oracle E-Business PL/SQL environment. It serves as the workflow integration layer for the Cash Management bank signatory approval process. The package bridges Oracle Workflow and the signatory maintenance functionality, enabling electronic routing, approval, and rejection of bank signatory records through the Oracle Approvals Management (AME) and Workflow engines. In EBS 12.1.1 and 12.2.2, the package is classified under API classification "OTHER" and is not referenced by any other documented package, indicating it is an integration endpoint rather than a reusable utility.

The package relies heavily on package-level global variables — including g_name, g_signatory_id, g_approver_person_id, g_bank_account_name, g_currency_code, and g_org_id — to hold signatory context across the workflow callbacks. The user search term "g_name" corresponds to one of these package globals, a VARCHAR2(100) variable that carries signatory name context during workflow execution.

Key Procedures and Functions

• INITIALIZE — Establishes the session context by retrieving the ORG_ID profile, setting the multi-org context via FND_CLIENT_INFO, initializing the global application context, and clearing prior AME approvals for the transaction.
• INIT_ALL — Performs broader initialization of all package state used during the workflow lifecycle.
• SELECTOR — Standard workflow selector function that determines the next processing step in the signatory workflow.
• SELECT_NEXT_APPROVER — Workflow callback that identifies and returns the next approver for the signatory transaction, interacting with AME approver records.
• STARTIT — Initiates the workflow process for a signatory approval transaction.
• APPROVE_SIGNATORY — Handles the approval action, updating the signatory record and advancing the workflow.
• REJECT_SIGNATORY — Handles rejection, returning the signatory record to an appropriate state.
• UPDATE_SIGNATORY_HISTORY_APPR — Writes an approval entry into the signatory history table.
• UPDATE_SIGNATORY_HISTORY_REJ — Writes a rejection entry into the signatory history table.
• INSERT_HISTORY_RECORD — Inserts a general audit record capturing signatory workflow activity.

Tables Accessed

• CE_BA_SIGNATORIES — Primary signatory definition table; read for limits, dates, and person attributes, and updated during approval/rejection.
• CE_BA_SIGNATORY_HIST_H — History table where approval, rejection, and audit records are inserted.
• CE_BANK_ACCOUNTS — Source of bank account name and account number context captured in globals such as g_bank_account_number.
• FND_CURRENCIES — Provides currency code values for limit evaluation.
• FND_USER — Resolves workflow user names to application user accounts.

Usage Notes

CE_BASIG_WF is invoked indirectly through the Oracle Workflow engine rather than called directly by custom code. It is triggered when a bank signatory record is submitted for approval from the Cash Management signatory maintenance forms. The workflow callbacks (SELECT_NEXT_APPROVER, APPROVE_SIGNATORY, REJECT_SIGNATORY) execute within the Workflow background process, and INITIALIZE establishes the required multi-org and AME context before each run. Because the package is documented as referenced by zero other packages, customization should avoid direct invocation; instead, extend behavior through Workflow attributes and AME rules. The package globals such as g_name are session-scoped and must not be relied upon outside the workflow transaction boundary.