Results for “get_assignment_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PER_BF_GEN_DATA_PUMP is a server-side PL/SQL package body that belongs to the Oracle Human Resources (HR) and Oracle Payroll "data pump" framework in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its role is to resolve and supply the internal surrogate keys required when payroll and HR balance data are moved between the transactional schema and the data pump staging tables used by the BIS (Business Intelligence System) / HRMS data extraction architecture. Rather than performing business calculations itself, the package functions as a lookup utility that translates user-meaningful reporting names, business groups, and effective dates into the numeric identifiers that downstream pump processes require.

The package source header identifies the file as pebgendp.pkb and the package is owned by APPS. It is registered in ETRM with an API classification of OTHER, and it is referenced by four other packages in the application schema, confirming that it acts as a shared dependency for higher-level pump programs rather than an entry point invoked directly by end users.

Key Procedures and Functions

The documented package exposes six functions, all of which return BINARY_INTEGER surrogate identifiers:

• GET_INPUT_VALUE_ID — Resolves the input value identifier for a given reporting name, business group, and effective date. The excerpt shows it joins PAY_INPUT_VALUES_F to PAY_ELEMENT_TYPES_F, filters on the first display sequence, and excludes the "Pay Value" input. On failure it calls the diagnostic routine HR_DATA_PUMP.FAIL and re-raises the exception.
• GET_BALANCE_TYPE_ID — Returns the balance type identifier for a named balance type within a business group at a given effective date. The source includes an explicit cursor for this retrieval.
• GET_PAYROLL_ID — Returns the internal payroll identifier corresponding to a payroll name and business group.
• GET_PAYROLL_RUN_ID — Returns the identifier of a specific payroll run, used to link extracted data to its processing context.
• GET_ASSIGNMENT_ID — Returns the assignment identifier for a person within an effective-dated context.
• GET_PERSONAL_PAYMENT_METHOD_ID — Returns the personal payment method identifier used for payroll disbursement mapping.

Each function follows a consistent pattern: accept a reporting name (or comparable natural key), a business group, and an effective date; resolve the surrogate key; and delegate error handling to the shared data pump failure routine.

Tables Accessed

The package reads from the following tables through APPS synonyms:

• PAY_INPUT_VALUES_F and PAY_ELEMENT_TYPES_F — effective-dated element and input value definitions, joined to resolve input value identifiers.
• PER_BF_BALANCE_TYPES — balance type definitions used by GET_BALANCE_TYPE_ID.
• PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F — assignment and person records, supporting GET_ASSIGNMENT_ID.
• PAY_PERSONAL_PAYMENT_METHODS_F and PAY_ORG_PAYMENT_METHODS_F_TL — personal and organizational payment method definitions.
• HR_PUMP_BATCH_LINE_USER_KEYS — the pump staging table that stores user-defined keys for batch lines, linking the resolved identifiers back to the extraction run.

Usage Notes

PER_BF_GEN_DATA_PUMP is not intended for direct invocation by end users. It is called programmatically by the payroll and HRMS data pump processes — typically initiated from concurrent programs that extract payroll, balance, and assignment data into the BIS staging schema. Custom extensions that participate in the data pump should call these functions to obtain identifiers consistently with the delivered code, rather than duplicating the effective-dated lookup logic. Because all lookups are effective-dated and business-group scoped, callers must supply a valid business group and effective date; failure to do so results in the standard HR_DATA_PUMP.FAIL diagnostic being raised. The package is available in both 12.1.1 and 12.2.2 with no documented signature changes between those releases.