Search Results get_cprog_parameter_value

Overview

PAY_US_GET_ITEM_DATA_PKG is a United States payroll utility package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its business function is to resolve and assemble the person, address, organization, and contact data elements required by U.S. year-end and regulatory reporting programs. The package name indicates that it "gets item data" — that is, it retrieves the discrete data items (employee names, addresses, organization names, contact information, and reporting parameters) that are consumed when a statutory form or magnetic media file is constructed. It is classified as an OTHER API rather than a public, supported interface, and therefore should be regarded as an internal reporting utility rather than an integration point.

The dependency footprint confirms this role. The package is referenced by the core U.S. reporting objects, including PAY_1099R_PKG, PAY_US_1099R_UDFS, PAY_US_PSD_XML, PAY_US_PSD_GENERIC_EXTRACT, PAY_US_MMREF_LOCAL, PAY_US_MMREF_LOCAL_XML, PAY_US_REPORTING_UTILS_PKG, PAY_US_W2C_REPORTING_UTILS, PAY_US_W2C_RPT, and PAY_US_W2_INFO_PKG. This pattern places the package squarely beneath the W-2, 1099-R, and magnetic media (MMREF) generation stack.

Key Procedures and Functions

The ETRM metadata documents six callable units, all oriented toward data retrieval:

• GET_PERSON_NAME_ADDRESS — returns the formatted name and address of an employee or payee, normally for printing on a statutory form or writing into a reporting file.
• GET_MMREF_EMPLOYEE_ADDRESS — resolves the employee address in the specific format required by the magnetic media reporting (MMREF) layout, which imposes stricter field and formatting rules than a printed form.
• GET_MMREF_EMPLOYER_ADDRESS — resolves the employer address for the same MMREF output, drawn from the legal employer or reporting establishment defined in organization and location data.
• GET_ORGANIZATION_NAME_ADDRESS — returns the name and address of an organization unit, used for employer blocks and reporting entity identification.
• GET_CONTACT_PERSON_INFO — retrieves contact details for a designated person, supporting the contact information fields required on certain filings.
• GET_CPROG_PARAMETER_VALUE — reads a concurrent program parameter value so that reporting logic can honor the parameters supplied when the reporting request was submitted.

No parameter lists are documented in the metadata; the descriptions above reflect purpose only.

Tables Accessed

The package reads from a defined set of HR and Payroll tables, accessed through APPS synonyms:

• PER_ALL_PEOPLE_F and PER_ADDRESSES — source of person names and address records.
• HR_LOCATIONS_ALL — supplies location and address detail for organizations and establishments.
• HR_ORGANIZATION_UNITS, HR_ALL_ORGANIZATION_UNITS, and HR_ORGANIZATION_INFORMATION — resolve organization names and classification information.
• FND_TERRITORIES and FND_TERRITORIES_TL — provide territory and country names for address formatting.
• PER_ALL_ASSIGNMENTS_F, HR_ALL_POSITIONS_F, and PER_PHONES — support assignment, position, and telephone data retrieval.
• PAY_PAYROLL_ACTIONS — links retrieved data to the payroll action or reporting run context.

Usage Notes

PAY_US_GET_ITEM_DATA_PKG is not intended for direct invocation by end users. It is called internally by the U.S. year-end reporting packages listed above when concurrent programs such as W-2, 1099-R, and magnetic media extracts execute. Customers extending year-end output, for example through PAY_US_1099R_UDFS or custom reporting utilities, may reference these procedures, but because the package is classified as OTHER and is not a supported API, customizations should be validated against each patch level. In 12.2.2 the package remains VALID and its documented dependency set is consistent with the 12.1.1 reporting architecture.