Search Results get_wf_item_attribute_number

Overview

EDR_PSIG_PAGE_FLOW is an Oracle E-Business Suite PL/SQL package body owned by APPS that implements the core routing and state-management logic for the EDR (Electronic Document Repository) electronic signature and approval workflow. In the context of Oracle EBS 12.1.1 and 12.2.2, this package governs how a signature page flows through the approval lifecycle when the response is captured in offline mode — that is, when an approver responds through a notification or a disconnected channel rather than synchronously through a form. The package bridges the EDR signature records (EDR_ERECORDS, EDR_ESIGNATURES, EDR_PSIG_DETAILS, EDR_PSIG_DOCUMENTS) with the Oracle Workflow engine (WF_ITEMS, WF_NOTIFICATIONS, WF_EVENT_T), deciding whether a response completes a signature, cancels it, rejects it, or moves the workflow to the next activity.

The user search term "edr_psig_doc_err" relates to error handling encountered while routing signature documents; this package is the routing engine whose logic surfaces such errors when a page flow cannot be resolved.

Key Procedures and Functions

• GET_PAGE_FLOW_STATUS — Returns the current status of the signature page flow for a given document or workflow item, used by callers to determine the next action.
• AUTHENTICATE_RESPONSE — Validates that a captured approver response is genuine and authorized before it is applied to the signature record.
• CANCEL_RESPONSE — Processes an approver's cancellation of a signature request, reversing pending approvals.
• PROCESS_RESPONSE — Applies a completed approver response to the underlying signature and document records.
• UPDATE_NOTIF_RESPONSE — Updates the associated Workflow notification to reflect the response outcome.
• NOTIF_APPROVED, NOTIF_CANCELED, NOTIF_REJECTED — Handle the approved, canceled, and rejected notification outcomes respectively, driving the corresponding workflow transitions.
• SPWAN_OFFLINE_PROCESS — Spawns the offline processing routine that handles responses submitted outside the live session.
• IS_IT_TOTAL_OFFLINE — Determines whether the page flow is operating in fully offline mode, which changes the routing path.
• CHECK_TIMEOUT — Evaluates whether a pending response has exceeded its allowed time window.
• GETITEMKEY, GETNOTIFICATIONID — Retrieval helpers returning the Workflow item key and notification identifier for a given flow.
• SEND_FINAL_APPROVAL_NTF, SEND_INDV_APPROVAL_NTF — Dispatch final and individual approval notifications to the next approvers in the hierarchy.
• RAISE_APPR_COMPLETION_EVT — Raises the Workflow approval-completion event.
• MOVE_WF_ACTIVITY — Advances the workflow instance to its next activity once the current step is satisfied.

Tables Accessed

The package reads and writes the EDR signature tables — EDR_ERECORDS, EDR_ESIGNATURES, EDR_PSIG_DETAILS, and EDR_PSIG_DOCUMENTS — to persist signature state and document linkage. EDR_TRANS_ACKN supplies transaction status via GET_TRANSACTIONSTATUS. FND_USER resolves approver identity. Workflow tables WF_ITEMS, WF_ITEM_ACTIVITY_STATUSES, WF_NOTIFICATIONS, WF_NOTIFICATION_ATTRIBUTES, WF_EVENT_T, and WF_PARAMETER_LIST_T support notification dispatch and activity transitions. PLITBLM is the standard EBS PL/SQL table used internally for list handling.

Usage Notes

EDR_PSIG_PAGE_FLOW is invoked principally from Oracle Workflow notification callbacks and from the EDR signature-responses form in offline mode, rather than from a standalone concurrent program. It is referenced by eight other packages, indicating it is a shared routing service within the EDR module. Customizations should call only the documented wrapper APIs (for example, GET_WF_ITEM_ATTRIBUTE_NUMBER and GET_WF_ITEM_ATTRIBUTE_TEXT, introduced by Bug 3916445) instead of accessing Workflow item attributes directly, and should treat the G_YES/G_NO and G_PRESUCCESS_STATUS/G_SUCCESS_STATUS constants as the canonical completion and status markers.