Search Results igc_cc_yep_process_pkg
Overview
IGC_CC_YEP_PROCESS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema, classified as an "OTHER" API within the ETRM (E-Business Suite Technical Reference Manual) documentation set. The package belongs to the IGC product family, which corresponds to Oracle's Contracts Core (formerly Government Contracts / Contract Commitment) application. The "CC" segment of the name denotes Contracts Core, while "YEP" refers to Year-End Processing. Collectively, the package supports the fiscal year-end close and carry-forward cycle for contract commitments, enabling the application to roll balances, reconcile period status, and post the resulting accounting and commitment entries for the closing fiscal year. Its inclusion of PO_HEADERS_ALL and GL period tables indicates that year-end processing spans both purchasing commitments and general ledger period control, a typical requirement when commitments must be reconciled against the closing accounting period before the next fiscal year begins.
Key Procedures and Functions
The documented API surface for this package consists of a single public entry point:
- YEAR_END_MAIN — The primary driver procedure for year-end processing. It orchestrates the sequence of tasks required to close out a fiscal year for contract commitments, including selection of eligible records, population of the processing workset, application of year-end rules, and generation of the resulting accounting and exception data. It is designed to be invoked once per year-end run, typically on a controlled schedule coordinated with the general ledger close calendar.
Because ETRM documents only this single procedure, no additional public parameters, helper functions, or internal subprogram signatures are asserted here. Implementers should reference the deployed package specification in the target environment for the authoritative parameter list before calling the API directly.
Tables Accessed
The package reads from and writes to the following documented tables, accessed through APPS synonyms:
- IGC_CC_HEADERS, IGC_CC_ACCT_LINES, IGC_CC_DET_PF — contract commitment header, accounting line, and detail/performance data that represent the commitments subject to year-end roll-forward.
- IGC_CC_PERIODS, GL_PERIODS, GL_PERIOD_STATUSES, FND_APPLICATION — period definition and open/closed status information used to identify the correct fiscal year and validate that the closing period is available.
- IGC_CC_PROCESS_DATA, IGC_CC_PROCESS_EXCEPTIONS, IGC_CC_INTERFACE — staging and interface tables that hold year-end worksets, log processing exceptions, and feed downstream processing.
- IGC_CC_ACTIONS — the action/event table recording the year-end processing activity.
- PO_HEADERS_ALL — purchasing document headers referenced for commitment reconciliation.
Usage Notes
IGC_CC_YEP_PROCESS_PKG is an internal application-tier package rather than a published integration API. It is most commonly invoked by Oracle Contracts Core concurrent programs or forms during the year-end close cycle, and its operation is tied to GL period statuses and to the availability of the relevant IGC_CC period records. The ETRM metadata records no other APPS package as referencing this package, and the package itself depends only on SYS.STANDARD; the meaningful dependencies are the table references listed above. Customizations should avoid direct calls to YEAR_END_MAIN unless the surrounding period state and staging tables are fully controlled, because the procedure modifies commitment, accounting line, and interface data as part of a single logical close. The package is documented as VALID in the ETRM 12.2.2 reference and is expected to behave consistently across EBS 12.1.1 and 12.2.2, as the contracts core year-end logic was not materially re-architected between those releases.
-
PACKAGE: APPS.IGC_CC_YEP_PROCESS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_YEP_PROCESS_PKG, status:VALID,
-
PACKAGE: APPS.IGC_CC_YEP_PROCESS_PKG
12.1.1
-
PACKAGE: APPS.IGC_CC_YEP_PROCESS_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_YEP_PROCESS_PKG, status:VALID,
-
PACKAGE: APPS.IGC_CC_YEP_PROCESS_PKG
12.2.2
-
PACKAGE BODY: APPS.IGC_CC_YEP_PROCESS_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IGC_CC_YEP_PROCESS_PKG, status:VALID,
-
PACKAGE BODY: APPS.IGC_CC_YEP_PROCESS_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGC_CC_YEP_PROCESS_PKG, status:VALID,
-
SYNONYM: APPS.IGC_CC_PROCESS_EXCEPTIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGC_CC_PROCESS_EXCEPTIONS, status:VALID,
-
SYNONYM: APPS.IGC_CC_PROCESS_EXCEPTIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGC_CC_PROCESS_EXCEPTIONS, status:VALID,
-
SYNONYM: APPS.IGC_CC_PERIODS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGC_CC_PERIODS, status:VALID,
-
SYNONYM: APPS.IGC_CC_PROCESS_DATA
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGC_CC_PROCESS_DATA, status:VALID,
-
SYNONYM: APPS.IGC_CC_PERIODS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGC_CC_PERIODS, status:VALID,
-
SYNONYM: APPS.IGC_CC_PROCESS_DATA
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGC_CC_PROCESS_DATA, status:VALID,
-
PACKAGE: APPS.IGC_CC_ACCT_LINE_HISTORY_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_ACCT_LINE_HISTORY_PKG, status:VALID,
-
PACKAGE: APPS.IGC_CC_DET_PF_HISTORY_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_DET_PF_HISTORY_PKG, status:VALID,
-
PACKAGE: APPS.IGC_CC_HEADERS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_HEADERS_PKG, status:VALID,
-
PACKAGE: APPS.IGC_CC_DET_PF_HISTORY_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_DET_PF_HISTORY_PKG, status:VALID,
-
PACKAGE: APPS.IGC_CC_REP_YEP_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_REP_YEP_PVT, status:VALID,
-
PACKAGE: APPS.IGC_CC_ACCT_LINE_HISTORY_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_ACCT_LINE_HISTORY_PKG, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
12.2.2 DBA Data
12.2.2
-
SYNONYM: APPS.IGC_CC_ACTIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGC_CC_ACTIONS, status:VALID,
-
PACKAGE: APPS.IGC_CC_DET_PF_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_DET_PF_PKG, status:VALID,
-
PACKAGE: APPS.IGC_CC_HEADER_HISTORY_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_HEADER_HISTORY_PKG, status:VALID,
-
PACKAGE: APPS.IGC_CC_HEADER_HISTORY_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_HEADER_HISTORY_PKG, status:VALID,
-
PACKAGE: APPS.IGC_CC_REP_YEP_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_REP_YEP_PVT, status:VALID,
-
PACKAGE: APPS.IGC_CC_ACCT_LINES_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_ACCT_LINES_PKG, status:VALID,
-
12.2.2 DBA Data
12.2.2
-
PACKAGE: APPS.IGC_CC_HEADERS_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_HEADERS_PKG, status:VALID,
-
PACKAGE: APPS.IGC_CC_ACCT_LINES_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_ACCT_LINES_PKG, status:VALID,
-
PACKAGE: APPS.IGC_CC_PO_INTERFACE_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_PO_INTERFACE_PKG, status:VALID,
-
PACKAGE: APPS.IGC_CC_COMMON_UTILS_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_COMMON_UTILS_PVT, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
PACKAGE: APPS.IGC_CC_COMMON_UTILS_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_COMMON_UTILS_PVT, status:VALID,
-
SYNONYM: APPS.IGC_CC_ACTIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGC_CC_ACTIONS, status:VALID,
-
PACKAGE: APPS.IGC_CC_DET_PF_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_DET_PF_PKG, status:VALID,
-
PACKAGE: APPS.IGC_CC_ACTIONS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_ACTIONS_PKG, status:VALID,
-
PACKAGE: APPS.IGC_CC_PO_INTERFACE_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_PO_INTERFACE_PKG, status:VALID,
-
PACKAGE: APPS.IGC_CC_ACTIONS_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGC_CC_ACTIONS_PKG, status:VALID,
-
SYNONYM: APPS.IGC_CC_DET_PF
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGC_CC_DET_PF, status:VALID,
-
SYNONYM: APPS.IGC_CC_INTERFACE
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGC_CC_INTERFACE, status:VALID,
-
SYNONYM: APPS.IGC_CC_INTERFACE
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGC_CC_INTERFACE, status:VALID,
-
SYNONYM: APPS.IGC_CC_DET_PF
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGC_CC_DET_PF, status:VALID,
-
SYNONYM: APPS.IGC_CC_HEADERS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGC_CC_HEADERS, status:VALID,
-
SYNONYM: APPS.IGC_CC_ACCT_LINES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGC_CC_ACCT_LINES, status:VALID,
-
SYNONYM: APPS.IGC_CC_ACCT_LINES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGC_CC_ACCT_LINES, status:VALID,
-
SYNONYM: APPS.IGC_CC_HEADERS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IGC_CC_HEADERS, status:VALID,
-
PACKAGE: APPS.IGI_GEN
12.2.2
owner:APPS, object_type:PACKAGE, object_name:IGI_GEN, status:VALID,
-
PACKAGE: APPS.IGI_GEN
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGI_GEN, status:VALID,
-
VIEW: APPS.GL_PERIODS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_PERIODS_V, object_name:GL_PERIODS_V, status:VALID,
-
VIEW: APPS.GL_PERIODS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_PERIODS_V, object_name:GL_PERIODS_V, status:VALID,