Search Results get_job_roles

Overview

APPS.CN_JOB_TITLE_PVT is a private PL/SQL package in the Oracle EBS Incentive Compensation (CN) module. It provides the core programmatic interface for maintaining the relationship between job titles and roles within the compensation engine. In Incentive Compensation, a job title represents an organizational position, and a role represents a functional responsibility (for example, a sales representative role or a sales manager role). The CN_JOB_ROLES table binds the two together, and this package encapsulates the business logic that creates, modifies, and removes those bindings while enforcing standard concurrent-programming and validation conventions.

The package declares AUTHID CURRENT_USER and is classified as a PVT (private) API, meaning it is intended for internal consumption by other Incentive Compensation packages rather than as a public integration surface. It defines two PL/SQL record types, job_title_rec_type and job_role_rec_type, plus their index-by tables. The job role record mirrors the full CN_JOB_ROLES row layout, including the fifteen descriptive flexfield attributes, the default flag, the effective start and end dates, and the object version number used for optimistic locking.

Key Procedures and Functions

• CREATE_JOB_ROLE — Inserts a new job title to role assignment. Accepts an API version and initialization flag along with a job role record, and returns the newly generated job role identifier.
• UPDATE_JOB_ROLE — Modifies an existing job role assignment, including effective dates, the default flag, and flexfield attribute values.
• DELETE_JOB_ROLE — Removes a job role assignment from the repository.
• GET_JOB_DETAILS — Retrieves descriptive details for a specific job title.
• GET_JOB_TITLES — Returns job title information for a defined selection criteria set.
• GET_ALL_JOB_TITLES — Returns the complete set of job titles, typically used to populate list-of-values selections.
• GET_JOB_ROLES — Returns the roles associated with a job title, expressed through the job_role_tbl_type structure. This is the procedure most frequently referenced by callers searching for job role retrieval logic, and the one most often invoked by dependent packages to resolve a job title into its role assignments.

Tables Accessed

The package operates against CN_JOB_ROLES, accessed through the APPS synonym. This table stores the intersection between job titles and roles, together with the effective dating and flexfield columns defined in job_role_rec_type. The referenced views CN_JOB_TITLES and CN_ROLES supply the descriptive name and code columns embedded in the record definitions, and the private package maintains both the assignment rows and their associated descriptive flexfield context.

Usage Notes

Because CN_JOB_TITLE_PVT is a private API, it is normally invoked by sibling Incentive Compensation packages rather than directly by external integrations. The ETRM metadata records that two other packages reference it, confirming this internal dependency pattern. Within the standard application, job title and role maintenance is driven from the Incentive Compensation administrative setup forms, which delegate persistence and validation to this layer. Concurrent programs that seed or validate compensation plan structures may also call it.

Custom development should treat CN_JOB_TITLE_PVT as an internal implementation detail. Where job role data must be read or written from custom code, the supported approach is to call the corresponding public Incentive Compensation API rather than this private package, since private package signatures are not guaranteed across patches or point releases. When direct invocation is unavoidable, callers should supply p_api_version, set p_init_msg_list consistently with FND_MSG_PUB conventions, honor the object version number on updates to respect optimistic locking, and inspect the standard return status and message stack before committing.