Results for “delete_corps”
10 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PQH_CORPS_COPY is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and delivered as part of the Public Sector/HR "Corps" (Corps of Engineers-style career group) configuration utilities. Its principal role is to duplicate an existing corps definition — including its associated grades, documents, examinations, training requirements, organizations, and career-path structures — into a new corps definition within a specified business group and effective date range. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking session rather than the definer, so callers must already hold the requisite HR and corps configuration privileges.
In the 12.1.1 and 12.2.2 codelines, PQH_CORPS_COPY is a maintenance and setup-migration utility. It allows implementers to clone a fully configured corps (a grouping construct used to organize career paths and progression rules) rather than re-entering every grade, spinal point, and career-path node by hand. The header comment identifies the source file as pqcpdcpy.pkh, a "noship" (non-shipped to customer-visible menus) package, confirming its role as an internal API rather than an end-user-facing screen.
Key Procedures and Functions
- COPY_CORPS — The central entry point. It copies a source corps definition into a new corps, accepting control flags that govern which subordinate components are duplicated: grades, documents, exams, training, organizations, career data, and "others," plus ten generic filler/reference code parameters (
p_filere1_cdthroughp_filere10_cd). It also accepts name, nature code, business group, and effective date. - GET_STEP_NAME / GET_GRADE_NAME / GET_GRADE_ID — Lookup helpers that resolve a grade-step identifier to its step name, grade name, or parent grade identifier, respectively, supporting validation and reporting during the copy.
- GET_HIER_VER — Returns the current hierarchy version used to anchor career-path copying.
- INSERT_CAREER_PATH / UPDATE_CAREER_PATH / DELETE_CAREER_PATH — Maintain individual career-path nodes, mapping a source grade step to a destination grade step and recording seniority bounds and node/version output parameters.
- ADD_CORPS_FILERES / DELETE_CORPS_FILERES — Populate or remove the ten filler/reference code attributes associated with a corps.
- DELETE_CORPS / DELETE_CORPS_GRADE — Remove an entire corps definition or a single grade association, providing the inverse of the copy operation.
Tables Accessed
The package operates against the HR grade and hierarchy model:
- PER_GEN_HIERARCHY / PER_GEN_HIERARCHY_NODES / PER_GEN_HIERARCHY_VERSIONS — Store the generic hierarchy header, node, and version records that underpin career paths; the package reads the active version and writes new nodes when career paths are copied.
- PER_GRADES — The grade definition table, used to resolve and duplicate grade records.
- PER_GRADE_SPINES_F / PER_SPINAL_POINTS / PER_SPINAL_POINT_STEPS_F — Date-effective grade-spine, spinal-point, and spinal-point-step tables that define the step structure copied with each grade.
Access occurs through APPS synonyms, so the underlying objects reside in the HR (PER) schema.
Usage Notes
PQH_CORPS_COPY is invoked programmatically — typically from corps administration forms in the Public Sector/HR module or from custom setup scripts and concurrent programs that automate configuration migration between environments. Because it is an AUTHID CURRENT_USER package and is flagged "noship," it should not appear on standard menus. ETRM records that it is referenced by one other package, indicating a controlled, layered dependency rather than broad public use. When invoking it, callers should supply a valid business group and effective date, and be aware that the copy flags default to 'Y' for grades, docs, exams, training, organizations, others, and career, meaning a bare call duplicates the full corps footprint. The delete procedures should be used with the same care as any date-effective HR data removal, since they affect hierarchy nodes and grade associations consumed by ongoing career-path processing.
-
PACKAGE: APPS.PQH_CORPS_COPY 12.2.2
-
PACKAGE: APPS.PQH_CORPS_COPY 12.1.1
-
PACKAGE: APPS.PQH_CORPS_COPY 12.2.2
-
PACKAGE: APPS.PQH_CORPS_COPY 12.1.1