[Home] [Help]
PACKAGE: APPS.OKL_SRL_PVT
Source
1 PACKAGE OKL_SRL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSSRLS.pls 115.3 2003/10/16 07:06:16 smahapat noship $ */
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
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
36 ,creation_date OKL_SIF_RET_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
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); --smahapat 10/12/03
42 GMissOklSifRetLevelsVRec okl_sif_ret_levels_v_rec_type;
43 TYPE okl_sif_ret_levels_v_tbl_type IS TABLE OF okl_sif_ret_levels_v_rec_type
44 INDEX BY BINARY_INTEGER;
45 -- OKL_SIF_RET_LEVELS Record Spec
46 TYPE srl_rec_type IS RECORD (
47 id NUMBER := OKC_API.G_MISS_NUM
48 ,sir_id NUMBER := OKC_API.G_MISS_NUM
49 ,index_number NUMBER := OKC_API.G_MISS_NUM
50 ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
51 ,level_index_number NUMBER := OKC_API.G_MISS_NUM
52 ,level_type OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR
53 ,amount NUMBER := OKC_API.G_MISS_NUM
54 ,advance_or_arrears OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR
55 ,period OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR
56 ,lock_level_step OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR
57 ,days_in_period NUMBER := OKC_API.G_MISS_NUM
58 ,first_payment_date OKL_SIF_RET_LEVELS.FIRST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
59 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
60 ,stream_interface_attribute1 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
61 ,stream_interface_attribute2 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
62 ,stream_interface_attribute3 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
63 ,stream_interface_attribute4 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
64 ,stream_interface_attribute5 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
65 ,stream_interface_attribute6 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
66 ,stream_interface_attribute7 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
67 ,stream_interface_attribute8 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
68 ,stream_interface_attribute9 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
69 ,stream_interface_attribute10 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
70 ,stream_interface_attribute11 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
71 ,stream_interface_attribute12 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
72 ,stream_interface_attribute13 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
73 ,stream_interface_attribute14 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
74 ,stream_interface_attribute15 OKL_SIF_RET_LEVELS.STREAM_INTERFACE_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
75 ,creation_date OKL_SIF_RET_LEVELS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
76 ,created_by NUMBER := OKC_API.G_MISS_NUM
77 ,last_update_date OKL_SIF_RET_LEVELS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
78 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
79 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
80 ,rate NUMBER := OKC_API.G_MISS_NUM); --smahapat 10/12/03
81 G_MISS_srl_rec srl_rec_type;
82 TYPE srl_tbl_type IS TABLE OF srl_rec_type
83 INDEX BY BINARY_INTEGER;
84 ---------------------------------------------------------------------------
85 -- GLOBAL MESSAGE CONSTANTS
86 ---------------------------------------------------------------------------
87 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
88 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
89 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
90 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
94 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
95 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
96 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
97 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
98 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
99 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
100
101 ---------------------------------------------------------------------------
102 -- GLOBAL EXCEPTIONS
103 ---------------------------------------------------------------------------
104 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
105
106 ---------------------------------------------------------------------------
107 -- GLOBAL VARIABLES
108 ---------------------------------------------------------------------------
109 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SRL_PVT';
110 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
111 ---------------------------------------------------------------------------
112 -- Procedures and Functions
113 ---------------------------------------------------------------------------
114
115 PROCEDURE qc;
116 PROCEDURE change_version;
117 PROCEDURE api_copy;
118 PROCEDURE insert_row(
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
125 x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type);
126 PROCEDURE insert_row(
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_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
133 x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
134 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
135 PROCEDURE insert_row(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
142 x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type);
143 PROCEDURE lock_row(
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type);
150 PROCEDURE lock_row(
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
157 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
158 PROCEDURE lock_row(
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type);
165 PROCEDURE update_row(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type,
172 x_okl_sif_ret_levels_v_rec OUT NOCOPY okl_sif_ret_levels_v_rec_type);
173 PROCEDURE update_row(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
180 x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type,
181 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
182 PROCEDURE update_row(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
189 x_okl_sif_ret_levels_v_tbl OUT NOCOPY okl_sif_ret_levels_v_tbl_type);
190 PROCEDURE delete_row(
191 p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2,
196 p_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type);
197 PROCEDURE delete_row(
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
204 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
205 PROCEDURE delete_row(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type);
212 PROCEDURE validate_row(
213 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_okl_sif_ret_levels_v_rec IN okl_sif_ret_levels_v_rec_type);
219 PROCEDURE validate_row(
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2,
225 p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type,
226 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
227 PROCEDURE validate_row(
228 p_api_version IN NUMBER,
229 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
230 x_return_status OUT NOCOPY VARCHAR2,
231 x_msg_count OUT NOCOPY NUMBER,
232 x_msg_data OUT NOCOPY VARCHAR2,
233 p_okl_sif_ret_levels_v_tbl IN okl_sif_ret_levels_v_tbl_type);
234 END OKL_SRL_PVT;