Search Results get_to_email




Overview
Explore in AI Chat

Overview

OKS_K_ACTIONS_PVT is a private PL/SQL package in the APPS schema that supports service contract action processing within the Oracle Service (OKS) module of Oracle E-Business Suite. Its classification as a PVT (private) package indicates that it is an internal implementation unit, not part of the published API surface intended for direct third-party invocation. It is called by other service packages, most notably OKS_WF_K_PROCESS_PVT, which drives workflow-enabled contract processes. The package consolidates logic for renewal validation, email notification, quality assurance check-list execution, and repository maintenance of email details. It operates over the service contract header structures defined in OKC_K_HEADERS_ALL_B and OKS_K_HEADERS_B, tying contract actions to notification and process-driven behaviour. The metadata confirms a valid, compiled status in both 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

Eleven documented entry points are associated with this package:

  • VALIDATEFORRENEWALACTION — Evaluates whether a contract qualifies for a renewal action, applying the business rules that gate renewal eligibility.
  • SEND_EMAIL — Dispatches email notifications generated in the context of contract actions.
  • STORE_EMAIL_DTLS — Persists email detail records; the inverse of GET_EMAIL_DTLS.
  • GET_EMAIL_DTLS — Retrieves stored email detail information for a contract or action context.
  • DEL_EMAIL_DTLS — Removes email detail records that are no longer required.
  • GET_TO_EMAIL — Resolves the recipient email address used by the notification logic.
  • EXECUTE_QA_CHECK_LIST — Runs the quality assurance check-list associated with a contract action.
  • LAUNCH_QA_REPORT — Initiates generation or display of the QA report, drawing on report templates.
  • SETREMINDERSYN — Sets the reminder flag or synchronisation indicator governing reminder behaviour for a contract.
  • UPDATE_SINGLE_CONTRACTS — Applies updates to individual contract header records in the service contract tables.

Parameter lists are not reproduced here; the descriptions above reflect documented purpose only.

Tables Accessed

  • OKC_K_HEADERS_ALL_B and OKS_K_HEADERS_B — the core contract header entities read and updated during actions, including renewal validation and single-contract updates.
  • JTF_NOTES_TL — the translatable notes table used for attaching notes to contract records.
  • OKC_PROCESS_DEFS_B and OKC_STATUSES_B — process definition and status reference data that govern valid action transitions.
  • OKS_EMAIL_DETAILS and its sequence OKS_EMAIL_DETAILS_S1 — storage of email notification details maintained by the STORE/GET/DEL procedures.
  • OKS_REPORT_TEMPLATES — template definitions used when launching QA reports.
  • WF_ITEMS — the workflow runtime item table, linking contract actions to their workflow context.
  • DBMS_TRANSACTION and PLITBLM — transaction control and PL/SQL internal table/buffer utilities used during processing.

Usage Notes

As a PVT package, OKS_K_ACTIONS_PVT is not a supported integration point for customer extensions. It is invoked indirectly through service contract forms, workflow process activities configured against OKS_WF_K_PROCESS_PVT, and internal service concurrent processing. Because only OKS_WF_K_PROCESS_PVT is documented as referencing it, any custom code that calls this package directly risks breakage on patch application, since private package signatures may change without notice. Developers who need equivalent functionality should reproduce the logic using public APIs on the contract header entities rather than depending on this unit, while DBAs may consult it when diagnosing workflow failures, missing notifications, or renewal validation errors.