Search Results hr_copy_gsp




Overview
Explore in AI Chat

Overview

HR_COPY_GSP is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, documented as VALID and classified under the ETRM as an "OTHER" API type. The name and structure indicate that the package supports the copy of Global Set Profile (GSP) data within Oracle Human Resources, specifically the mechanism by which global values for a set profile option are propagated or duplicated into a context, business group, or subordinate level. The package does not expose a public procedural interface of the kind associated with seeded business APIs such as HR_EMPLOYEE_API or HR_PERSON_API; instead it is an internal utility package invoked by other HR components when global set profiles are copied or applied. Its only documented dependency is the SYS.STANDARD package, reflecting routine use of standard PL/SQL datatypes. Because it is referenced by no external packages in the documented metadata, HR_COPY_GSP should be regarded as a tightly scoped implementation helper rather than a general-purpose integration point.

Key Procedures and Functions

The documented interface consists of three program units. No parameter lists are published in the ETRM record, and none are inferred here.

  • TEMPLATE — Serves as the template or master routine of the package. In copy utilities of this kind, the template unit typically establishes the working copy pattern: it identifies the source set of global profile values and drives their duplication into the target scope. It is the entry point that the remaining units support.
  • ITU — An internally named helper invoked during the copy operation. Given the naming conventions used in HR copy packages, ITU most likely handles the insert/update translation of rows as global values are written into the target context, applying the destination-specific values required to complete the copy.
  • ITEM_TYPE — Resolves or classifies the item type associated with the set profile data being copied. This unit determines the category of the profile item so that the correct copy logic and validation path are applied to each element of the global set.

All three units are implementation-level and are not published as supported customer-callable APIs.

Tables Accessed

The ETRM metadata for HR_COPY_GSP lists no directly referenced application tables through APPS synonyms. This is consistent with a package that performs its data manipulation indirectly, either through other HR packages or through dynamic SQL against HR profile and set profile tables. In practice, packages of this family operate against the HR global set profile structures — the definitions of set profiles, the profile option level values, and the assignment of values to business groups and other contexts — but the documented record does not attribute any specific table to HR_COPY_GSP. Any table-level impact should therefore be established by reviewing the package body source rather than assumed from the metadata.

Usage Notes

HR_COPY_GSP is not a seeded concurrent program entry point and exposes no documented form-level trigger or menu function. It is invoked from within other HR processing that needs to copy global set profile values, so end users do not call it directly. Because the ETRM classifies it as OTHER and records zero packages referencing it, the object is effectively private to the Oracle HR application code. Custom development should not call these units; supported customization should use the published HR profile and set profile APIs instead. When diagnosing copy behavior in a 12.1.1 or 12.2.2 environment, HR_COPY_GSP is best examined as a dependency of the calling HR process, with the package body reviewed to confirm actual table access and execution flow.