Search Results check_last_opened_period




Overview
Explore in AI Chat

Overview

GL_MOVEMERGE_REQUESTS_PKG is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite, declared AUTHID CURRENT_USER. Its documented purpose is to provide the server routines that operate on the GL_MOVEMERGE_REQUESTS table, which stores the account move and merge requests used by General Ledger to consolidate, transfer, or combine account balances across ledgers and charts of accounts. The package encapsulates the business rules, validations, and identifier generation logic that surround those requests, and it serves as the data-access and validation layer behind the move/merge maintenance user interface. Its header history dates to 1997, and the most recent shipped revision of the source is dated 2004, indicating a stable, long-lived component of the General Ledger schema.

Key Procedures and Functions

  • GET_UNIQUE_ID — Function that returns the next value from the GL_MOVEMERGE_REQUESTS_S sequence, supplying primary keys for new move/merge request rows. It raises GL_ERROR_GETTING_UNIQUE_ID on failure.
  • MUST_HAVE_ACCOUNTS — Procedure that enforces the business rule that every GL_MOVEMERGE_REQUESTS record must have at least one associated GL_MOVEMERGE_ACCOUNTS record. It raises GL_MM_REQUEST_WITHOUT_ACCOUNTS when the rule is violated.
  • DELETE_ALL_ACCOUNTS — Procedure that performs the cascade delete from the parent request to its child account rows, keeping the two tables consistent when a request is removed.
  • CHECK_UNIQUE_NAME — Procedure that validates that a move/merge request name is unique, taking a row identifier, chart of accounts identifier, and name as its inputs.
  • PRE_INSERT — Procedure that performs validations on the request block before an insert is applied, covering name and chart of accounts context.
  • VALIDATE_SEGMENTS — Function that calls the segment validation routine in FND_FLEX_KEYVAL, accepting an operations string, a concatenated accounting flexfield string, and a chart of accounts identifier, and returning the validation result.
  • CHECK_LAST_OPENED_PERIOD — Procedure associated with period-related validation for move/merge processing.
  • GET_MM_LEDGER_ID — Procedure or function that resolves the ledger identifier relevant to a move/merge request from the ledger configuration tables.

Tables Accessed

The package works primarily with GL_MOVEMERGE_REQUESTS and its child GL_MOVEMERGE_ACCOUNTS, and it reads the request sequence GL_MOVEMERGE_REQUESTS_S for key generation. Ledger resolution and validation draw on GL_LEDGERS, GL_LEDGER_RELATIONSHIPS, and GL_LEDGER_SET_ASSIGNMENTS, and the package may reference DUAL for trivial contextual queries.

Usage Notes

This package is invoked from the General Ledger move/merge maintenance forms to validate names, accounts, and segments before rows are committed, and it may be called from custom code that creates or purges move/merge requests. Because VALIDATE_SEGMENTS delegates to FND_FLEX_KEYVAL, callers must supply a valid chart of accounts identifier and a correctly formatted concatenated segment string. No other documented package references GL_MOVEMERGE_REQUESTS_PKG, so its exposure is chiefly through the forms layer.