Search Results copy_project_int_options
Overview
PA_PROJECT_INTEGRATION_PUB is a public PL/SQL API package in the Oracle E-Business Suite Applications (APPS) schema, classified as a PUB interface intended for external and cross-product consumption. Its principal business function is the synchronization of project and budget data between Oracle Projects and external or downstream systems. Interactive and batch integrations—such as those originating from Oracle Project Manufacturing, Oracle Grants, or third-party project systems—rely on this package to import project structures and budget versions into the Oracle Projects repository, and to return confirmation records through outbound object tables. The package is marked VALID in the ETRM 12.2.2 metadata and is present in both 12.1.1 and 12.2.2 environments.
Key Procedures and Functions
The documented API exposes nine procedures and functions. SYNC_PROJECTS and SYNC_BUDGETS are the primary integration entry points, driving the transfer of project and budget records respectively between the calling system and Oracle Projects. LOAD_PROJECT_IN_REC supports loading of an inbound project record, working in conjunction with the PROJECT_IN_OBJ and PROJECT_IN_OBJ_TBL object types listed in the dependency information. WRITE_LOG captures diagnostic and processing messages into the FND logging infrastructure. WBS_ORDER derives or validates the hierarchical ordering of work breakdown structure elements, which is essential when project structures are supplied out of sequence. DELETE_TASK_PVT and DELETE_RES_ASSGN_PVT are private helper routines that remove task and resource assignment records as part of synchronization cleanup. COPY_PROJECT_INT_OPTIONS copies integration configuration settings, and GET_PROJECT_ORG_NAME resolves the owning organization name for a given project.
Tables Accessed
The package operates across the core Oracle Projects data model. PA_PROJECTS_ALL holds the master project records written during synchronization, while PA_PROJ_ELEMENTS, PA_PROJ_ELEMENT_VERSIONS, and PA_PROJ_ELEM_VER_STRUCTURE store WBS elements and their versioned hierarchy. Tasks and resource assignments are managed through PA_TASKS and PA_RESOURCE_ASSIGNMENTS. Budget processing reads PA_BUDGET_VERSIONS, PA_BUDGET_ENTRY_METHODS, and PA_PROJ_FP_OPTIONS. Structural metadata is drawn from PA_STRUCTURE_TYPES, PA_PROJ_STRUCTURE_TYPES, and PA_PROJ_WORKPLAN_ATTR, and integration configuration is read from PA_INTEGRATION_SETTINGS. Diagnostic output is written to FND_LOG_MESSAGES and FND_LOG_MESSAGES_S.
Usage Notes
PA_PROJECT_INTEGRATION_PUB is referenced by the PA_PROJECT_CORE1 package and by itself, indicating its role in the Projects core processing stack. It is typically invoked from concurrent programs and integration batch processes that import or refresh project and budget data, from Oracle Projects forms where integration synchronization is triggered, and from custom PL/SQL integrations that populate the PROJECT_IN_OBJ_TBL and BUDGET_IN_OBJ_TBL collections and consume the corresponding outbound object tables. Because the package is classified as PUB, it is supported for direct customer and partner invocation. Callers should perform all work through the documented procedures and avoid the private helper routines (DELETE_TASK_PVT, DELETE_RES_ASSGN_PVT), which are implementation details subject to change. All synchronization activity should be preceded by validation of the inbound records against the structure and budget metadata to avoid incomplete WBS hierarchies or orphaned task assignments.