Overview

The OCL_CLIENT_PACK package consists of two files in the RXC_INSTALL directory, ocl_client_ps.sql and ocl_client_pb.sql. Refer to these files while reading this chapter. The files serve the following purposes:

• ocl_client_ps.sql
  • Package specification
  • Creating the public synonym
  • Granting execute privilege to both RXCLIN_MOD and RXCLIN_READ database roles
• ocl_client_pb.sql
  • Container for the function bodies for the OCL_CLIENT_PACK package

Use SQL*Plus from the RXC database account to execute ocl_client_ps.sql:

• When initially installing the Oracle Clinical application
• Once after each time you modify the file

This file is a skeleton for creating custom validation and derivation because each function provides a stub; as delivered all validations succeeds and no derivation occurs. Each function includes detailed header comments that describe its purpose, parameters, and usage.

The functions in the OCL_CLIENT_PACK package are described in the following sections:

Functions for validation and derivation

• ValidateName
• ValidateDocument
• DeriveDocumentNumber

Functions for page tracking

• DefaultBookPageNumber
• TrimPageNumber
• ChangePageStatus
• AddPhysPageNumber

In each case, the function duplicates a function that already exists in the Oracle Clinical code. If you write new code for the function, your code supersedes the existing application code; otherwise, it simply uses the default system code. The SQL files ocl_client_ps.sql and ocl_client_pb.sql in the RXC_INSTALL are well commented, use them for additional information and to implement your custom functions.