Search Results get_route_data_to_owner

Overview

APPS.CSM_PROFILE_PKG is a profile-value resolution package in Oracle E-Business Suite, owned by the APPS schema and classified as an OTHER-type API. Its declared purpose, per the embedded header comment, is to "contain routines getting profile values." Rather than exposing a single generic accessor, the package provides a family of typed getter functions that translate Oracle EBS profile option settings into the specific numeric and character values required by the Complex Maintenance, Repair and Overhaul (CSM) and Enterprise Asset Management (EAM) application flows. The header identifies the base creation author as Melvin P (04/30/02), with the latest shipped revision being 120.5.12020000.2 (2013/04/09), confirming that the package is maintained across the 12.1.1 and 12.2.2 release streams.

The package is declared AUTHID CURRENT_USER, meaning that resolution of the FND profile tables and APPS synonyms occurs under the privileges of the calling session rather than the definer. It also declares three package-level constants — G_CLIENT_WINS, G_SERVER_WINS, and G_JTM_APPL_CONFLICT_RULE, plus G_CSF_M_HISTORY_DAYS (NUMBER := 7) — which are used internally to interpret conflict-rule and history-window settings.

Key Procedures and Functions

The ETRM metadata documents eighteen functions. The most general is VALUE_SPECIFIC, which returns a profile option value as a VARCHAR2 given a profile option name and, optionally, a user, responsibility, and application context — the standard FND profile hierarchy. Several typed getters wrap this pattern for numeric IDs:

• GET_MASTER_ORGANIZATION_ID, GET_SERVICE_VALIDATION_ORG, GET_ORGANIZATION_ID, and GET_ORG_ID return organization identifiers used for inventory and service validation.
• GET_CATEGORY_SET_ID and GET_CATEGORY_ID return the category set and category identifiers used in CSM/EAM item classification.
• GET_HISTORY_COUNT and GET_TASK_HISTORY_DAYS return numeric history-window settings that govern how many historical records are retained or displayed.
• GET_MAX_ATTACHMENT_SIZE, GET_MAX_IB_AT_LOCATION, and GET_MAX_READINGS_PER_COUNTER return resource limits (attachment size, installed-base quantities per location, and meter readings per counter).
• GETDEFAULTSTATUSRESPONSIBILITY resolves a default responsibility used when a status-driven task is created.
• GET_CHANGE_COMPLETED_TASKS, SHOW_NEW_MAIL_ONLY, GET_ROUTE_DATA_TO_OWNER, and GET_DOWNLOAD_INVENTORY_FLAG return boolean-style flags controlling task-change behaviour, mail display, routing of data to the owner, and whether inventory is downloaded to mobile devices.
• GET_MOBILE_QUERY_SCHEMA returns the schema name used by the mobile query layer — the function referenced in the user's search and the key accessor for mobile-field-service query generation.

Each function accepts (or defaults) the standard user/responsibility/application arguments, but parameter lists are defined in the package specification as documented in the source and are not reproduced here.

Tables Accessed

The package reads the standard FND profile tables via APPS synonyms: FND_PROFILE_OPTIONS and FND_PROFILE_OPTION_VALUES supply the option definitions and their hierarchical values, while FND_APPLICATION, FND_USER, and FND_RESPONSIBILITY supply the context identifiers used to resolve the correct level. CSM_PROFILE_OPTION_VALUES_ACC provides application-specific profile values, and ASG_USER supports user-level (assignment) resolution. The package is documented as read-only with respect to these tables; it does not maintain profile data.

Usage Notes

CSM_PROFILE_PKG is invoked at runtime by CSM/EAM forms, concurrent programs, and mobile-field-service flows whenever a profile-driven value must be resolved in the current session context. The metadata records that it is referenced by 31 other packages, confirming that it is a shared utility rather than a standalone API. Custom code should call the typed getters instead of querying FND_PROFILE tables directly, so that hierarchy resolution and application-specific overrides are honoured consistently. Because the package is AUTHID CURRENT_USER, callers require EXECUTE privilege and appropriate read access to the underlying FND and CSM profile tables. Full parameter lists should be confirmed against the installed package specification before use.