Search Results launch_profile_mon

Overview

The APPS.MSC_CL_PROFILE_LOADERS package is a PL/SQL utility within the Oracle Advanced Supply Chain Planning (ASCP) module of Oracle E-Business Suite. Its principal business function is to orchestrate the parallel loading of profile option values that govern planning data collection and profile monitoring operations. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, which is a deliberate design choice for a loader utility that must respect the schema context of the caller.

The package header (version 115.0, dated 2003) defines only a small set of public constructs: two collection types (NumTblTyp and VarcharTblTyp), a series of status and system constants, and a single public procedure, LAUNCH_PROFILE_MON. The constants encapsulate the package's internal convention for representing "null" values within SQL WHERE clauses, and this is directly relevant to the search term null_date.

Key Procedures and Functions

Only one procedure is documented in the ETRM metadata:

• LAUNCH_PROFILE_MON — The sole public entry point. As its name suggests, it launches a profile monitoring process. It accepts parameters controlling execution timeout, path separators, control file paths, directory paths, the number of parallel workers, and an optional profile value retrieval flag. It returns an error buffer and a numeric return code to the caller. The procedure coordinates a multi-worker (parallel) load, consistent with the PIPE_TIME_OUT and worker-status constants declared in the header.

Supporting declarations include constants SYS_YES, SYS_NO, G_SUCCESS, G_WARNING, and G_ERROR for status reporting, and OK/FAIL for worker state. No other functions or procedures are published.

Tables Accessed

The package references the following objects via APPS synonyms:

• DBMS_LOCK — Used to serialize concurrent worker sessions and prevent overlapping profile-load runs. This is essential in a parallel loader where multiple workers must not corrupt shared state.
• DUAL — Used for single-row constant evaluation, including the derivation of the NULL_DATE sentinel value (SYSDATE-36500, i.e., roughly 100 years prior).
• PLITBLM — The PL/SQL table/array management package, used to manipulate the NumTblTyp and VarcharTblTyp collections.

Usage Notes

The package is not referenced by any other documented packages, so it is invoked directly — typically from a concurrent program or an ASCP administrator form — rather than through an API chain. It is a utility layer, and its presence in the ETRM registry reflects its role in the profile-loading infrastructure of ASCP.

Regarding the search term null_date: the constant NULL_DATE CONSTANT DATE := SYSDATE-36500 is the specific construct the user is likely seeking. It is not a true NULL; it is a sentinel date value chosen to be safely outside any realistic planning horizon. It is complemented by NULL_VALUE (-23453) and NULL_CHAR ('-23453') for numeric and character columns. These sentinels allow the loader to distinguish a genuine "no value supplied" condition from an actual business value in SQL predicates. Custom code that reproduces or extends this package's behavior should re-use the same sentinel semantics to remain compatible with the loader's filtering logic.