1 Package OKC_PARAMETERS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPPRMS.pls 120.2 2006/02/28 14:46:41 smallya noship $ */
3
4 subtype prmv_rec_type is OKC_PRM_PVT.prmv_rec_type;
5
6 TYPE prmv_tbl_type IS TABLE OF prmv_rec_type
7 INDEX BY BINARY_INTEGER;
8
9 TYPE name_value_rec_type IS RECORD (
10 NAME VARCHAR2(100),
11 VALUE VARCHAR2(2000));
12
13 TYPE name_value_tbl_type IS TABLE OF name_value_rec_type
14 INDEX BY BINARY_INTEGER;
15
16 PROCEDURE add_language;
17
18 procedure create_parameter(p_api_version IN NUMBER,
19 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_count OUT NOCOPY NUMBER,
22 x_msg_data OUT NOCOPY VARCHAR2,
23 p_prmv_rec IN prmv_rec_type,
24 x_prmv_rec OUT NOCOPY prmv_rec_type);
25 procedure create_parameter(p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30 p_prmv_tbl IN prmv_tbl_type,
31 x_prmv_tbl OUT NOCOPY prmv_tbl_type);
32
33 procedure update_parameter(p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 p_prmv_rec IN prmv_rec_type,
39 x_prmv_rec OUT NOCOPY prmv_rec_type);
40 procedure update_parameter(p_api_version IN NUMBER,
41 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 p_prmv_tbl IN prmv_tbl_type,
46 x_prmv_tbl OUT NOCOPY prmv_tbl_type);
47
48 procedure delete_parameter(p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2,
53 p_prmv_rec IN prmv_rec_type);
54 procedure delete_parameter(p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_prmv_tbl IN prmv_tbl_type);
60
61 procedure lock_parameter(p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2,
66 p_prmv_rec IN prmv_rec_type);
67 procedure lock_parameter(p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2,
72 p_prmv_tbl IN prmv_tbl_type);
73
74 -- for lct only
75 procedure set_sql_id (p_sql_id number);
76 function get_sql_id return number;
77
78 -- for process api only
79 function Count_Params RETURN NUMBER;
80 procedure Set_Params(p_array in JTF_VARCHAR2_TABLE_2000);
81 function Get_Name(p_index in number) return varchar2;
82 function Get_Value(p_index in number) return varchar2;
83 function Get(p_name in varchar2) return varchar2;
84
85 function Get_Index(p_name in varchar2) return number;
86 procedure Reset_Param(p_index in number, p_value in varchar2);
87
88 END OKC_PARAMETERS_PUB;