[Home] [Help]
PACKAGE: APPS.OKL_LRT_PVT
Source
1 PACKAGE okl_lrt_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSLRTS.pls 120.5 2005/07/05 12:35:30 asawanka noship $ */
3
4 -----------------------------------------------------------------------------
5 -- PACKAGE CONSTANTS
6 -----------------------------------------------------------------------------
7
8 g_pkg_name CONSTANT varchar2(200) := 'OKL_LRT_PVT';
9 g_app_name CONSTANT varchar2(3) := okl_api.g_app_name;
10 g_api_version CONSTANT number := 1;
11 g_false CONSTANT varchar2(1) := fnd_api.g_false;
12 g_true CONSTANT varchar2(1) := fnd_api.g_true;
13 g_db_error CONSTANT varchar2(12) := 'OKL_DB_ERROR';
14 g_prog_name_token CONSTANT varchar2(9) := 'PROG_NAME';
15 g_sqlcode_token CONSTANT varchar2(7) := 'SQLCODE';
16 g_sqlerrm_token CONSTANT varchar2(7) := 'SQLERRM';
17 g_ret_sts_success CONSTANT varchar2(1) := fnd_api.g_ret_sts_success;
18 g_ret_sts_unexp_error CONSTANT varchar2(1) := fnd_api.g_ret_sts_unexp_error;
19 g_ret_sts_error CONSTANT varchar2(1) := fnd_api.g_ret_sts_error;
20 g_miss_char CONSTANT varchar2(1) := fnd_api.g_miss_char;
21 g_miss_num CONSTANT number := fnd_api.g_miss_num;
22 g_miss_date CONSTANT date := fnd_api.g_miss_date;
23 g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
24 g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
25 g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
26 g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
27 g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
28 g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
29 g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
30 g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
31 g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
32 g_child_table_token CONSTANT varchar2(200) := okl_api.g_child_table_token;
33 g_unexpected_error CONSTANT varchar2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
34
35 ---------------------------------------------------------------------------
36 -- DATA STRUCTURES
37 ---------------------------------------------------------------------------
38 -- OKL_LS_RT_FCTR_SETS_V Record Spec
39
40 TYPE lrtv_rec_type IS RECORD (
41 id number,
42 object_version_number number,
43 sfwt_flag okl_ls_rt_fctr_sets_v.sfwt_flag%TYPE,
44 try_id number,
45 pdt_id number,
46 rate number,
47 frq_code okl_ls_rt_fctr_sets_v.frq_code%TYPE,
48 arrears_yn okl_ls_rt_fctr_sets_v.arrears_yn%TYPE,
49 start_date okl_ls_rt_fctr_sets_v.start_date%TYPE,
50 end_date okl_ls_rt_fctr_sets_v.end_date%TYPE,
51 name okl_ls_rt_fctr_sets_v.name%TYPE,
52 description okl_ls_rt_fctr_sets_v.description%TYPE,
53 created_by number,
54 creation_date okl_ls_rt_fctr_sets_v.creation_date%TYPE,
55 last_updated_by number := okl_api.g_miss_num,
56 last_update_date okl_ls_rt_fctr_sets_v.last_update_date%TYPE,
57 last_update_login number,
58 attribute_category okl_ls_rt_fctr_sets_v.attribute_category%TYPE,
59 attribute1 okl_ls_rt_fctr_sets_v.attribute1%TYPE,
60 attribute2 okl_ls_rt_fctr_sets_v.attribute2%TYPE,
61 attribute3 okl_ls_rt_fctr_sets_v.attribute3%TYPE,
62 attribute4 okl_ls_rt_fctr_sets_v.attribute4%TYPE,
63 attribute5 okl_ls_rt_fctr_sets_v.attribute5%TYPE,
64 attribute6 okl_ls_rt_fctr_sets_v.attribute6%TYPE,
65 attribute7 okl_ls_rt_fctr_sets_v.attribute7%TYPE,
66 attribute8 okl_ls_rt_fctr_sets_v.attribute8%TYPE,
67 attribute9 okl_ls_rt_fctr_sets_v.attribute9%TYPE,
68 attribute10 okl_ls_rt_fctr_sets_v.attribute10%TYPE,
69 attribute11 okl_ls_rt_fctr_sets_v.attribute11%TYPE,
70 attribute12 okl_ls_rt_fctr_sets_v.attribute12%TYPE,
71 attribute13 okl_ls_rt_fctr_sets_v.attribute13%TYPE,
72 attribute14 okl_ls_rt_fctr_sets_v.attribute14%TYPE,
73 attribute15 okl_ls_rt_fctr_sets_v.attribute15%TYPE,
74 sts_code okl_ls_rt_fctr_sets_v.sts_code%TYPE,
75 org_id number,
76 currency_code okl_ls_rt_fctr_sets_v.currency_code%TYPE,
77 lrs_type_code okl_ls_rt_fctr_sets_v.lrs_type_code%TYPE,
78 end_of_term_id number,
79 orig_rate_set_id number
80 );
81
82 TYPE lrtv_tbl_type IS TABLE OF lrtv_rec_type INDEX BY BINARY_INTEGER;
83
84 -- OKL_LS_RT_FCTR_SETS_B Record Spec
85
86 TYPE lrt_rec_type IS RECORD (
87 id number,
88 object_version_number number,
89 name okl_ls_rt_fctr_sets_b.name%TYPE,
90 arrears_yn okl_ls_rt_fctr_sets_b.arrears_yn%TYPE,
91 start_date okl_ls_rt_fctr_sets_b.start_date%TYPE,
92 end_date okl_ls_rt_fctr_sets_b.end_date%TYPE,
93 pdt_id number,
94 rate number,
95 try_id number,
96 frq_code okl_ls_rt_fctr_sets_b.frq_code%TYPE,
97 created_by number,
98 creation_date okl_ls_rt_fctr_sets_b.creation_date%TYPE,
99 last_updated_by number,
100 last_update_date okl_ls_rt_fctr_sets_b.last_update_date%TYPE,
101 last_update_login number,
102 attribute_category okl_ls_rt_fctr_sets_b.attribute_category%TYPE,
103 attribute1 okl_ls_rt_fctr_sets_b.attribute1%TYPE,
104 attribute2 okl_ls_rt_fctr_sets_b.attribute2%TYPE,
105 attribute3 okl_ls_rt_fctr_sets_b.attribute3%TYPE,
106 attribute4 okl_ls_rt_fctr_sets_b.attribute4%TYPE,
107 attribute5 okl_ls_rt_fctr_sets_b.attribute5%TYPE,
108 attribute6 okl_ls_rt_fctr_sets_b.attribute6%TYPE,
109 attribute7 okl_ls_rt_fctr_sets_b.attribute7%TYPE,
110 attribute8 okl_ls_rt_fctr_sets_b.attribute8%TYPE,
111 attribute9 okl_ls_rt_fctr_sets_b.attribute9%TYPE,
112 attribute10 okl_ls_rt_fctr_sets_b.attribute10%TYPE,
113 attribute11 okl_ls_rt_fctr_sets_b.attribute11%TYPE,
114 attribute12 okl_ls_rt_fctr_sets_b.attribute12%TYPE,
115 attribute13 okl_ls_rt_fctr_sets_b.attribute13%TYPE,
116 attribute14 okl_ls_rt_fctr_sets_b.attribute14%TYPE,
117 attribute15 okl_ls_rt_fctr_sets_b.attribute15%TYPE,
118 sts_code okl_ls_rt_fctr_sets_b.sts_code%TYPE,
119 org_id number,
120 currency_code okl_ls_rt_fctr_sets_b.currency_code%TYPE,
121 lrs_type_code okl_ls_rt_fctr_sets_b.lrs_type_code%TYPE,
122 end_of_term_id number,
123 orig_rate_set_id number
124 );
125
126 TYPE lrt_tbl_type IS TABLE OF lrt_rec_type INDEX BY BINARY_INTEGER;
127
128 -- OKL_LS_RT_FCTR_SETS_TL Record Spec
129
130 TYPE lrttl_rec_type IS RECORD (
131 id number,
132 language okl_ls_rt_fctr_sets_tl.language%TYPE,
133 source_lang okl_ls_rt_fctr_sets_tl.source_lang%TYPE,
134 sfwt_flag okl_ls_rt_fctr_sets_tl.sfwt_flag%TYPE,
135 description okl_ls_rt_fctr_sets_tl.description%TYPE,
136 created_by number,
137 creation_date okl_ls_rt_fctr_sets_tl.creation_date%TYPE,
138 last_updated_by number,
139 last_update_date okl_ls_rt_fctr_sets_tl.last_update_date%TYPE,
140 last_update_login number
141 );
142
143 TYPE lrttl_tbl_type IS TABLE OF lrttl_rec_type INDEX BY BINARY_INTEGER;
144
145 ---------------------------------------------------------------------------
146 -- PROGRAM UNITS
147 ---------------------------------------------------------------------------
148
149 PROCEDURE add_language;
150
151 PROCEDURE insert_row(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_lrtv_rec IN lrtv_rec_type
157 ,x_lrtv_rec OUT NOCOPY lrtv_rec_type);
158
159 PROCEDURE insert_row(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_lrtv_tbl IN lrtv_tbl_type
165 ,x_lrtv_tbl OUT NOCOPY lrtv_tbl_type);
166
167 PROCEDURE lock_row(p_api_version IN number
168 ,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
169 ,x_return_status OUT NOCOPY varchar2
170 ,x_msg_count OUT NOCOPY number
171 ,x_msg_data OUT NOCOPY varchar2
172 ,p_lrtv_rec IN lrtv_rec_type);
173
174 PROCEDURE lock_row(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_lrtv_tbl IN lrtv_tbl_type);
180
181 PROCEDURE update_row(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_lrtv_rec IN lrtv_rec_type
187 ,x_lrtv_rec OUT NOCOPY lrtv_rec_type);
188
189 PROCEDURE update_row(p_api_version IN number
190 ,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
191 ,x_return_status OUT NOCOPY varchar2
192 ,x_msg_count OUT NOCOPY number
193 ,x_msg_data OUT NOCOPY varchar2
194 ,p_lrtv_tbl IN lrtv_tbl_type
195 ,x_lrtv_tbl OUT NOCOPY lrtv_tbl_type);
196
197 PROCEDURE delete_row(p_api_version IN number
198 ,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
199 ,x_return_status OUT NOCOPY varchar2
200 ,x_msg_count OUT NOCOPY number
201 ,x_msg_data OUT NOCOPY varchar2
202 ,p_lrtv_rec IN lrtv_rec_type);
203
204 PROCEDURE delete_row(p_api_version IN number
205 ,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
206 ,x_return_status OUT NOCOPY varchar2
207 ,x_msg_count OUT NOCOPY number
208 ,x_msg_data OUT NOCOPY varchar2
209 ,p_lrtv_tbl IN lrtv_tbl_type);
210
211 PROCEDURE validate_row(p_api_version IN number
212 ,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
213 ,x_return_status OUT NOCOPY varchar2
214 ,x_msg_count OUT NOCOPY number
215 ,x_msg_data OUT NOCOPY varchar2
216 ,p_lrtv_rec IN lrtv_rec_type);
217
218 PROCEDURE validate_row(p_api_version IN number
219 ,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
220 ,x_return_status OUT NOCOPY varchar2
221 ,x_msg_count OUT NOCOPY number
222 ,x_msg_data OUT NOCOPY varchar2
223 ,p_lrtv_tbl IN lrtv_tbl_type);
224
225 END okl_lrt_pvt;