Search Results chk_approval_authority

Overview

APPS.PER_JOB_BUS is the business-rule layer of the Oracle EBS Job (HR) entity. It sits beneath the table-handler package PER_JOB_API and above the base table PER_JOBS, and encapsulates the validation logic that governs the creation, maintenance, and deletion of job records in Oracle Human Resources. In Oracle EBS 12.1.1 and 12.2.2 the package is classified as an OTHER API rather than a public interface, meaning it is intended primarily for internal table-handler and forms use rather than direct third-party invocation.

The package header comment identifies it as pejobrhi.pkb and describes it as a business-rule package whose procedures raise application errors and halt processing when a business rule is violated. The 15 documented procedures cover insert, update, and delete validation, legislative-code resolution, and a series of field-level checks. The "chk_approval_authority" procedure, which the user searched for, is one of these field-level validators and is documented as CHK_APPROVAL_AUTHORITY.

Key Procedures and Functions

The API exposes the following documented procedures and functions:

• INSERT_VALIDATE — entry-point validation executed before a new job row is inserted; delegates to the individual check procedures.
• UPDATE_VALIDATE — validation executed before an existing job row is updated.
• DELETE_VALIDATE — validation executed before a job row is deleted.
• RETURN_LEGISLATION_CODE — derives the legislation code for a given job; drives the two private globals g_legislation_code and g_job_id.
• CHK_NON_UPDATEABLE_ARGS — asserts that arguments which must not change on update remain unchanged.
• CHK_EMP_RIGHTS_FLAG — validates the employee-rights indicator.
• CHK_JOB_GROUP_ID — verifies that a job group identifier is valid.
• CHK_APPROVAL_AUTHORITY — validates the approval-authority attribute of a job record.
• CHK_BENCHMARK_JOB_FLAG — validates the benchmark-job indicator.
• CHK_BENCHMARK_JOB_ID — validates the benchmark-job reference when the benchmark flag is set.
• CHECK_UNIQUE_NAME — enforces uniqueness of job name within the business group.
• CHECK_DATE_FROM — validates the date-from value.
• CHECK_ALTERED_END_DATE — validates the altered end date.
• CHECK_DELETE_RECORD — confirms the record may be deleted (for example, no dependent assignments).
• CHECK_EVALUATION_DATES — validates evaluation date ranges.

Parameter lists are not reproduced here; callers should obtain exact signatures from the packaged source or the data dictionary.

Tables Accessed

The package reads and (through the table handler) writes PER_JOBS, and additionally references PER_JOB_DEFINITIONS, PER_JOB_GROUPS, PER_JOB_EVALUATIONS, PER_JOB_REQUIREMENTS, PER_VALID_GRADES, PER_CAREER_PATH_ELEMENTS, PER_BUDGET_ELEMENTS, PER_ROLES, HR_ALL_POSITIONS_F, PER_ALL_ASSIGNMENTS_F, and PAY_ELEMENT_LINKS_F via APPS synonyms. PER_JOB_DEFINITIONS supplies job-definition validation, PER_JOB_GROUPS supports CHK_JOB_GROUP_ID, PER_JOB_EVALUATIONS supports CHECK_EVALUATION_DATES, and the assignment/position/pay tables supply dependency checks used by CHECK_DELETE_RECORD. DBMS_SQL is used for dynamic SQL within the package.

Usage Notes

PER_JOB_BUS is invoked indirectly through PER_JOB_API from the Job form and from concurrent/HR processes rather than called directly by custom code. The four packages that reference it rely on its validate procedures. If extending or debugging job validation — particularly the approval-authority check — trace through INSERT_VALIDATE or UPDATE_VALIDATE rather than calling CHK_APPROVAL_AUTHORITY in isolation, as the orchestrating procedures establish the required context.