Search Results set_reviewed_flag

Overview

PSB_Submit_Worksheet_PVT is a private (PVT) PL/SQL package in the APPS schema that supports the Oracle Enterprise Planning and Budgeting (PSB) worksheet submission and approval workflow. It encapsulates the server-side logic that drives worksheet lifecycle operations — creation, population, validation, review group approval, freezing, merging, and notification — as part of an Oracle Workflow-driven process. Because the package is classified as PVT, its procedures are not intended as a public integration API; they are invoked internally by workflow activities and sibling PSB packages. The presence of the set_reviewed_flag search term indicates this package is commonly examined when implementers investigate how a worksheet's reviewed status is programmatically set during the approval cycle, typically in the context of review group routing or sign-off behavior.

Key Procedures and Functions

The package exposes a workflow-oriented interface. START_PROCESS is the primary entry point, accepting API versioning, validation level, commit and message-list flags, plus business parameters such as item key, submitter identity, operation type, review group indicator, originating system, merge target worksheet, comments, operation ID, and constraint set ID. Several procedures follow the standard Oracle Workflow PL/SQL signature (itemtype, itemkey, actid, funcmode, result) and are wired as workflow function activities:

• POPULATE_WORKSHEET — assembles worksheet line data for the in-progress document.
• ENFORCE_CONCURRENCY_CHECK — verifies that no conflicting user has modified the worksheet.
• PERFORM_VALIDATION and VALIDATE_CONSTRAINTS — apply budget validation rules and constraint set checks to worksheet content.
• SELECT_OPERATION — determines the applicable operation path for the submission.
• COPY_WORKSHEET, MERGE_WORKSHEETS, FREEZE_WORKSHEETS, and UNFREEZE_WORKSHEETS — manage worksheet duplication, consolidation, and lock states.
• UPDATE_VIEW_LINE_FLAG and CHANGE_WORKSHEET_STAGE — maintain line-level display flags and move worksheets through stages.
• CREATE_REVIEW_GROUP_WORKSHEET, PERFORM_REVIEW_GROUP_APPROVAL, SELECT_APPROVERS, and FIND_APPROVAL_OPTION — implement review group routing and approver selection.
• SET_LOOP_LIMIT and NEW_WORKSHEET_CREATED — control workflow iteration and signal worksheet creation events.
• SET_REVIEWED_FLAG — marks a worksheet as reviewed, supporting review group sign-off and downstream approval decisions.
• SEND_APPROVAL_NOTIFICATION — dispatches approval notifications through the workflow notification system.

Tables Accessed

The package operates across the core PSB worksheet and budget schema through APPS synonyms. PSB_WORKSHEETS and PSB_WS_LINES hold the worksheet header and line records central to submission. PSB_WS_ACCOUNT_LINES and PSB_WS_LINES_POSITIONS store account-level and position-level line detail. Budget structure is referenced via PSB_BUDGET_ACCOUNTS, PSB_BUDGET_GROUPS, PSB_BUDGET_GROUP_CATEGORIES, PSB_BUDGET_GROUP_RESP, PSB_BUDGET_POSITIONS, PSB_BUDGET_STAGES, PSB_BUDGET_WORKFLOW_RULES, PSB_POSITIONS, and PSB_SET_RELATIONS. Workflow and approval routing data reside in PSB_WF_REVIEW_GROUPS and PSB_WORKFLOW_PROCESSES.

Usage Notes

PSB_Submit_Worksheet_PVT is invoked indirectly. Its workflow-signature procedures are registered as Oracle Workflow function activities within the worksheet submission and approval process, and it is referenced by one other PSB package. Direct calls from Forms are atypical; the Forms layer generally launches the workflow, which then executes these procedures. Customizations that require setting the reviewed flag or driving review group approval should be approached cautiously, since the PVT designation signals no public API commitment and signatures may change between 12.1.1 and 12.2.2. Where behavior must be extended, the recommended pattern is to wrap or replicate the relevant logic in a custom package rather than modify the seeded private package.