1 PACKAGE CCT_LKUP_PUB AS
2 /*$Header: cctplovs.pls 120.0 2005/06/02 09:25:20 appldev noship $*/
3
4
5
6 PROCEDURE GET_TRUE_FALSE_LOV
7 (
8 p_server_group_id IN NUMBER , -- server group id
9 p_server_id IN NUMBER , -- server id
10 p_server_parameter_id IN NUMBER , -- server parameter id
11 p_env_lang IN VARCHAR2 , -- language
12 x_lov_count OUT NOCOPY NUMBER , -- number of lov_data returned
13 x_lov_data OUT NOCOPY IEO_STRING_VARR, -- list of lov_data returned.
14 x_return_status OUT NOCOPY VARCHAR2,
15 x_msg_count OUT NOCOPY NUMBER,
16 x_msg_data OUT NOCOPY VARCHAR2
17 );
18
19 PROCEDURE GET_JDBC_CONN_LOV
20 (
21 p_server_group_id IN NUMBER , -- server group id
22 p_server_id IN NUMBER , -- server id
23 p_server_parameter_id IN NUMBER , -- server parameter id
24 p_env_lang IN VARCHAR2 , -- language
25 x_lov_count OUT NOCOPY NUMBER , -- number of lov_data returned
26 x_lov_data OUT NOCOPY IEO_STRING_VARR, -- list of lov_data returned.
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2
30
31 );
32
33
34 PROCEDURE GET_TRACE_LOV
35 (
36 p_server_group_id IN NUMBER , -- server group id
37 p_server_id IN NUMBER , -- server id
38 p_server_parameter_id IN NUMBER , -- server parameter id
39 p_env_lang IN VARCHAR2 , -- language
40 x_lov_count OUT NOCOPY NUMBER , -- number of lov_data returned
41 x_lov_data OUT NOCOPY IEO_STRING_VARR, -- list of lov_data returned.
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2
45
46 );
47
48 PROCEDURE GET_TEST_TYPE_LOV
49 (
50 p_server_group_id IN NUMBER , -- server group id
51 p_server_id IN NUMBER , -- server id
52 p_server_parameter_id IN NUMBER , -- server parameter id
53 p_env_lang IN VARCHAR2 , -- language
54 x_lov_count OUT NOCOPY NUMBER , -- number of lov_data returned
55 x_lov_data OUT NOCOPY IEO_STRING_VARR, -- list of lov_data returned.
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2
59
60 );
61
62
63 PROCEDURE GET_MW_LOV
64 (
65 p_server_group_id IN NUMBER , -- server group id
66 p_server_id IN NUMBER , -- server id
67 p_server_parameter_id IN NUMBER , -- server parameter id
68 p_env_lang IN VARCHAR2 , -- language
69 x_lov_count OUT NOCOPY NUMBER , -- number of lov_data returned
70 x_lov_data OUT NOCOPY IEO_STRING_VARR, -- list of lov_data returned.
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2
74
75 );
76
77
78
79 PROCEDURE GET_ROUTE_POINT_LOV
80 (
81 p_server_group_id IN NUMBER , -- server group id
82 p_server_id IN NUMBER , -- server id
83 p_server_parameter_id IN NUMBER , -- server parameter id
84 p_env_lang IN VARCHAR2 , -- language
85 x_lov_count OUT NOCOPY NUMBER , -- number of lov_data returned
86 x_lov_data OUT NOCOPY IEO_STRING_VARR, -- list of lov_data returned.
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2
90
91 );
92
93
94 END CCT_LKUP_PUB;