4: ---------------------------------------------------------------------------
5: -- TYPE Definitions
6: ---------------------------------------------------------------------------
7: -- Contracts business events codes TBL Type
8: SUBTYPE EVENT_TBL_TYPE IS OKC_TERMS_QA_GRP.BUSDOCDATES_TBL_TYPE;
9: ---------------------------------------------------------------------------
10: -- Global VARIABLES
11: ---------------------------------------------------------------------------
12: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_REP_QA_CHECK_PVT';
26: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
27: G_REP_QA_TYPE CONSTANT VARCHAR2(30) := 'REPOSITORY';
28: G_QA_LOOKUP CONSTANT VARCHAR2(30) := 'OKC_TERM_QA_LIST';
29:
30: G_QA_STS_SUCCESS CONSTANT varchar2(1) := OKC_TERMS_QA_GRP.G_QA_STS_SUCCESS;
31: G_QA_STS_ERROR CONSTANT varchar2(1) := OKC_TERMS_QA_GRP.G_QA_STS_ERROR;
32: G_QA_STS_WARNING CONSTANT varchar2(1) := OKC_TERMS_QA_GRP.G_QA_STS_WARNING;
33:
34:
27: G_REP_QA_TYPE CONSTANT VARCHAR2(30) := 'REPOSITORY';
28: G_QA_LOOKUP CONSTANT VARCHAR2(30) := 'OKC_TERM_QA_LIST';
29:
30: G_QA_STS_SUCCESS CONSTANT varchar2(1) := OKC_TERMS_QA_GRP.G_QA_STS_SUCCESS;
31: G_QA_STS_ERROR CONSTANT varchar2(1) := OKC_TERMS_QA_GRP.G_QA_STS_ERROR;
32: G_QA_STS_WARNING CONSTANT varchar2(1) := OKC_TERMS_QA_GRP.G_QA_STS_WARNING;
33:
34:
35: G_OKC CONSTANT VARCHAR2(3) := 'OKC';
28: G_QA_LOOKUP CONSTANT VARCHAR2(30) := 'OKC_TERM_QA_LIST';
29:
30: G_QA_STS_SUCCESS CONSTANT varchar2(1) := OKC_TERMS_QA_GRP.G_QA_STS_SUCCESS;
31: G_QA_STS_ERROR CONSTANT varchar2(1) := OKC_TERMS_QA_GRP.G_QA_STS_ERROR;
32: G_QA_STS_WARNING CONSTANT varchar2(1) := OKC_TERMS_QA_GRP.G_QA_STS_WARNING;
33:
34:
35: G_OKC CONSTANT VARCHAR2(3) := 'OKC';
36: G_NORMAL_QA CONSTANT VARCHAR2(30) := 'NORMAL';