[Home] [Help]
PACKAGE: APPS.OKL_LPO_PVT
Source
1 PACKAGE OKL_LPO_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSLPOS.pls 115.5 2003/11/06 01:41:44 pjgomes noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE lpov_rec_type IS RECORD (
7 id NUMBER := Okc_Api.G_MISS_NUM
8 ,org_id NUMBER := Okc_Api.G_MISS_NUM
9 ,name OKL_LATE_POLICIES_V.NAME%TYPE := Okc_Api.G_MISS_CHAR
10 ,description OKL_LATE_POLICIES_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR
11 ,ise_id NUMBER := Okc_Api.G_MISS_NUM
12 ,tdf_id NUMBER := Okc_Api.G_MISS_NUM
13 ,idx_id NUMBER := Okc_Api.G_MISS_NUM
14 ,late_policy_type_code OKL_LATE_POLICIES_V.LATE_POLICY_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR
15 ,object_version_number NUMBER := Okc_Api.G_MISS_NUM
16 ,late_chrg_allowed_yn OKL_LATE_POLICIES_V.LATE_CHRG_ALLOWED_YN%TYPE := Okc_Api.G_MISS_CHAR
17 ,late_chrg_fixed_yn OKL_LATE_POLICIES_V.LATE_CHRG_FIXED_YN%TYPE := Okc_Api.G_MISS_CHAR
18 ,late_chrg_amount NUMBER := Okc_Api.G_MISS_NUM
19 ,late_chrg_rate NUMBER := Okc_Api.G_MISS_NUM
20 ,late_chrg_grace_period NUMBER := Okc_Api.G_MISS_NUM
21 ,late_chrg_minimum_balance NUMBER := Okc_Api.G_MISS_NUM
22 ,minimum_late_charge NUMBER := Okc_Api.G_MISS_NUM
23 ,maximum_late_charge NUMBER := Okc_Api.G_MISS_NUM
24 ,late_int_allowed_yn OKL_LATE_POLICIES_V.LATE_INT_ALLOWED_YN%TYPE := Okc_Api.G_MISS_CHAR
25 ,late_int_fixed_yn OKL_LATE_POLICIES_V.LATE_INT_FIXED_YN%TYPE := Okc_Api.G_MISS_CHAR
26 ,late_int_rate NUMBER := Okc_Api.G_MISS_NUM
27 ,adder_rate NUMBER := Okc_Api.G_MISS_NUM
28 ,late_int_grace_period NUMBER := Okc_Api.G_MISS_NUM
29 ,late_int_minimum_balance NUMBER := Okc_Api.G_MISS_NUM
30 ,minimum_late_interest NUMBER := Okc_Api.G_MISS_NUM
31 ,maximum_late_interest NUMBER := Okc_Api.G_MISS_NUM
32 ,attribute_category OKL_LATE_POLICIES_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR
33 ,attribute1 OKL_LATE_POLICIES_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR
34 ,attribute2 OKL_LATE_POLICIES_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR
35 ,attribute3 OKL_LATE_POLICIES_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR
36 ,attribute4 OKL_LATE_POLICIES_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR
37 ,attribute5 OKL_LATE_POLICIES_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR
38 ,attribute6 OKL_LATE_POLICIES_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR
39 ,attribute7 OKL_LATE_POLICIES_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR
40 ,attribute8 OKL_LATE_POLICIES_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR
41 ,attribute9 OKL_LATE_POLICIES_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR
42 ,attribute10 OKL_LATE_POLICIES_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR
43 ,attribute11 OKL_LATE_POLICIES_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR
44 ,attribute12 OKL_LATE_POLICIES_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR
45 ,attribute13 OKL_LATE_POLICIES_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR
46 ,attribute14 OKL_LATE_POLICIES_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR
47 ,attribute15 OKL_LATE_POLICIES_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR
48 ,created_by NUMBER := Okc_Api.G_MISS_NUM
49 ,creation_date OKL_LATE_POLICIES_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
50 ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
51 ,last_update_date OKL_LATE_POLICIES_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
52 ,last_update_login NUMBER := Okc_Api.G_MISS_NUM
53 ,DAYS_IN_YEAR OKL_LATE_POLICIES_V.DAYS_IN_YEAR%TYPE := Okc_Api.G_MISS_CHAR);
54 G_MISS_lpov_rec lpov_rec_type;
55 TYPE lpov_tbl_type IS TABLE OF lpov_rec_type
56 INDEX BY BINARY_INTEGER;
57 TYPE lpo_rec_type IS RECORD (
58 id NUMBER := Okc_Api.G_MISS_NUM
59 ,org_id NUMBER := Okc_Api.G_MISS_NUM
60 ,ise_id NUMBER := Okc_Api.G_MISS_NUM
61 ,tdf_id NUMBER := Okc_Api.G_MISS_NUM
62 ,idx_id NUMBER := Okc_Api.G_MISS_NUM
63 ,late_policy_type_code OKL_LATE_POLICIES_B.LATE_POLICY_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR
64 ,object_version_number NUMBER := Okc_Api.G_MISS_NUM
65 ,late_chrg_allowed_yn OKL_LATE_POLICIES_B.LATE_CHRG_ALLOWED_YN%TYPE := Okc_Api.G_MISS_CHAR
66 ,late_chrg_fixed_yn OKL_LATE_POLICIES_B.LATE_CHRG_FIXED_YN%TYPE := Okc_Api.G_MISS_CHAR
67 ,late_chrg_amount NUMBER := Okc_Api.G_MISS_NUM
68 ,late_chrg_rate NUMBER := Okc_Api.G_MISS_NUM
69 ,late_chrg_grace_period NUMBER := Okc_Api.G_MISS_NUM
70 ,late_chrg_minimum_balance NUMBER := Okc_Api.G_MISS_NUM
71 ,minimum_late_charge NUMBER := Okc_Api.G_MISS_NUM
72 ,maximum_late_charge NUMBER := Okc_Api.G_MISS_NUM
73 ,late_int_allowed_yn OKL_LATE_POLICIES_B.LATE_INT_ALLOWED_YN%TYPE := Okc_Api.G_MISS_CHAR
74 ,late_int_fixed_yn OKL_LATE_POLICIES_B.LATE_INT_FIXED_YN%TYPE := Okc_Api.G_MISS_CHAR
75 ,late_int_rate NUMBER := Okc_Api.G_MISS_NUM
76 ,adder_rate NUMBER := Okc_Api.G_MISS_NUM
77 ,late_int_grace_period NUMBER := Okc_Api.G_MISS_NUM
78 ,late_int_minimum_balance NUMBER := Okc_Api.G_MISS_NUM
79 ,minimum_late_interest NUMBER := Okc_Api.G_MISS_NUM
80 ,maximum_late_interest NUMBER := Okc_Api.G_MISS_NUM
81 ,attribute_category OKL_LATE_POLICIES_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR
82 ,attribute1 OKL_LATE_POLICIES_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR
83 ,attribute2 OKL_LATE_POLICIES_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR
84 ,attribute3 OKL_LATE_POLICIES_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR
85 ,attribute4 OKL_LATE_POLICIES_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR
86 ,attribute5 OKL_LATE_POLICIES_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR
87 ,attribute6 OKL_LATE_POLICIES_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR
88 ,attribute7 OKL_LATE_POLICIES_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR
89 ,attribute8 OKL_LATE_POLICIES_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR
90 ,attribute9 OKL_LATE_POLICIES_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR
91 ,attribute10 OKL_LATE_POLICIES_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR
92 ,attribute11 OKL_LATE_POLICIES_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR
93 ,attribute12 OKL_LATE_POLICIES_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR
94 ,attribute13 OKL_LATE_POLICIES_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR
95 ,attribute14 OKL_LATE_POLICIES_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR
96 ,attribute15 OKL_LATE_POLICIES_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR
97 ,created_by NUMBER := Okc_Api.G_MISS_NUM
98 ,creation_date OKL_LATE_POLICIES_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
99 ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
100 ,last_update_date OKL_LATE_POLICIES_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
101 ,last_update_login NUMBER := Okc_Api.G_MISS_NUM
102 ,DAYS_IN_YEAR OKL_LATE_POLICIES_B.DAYS_IN_YEAR%TYPE := Okc_Api.G_MISS_CHAR);
103
104 G_MISS_lpo_rec lpo_rec_type;
105 TYPE lpo_tbl_type IS TABLE OF lpo_rec_type
106 INDEX BY BINARY_INTEGER;
107 TYPE okl_late_policies_tl_rec_type IS RECORD (
108 id NUMBER := Okc_Api.G_MISS_NUM
109 ,LANGUAGE OKL_LATE_POLICIES_TL.LANGUAGE%TYPE := Okc_Api.G_MISS_CHAR
110 ,source_lang OKL_LATE_POLICIES_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR
111 ,name OKL_LATE_POLICIES_TL.NAME%TYPE := Okc_Api.G_MISS_CHAR
112 ,description OKL_LATE_POLICIES_TL.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR
113 ,created_by NUMBER := Okc_Api.G_MISS_NUM
114 ,creation_date OKL_LATE_POLICIES_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
115 ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
116 ,last_update_date OKL_LATE_POLICIES_TL.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
117 ,last_update_login NUMBER := Okc_Api.G_MISS_NUM);
118 GMissOklLatePoliciesTlRec okl_late_policies_tl_rec_type;
119 TYPE okl_late_policies_tl_tbl_type IS TABLE OF okl_late_policies_tl_rec_type
120 INDEX BY BINARY_INTEGER;
121 ---------------------------------------------------------------------------
122 -- GLOBAL MESSAGE CONSTANTS
123 ---------------------------------------------------------------------------
124 G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
125 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
126 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
127 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
128 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
129 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
130 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
131 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
132 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
133 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
134 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
135 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
136 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
137
138 ---------------------------------------------------------------------------
139 -- GLOBAL EXCEPTIONS
140 ---------------------------------------------------------------------------
141 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
142
143 ---------------------------------------------------------------------------
144 -- GLOBAL VARIABLES
145 ---------------------------------------------------------------------------
146 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_LPO_PVT';
147 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
148 ---------------------------------------------------------------------------
149 -- Procedures and Functions
150 ---------------------------------------------------------------------------
151
152 PROCEDURE qc;
153 PROCEDURE change_version;
154 PROCEDURE api_copy;
155 PROCEDURE add_language;
156 PROCEDURE insert_row(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_lpov_rec IN lpov_rec_type,
163 x_lpov_rec OUT NOCOPY lpov_rec_type);
164 PROCEDURE insert_row(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_lpov_tbl IN lpov_tbl_type,
171 x_lpov_tbl OUT NOCOPY lpov_tbl_type);
172 PROCEDURE lock_row(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_lpov_rec IN lpov_rec_type);
179 PROCEDURE lock_row(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_lpov_tbl IN lpov_tbl_type);
186 PROCEDURE update_row(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2,
192 p_lpov_rec IN lpov_rec_type,
193 x_lpov_rec OUT NOCOPY lpov_rec_type);
194 PROCEDURE update_row(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_lpov_tbl IN lpov_tbl_type,
201 x_lpov_tbl OUT NOCOPY lpov_tbl_type);
202 PROCEDURE delete_row(
203 p_api_version IN NUMBER,
204 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2,
208 p_lpov_rec IN lpov_rec_type);
209 PROCEDURE delete_row(
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_lpov_tbl IN lpov_tbl_type);
216 PROCEDURE validate_row(
217 p_api_version IN NUMBER,
218 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_msg_count OUT NOCOPY NUMBER,
221 x_msg_data OUT NOCOPY VARCHAR2,
222 p_lpov_rec IN lpov_rec_type);
223 PROCEDURE validate_row(
224 p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_msg_count OUT NOCOPY NUMBER,
228 x_msg_data OUT NOCOPY VARCHAR2,
229 p_lpov_tbl IN lpov_tbl_type);
230 END Okl_Lpo_Pvt;