1 Package okl_la_validation_util_pvt as
2 /* $Header: OKLPDVUS.pls 120.2 2006/11/13 07:33:37 dpsingh noship $ */
3
4 --Start of Comments
5 --API Name : okl_la_validation_util_pvt
6 --Description : Fetches item meta data
7 --End of Comments
8
9 ---------------------------------------------------------------------------
10 -- GLOBAL MESSAGE CONSTANTS
11 ---------------------------------------------------------------------------
12 G_SERVICED_ASSET_LTY_CODE CONSTANT VARCHAR2(15) := 'LINK_SERV_ASSET';
13 G_FEE_ASSET_LTY_CODE CONSTANT VARCHAR2(15) := 'LINK_FEE_ASSET';
14 G_SERVICE_LTY_CODE CONSTANT VARCHAR2(12) := 'SOLD_SERVICE';
15 G_FEE_LTY_CODE CONSTANT VARCHAR2(12) := 'FEE';
16 G_INVALID_VALUE CONSTANT VARCHAR2(2000) := 'OKL_CONTRACTS_INVALID_VALUE';
17 G_PKG_NAME CONSTANT VARCHAR2(200) := 'okl_la_validation_util_pvt';
18 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
19 G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
20 G_COL_NAME_TOKEN CONSTANT VARCHAR2(2000) := OKL_API.G_COL_NAME_TOKEN;
21 -- SUBTYPE chrv_rec_type IS OKL_OKC_MIGRATION_PVT.chrv_rec_type;
22 -- SUBTYPE khrv_rec_type IS OKL_CONTRACT_PUB.khrv_rec_type;
23
24
25 Procedure Get_Rule_Jtot_Metadata (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_chr_id IN NUMBER,
31 p_rgd_code IN VARCHAR2,
32 p_rdf_code IN VARCHAR2,
33 p_name IN VARCHAR2,
34 p_id1 IN VARCHAR2,
35 p_id2 IN VARCHAR2,
36 x_select_clause OUT NOCOPY VARCHAR2,
37 x_from_clause OUT NOCOPY VARCHAR2,
38 x_where_clause OUT NOCOPY VARCHAR2,
39 x_order_by_clause OUT NOCOPY VARCHAR2,
40 x_object_code OUT NOCOPY VARCHAR2);
41
42 --Added by dpsingh for LE Uptake
43 Procedure Validate_Legal_Entity(x_return_status OUT NOCOPY VARCHAR2,
44 p_chrv_rec IN OKL_OKC_MIGRATION_PVT.CHRV_REC_TYPE,
45 p_mode IN VARCHAR2);
46
47 Procedure Validate_Rule (p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_chr_id IN NUMBER,
53 p_rgd_code IN VARCHAR2,
54 p_rdf_code IN VARCHAR2,
55 p_id1 IN OUT NOCOPY VARCHAR2,
56 p_id2 IN OUT NOCOPY VARCHAR2,
57 p_name IN VARCHAR2,
58 p_object_code IN OUT NOCOPY VARCHAR2,
59 p_ak_region IN VARCHAR2,
60 p_ak_attribute IN VARCHAR2
61 );
62
63
64 Procedure Validate_Contact (p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2,
69 p_chr_id IN NUMBER,
70 p_rle_code IN VARCHAR2,
71 p_cro_code IN VARCHAR2,
72 p_id1 IN OUT NOCOPY VARCHAR2,
73 p_id2 IN OUT NOCOPY VARCHAR2,
74 p_name IN VARCHAR2,
75 p_object_code IN OUT NOCOPY VARCHAR2,
76 p_ak_region IN VARCHAR2,
77 p_ak_attribute IN VARCHAR2
78 );
79
80
81 Procedure Validate_Link_Asset (p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_chr_id IN NUMBER,
87 p_parent_cle_id IN NUMBER,
88 p_id1 IN OUT NOCOPY VARCHAR2,
89 p_id2 IN OUT NOCOPY VARCHAR2,
90 p_name IN VARCHAR2,
91 p_object_code IN VARCHAR2);
92
93
94 Procedure Validate_Party (p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_chr_id IN NUMBER,
100 p_cle_id IN NUMBER,
101 p_cpl_id IN NUMBER,
102 p_lty_code IN VARCHAR2,
103 p_rle_code IN VARCHAR2,
104 p_id1 IN OUT NOCOPY VARCHAR2,
105 p_id2 IN OUT NOCOPY VARCHAR2,
106 p_name IN VARCHAR2,
107 p_object_code IN VARCHAR2);
108
109
110 Procedure Get_Party_Jtot_data (p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_scs_code IN VARCHAR2,
116 p_buy_or_sell IN VARCHAR2,
117 p_rle_code IN VARCHAR2,
118 p_id1 IN OUT NOCOPY VARCHAR2,
119 p_id2 IN OUT NOCOPY VARCHAR2,
120 p_name IN VARCHAR2,
121 p_object_code IN OUT NOCOPY VARCHAR2,
122 p_ak_region IN VARCHAR2,
123 p_ak_attribute IN VARCHAR2
124 );
125
126 PROCEDURE validate_deal(
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_chr_id IN NUMBER,
133 p_scs_code IN VARCHAR2,
134 p_contract_number IN VARCHAR2,
135 p_customer_id1 IN OUT NOCOPY VARCHAR2,
136 p_customer_id2 IN OUT NOCOPY VARCHAR2,
137 p_customer_code IN OUT NOCOPY VARCHAR2,
138 p_customer_name IN VARCHAR2,
139 p_chr_cust_acct_id OUT NOCOPY NUMBER,
140 p_customer_acc_name IN VARCHAR2,
141 p_product_name IN VARCHAR2,
142 p_product_id IN OUT NOCOPY VARCHAR2,
143 p_product_desc IN OUT NOCOPY VARCHAR2,
144 p_contact_id1 IN OUT NOCOPY VARCHAR2,
145 p_contact_id2 IN OUT NOCOPY VARCHAR2,
146 p_contact_code IN OUT NOCOPY VARCHAR2,
147 p_contact_name IN VARCHAR2,
148 p_mla_no IN VARCHAR2,
149 p_mla_id IN OUT NOCOPY VARCHAR2,
150 p_program_no IN VARCHAR2,
151 p_program_id IN OUT NOCOPY VARCHAR2,
152 p_credit_line_no IN VARCHAR2,
153 p_credit_line_id IN OUT NOCOPY VARCHAR2,
154 p_currency_name IN VARCHAR2,
155 p_currency_code IN OUT NOCOPY VARCHAR2,
156 p_start_date IN DATE,
157 p_deal_type IN VARCHAR2
158 );
159
160 Procedure Validate_Service (p_api_version IN NUMBER,
161 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 p_chr_id IN NUMBER,
166 p_cle_id IN NUMBER,
167 p_lty_code IN VARCHAR2,
168 p_item_id1 IN OUT NOCOPY VARCHAR2,
169 p_item_id2 IN OUT NOCOPY VARCHAR2,
170 p_item_name IN VARCHAR2,
171 p_item_object_code IN OUT NOCOPY VARCHAR2,
172 p_cpl_id IN NUMBER,
173 p_rle_code IN VARCHAR2,
174 p_party_id1 IN OUT NOCOPY VARCHAR2,
175 p_party_id2 IN OUT NOCOPY VARCHAR2,
176 p_party_name IN VARCHAR2,
177 p_party_object_code IN OUT NOCOPY VARCHAR2,
178 p_amount IN NUMBER
179 );
180
181 Procedure Validate_Fee (p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_chr_id IN NUMBER,
187 p_cle_id IN NUMBER,
188 p_lty_code IN VARCHAR2,
189 p_item_id1 IN OUT NOCOPY VARCHAR2,
190 p_item_id2 IN OUT NOCOPY VARCHAR2,
191 p_item_name IN VARCHAR2,
192 p_item_object_code IN OUT NOCOPY VARCHAR2,
193 p_cpl_id IN NUMBER,
194 p_rle_code IN VARCHAR2,
195 p_party_id1 IN OUT NOCOPY VARCHAR2,
196 p_party_id2 IN OUT NOCOPY VARCHAR2,
197 p_party_name IN VARCHAR2,
198 p_party_object_code IN OUT NOCOPY VARCHAR2,
199 p_amount IN NUMBER
200 );
201
202 Procedure Validate_Fee (p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207 p_chr_id IN NUMBER,
208 p_cle_id IN NUMBER,
209 p_amount IN NUMBER,
210 p_init_direct_cost IN NUMBER
211 );
212
213 PROCEDURE VALIDATE_ROLE_JTOT (p_api_version IN NUMBER,
214 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 p_object_name IN VARCHAR2,
219 p_id1 IN VARCHAR2,
220 p_id2 IN VARCHAR2);
221
222
223 PROCEDURE VALIDATE_CONTACT_JTOT (p_api_version IN NUMBER,
224 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_msg_data OUT NOCOPY VARCHAR2,
228 p_object_name IN VARCHAR2,
229 p_id1 IN VARCHAR2,
230 p_id2 IN VARCHAR2);
231
232
233 PROCEDURE VALIDATE_STYLE_JTOT (p_api_version IN NUMBER,
234 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
235 x_return_status OUT NOCOPY VARCHAR2,
236 x_msg_count OUT NOCOPY NUMBER,
237 x_msg_data OUT NOCOPY VARCHAR2,
238 p_object_name IN VARCHAR2,
239 p_id1 IN VARCHAR2,
240 p_id2 IN VARCHAR2);
241
242 Procedure validate_crdtln_wrng (p_api_version IN NUMBER,
243 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
244 x_return_status OUT NOCOPY VARCHAR2,
245 x_msg_count OUT NOCOPY NUMBER,
246 x_msg_data OUT NOCOPY VARCHAR2,
247 p_chr_id IN NUMBER
248 );
249
250 Procedure validate_crdtln_err (p_api_version IN NUMBER,
251 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
252 x_return_status OUT NOCOPY VARCHAR2,
253 x_msg_count OUT NOCOPY NUMBER,
254 x_msg_data OUT NOCOPY VARCHAR2,
255 p_chr_id IN NUMBER
256 );
257
258 Procedure validate_creditline (p_api_version IN NUMBER,
259 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
260 x_return_status OUT NOCOPY VARCHAR2,
261 x_msg_count OUT NOCOPY NUMBER,
262 x_msg_data OUT NOCOPY VARCHAR2,
263 p_chr_id IN NUMBER,
264 p_deal_type IN VARCHAR2,
265 p_mla_no IN VARCHAR2,
266 p_cl_no IN VARCHAR2);
267
268
269
270 end okl_la_validation_util_pvt;