1 PACKAGE OKL_XMLP_PARAMS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRXMPS.pls 120.1 2007/01/04 14:51:29 udhenuko noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ---------------------------------------------------------------------------
6
7 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_XMLP_PARAMS_PVT';
9 G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
10 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
11
12
13 SUBTYPE xmp_rec_type IS okl_xmp_pvt.xmp_rec_type ;
14 SUBTYPE xmp_tbl_type IS okl_xmp_pvt.xmp_tbl_type ;
15 ---------------------------------------------------------------------------
16 -- Procedures and Functions
17 ---------------------------------------------------------------------------
18 ----------------------------------------------------------------------------
19 -- PROCEDURE create_xmlp_params_rec
20 ---------------------------------------------------------------------------
21 -- Start of comments
22 --
23 -- Procedure Name : create_xmlp_params_rec
24 -- Description : procedure for inserting the records in
25 -- table OKL_XMLP_PARAMS
26 -- Business Rules : This procedure creates a record containing the parameter
27 -- name, value and type code. x_return_status is 'S' on success.
28 -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
29 -- x_msg_data, p_xmp_rec, x_xmp_rec.
30 -- Version : 1.0
31 -- End of comments
32 ---------------------------------------------------------------------------
33 PROCEDURE create_xmlp_params_rec ( p_api_version IN NUMBER
34 ,p_init_msg_list IN VARCHAR2
35 ,x_return_status OUT NOCOPY VARCHAR2
36 ,x_msg_count OUT NOCOPY NUMBER
37 ,x_msg_data OUT NOCOPY VARCHAR2
38 ,p_xmp_rec IN xmp_rec_type
39 ,x_xmp_rec OUT NOCOPY xmp_rec_type
40 );
41
42 ----------------------------------------------------------------------------
43 -- PROCEDURE create_xmlp_params_tbl
44 ---------------------------------------------------------------------------
45 -- Start of comments
46 --
47 -- Procedure Name : create_xmlp_params_tbl
48 -- Description : procedure for inserting the records in
49 -- table OKL_XMLP_PARAMS
50 -- Business Rules : This procedure creates a record containing the parameter
51 -- name, value and type code. x_return_status is 'S' on success.
52 -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
53 -- x_msg_data, p_xmp_tbl, x_xmp_tbl.
54 -- Version : 1.0
55 -- End of comments
56 ---------------------------------------------------------------------------
57 PROCEDURE create_xmlp_params_tbl ( p_api_version IN NUMBER
58 ,p_init_msg_list IN VARCHAR2
59 ,x_return_status OUT NOCOPY VARCHAR2
60 ,x_msg_count OUT NOCOPY NUMBER
61 ,x_msg_data OUT NOCOPY VARCHAR2
62 ,p_xmp_tbl IN xmp_tbl_type
63 ,x_xmp_tbl OUT NOCOPY xmp_tbl_type
64 );
65
66 -----------------------------------------------------------------------------
67 -- PROCEDURE update_xmlp_params_rec
68 ---------------------------------------------------------------------------
69 -- Start of comments
70 --
71 -- Procedure Name : update_xmlp_params_rec
72 -- Description : procedure for updating the records in
73 -- table OKL_XMLP_PARAMS
74 -- Business Rules : This procedure updates a record based on the id provided.
75 -- x_return_status is 'S' on success.
76 -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
77 -- x_msg_data, p_xmp_rec, x_xmp_rec.
78 -- Version : 1.0
79 -- End of comments
80 ---------------------------------------------------------------------------
81 PROCEDURE update_xmlp_params_rec ( p_api_version IN NUMBER
82 ,p_init_msg_list IN VARCHAR2
83 ,x_return_status OUT NOCOPY VARCHAR2
84 ,x_msg_count OUT NOCOPY NUMBER
85 ,x_msg_data OUT NOCOPY VARCHAR2
86 ,p_xmp_rec IN xmp_rec_type
87 ,x_xmp_rec OUT NOCOPY xmp_rec_type
88 );
89
90 -----------------------------------------------------------------------------
91 -- PROCEDURE update_xmlp_params_tbl
92 ---------------------------------------------------------------------------
93 -- Start of comments
94 --
95 -- Procedure Name : update_xmlp_params_tbl
96 -- Description : procedure for updating the records in
97 -- table OKL_XMLP_PARAMS
98 -- Business Rules : This procedure updates a record based on the id provided.
99 -- x_return_status is 'S' on success.
100 -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
101 -- x_msg_data, p_xmp_tbl, x_xmp_tbl.
102 -- Version : 1.0
103 -- End of comments
104 ---------------------------------------------------------------------------
105 PROCEDURE update_xmlp_params_tbl ( p_api_version IN NUMBER
106 ,p_init_msg_list IN VARCHAR2
107 ,x_return_status OUT NOCOPY VARCHAR2
108 ,x_msg_count OUT NOCOPY NUMBER
109 ,x_msg_data OUT NOCOPY VARCHAR2
110 ,p_xmp_tbl IN xmp_tbl_type
111 ,x_xmp_tbl OUT NOCOPY xmp_tbl_type
112 );
113
114 ----------------------------------------------------------------------------
115 -- PROCEDURE delete_xmlp_params_rec
116 ---------------------------------------------------------------------------
117 -- Start of comments
118 --
119 -- Procedure Name : delete_xmlp_params_rec
120 -- Description : procedure for deleting the records in
121 -- table OKL_XMLP_PARAMS
122 -- Business Rules : This procedure deletes a record based on the id provided.
123 -- x_return_status is 'S' on success.
124 -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
125 -- x_msg_data, p_xmp_rec, x_xmp_rec.
126 -- Version : 1.0
127 -- End of comments
128 ---------------------------------------------------------------------------
129 PROCEDURE delete_xmlp_params ( p_api_version IN NUMBER
130 ,p_init_msg_list IN VARCHAR2
131 ,x_return_status OUT NOCOPY VARCHAR2
132 ,x_msg_count OUT NOCOPY NUMBER
133 ,x_msg_data OUT NOCOPY VARCHAR2
134 ,p_batch_id IN OKL_XMLP_PARAMS.Batch_Id%TYPE
135 );
136
137
138 ---------------------------------------------------------------------------
139 -- PROCEDURE validate_xmlp_params_rec
140 ---------------------------------------------------------------------------
141 -- Start of comments
142 --
143 -- Procedure Name : validate_xmlp_params_rec
144 -- Description : procedure for validating the records in
145 -- table OKL_XMLP_PARAMS
146 -- Business Rules : Validates the record passed to it. x_return_status is 'S' on success.
147 -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
148 -- x_msg_data, p_xmp_rec.
149 -- Version : 1.0
150 -- End of comments
151 ---------------------------------------------------------------------------
152
153 PROCEDURE validate_xmlp_params_rec( p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2,
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2,
158 p_xmp_rec IN xmp_rec_type);
159
160 ---------------------------------------------------------------------------
161 -- PROCEDURE validate_xmlp_params_tbl
162 ---------------------------------------------------------------------------
163 -- Start of comments
164 --
165 -- Procedure Name : validate_xmlp_params_tbl
166 -- Description : procedure for validating the records in
167 -- table OKL_XMLP_PARAMS
168 -- Business Rules : Validates the records passed to it. x_return_status is 'S' on success.
169 -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
170 -- x_msg_data, p_xmp_tbl.
171 -- Version : 1.0
172 -- End of comments
173 ---------------------------------------------------------------------------
174
175 PROCEDURE validate_xmlp_params_tbl( p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2,
180 p_xmp_tbl IN xmp_tbl_type);
181
182 END OKL_XMLP_PARAMS_PVT;