DBA Data[Home] [Help]

PACKAGE: APPS.OKS_COV_ENT_PVT

Source


1 PACKAGE OKS_COV_ENT_PVT AS
2 /* $Header: OKSRCENS.pls 120.0.12000000.1 2007/01/16 22:09:38 appldev ship $ */
3 
4 -----------------------------------------------------------------------------------------------------------------------*
5 
6   SUBTYPE Gx_Boolean         IS VARCHAR2(1);
7   SUBTYPE Gx_YesNo           IS VARCHAR2(1);
8   SUBTYPE Gx_Ret_Sts         IS VARCHAR2(1);
9   SUBTYPE Gx_ExceptionMsg    IS VARCHAR2(200);
10 
11 -----------------------------------------------------------------------------------------------------------------------*
12 
13   SUBTYPE Gx_TimeZoneId      IS NUMBER; --OKX_TIMEZONES_V.TIMEZONE_ID%TYPE;
14   SUBTYPE Gx_ReactDurn       IS NUMBER(15,2);--OKC_REACT_INTERVALS.DURATION%TYPE;
15   SUBTYPE Gx_ReactUOM        IS VARCHAR2(3); --OKC_REACT_INTERVALS.UOM_CODE%TYPE;
16   SUBTYPE Gx_OKS_Id          IS NUMBER;
17   SUBTYPE Gx_BusProcess_Id   IS NUMBER; --OKX_BUS_PROCESSES_V.ID1%TYPE;
18   SUBTYPE Gx_Severity_Id     IS NUMBER; --OKX_INCIDENT_SEVERITS_V.ID1%TYPE;
19 
20   SUBTYPE rcn_rsn_rec_type   IS OKS_COV_ENT_PUB.rcn_rsn_rec_type;
21   SUBTYPE gdrt_inp_rec_type  IS OKS_COV_ENT_PUB.gdrt_inp_rec_type;
22 
23   G_RET_STS_SUCCESS        CONSTANT Gx_Ret_Sts    := OKC_API.G_RET_STS_SUCCESS;
24   G_RET_STS_ERROR	       CONSTANT Gx_Ret_Sts    := OKC_API.G_RET_STS_ERROR;
25   G_RET_STS_UNEXP_ERROR    CONSTANT Gx_Ret_Sts    := OKC_API.G_RET_STS_UNEXP_ERROR;
26 
27   G_TRUE                   CONSTANT Gx_Boolean    := OKC_API.G_TRUE;
28   G_FALSE                  CONSTANT Gx_Boolean    := OKC_API.G_FALSE;
29 
30   G_REQUIRED_VALUE         CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
31   G_INVALID_VALUE          CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
32 
33   G_COL_NAME_TOKEN         CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
34   G_PARENT_TABLE_TOKEN     CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
35   G_CHILD_TABLE_TOKEN      CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
36   G_NO_PARENT_RECORD       CONSTANT VARCHAR2(200) := 'OKS_NO_PARENT_RECORD';
37 
38   G_UNEXPECTED_ERROR       CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
39   G_SQLERRM_TOKEN          CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';  --'SQLerrm';
40   G_SQLCODE_TOKEN          CONSTANT VARCHAR2(200) := 'ERROR_CODE';     --'SQLcode';
41 
42   G_DEBUG_TOKEN            CONSTANT VARCHAR2(200) := 'OKS_ENT_DEBUG';
43   G_PACKAGE_TOKEN          CONSTANT VARCHAR2(200) := 'Package';
44   G_PROGRAM_TOKEN          CONSTANT VARCHAR2(200) := 'Program';
45   G_PKG_NAME	           CONSTANT VARCHAR2(200) := 'OKS_COV_ENT_PUB';
46   G_APP_NAME_OKS	       CONSTANT VARCHAR2(3)   := 'OKS';
47   G_APP_NAME_OKC	       CONSTANT VARCHAR2(3)   := 'OKC';
48 
49 
50 PROCEDURE Get_default_react_resolve_by
51     (p_api_version           in  number
52     ,p_init_msg_list         in  varchar2
53     ,p_inp_rec               in  gdrt_inp_rec_type
54     ,x_return_status         out nocopy varchar2
55     ,x_msg_count             out nocopy number
56     ,x_msg_data              out nocopy varchar2
57     ,x_react_rec             out nocopy rcn_rsn_rec_type
58     ,x_resolve_rec           out nocopy rcn_rsn_rec_type);
59 
60 END OKS_COV_ENT_PVT;
61