Search Results finalize_transaction

Overview

APPS.PER_VACANCY_SWI is a server-side PL/SQL package body that implements the business logic for the Oracle E-Business Suite Recruiting vacancy API layer. The package header exposes a set of public procedures that form the supported programmatic interface for creating, updating, and deleting vacancy records, while the body supplies the underlying validation, XML handling, and transaction finalization routines. In Oracle EBS 12.1.1 and 12.2.2, this package is a critical component of the Oracle iRecruitment and Human Resources vacancy management flow, allowing vacancies to be defined, modified, and removed through a controlled API rather than direct table manipulation. The source header (pevacswi.pkb 120.8) indicates the package has been maintained across multiple releases and is stored under the APPS schema, making it callable from forms, concurrent programs, and custom integrations.

A recurring theme in the package body is transaction control and attachment handling. The presence of the g_commiting_via_workflow package variable shows that the package is designed to behave differently when executed within an Oracle Workflow context, where commit and rollback semantics must be deferred to the workflow engine rather than performed by the API itself.

Key Procedures and Functions

• CREATE_VACANCY — Creates a new vacancy record. The procedure accepts a broad set of vacancy attributes, including requisition, effective dates, name, security method, business group, position, job, grade, organization, people group, location, recruiter, description, number of openings, status, budget measurement details, vacancy category, manager, posting and assessment references, and descriptive flexfield attributes.
• UPDATE_VACANCY — Modifies an existing vacancy, applying the same attribute set subject to validation rules.
• DELETE_VACANCY — Removes a vacancy record through the supported API path.
• PROCESS_API — Internal driver that routes requests to the appropriate create, update, or delete logic and coordinates validation and commit behavior.
• FINALIZE_TRANSACTION — The routine responsible for completing the transaction once validation and data changes succeed. It manages commit handling, particularly when the caller is Oracle Workflow, and is the entry point users typically search for when troubleshooting transaction completion behavior.
• GETNUMBERVALUEP2 — A utility helper that extracts a numeric value from the XML/parameter payload, used during parsing and validation.
• HANDLEATTACHMENTSWHENCOMMIT, HANDLEATTACHMENTSWHENREJECTED, HANDLEATTACHMENTSWHENEDIT, COPYATTACHMENTS — Attachment lifecycle routines that copy, retain, or discard vacancy attachments depending on whether the transaction is committed, rejected, or edited.

Tables Accessed

• HR_API_TRANSACTIONS — Records the API transaction context, supporting validation and audit of vacancy operations.
• XMLDOM, XMLPARSER, XSLPROCESSOR — XML parsing and transformation utilities used to process vacancy payloads and attachment data.

Usage Notes

PER_VACANCY_SWI is typically invoked from Oracle iRecruitment forms and from concurrent or custom programs that need to manage vacancies programmatically. Callers should supply the effective date and business group, and should respect the validation flag so that operations can be rehearsed before commit. Because FINALIZE_TRANSACTION defers committing when running under Workflow, custom code should not assume that a successful API call has already committed the data. The package is referenced by one other package, so changes to its behavior can cascade into dependent recruiting logic.