Results for “countorgsineffctrl_finitem”
9 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
AMW_FINSTMT_CERT_PVT is a private PL/SQL package owned by the APPS schema within the Oracle E-Business Suite environment. It belongs to the Application Management Workspace (AMW) module, specifically the financial statement certification subsystem introduced under the ETRM (Enterprise Transaction and Risk Management) framework. The package's core business function is to assemble, update, and persist the summary and evaluation data associated with a financial statement certification cycle. Within Oracle EBS 12.1.1 and 12.2.2, financial statement certification supports internal control and compliance requirements, allowing an organisation to gather control evaluations, process information, identified risks, and account-level details into a consolidated certification record.
The package bears the _PVT suffix, which designates it as a private or internal API. It is not intended for direct invocation by external customisations and exposes no public contract. Its procedures are consumed by user-facing pages, concurrent programs, and higher-level public APIs within the AMW framework.
Key Procedures and Functions
The package exposes numerous procedures that fall broadly into two categories: record update routines and summary population routines. The documented update procedures include UPDATE_NEXT_LEVEL_PROC_INFO, UPDATE_GLOBAL_PROC_INFO, UPDATE_LAST_EVALUATION_INFO, UPDATE_CERTIFICATION_DETAIL, UPDATE_UNMITIGATED_RISKS, and UPDATE_INEFFECTIVE_CONTROLS. These routines refresh certification-level data for a given process, organisation, and certification, capturing the outcome of hierarchical process rollups, prior evaluations, outstanding unmitigated risks, and ineffective control results.
The population routines assemble aggregated summaries into staging and reporting tables. POPULATE_SUMMARY and POPULATE_ALL_CERT_SUMMARY build certification-level rollups, while POPULATE_CERT_GENERAL_SUM produces general certification summary content. Further aggregation procedures include POPULATE_ALL_FIN_PROC_EVAL_SUM, POPULATE_FIN_STMT_CERT_SUM, and the documented but commented POPULATE_ALL_CERT_GENERAL_SUM and POPULATE_ALL_FIN_ORG_EVAL_SUM entries. Supporting procedures such as BUILD_AMW_FIN_CERT_EVAL_SUM, RESET_AMW_FIN_CERT_EVAL_SUM, COMPUTE_VALUES_FOR_EVAL_SUM, and INSERT_FIN_CERT_EVAL_SUM manage the evaluation summary lifecycle, computing values and inserting calculated results. Helper routines including GETTOTALPROCESSES_FOR_ACCOUNT, GETGLPERIODFOR_FINCERTEVALSUM, and COUNTPROCSCERTRECORDED_ACCNTS supply counts and GL period context used in the aggregation logic.
Tables Accessed
The package reads and writes a wide set of AMW tables through APPS synonyms. Certification structure and header data reside in AMW_CERTIFICATION_B. Summary output is stored in AMW_CERT_DASHBOARD_SUM, AMW_FIN_CERT_EVAL_SUM, AMW_FIN_ORG_EVAL_SUM, and AMW_FIN_PROCESS_EVAL_SUM. Account and control relationships are drawn from AMW_ACCT_ASSOCIATIONS, AMW_CONTROL_ASSOCIATIONS, AMW_FIN_ITEMS_KEY_ACC, AMW_FIN_KEY_ACCOUNTS_B, AMW_FIN_KEY_ACCT_FLAT, AMW_FIN_ITEM_FLAT, AMW_FIN_PROC_CERT_RELAN, and AMW_FIN_STMNT_ITEMS_B. Opinion data is sourced from AMW_OPINION_TYPES_B and AMW_OBJECT_OPINION_TYPES.
Usage Notes
Because AMW_FINSTMT_CERT_PVT is classified as a private package and is not referenced by any other packaged API, it is invoked exclusively by internal AMW components rather than by customer extensions. Typical invocation paths include the certification user interface pages that display or finalise a certification, and concurrent programs that batch-process summary population using the standard errbuf and retcode output parameters visible in procedures such as POPULATE_ALL_CERT_SUMMARY and POPULATE_ALL_FIN_PROC_EVAL_SUM. Custom code should not call these routines directly; integrators seeking certification data should query the underlying summary tables or use the supported public AMW APIs instead.