1 PACKAGE OKS_COV_ENT_PUB AS
2 /* $Header: OKSPCENS.pls 120.1 2005/06/19 19:41:43 appldev $ */
3
4 -- GLOBAL VARIABLES
5 -------------------------------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_COV_ENT_PUB';
7 G_APP_NAME_OKS CONSTANT VARCHAR2(3) := 'OKS';
8 G_APP_NAME_OKC CONSTANT VARCHAR2(3) := 'OKC';
9 -------------------------------------------------------------------------------
10
11
12 G_BEST CONSTANT VARCHAR2(10):= 'BEST';
13 G_FIRST CONSTANT VARCHAR2(10):= 'FIRST';
14 G_REACTION CONSTANT VARCHAR2(90) := 'RCN';
15 G_RESOLUTION CONSTANT VARCHAR2(90) := 'RSN';
16 G_REACT_RESOLVE CONSTANT VARCHAR2(90) := 'RCN_RSN';
17
18 G_REACTION_TIME CONSTANT VARCHAR2(10):= 'RCN';
19 G_RESOLUTION_TIME CONSTANT VARCHAR2(10):= 'RSN';
20 G_COVERAGE_TYPE_IMP_LEVEL CONSTANT VARCHAR2(10):= 'COVTYP_IMP';
21 G_NO_SORT_KEY CONSTANT VARCHAR2(10):= 'NO_KEY';
22
23 /**
24
25 Procedure Specification:
26
27 PROCEDURE Get_default_react_resolve_by
28 (p_api_version in number
29 ,p_init_msg_list in varchar2
30 ,p_inp_rec in gdrt_inp_rec_type
31 ,x_return_status out nocopy varchar2
32 ,x_msg_count out nocopy number
33 ,x_msg_data out nocopy varchar2
34 ,x_react_rec out nocopy rcn_rsn_rec_type
35 ,x_resolve_rec out nocopy rcn_rsn_rec_type);
36
37 Current Version:
38 1.0
39
40 Parameter Descriptions:
41
42 The following table describes the IN parameters associated with this API.
43
44 Parameter Data Type Required Description and
45 Validations
46
47 p_api_version NUMBER Yes Standard IN Parameter.Represents API version.
48 p_init_msg_list VARCHAR2 Yes Standard IN Parameter.Initializes message list.
49 p_inp_rec gdrt_inp_rec_type Yes See Below the Data Structure Specification: gdrt_inp_rec_type.
50
51
52 Input Record Specification: gdrt_inp_rec_type
53
54 Parameter Data Type Required Description and Validations
55
56 coverage_template_id NUMBER Yes Coverage Template line ID.
57 business_process_id NUMBER Yes Business Process ID.
58 request_date DATE No Request Date. The default is system date.
59 severity_id NUMBER Yes Severity ID. service request severity id.
60 time_zone_id NUMBER Yes Request Time Zone ID.
61
62 The following table describes the OUT parameters associated with this API:
63
64 Parameter Data Type Description
65
66 x_return_status VARCHAR2 Standard OUT Parameter.API return stautus.'S'(Success),'U'(Unexpected Error),'E'(Error)
67 x_msg_count NUMBER Standard OUT Parameter.Error message count.
68 x_msg_data VARCHAR2 Standard OUT Parameter. Error message.
69 x_react_rec rcn_rsn_rec_type Reaction Time information.
70 See the Data Structure Specification: rcn_rsn_rec_type
71 x_resolve_rec rcn_rsn_rec_type Resolution Time information.
72 See the Data Structure Specification: rcn_rsn_rec_type.
73
74 Output Record Specification: rcn_rsn_rec_type:
75
76 Parameter Data Type Description
77
78 by_date_start DATE Date and Time by which the Reaction
79 or Resolution has begun for a Service Request.
80 by_date_end DATE Date and Time by which the Reaction
81 or Resolution has to be completed for a Service Request.
82
83 Procedure Description:
84
85 This API returns react by start and end times as x_react_rec
86 and resolve by start and end times as x_resolv_rec for the given inputs.
87
88 The API accepts input as a record type grt_inp_rec_type.
89
90 The inputs accepted are
91 contract_line_id,business_process_id,severity_id,request_date,time_zone_id,
92 category_rcn_rsn,compute_option.
93
94 */
95
96
97 TYPE gdrt_inp_rec_type IS RECORD
98 (Coverage_template_id number
99 ,Business_process_id number
100 ,request_date date
101 ,Severity_id number
102 ,Time_zone_id number
103 ,Dates_In_Input_TZ VARCHAR2(1)); -- Added for 12.0 ENT-TZ project (JVARGHES)
104
105 TYPE rcn_rsn_rec_type IS RECORD
106 (by_date_start date
107 ,by_date_end date);
108
109 PROCEDURE Get_default_react_resolve_by
110 (p_api_version in number
111 ,p_init_msg_list in varchar2
112 ,p_inp_rec in gdrt_inp_rec_type
113 ,x_return_status out nocopy varchar2
114 ,x_msg_count out nocopy number
115 ,x_msg_data out nocopy varchar2
116 ,x_react_rec out nocopy rcn_rsn_rec_type
117 ,x_resolve_rec out nocopy rcn_rsn_rec_type);
118
119 END OKS_COV_ENT_PUB;