Search Results per_vacancy_swi




Overview
Explore in AI Chat

Overview

APPS.PER_VACANCY_SWI is a server-side PL/SQL package that provides the integration layer for vacancy records within Oracle E-Business Suite Human Resources. Its name follows the Oracle "SWI" (Server Web Interface / simple web interface) convention, indicating that it wraps core business logic behind a simplified callable interface designed to be driven by external or web-tier clients rather than by an Oracle Forms session. In practice, the package brokers create, update, and delete operations on vacancy entities, delegating the underlying validation and persistence to the HR API layer referenced in its dependency chain. It is classified as an OTHER API within the ETRM 12.2.2 metadata, meaning it is not a formally published public interface but an internal integration package consumed by other application modules. Its principal consumer is IRC_VACANCY_COMMIT, the recruiting-side object that commits vacancy changes, which confirms the package's role as the bridge between Recruitment (iRecruitment) vacancy maintenance and the HR vacancy repository. The package is documented as VALID in the APPS schema and depends on APPS.HR_API for the standard validation and datetrack-aware transaction handling that governs HR entities.

Key Procedures and Functions

The package exposes ten documented procedures and functions:

  • CREATE_VACANCY — Creates a new vacancy record, routing the request through the HR API layer to apply standard validation and datetrack rules.
  • DELETE_VACANCY — Removes an existing vacancy, applying the HR API's deletion semantics.
  • UPDATE_VACANCY — Modifies an existing vacancy, again delegating validation and date-effective handling to HR_API.
  • PROCESS_API — The central dispatcher that determines which of the create, update, or delete paths should execute for a given request.
  • GETNUMBERVALUEP2 — A numeric helper that extracts and converts a numeric value from the incoming payload for use in downstream processing.
  • FINALIZE_TRANSACTION — Completes the transaction, issuing the commit or equivalent end-of-unit-of-work processing once all operations succeed.
  • HANDLEATTACHMENTSWHENCOMMIT — Manages attachment persistence when a vacancy transaction is committed.
  • HANDLEATTACHMENTSWHENREJECTED — Manages attachment handling when a vacancy transaction is rejected, cleaning up or preserving attachments as appropriate.
  • HANDLEATTACHMENTSWHENEDIT — Manages attachment synchronization when a vacancy is subsequently edited.
  • COPYATTACHMENTS — Duplicates attachment records, typically when a vacancy is cloned or an attachment set is replicated.

Tables Accessed

The documented table access is through APPS synonyms: XMLPARSER and XMLDOM, which indicate that the package parses XML payloads representing vacancy data and constructs a DOM tree for traversal; XSLPROCESSOR, used to transform that XML against a stored or supplied stylesheet before the results are applied; and HR_API_TRANSACTIONS, the standard HR API transaction log that records the outcome of each API call and supports the FINALIZE_TRANSACTION step. Together these tables show that PER_VACANCY_SWI operates as an XML-driven interface: input arrives as XML, is parsed and transformed, applied to vacancy records via HR_API, and logged in HR_API_TRANSACTIONS.

Usage Notes

PER_VACANCY_SWI is not intended for direct invocation from Oracle Forms or from ad hoc custom code. It is referenced by only one other package, IRC_VACANCY_COMMIT, which is the normal entry point for vacancy commit processing on the recruiting side. Customizations and extensions should therefore call IRC_VACANCY_COMMIT or the underlying HR_API rather than PER_VACANCY_SWI directly, since the SWI layer's XML contract and attachment-handling logic are tuned to its internal caller. Because the package is classified as OTHER rather than PUBLIC, its signature is not guaranteed to remain stable across patches or upgrades, and any custom dependency on it should be re-verified during 12.1.1 to 12.2.x migration testing.