[Home] [Help]
Skip to content
PACKAGE: APPS.OKL_SRL_PVT
Source
1 PACKAGE OKL_SRL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSSRLS.pls 120.1.12020000.2 2013/02/20 11:15:53 racheruv ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_SIF_RET_LEVELS_V Record Spec
7 TYPE okl_sif_ret_levels_v_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,level_index_number NUMBER := OKC_API.G_MISS_NUM
10 ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
11 ,sir_id NUMBER := OKC_API.G_MISS_NUM
12 ,index_number NUMBER := OKC_API.G_MISS_NUM
13 ,level_type OKL_SIF_RET_LEVELS_V.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR
14 ,amount NUMBER := OKC_API.G_MISS_NUM
15 ,advance_or_arrears OKL_SIF_RET_LEVELS_V.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR
16 ,period OKL_SIF_RET_LEVELS_V.PERIOD%TYPE := OKC_API.G_MISS_CHAR
17 ,lock_level_step OKL_SIF_RET_LEVELS_V.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR
18 ,days_in_period NUMBER := OKC_API.G_MISS_NUM
19 ,first_payment_date OKL_SIF_RET_LEVELS_V.FIRST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
20 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
21 ,stream_interface_attribute1 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
22 ,stream_interface_attribute2 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
23 ,stream_interface_attribute3 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
24 ,stream_interface_attribute4 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
25 ,stream_interface_attribute5 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
26 ,stream_interface_attribute6 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
27 ,stream_interface_attribute7 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
28 ,stream_interface_attribute8 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
29 ,stream_interface_attribute9 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
30 ,stream_interface_attribute10 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
31 ,stream_interface_attribute11 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
32 ,stream_interface_attribute12 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
36 ,creation_date OKL_SIF_RET_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
33 ,stream_interface_attribute13 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
34 ,stream_interface_attribute14 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
35 ,stream_interface_attribute15 OKL_SIF_RET_LEVELS_V.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
37 ,created_by NUMBER := OKC_API.G_MISS_NUM
38 ,last_update_date OKL_SIF_RET_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
39 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
40 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
41 ,rate NUMBER := OKC_API.G_MISS_NUM
42 ,reamort_balance NUMBER := OKC_API.G_MISS_NUM
43 ,reamort_date DATE := OKC_API.G_MISS_DATE); --racheruv 18.02.2013
44 GMissOklSifRetLevelsVRec okl_sif_ret_levels_v_rec_type;
45 TYPE okl_sif_ret_levels_v_tbl_type IS TABLE OF okl_sif_ret_levels_v_rec_type
46 INDEX BY BINARY_INTEGER;
47 -- OKL_SIF_RET_LEVELS Record Spec
48 TYPE srl_rec_type IS RECORD (
49 id NUMBER := OKC_API.G_MISS_NUM
50 ,sir_id NUMBER := OKC_API.G_MISS_NUM
51 ,index_number NUMBER := OKC_API.G_MISS_NUM
52 ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
53 ,level_index_number NUMBER := OKC_API.G_MISS_NUM
54 ,level_type OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR
55 ,amount NUMBER := OKC_API.G_MISS_NUM
56 ,advance_or_arrears OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR
57 ,period OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR
58 ,lock_level_step OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR
59 ,days_in_period NUMBER := OKC_API.G_MISS_NUM
60 ,first_payment_date OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
61 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
62 ,stream_interface_attribute1 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
63 ,stream_interface_attribute2 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
64 ,stream_interface_attribute3 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
65 ,stream_interface_attribute4 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
66 ,stream_interface_attribute5 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
67 ,stream_interface_attribute6 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
68 ,stream_interface_attribute7 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
69 ,stream_interface_attribute8 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
70 ,stream_interface_attribute9 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
71 ,stream_interface_attribute10 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
72 ,stream_interface_attribute11 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
73 ,stream_interface_attribute12 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
74 ,stream_interface_attribute13 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
75 ,stream_interface_attribute14 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
76 ,stream_interface_attribute15 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
77 ,creation_date OKL_SIF_RET_LEVELS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
78 ,created_by NUMBER := OKC_API.G_MISS_NUM
79 ,last_update_date OKL_SIF_RET_LEVELS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
80 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
81 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
82 ,rate NUMBER := OKC_API.G_MISS_NUM
83 ,reamort_balance NUMBER := OKC_API.G_MISS_NUM
84 ,reamort_date DATE := OKC_API.G_MISS_DATE); --racheruv 18.02.2013
85 G_MISS_srl_rec srl_rec_type;
86 TYPE srl_tbl_type IS TABLE OF srl_rec_type
87 INDEX BY BINARY_INTEGER;
88 ---------------------------------------------------------------------------
89 -- GLOBAL MESSAGE CONSTANTS
90 ---------------------------------------------------------------------------
91 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
100 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
101 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
102 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
103 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
104
105 ---------------------------------------------------------------------------
106 -- GLOBAL EXCEPTIONS
107 ---------------------------------------------------------------------------
108 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
109
113 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SRL_PVT';
110 ---------------------------------------------------------------------------
111 -- GLOBAL VARIABLES
112 ---------------------------------------------------------------------------
114 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
115 ---------------------------------------------------------------------------
116 -- Procedures and Functions
117 ---------------------------------------------------------------------------
118
119 PROCEDURE qc;
120 PROCEDURE change_version;
121 PROCEDURE api_copy;
122 PROCEDURE insert_row(
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
129 x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type);
130 PROCEDURE insert_row(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
137 x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
138 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
139 PROCEDURE insert_row(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
146 x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type);
147 PROCEDURE lock_row(
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type);
154 PROCEDURE lock_row(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
161 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
162 PROCEDURE lock_row(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type);
169 PROCEDURE update_row(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
176 x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type);
177 PROCEDURE update_row(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
184 x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
185 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_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_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
193 x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type);
194 PROCEDURE delete_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_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type);
201 PROCEDURE delete_row(
202 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_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
208 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_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_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_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_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_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_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
230 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
231 PROCEDURE validate_row(
232 p_api_version IN NUMBER,
233 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
234 x_return_status OUT NOCOPY VARCHAR2,
235 x_msg_count OUT NOCOPY NUMBER,
236 x_msg_data OUT NOCOPY VARCHAR2,
237 p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type);
238 END OKL_SRL_PVT;