Search Results get_p_access_profile_rec

Overview

APPS.AS_API_RECORDS_PKG is a public PL/SQL package in Oracle E-Business Suite that supports the Oracle Sales and Oracle TeleSales (AS) product family. Its role is to expose strongly typed record and table type constructors used by the Sales foundation public APIs. The package declares AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking user rather than the definer, and it is compiled into the APPS schema.

The package does not itself perform sales transactions such as creating or updating leads and opportunities. Instead, it centralizes access to the PL/SQL record and table type definitions declared in the public API packages AS_SALES_LEADS_PUB and AS_OPPORTUNITY_PUB. Client code calls these accessor functions to obtain correctly typed, initialized structures before populating and passing them to the corresponding public API procedures. The header revision notes confirm it is derived from earlier sales lead and opportunity API source files (asxpslms.pls and asxpopps.pls).

Key Procedures and Functions

The package exposes a series of parameterless functions, each returning a PL/SQL record or table type. The documented functions are grouped as follows:

• Sales lead accessors: GET_P_SALES_LEAD_REC and GET_P_SALES_LEAD_TBL return the lead record and lead table types from AS_SALES_LEADS_PUB.
• Sales lead line accessors: GET_P_SALES_LEAD_LINE_REC, GET_P_SALES_LEAD_LINE_TBL, GET_P_SALES_LEAD_LINE_OUT_REC, and GET_P_SALES_LEAD_LINE_OUT_TBL return line-level and line output record and table types.
• Sales lead contact accessors: GET_P_SALES_LEAD_CONTACT_REC, GET_P_SALES_LEAD_CONTACT_TBL, GET_P_SALES_LEAD_CNT_OUT_REC, and GET_P_SALES_LEAD_CNT_OUT_TBL return contact and contact output structures.
• Opportunity accessors: GET_P_HEADER_REC, GET_P_HEADER_TBL, GET_P_LINE_REC, GET_P_LINE_TBL, GET_P_LINE_OUT_REC, and GET_P_LINE_OUT_TBL return opportunity header and line record and table types from AS_OPPORTUNITY_PUB.
• Sales credit accessors: GET_P_SALES_CREDIT_REC, GET_P_SALES_CREDIT_TBL, GET_P_SALES_CREDIT_OUT_REC, and GET_P_SALES_CREDIT_OUT_TBL return sales credit record and table types.

The ETRM metadata lists 47 documented procedures or functions in total; the excerpt above enumerates the primary accessor set. The user search term get_p_access_profile_rec corresponds to accessor naming conventions used within this family of constructor functions.

Tables Accessed

No base tables are documented as being referenced directly by this package through APPS synonyms. The package is a type-access layer: it returns PL/SQL record and table structures whose fields map to the columns of the underlying sales lead, opportunity, line, contact, and sales credit entities. DML against those entities is performed by the corresponding public API packages, not by this package.

Usage Notes

This package is typically invoked from forms, concurrent programs, and custom PL/SQL integration code that must supply typed parameters to the Sales public APIs. A caller first obtains an initialized record or table via the appropriate GET_P_* function, populates its attributes, and then passes the structure to the matching public API routine. The package is referenced by four other packages within the E-Business Suite. Because it is a type constructor utility, it is not normally scheduled as a standalone concurrent program.