Search Results create_amg_task




Overview
Explore in AI Chat

Overview

PJM_SEIBAN_PKG is a PL/SQL package owned by the APPS schema that supports the creation and validation of projects and tasks associated with SEIBAN-style project numbering and naming requirements. It sits within the Oracle Projects module (PA/PJM) and provides a controlled interface for generating project and task records while enforcing uniqueness rules on project numbers and project names. The package is classified as an OTHER API in the ETRM documentation, meaning it is not a formally published public API but is nonetheless a reusable, callable unit relied upon internally by other Oracle Projects components.

The package contains both a specification and a body, and its status is VALID in the ETRM repository. It depends on the SYS.STANDARD package and is referenced by two other APPS packages — PA_PROJECT_CORE1 and PA_PROJECT_PUB — indicating that it participates in the core project creation flow and is invoked from the higher-level project public API layer.

Key Procedures and Functions

The package exposes seven documented procedures and functions. Their purposes are as follows:

  • PROJECT_NUMBER_DUP — Determines whether a supplied project number already exists, supporting duplicate detection during project creation.
  • PROJECT_NAME_DUP — Determines whether a supplied project name already exists, supporting duplicate detection on the project name attribute.
  • CHECK_DUP_PROJECT_NUM — Performs validation logic that raises an error or returns a status when a duplicate project number is encountered.
  • CHECK_DUP_PROJECT_NAME — Performs validation logic that raises an error or returns a status when a duplicate project name is encountered.
  • CREATE_AMG_PROJECT — Creates a project record, applying the SEIBAN numbering conventions managed by this package.
  • CREATE_AMG_TASK — Creates a task record beneath a project, consistent with the same numbering scheme.
  • CONC_CREATE — A concurrent-program entry point that orchestrates bulk or batch creation of projects and tasks, suitable for invocation from a concurrent manager request.

Parameter lists are not documented in the ETRM metadata and should be confirmed directly against the package specification in the target environment.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

  • PA_PROJECTS and PA_PROJECTS_ALL — The core project definition tables, used to insert and validate project records. The _ALL variant supports multi-organization access.
  • PA_TASKS — Stores task definitions; written when CREATE_AMG_TASK is executed.
  • PJM_SEIBAN_NUMBERS — The SEIBAN-specific numbering table, likely used to generate and track sequential project and task numbers.
  • FND_RESPONSIBILITY — Referenced to validate responsibility context, typically to enforce access or determine which operating unit or responsibility is performing the creation.

Usage Notes

PJM_SEIBAN_PKG is typically invoked in three ways. First, it is called internally by PA_PROJECT_CORE1 and PA_PROJECT_PUB during standard project creation, ensuring SEIBAN-specific validation and numbering rules are applied. Second, CONC_CREATE can be submitted as a concurrent program to mass-create projects and tasks. Third, custom code may call the package directly where an integration or extension requires SEIBAN-compliant project or task creation. Because it is not a published API, direct calls should be implemented cautiously, and the package specification should be reviewed for the exact signature of each routine before use in Oracle EBS 12.1.1 or 12.2.2.