Results for “get_so_number_status”

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

Overview

APPS.POR_VIEW_REQS_PKG is a requisition display utility package used by the Oracle Purchasing (PO) and iProcurement modules in Oracle E-Business Suite release 12.1.1 and 12.2.2. Its principal business function is to supply derived descriptive information for a requisition and its associated lines so that EBS forms, workflows, and self-service pages can present meaningful labels rather than raw foreign key identifiers. Rather than storing redundant descriptive columns on the requisition tables, the forms call this package at runtime to resolve values such as the requisition requester name, the deliver-to location, the supplier and sourcing document on which a line is placed, and the total requisition value.

The package is classified in the ETRM repository under API classification OTHER, meaning Oracle does not publish it as a supported public API for external integrations. The header line references PORVRQSB.pls, version 120.26.12020000.3, indicating the file has been maintained through the 12.2 code line. The package includes FND_LOG static variables (G_CURRENT_RUNTIME_LEVEL, G_LEVEL_UNEXPECTED, G_LEVEL_ERROR, G_LEVEL_EXCEPTION, G_LEVEL_EVENT, G_LEVEL_PROCEDURE, G_LEVEL_STATEMENT) and a module name constant used by the FND logging framework, so diagnostic messages from this package are written to the Oracle EBS logging tables when logging is enabled. The package body also retains vestigial code relating to the obsolete POR_APPROVAL_STATUS_LINES_V view; the header comment from liwang dated 06/15/2004 states that this function should be obsoleted in release 11.5.10 but was retained with an empty body to satisfy the view dependency, and the view itself was slated for removal in a later release.

Key Procedures and Functions

The ETRM metadata documents 40 procedures and functions. The following are the principal documented entries:

• GET_REQUESTER — Returns the requester associated with a requisition header, resolving the person through PER_ALL_PEOPLE_F.
• GET_DELIVER_TO — Returns the deliver-to location for a requisition or line. The excerpt shows an alternative construction using PER_PHONES with phone type W1 and parent table PER_ALL_PEOPLE_F, indicating the package resolves contact and location information from the HR tables.
• GET_NOTE_TO_AGENT — Returns the note-to-agent text associated with a requisition line.
• GET_REQ_TOTAL — Returns the total value of a requisition. The excerpt includes a query against PO_REQUISITION_HEADERS_ALL joined to FND_USER, PER_ALL_PEOPLE_F, PER_PHONES, and WF_NOTIFICATIONS, supplied with a requisition_header_id such as 140331 and an employee_id such as 57.
• GET_ACCOUNT_NUMBER, GET_PROJECT_NUMBER, GET_TASK_NAME, GET_EXPENDITURE_TYPE — Return the distribution accounting flexfield, project, task, and expenditure type information for a requisition line, resolving project data through PA_PROJECTS and PA_PROJECTS_ALL.
• GET_SUPPLIER_NAME — Returns the supplier name associated with a requisition line.
• IS_PLACEDONPO, IS_PLACEDONSO, IS_PLACEDONNG — Predicate functions that indicate whether a line has been placed on a purchase order, sales order, or another sourcing document.
• GET_APPROVER_NAME, GET_APPROVER_EMAIL — Return the name and e-mail address of the current approver for the requisition.
• GET_BUSINESS_GROUP_NAME — Returns the business group name for the requisition operating unit.
• GET_SHIPMENT_NUMBER, GET_SO_NUMBER_STATUS, GET_SO_NUMBER_STATUS_CODE, GET_SO_STATUS — Return shipment and sales order status information by joining OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL.
• GETLINEINFO — Returns consolidated line information for display.

Tables Accessed

The package reads from FINANCIALS_SYSTEM_PARAMS_ALL for operating unit and system parameters, FND_LOOKUP_VALUES for descriptive lookup values, FND_TERRITORIES_TL for territory names, and FND_USER for user identity resolution. HR data comes from PER_ALL_PEOPLE_F, PER_PHONES, and HR_LOCATIONS_ALL_TL. Purchasing data is drawn from PO_HEADERS_ALL, PO_DISTRIBUTIONS_ALL, and POR_ITEM_ATTRIBUTE_VALUES. Project accounting data is read from PA_PROJECTS and PA_PROJECTS_ALL. Sales order information is read from OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL. Logging output is written to FND_LOG_MESSAGES.

Usage Notes

The package is invoked at runtime by EBS forms and self-service requisition pages when displaying requisition headers and lines, and by workflow notification activities that require approver names and e-mail addresses. It is referenced by 12 other packages in the ETRM dependency map. Because it is classified OTHER rather than as a public API, customizations should avoid calling it directly; the supported interfaces for requisition data are the PO and iProcurement APIs. The functions are stateless and read-only with respect to the business tables, so they are safe to call repeatedly within a form or concurrent program session.