Search Results create_project




Overview
Explore in AI Chat

Overview

APPS.PA_PROJECTS_MAINT_PUB is the public maintenance API for Oracle Projects (PA) in Oracle E-Business Suite 12.1.1 and 12.2.2. Its PL/SQL body wraps the underlying validation and DML logic that creates, updates, and manages project records and their dependent entities. The package follows the standard Oracle EBS API conventions, accepting p_api_version, p_init_msg_list, p_commit, p_validate_only, p_validation_level, and p_max_msg_count, and returning standard x_return_status, x_msg_count, and x_msg_data values. Because the package is classified as a public (PUB) API, Oracle supports its direct invocation from custom code, unlike its internal counterparts. The header shown in the source (PARMPRPB.pls 120.4.12010000.4) identifies it as core Projects maintenance logic. The user search term create_classifications corresponds to one of the eleven documented public procedures used to associate classification categories and codes with a project.

Key Procedures and Functions

  • CREATE_PROJECT — Creates a new project header record. It is the primary entry point for project creation and accepts required parameters such as p_orig_project_id and p_project_name, along with optional descriptive, status, date, and value attributes. Defaults follow FND_API conventions (for example, p_commit defaults to FND_API.G_FALSE and p_validate_only defaults to FND_API.G_TRUE).
  • CREATE_CUSTOMER — Associates a customer to a project, presumably by creating or linking a record in the project customer table.
  • UPDATE_PROJECT_BASIC_INFO — Updates core project attributes such as name, number, and description.
  • UPDATE_PROJECT_ADDITIONAL_INFO — Updates secondary project attributes not covered by the basic routine.
  • UPDATE_PROJECT_PIPELINE_INFO — Updates pipeline-related data, including probability, expected approval date, and project value.
  • CREATE_CLASSIFICATIONS — Creates one or more project classification assignments, relating a project to a classification category and code (for example, industry or product line).
  • UPDATE_CLASSIFICATIONS — Modifies existing classification assignments on a project.
  • DELETE_CLASSIFICATIONS — Removes classification assignments from a project.
  • UPDATE_PROJECT_STAFFING_INFO — Updates staffing-related project attributes.
  • CREATE_ORG_ROLE — Creates an organization role association for the project.
  • PROJECT_STATUS_CHANGE — Changes a project's status and records the transition in the status change table.

Tables Accessed

The package reads and writes through APPS synonyms. Project header and detail data are stored in PA_PROJECTS_ALL and PA_PROJECTS. Classification logic references PA_CLASS_CATEGORIES and PA_CLASS_CODES to validate category and code combinations. Customer associations use HZ_CUST_ACCOUNTS and PA_PROJECT_CUSTOMERS. Pipeline and opportunity attributes are held in PA_PROJECT_OPP_ATTRS, with probability defined by PA_PROBABILITY_MEMBERS. Status changes are logged in PA_OBJ_STATUS_CHANGES_S. Supporting references include PA_PROJECT_PARTIES (staffing and roles), PA_LOCATIONS, PER_ORGANIZATION_STRUCTURES, PA_PM_CONTROL_ACTIONS, PA_PM_PRODUCT_CONTROL_RULES, and FND_NEW_MESSAGES for messaging. Because the body is a public API wrapper, these tables are typically accessed indirectly through the internal private packages it calls.

Usage Notes

PA_PROJECTS_MAINT_PUB is invoked from Oracle Projects forms, concurrent programs, and external integrations such as web services or middleware. Custom code should call the public procedures rather than mutating the underlying tables directly, ensuring that all business validations and status-change logging occur. Three other packages reference the API, confirming its role as a shared maintenance entry point. Callers must supply valid p_api_version values, initialize the message list, and inspect x_return_status for FND_API.G_RET_STS_ERROR or G_RET_STS_UNEXP_ERROR before committing. When creating classifications, the project must already exist, and the category/code pair must be valid in PA_CLASS_CATEGORIES and PA_CLASS_CODES.