Results for “create_trx”

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

Overview

IGIPFUNK is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM metadata as an "OTHER" API. Its name and procedure signatures indicate that it belongs to the Oracle Enterprise asset and expense tracking product family identified by the IGI table prefix, and it is specifically concerned with the generation and maintenance of expense numbering. The package provides the numbering engine that underpins expense document identification across classes, types and transaction categories, producing document numbers through the IGI_EXP_NUMBERING_ALL setup table and supporting the associated sequence bookkeeping for fiscal-year aware numbering. It is a low-level utility rather than a user-facing API: it exposes the primitives by which higher-level expense processing code obtains the next document number, inserts the corresponding numbering row, creates and cancels transactions, and reverses or redoes a previously generated number.

Key Procedures and Functions

The package declares seven documented procedures, all public within the package specification and defined with AUTHID CURRENT_USER.

• EXP_NUM — Returns the next expense number for a given combination of numbering code, document class, document type and transaction type. It is the primary entry point for callers that simply need a valid number.
• INSERT_NEW_EXP_ROW — Inserts a new row into the expense numbering setup, accepting the numbering code, document class, document type, transaction type, prefix, suffix, fiscal year and application context, and returning the generated numbering identifier. This supports the administrative maintenance of numbering definitions.
• CREATE_TRX — Creates a transaction record for a numbering identifier, advancing the prefix, suffix, next sequence value, GL date and fiscal year in the process.
• GET_FISCAL_YEAR — Derives the fiscal year that corresponds to a supplied GL date, allowing numbering to be segmented or reset by fiscal period.
• CANCEL_TRX — Cancels a previously generated transaction number, identified by prefix, sequence number and suffix, so that the number can be released or retired without reuse.
• INS_DEL — Performs the insert or delete bookkeeping for a numbering identifier and its sequence, prefix, suffix, transaction date and fiscal year.
• REDO_TRX — Regenerates a transaction number for an existing numbering identifier and returns the new expense number, used when a numbering attempt must be repeated.

Tables Accessed

The single documented table reference is IGI_EXP_NUMBERING_ALL, accessed through an APPS synonym. This table holds the numbering definitions that drive EXP_NUM and the transaction procedures, and it is the target of INSERT_NEW_EXP_ROW and INS_DEL. All fiscal-year, prefix, suffix and sequence values managed by the package are read from or written to this table, which makes it the authoritative configuration source for expense document numbering.

Usage Notes

IGIPFUNK is not referenced by any other documented package, so it is normally invoked directly by expense processing forms, concurrent programs or custom extensions rather than through a wrapper. Typical invocation patterns are: calling EXP_NUM to obtain a number for a new expense entry, calling CREATE_TRX when the number is committed, calling CANCEL_TRX when the entry is voided, and calling REDO_TRX when numbering must be retried. Because the package executes with AUTHID CURRENT_USER, callers must have the appropriate privileges on IGI_EXP_NUMBERING_ALL and the underlying IGI objects. The header comment dates the source to a 2002 revision, so the package has been stable across the 12.1.1 and 12.2.2 releases; no signature changes are documented between them.