Search Results get_pgp_from_pgp




Overview
Explore in AI Chat

Overview

HR_ASSIGNMENT_COMMON_SAVE_WEB is a server-side PL/SQL package owned by the APPS schema that supports the Oracle EBS 12.1.1 / 12.2.2 self-service web layer for employee assignment maintenance. Its principal business function is to validate, resolve, and persist assignment (`PER_ALL_ASSIGNMENTS_F`) data submitted through the web "Assignment" and "Change Assignment" flows used in Manager Self-Service and related employee self-service functions. The package encapsulates the validation logic required before an assignment row is saved, so that the same rules apply whether the assignment is being created or updated through a browser form. A secondary role is data resolution: several procedures and functions retrieve assignment, people-group, and soft-coding information from a PL/SQL associative array (a PL/SQL table type, abbreviated "TT" in the routine names), which is how the web layer passes form field values in bulk to the save logic.

The user query "get_asg_from_tt" corresponds to one of the documented routines of this package, GET_ASG_FROM_TT, which is the assignment extractor used when the save routine needs to pull the assignment record out of the in-memory PL/SQL table populated by the OAF/HTML form.

Key Procedures and Functions

The documented metadata lists ten callable units. Their purposes are:

  • VALIDATE_ASSIGNMENT — Validates all assignment attributes supplied by the web page (organization, position, job, grade, location, supervisor, normal hours, frequency, status, change reason, date-track update mode, and the assignment attribute flexfield segments) before the assignment is written. It is the main entry point for the save-time rule checks.
  • GET_ASG_FROM_TT — Extracts the assignment record from the PL/SQL table ("TT") populated by the self-service form. This is the routine referenced in the user's search.
  • GET_PGP_FROM_TT — Extracts people-group information from the same in-memory table.
  • GET_SCL_FROM_TT — Extracts soft-coding (key flexfield) information from the in-memory table.
  • GET_ASG_FROM_ASG — Copies or resolves assignment data from an existing assignment record rather than from the table, supporting update and correction scenarios.
  • GET_PGP_FROM_PGP — Resolves people-group data from an existing people-group record.
  • GET_SCL_FROM_SCL — Resolves soft-coding data from an existing soft-coding record.
  • GET_ASG — Retrieves a single assignment record, used as the base lookup for the "from_asg" and "from_tt" variants.
  • GET_STEP — Returns a step definition from the HR_API_TRANSACTION_STEPS table, used to drive the API transaction flow.
  • STEP_OPEN — Opens a transaction step, marking it in progress as part of the controlled save sequence.

Tables Accessed

The documented table dependencies, all reached through APPS synonyms, are: PER_ALL_ASSIGNMENTS_F (the assignment itself — the primary read/write target); PER_ALL_PEOPLE_F (person lookup and validation); PER_ASSIGNMENT_STATUS_TYPES (validating assignment status values supplied by the form); PAY_PEOPLE_GROUPS (resolving payroll people-group data); HR_SOFT_CODING_KEYFLEX (soft-coding key flexfield attributes); HR_API_TRANSACTION_STEPS and WF_ITEMS (transaction step and workflow item tracking used by GET_STEP and STEP_OPEN to manage the controlled save workflow).

Usage Notes

This package is internal to the HR self-service save flow and is not intended as a general-purpose public API. It is invoked by the assignment save web pages — for example the Change Assignment and Assignment form flows — and by the calling packages that build the in-memory PL/SQL table from browser input. Because it is referenced by three other packages, direct calls from custom code are possible but discouraged; the supported approach for assignment changes is the public HR_ASSIGNMENT_API. When extending self-service behavior, use this package's validation logic as a reference for the rules applied, but keep customizations on the supported API to remain upgrade-safe across 12.1.1 and 12.2.2.