Search Results delete_job_role

Overview

APPS.CN_JOB_TITLE_PVT is a private PL/SQL package body within the Oracle EBS Channel Management (CN) module. It encapsulates the business logic governing the relationship between job roles and job titles assigned to sales representatives. The package header is generated from the source file cnvjobb.pls (version 115.14.115100.3), indicating its origin in the Channel Management schema. In Oracle EBS 12.1.1 and 12.2.2, the "_PVT" suffix designates a private API layer: the procedures within this body are not intended to be called directly from external code but are instead invoked by the corresponding public wrapper package (CN_JOB_TITLE_PUB). The package provides both transactional operations (create, update, and delete of job roles) and read-only query routines that return job role, job title, and role detail information to calling forms and concurrent processes.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions exposed by this package body:

• CREATE_JOB_ROLE — Inserts a new job role assignment record, validating that the underlying job title and role combination meets business constraints before committing.
• UPDATE_JOB_ROLE — Modifies an existing job role record, typically re-validating date ranges and usage to preserve data integrity.
• DELETE_JOB_ROLE — Removes a job role assignment, subject to validation that no sales representative currently depends on it.
• GET_JOB_DETAILS — Returns detailed attributes for a specific job role or job title record.
• GET_JOB_TITLES — Retrieves a set of job titles matching the supplied selection criteria.
• GET_ALL_JOB_TITLES — Returns the complete list of job titles available in the system, commonly used to populate a list of values.
• GET_JOB_ROLES — Retrieves job role records, providing the association between job titles and roles.

Two additional internal validation procedures are visible in the source excerpt: valid_no_srp, which verifies that a job role is not referenced by any sales representative before allowing modification, and Verify_Date, which compares a proposed date range against the minimum start date and maximum end date of existing sales rep assignments, raising FND_API.G_EXC_ERROR with message CN_JOB_ROLE_USED when a conflict exists.

Tables Accessed

The package operates primarily on the CN_JOB_ROLES table (referenced through the APPS synonym), which stores the association between a job role and its position within the Channel Management hierarchy. The source excerpt additionally references CN_SRP_ROLE_DTLS_V, CN_SRP_JOB_TITLES, and CN_SRP_ROLES to cross-check whether sales representatives ("SRPs") are assigned to the job title and role being modified. These joins enforce referential integrity between job role definitions and live sales rep provisioning records.

Usage Notes

CN_JOB_TITLE_PVT is invoked indirectly through its public counterpart, CN_JOB_TITLE_PUB, and is referenced by two other packages, reflecting its role as a shared utility within the Channel Management module. Typical invocation points include the Job Titles and Job Roles maintenance forms in the Channel Management responsibility, where users create or amend role provisioning data, and any concurrent program or extension that queries job title and role associations. Because the package raises standard FND_API exceptions and uses FND_MESSAGE/FND_MSG_PUB for error communication, callers must implement the standard EBS exception handling pattern, checking FND_MSG_PUB.Count_And_Get after any API invocation. Direct calls to the private body should be avoided in customizations; developers integrating with this functionality should use CN_JOB_TITLE_PUB to insulate their code from internal implementation changes.