Search Results call_param

Overview

APPS.OE_GENERATE is a code-generation utility package belonging to the Oracle E-Business Suite Order Management (OE) module. Its source header (OEXTGENB.pls, version 120.0, dated 2005) identifies it as a non-shipped ("noship") internal development aid rather than a runtime business API. The package programmatically emits PL/SQL source text into a file handle supplied by UTL_FILE, allowing Oracle's development organization to generate repetitive or templated code constructs — package headers, parameter declarations, variable declarations, element assignments, exception blocks, and status checks — under consistent formatting rules. The global constant G_PKG_NAME retains the literal value 'OE_GENERATE' for diagnostic and error-tagging purposes. In 12.1.1 and 12.2.2 the package remains classified as OTHER within the ETRM registry, reflecting its utility rather than functional-API character.

Key Procedures and Functions

The documented surface comprises 64 procedures and functions. The generation primitives resolve syntactic markers embedded in text lines: Gen_Start_Token and Gen_End_Token strip the leading regeneration delimiters from a source line, while Is_Gen_Start and Is_Gen_End test whether a line begins with the '-- START GEN' or '-- END GEN' sentinel respectively. Start_Gen and End_Gen write those sentinel markers back into an output file so that subsequent regeneration passes can reliably locate managed regions.

File handling is centralized in Load_File, which reads a UTL_FILE handle line by line into the package collection g_src_tbl, terminating cleanly on NO_DATA_FOUND. The structural emitters then build source from this content: PKG_HEADER and PKG_END bracket a generated package specification or body; API_HEADER and API_PARAMETERS emit the signature and parameter list of a generated API; PARAMETER declares formal parameters; VARIABLE declares local variables; ELEMENT emits individual code elements; and ASSIGN writes assignment statements.

Control-flow and diagnostic generation are handled by CHECK_STATUS, which emits post-call status verification code, and by the call-construct trio CALL_PARAM, END_CALL, and the associated closing logic, which together build a multi-line invocation with its argument list. Text output utilities include COMMENT, TEXT, and MSG. Error-handling support is provided by ERROR_MSG, EXC_MSG, STD_EXC_HANDLER, and OTHERS_EXC. LOG_COMPILE records compilation outcomes. GET_MSG retrieves a message text for embedding.

Tables Accessed

The package references no application tables. All documented references resolve through APPS synonyms to supplied PL/SQL infrastructure: UTL_FILE for reading and writing operating-system files, DBMS_SQL for dynamic SQL execution where generated statements must be validated or run, and PLITBLM for PL/SQL internal table (index-by table) support. The in-memory work area is the package global g_src_tbl. Because no OE or other EBS base tables are touched, the package carries no data-integrity or concurrency implications.

Usage Notes

OE_GENERATE is invoked during development and build cycles, not from Oracle Forms, concurrent programs, or production runtime paths. It is referenced by 15 other packages, all of which consume its text-emission procedures to produce generated artifacts. Typical invocation supplies a UTL_FILE file handle opened in write or append mode, then calls PKG_HEADER, API_HEADER, API_PARAMETERS, and the element emitters in sequence, closing with PKG_END and LOG_COMPILE. The '-- START GEN' / '-- END GEN' sentinel convention permits regeneration without disturbing hand-maintained code outside the marked regions. Because the package is marked noship and classified OTHER, it should not be called from customer extensions; custom code requiring equivalent functionality should implement its own generation logic rather than depend on this internal utility.