Search Results find_code

Overview

FV_CCR_DATA_LOAD_PKG is a technical PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the Federal Contracts / Contractor Central Registration (CCR) data loading facility used by government contracting organizations. Its role is to ingest externally supplied vendor registration data — including business classification codes and territory information — into staging and reporting structures for validation, processing, and eventual vendor record creation. The package body carries the header signature $Header: FVCCRLDB.pls 120.4.12010000.2, indicating it was last revised in December 2008 and shipped with Release 12.1.1 and carried forward into 12.2.2.

Key Procedures and Functions

Two documented procedures constitute the public interface of this package:

• GET_TERRITORY_CODE — Retrieves the territory (country/region) identifier associated with a data-load record. It validates and maps incoming territory information against the FND_TERRITORIES reference table so that downstream vendor creation receives a recognized territory code.
• MAIN — The primary driver of the load process. It orchestrates the reading of CCR source data, applies code lookups, and populates the staging and reporting tables. Supporting internal logic within the body includes the INSERT_TEMP_DATA procedure, which inserts processed rows into FV_CCR_PROCESS_REPORT, and the FIND_CODE procedure, which resolves classification values against FND_LOOKUP_VALUES.

The user's search term, psc_code, corresponds directly to a declared package-level collection: psc_code l_bus_codes; — a PL/SQL associative array (indexed by BINARY_INTEGER) based on fnd_lookup_values.lookup_code%TYPE. It is populated by the cursor c_psc_codes, which selects lookup_code from FND_LOOKUP_VALUES where lookup_type = 'FV_PSC_TYPE' and language = userenv('LANG'). Parallel collections exist for business type, SIC, NAICS, and FSC codes (bus_code, sic_code, naic_code, fsc_code), each backed by a corresponding lookup type.

Tables Accessed

• FND_LOOKUP_VALUES — Source of all classification code lists (business type, SIC, NAICS, FSC, PSC), filtered by language.
• FND_TERRITORIES — Reference source for territory/country code validation via GET_TERRITORY_CODE.
• FV_CCR_FILE_TEMP and FV_CCR_BPN_CLOB_DATA — Staging structures holding uploaded CCR file content, including CLOB payloads.
• FV_CCR_PROCESS_GT — A global temporary table used as a transient work area during processing.
• FV_CCR_PROCESS_REPORT — Target of INSERT_TEMP_DATA; holds per-record processing output and error reporting.
• FV_CCR_ORGS, FV_CCR_VENDORS, FV_CCR_VENDORS_S — Vendor and organization entities maintained or validated by the load process.
• DUAL and PLITBLM — Utility references used for singleton and bulk-processing operations.

Usage Notes

FV_CCR_DATA_LOAD_PKG is classified as OTHER and is not an exposed public API; no other packages reference it, so it is invoked as a entry point rather than as a dependency. It is typically executed from a concurrent program or a custom wrapper that performs the CCR vendor upload, calling MAIN to process staged file data and GET_TERRITORY_CODE during record validation. Errors raised within nested operations are trapped and written to the processing report through FV_UTILITY.LOG_MESG at FND_LOG.LEVEL_STATEMENT, allowing administrators to review load failures. Because the lookup-driven collections are language-sensitive and cached in package memory, the package should be invoked in a session where the user's language is properly initialized.