Results for “get_trgr_table_pk_id”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.HR_PUMP_GET is a core lookup and resolution utility within the Oracle E-Business Suite HR Data Pump architecture. In Oracle EBS 12.1.1 and 12.2.2, the HR Data Pump (HR_DATA_PUMP) is the batch extraction and loading framework used to migrate, copy, and transform HR and payroll data between business groups, environments, and statutory contexts. While HR_DATA_PUMP performs the orchestration, validation, and write operations, HR_PUMP_GET acts as the read-side counterpart: it resolves incoming external user keys into the internal primary keys required by the pump's downstream insert and update logic.
The package body is owned by APPS and holds a VALID status. It exposes an extensive library of GET_* resolution functions—258 documented procedures and functions in total—that translate business-meaningful identifiers (names, codes, flex values) into row identifiers across the HR, Payroll, Benefit, and Person data model. It is one of the most heavily reused utilities in the Oracle HRMS schema, with 229 dependent packages referencing it, underscoring its role as a foundational component rather than an application-layer API.
Key Procedures and Functions
The documented procedures are uniformly identifier-resolution functions, each mapping a user key or descriptive attribute to a surrogate primary key. Representative examples include:
- GET_COLLECTIVE_AGREEMENT_ID — resolves a collective agreement record identifier.
- GET_CONTRACT_ID — returns the contract identifier associated with an assignment or person context.
- GET_ESTABLISHMENT_ID — resolves an establishment key to its internal identifier.
- GET_CAGR_ID_FLEX_NUM — retrieves the key flexfield number for a collective agreement.
- GET_EMP_FED_TAX_RULE_ID, GET_EMP_STATE_TAX_RULE_ID, GET_EMP_COUNTY_TAX_RULE_ID, GET_EMP_CITY_TAX_RULE_ID — resolve the four US statutory tax rule identifiers (federal, state, county, city) for an employee.
- GET_START_LIFE_REASON_ID, GET_END_LIFE_REASON_ID — resolve life-event reason identifiers used during benefits processing.
- GET_BENEFIT_GROUP_ID — returns the benefit group identifier.
- GET_PTNL_LER_FOR_PER_ID, GET_CSD_BY_PTNL_LER_FOR_PER_ID, GET_PTNL_LER_FOR_PER_OVN, GET_PER_IN_LER_ID — resolve potential and actual life-event records and their associated coverage start dates.
- GET_TRGR_TABLE_PK_ID — returns the primary key of a trigger (source) table.
- GET_WS_MGR_ID, GET_MGR_OVRID_PERSON_ID — resolve manager and manager-override person identifiers for assignment processing.
- GET_GROUP_PL_ID — resolves a group plan identifier.
- GET_BCKT_PER_IN_LER_ID — returns a bucket identifier within a person-in-life-event context.
These functions are designed to be invoked in sequence by the pump to translate an externally supplied user key into the internal PK, then pass that PK to dependent write APIs.
Tables Accessed
The package reads from a broad set of HRMS base tables, all accessed through APPS synonyms. The documented dependencies fall into four groupings:
- Benefits: BEN_ACTL_PREM_F, BEN_ACTY_BASE_RT_F, BEN_BENFTS_GRP, BEN_CBR_PER_IN_LER, BEN_CBR_QUALD_BNF, BEN_COMP_LVL_FCTR, BEN_CVG_AMT_CALC_MTHD_F, BEN_ELIG_CVRD_DPNT_F, BEN_ELIG_DPNT, BEN_ELIG_PER_ELCTBL_CHC, BEN_ELIG_PER_F, BEN_ELIG_PER_OPT_F, BEN_ENRT_PERD, BEN_ENRT_RT, BEN_LER_F, and related plan, option, and premium tables.
- Payroll: PAY_ELEMENT_TYPES_F, PAY_ELEMENT_ENTRIES_F, PAY_INPUT_VALUES_F, PAY_GRADE_RULES_F, PAY_PAYROLLS_F, PAY_PEOPLE_GROUPS, PAY_PERSONAL_PAYMENT_METHODS_F, PAY_RATES, PAY_USER_COLUMNS, and the US/Canada employee tax rule tables (PAY_US_EMP_FED/STATE/COUNTY/CITY_TAX_RULES_F, PAY_CA_EMP_FED/PROV_TAX_INFO_F).
- Core HR and Person: PER_ALL_PEOPLE_F, PER_ASSIGNMENTS_F, PER_ADDRESSES, PER_BUSINESS_GROUPS, PER_COLLECTIVE_AGREEMENTS, PER_COMPETENCES and related competence tables; HR_ALL_ORGANIZATION_UNITS, HR_ALL_POSITIONS_F, HR_LOCATIONS_ALL, HR_ORGANIZATION_INFORMATION, HR_LOOKUPS, HR_TAX_UNITS_V, HR_ESTABLISHMENTS_V, HR_SOFT_CODING_KEYFLEX.
- Foundation and framework: FND_CURRENCIES, FND_ID_FLEX_STRUCTURES, FND_LANGUAGES, FND_LOOKUP_VALUES, FND_SECURITY_GROUPS_TL, FND_TERRITORIES_VL, GL_SETS_OF_BOOKS, HR_DATA_PUMP, HR_API, HR_PUMP_GET itself, and HR_PUMP_BATCH_LINE_USER_KEYS.
The consistent use of _F (date-tracked) tables reflects the package's need to return current-effective identifiers.
Usage Notes
HR_PUMP_GET is not exposed through a standalone form. It is invoked programmatically from other PL/SQL packages—documented as referenced by 229 packages—and from the HR Data Pump concurrent programs and batch loading routines. It is also called from custom migration and integration code that relies on the Data Pump framework to move HR and Payroll data.
Typical invocation patterns include: resolving user keys read from HR_PUMP_BATCH_LINE_USER_KEYS into internal PKs; supplying identifiers to HR_DATA_PUMP and HR_API for downstream inserts; and feeding benefit and payroll resolution logic invoked during life-event or enrolment extraction. Because the functions are pure resolution lookups without DML, they are safe to call inside larger transactions. In 12.2.2 the same behavior and dependencies apply, so it remains the standard mechanism for key translation across HRMS batch processing.
Custom code should treat HR_PUMP_GET as an internal implementation utility: it is version-sensitive across EBS releases and should be invoked only where the standard Data Pump flow requires a user-key-to-PK resolution.
-
PACKAGE: APPS.HR_PUMP_GET 12.1.1
-
PACKAGE: APPS.HR_PUMP_GET 12.2.2
-
PACKAGE: APPS.HR_PUMP_GET 12.1.1
-
PACKAGE: APPS.HR_PUMP_GET 12.2.2