Results for “p_express_name”

12 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ICX_POR_EXT_TEST is a PL/SQL test harness package owned by the APPS schema in Oracle E-Business Suite. Its role is to provide an isolated, self-contained environment in which the Oracle iProcurement catalog and classification interfaces can be exercised and validated before production data is touched. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, which is characteristic of a diagnostic or verification utility rather than a business transaction API.

The naming convention reflects this purpose: the _EXT_TEST suffix denotes an extension test utility associated with iProcurement (ICX) purchasing (POR) functionality. The package contains no seeded business logic intended to run during normal application processing. Instead, it scaffolds categories, templates, items, and price records so that the catalog extraction and validation programs can be run against controlled input. A striking internal constant, TEST_USER_ID PLS_INTEGER := -99999, confirms the diagnostic intent by reserving a sentinel identifier that cannot collide with a real FND_USER record.

Key Procedures and Functions

Of the 51 documented program units, the publicly declared surface divides into three functional groups.

  • Environment control: SETCOMMITSIZE, SETTESTMODE, and SETTABLESPACE establish execution parameters. The package defaults to a commit size of 2000 rows (gCommitSize) and a nullable test mode flag (gTestMode), allowing the caller to tune batch behavior and direct DDL to a chosen tablespace.
  • Lifecycle management: CREATETABLES, PREPARE, DROPTABLES, CLEANUPDATA, and CLEANUP build, initialize, and tear down the scratch schema. PREPARE accepts an optional create-tables directive, enabling repeatable setup and rollback between test runs.
  • Data generation and verification: CREATECATEGORY, UPDATECATEGORY, and TRANSLATECATEGORY populate category and translated description records. CREATETEMPLATEHEADER and UPDATETEMPLATEHEADER manage storefront template definitions. CREATEGSB, CREATEFSP, CREATEITEM, and UPDATEITEM build inventory and item master records. The boolean predicates EXISTCATEGORY, NOTEXISTCATEGORY, and EXISTCATEGORYTL verify expected state after a load.

Tables Accessed

The package operates against the iProcurement catalog schema through APPS synonyms. Category definition data is written to ICX_CAT_CATEGORIES_TL, ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP, and ICX_CAT_EXT_ITEMS_TLP, while relationships and cross-references are held in ICX_CAT_CATEGORY_ITEMS and ICX_POR_CATEGORY_ORDER_MAP. Price information is sourced through ICX_CAT_ITEM_PRICES, and data source configuration through ICX_POR_CATEGORY_DATA_SOURCES. FND_LANGUAGES supplies the language list used by TRANSLATECATEGORY. Utility dependencies include DBMS_SQL for dynamic SQL, DUAL for singleton queries, and PLITBLM for index-by-table logistics. All references resolve through APPS synonyms, so the package must be compiled in a schema with appropriate synonym access.

Usage Notes

ICX_POR_EXT_TEST is invoked from SQL*Plus or a concurrent program during implementation, patching, or upgrade cycles, not from standard iProcurement forms. It is referenced by five other packages, which suggests it forms part of a wider extension test suite. Typical invocation begins with SETTABLESPACE and SETTESTMODE, followed by PREPARE, data creation calls, verification predicates, and finally CLEANUP to restore the schema. Because the package performs DDL through CREATETABLES and DROPTABLES, it should only be run in a non-production environment or a dedicated test schema. The absence of any relation to the search term "aadhar divice testing.vercel.app" is absolute; this object is unrelated to external device or identity testing websites.