Search Results pa_varchar2_30_tbl_type




Overview
Explore in AI Chat

Overview

APPS.PA_PLAN_RES_DEFAULTS_PUB is a public PL/SQL package in the Oracle E-Business Suite Projects (PA) module that manages resource default settings used during project and resource planning in Oracle Project Management and Oracle Project Resource Management. In Oracle EBS 12.1.1 and 12.2.2, resource defaults act as templates that pre-populate planning attributes — such as utilization percentages, assignment dates, formats, and resource types — when a planner adds a resource to a project plan or resource list. The package is classified as a PUB API, meaning it is intended for external invocation by other Oracle applications, forms, and approved custom extensions rather than being restricted to internal, private use within the PA schema.

The user search term "pa_varchar2_30_tbl_type" points directly to the package's dependency list. PA_VARCHAR2_30_TBL_TYPE is a PL/SQL collection type (a table of VARCHAR2(30) values) declared in the APPS schema and referenced by this package. It is used to pass arrays of short character strings — for example, lists of resource format names, resource type codes, or other identifier values — as a single bind parameter between the planner UI and the PL/SQL API, avoiding row-by-row calls and improving bulk-processing efficiency.

Key Procedures and Functions

The documented ETRM metadata records a single public procedure for this package:

  • UPDATE_RESOURCE_DEFAULTS — the principal entry point through which the package writes or refreshes the default attribute values associated with planning resources. Based on the tables it touches, it is designed to persist default settings applicable to a resource or resource list member so that later planning operations inherit those values. No explicit parameter list is asserted here; the procedure accepts collections of the type noted above (including PA_VARCHAR2_30_TBL_TYPE and the companion PA_VARCHAR2_1_TBL_TYPE and PA_NUM_TBL_TYPE types) to carry the sets of values being applied. It is a public procedure, so callers may invoke it directly through the APPS schema.

Tables Accessed

The package operates against the following documented tables:

  • PA_PLAN_RES_DEFAULTS — the primary storage table for planning resource default values; the package reads from and writes to it as the target of UPDATE_RESOURCE_DEFAULTS.
  • PA_RESOURCE_LIST_MEMBERS — defines which resources belong to a given resource list, linking defaults to the correct list membership.
  • PA_RES_FORMATS_B — the base table of resource formats, validating the format assigned to a default.
  • PA_RES_TYPES_B — the base table of resource types, validating the type associated with the default.
  • PLITBLM — the standard Oracle Applications PL/SQL table/message table used for storing and retrieving list data during API execution.

Usage Notes

PA_PLAN_RES_DEFAULTS_PUB is typically invoked from the Oracle Project Management and Project Resource Management forms when a planner saves or maintains resource default configurations, and it may be called by concurrent programs or other PA APIs that establish baseline resource settings. Custom code may call UPDATE_RESOURCE_DEFAULTS directly, provided the caller supplies the collection types (PA_VARCHAR2_30_TBL_TYPE, PA_VARCHAR2_1_TBL_TYPE, PA_NUM_TBL_TYPE) in the required order and initializes PLITBLM appropriately. The ETRM metadata notes that the package is referenced by zero other packages, confirming it sits at the top of its call hierarchy and is not a subordinate utility. Because it is a PUB API, callers should expect standard EBS commit and validation behavior rather than autonomous transactions.