[Home] [Help]
PACKAGE: APPS.OKL_LRF_PVT
Source
1 PACKAGE okl_lrf_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSLRFS.pls 120.3 2005/07/05 12:34:50 asawanka noship $ */
3
4 -----------------------------------------------------------------------------
5 -- PACKAGE CONSTANTS
6 -----------------------------------------------------------------------------
7
8 g_pkg_name CONSTANT varchar2(200) := 'OKL_LRF_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_ENTS_V Record Spec
39
40 TYPE lrfv_rec_type IS RECORD (
41 id number,
42 object_version_number number,
43 lrt_id number,
44 term_in_months number,
45 residual_value_percent number,
46 interest_rate number,
47 lease_rate_factor number,
48 created_by number,
49 creation_date okl_ls_rt_fctr_ents_v.creation_date%TYPE,
50 last_updated_by number,
51 last_update_date okl_ls_rt_fctr_ents_v.last_update_date%TYPE,
52 last_update_login number,
53 attribute_category okl_ls_rt_fctr_ents_v.attribute_category%TYPE,
54 attribute1 okl_ls_rt_fctr_ents_v.attribute1%TYPE,
55 attribute2 okl_ls_rt_fctr_ents_v.attribute2%TYPE,
56 attribute3 okl_ls_rt_fctr_ents_v.attribute3%TYPE,
57 attribute4 okl_ls_rt_fctr_ents_v.attribute4%TYPE,
58 attribute5 okl_ls_rt_fctr_ents_v.attribute5%TYPE,
59 attribute6 okl_ls_rt_fctr_ents_v.attribute6%TYPE,
60 attribute7 okl_ls_rt_fctr_ents_v.attribute7%TYPE,
61 attribute8 okl_ls_rt_fctr_ents_v.attribute8%TYPE,
62 attribute9 okl_ls_rt_fctr_ents_v.attribute9%TYPE,
63 attribute10 okl_ls_rt_fctr_ents_v.attribute10%TYPE,
64 attribute11 okl_ls_rt_fctr_ents_v.attribute11%TYPE,
65 attribute12 okl_ls_rt_fctr_ents_v.attribute12%TYPE,
66 attribute13 okl_ls_rt_fctr_ents_v.attribute13%TYPE,
67 attribute14 okl_ls_rt_fctr_ents_v.attribute14%TYPE,
68 attribute15 okl_ls_rt_fctr_ents_v.attribute15%TYPE,
69 is_new_flag varchar2(3),
70 rate_set_version_id number
71 );
72 g_miss_lrfv_rec lrfv_rec_type;
73
74 TYPE lrfv_tbl_type IS TABLE OF lrfv_rec_type INDEX BY BINARY_INTEGER;
75
76 -- OKL_LS_RT_FCTR_ENTS Record Spec
77
78 TYPE lrf_rec_type IS RECORD (
79 id number,
80 object_version_number number,
81 lrt_id number,
82 term_in_months number,
83 residual_value_percent number,
84 interest_rate number,
85 lease_rate_factor number,
86 created_by number,
87 creation_date okl_ls_rt_fctr_ents.creation_date%TYPE,
88 last_updated_by number,
89 last_update_date okl_ls_rt_fctr_ents.last_update_date%TYPE,
90 last_update_login number,
91 attribute_category okl_ls_rt_fctr_ents.attribute_category%TYPE,
92 attribute1 okl_ls_rt_fctr_ents.attribute1%TYPE,
93 attribute2 okl_ls_rt_fctr_ents.attribute2%TYPE,
94 attribute3 okl_ls_rt_fctr_ents.attribute3%TYPE,
95 attribute4 okl_ls_rt_fctr_ents.attribute4%TYPE,
96 attribute5 okl_ls_rt_fctr_ents.attribute5%TYPE,
97 attribute6 okl_ls_rt_fctr_ents.attribute6%TYPE,
98 attribute7 okl_ls_rt_fctr_ents.attribute7%TYPE,
99 attribute8 okl_ls_rt_fctr_ents.attribute8%TYPE,
100 attribute9 okl_ls_rt_fctr_ents.attribute9%TYPE,
101 attribute10 okl_ls_rt_fctr_ents.attribute10%TYPE,
102 attribute11 okl_ls_rt_fctr_ents.attribute11%TYPE,
103 attribute12 okl_ls_rt_fctr_ents.attribute12%TYPE,
104 attribute13 okl_ls_rt_fctr_ents.attribute13%TYPE,
105 attribute14 okl_ls_rt_fctr_ents.attribute14%TYPE,
106 attribute15 okl_ls_rt_fctr_ents.attribute15%TYPE,
107 is_new_flag varchar2(3),
108 rate_set_version_id number
109 );
110 g_miss_lrf_rec lrf_rec_type;
111
112 TYPE lrf_tbl_type IS TABLE OF lrf_rec_type INDEX BY BINARY_INTEGER;
113
114 ---------------------------------------------------------------------------
115 -- PROGRAM UNITS
116 ---------------------------------------------------------------------------
117
118 PROCEDURE insert_row(p_api_version IN number
119 ,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
120 ,x_return_status OUT NOCOPY varchar2
121 ,x_msg_count OUT NOCOPY number
122 ,x_msg_data OUT NOCOPY varchar2
123 ,p_lrfv_rec IN lrfv_rec_type
124 ,x_lrfv_rec OUT NOCOPY lrfv_rec_type);
125
126 PROCEDURE insert_row(p_api_version IN number
127 ,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
128 ,x_return_status OUT NOCOPY varchar2
129 ,x_msg_count OUT NOCOPY number
130 ,x_msg_data OUT NOCOPY varchar2
131 ,p_lrfv_tbl IN lrfv_tbl_type
132 ,x_lrfv_tbl OUT NOCOPY lrfv_tbl_type);
133
134 PROCEDURE lock_row(p_api_version IN number
135 ,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
136 ,x_return_status OUT NOCOPY varchar2
137 ,x_msg_count OUT NOCOPY number
138 ,x_msg_data OUT NOCOPY varchar2
139 ,p_lrfv_rec IN lrfv_rec_type);
140
141 PROCEDURE lock_row(p_api_version IN number
142 ,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
143 ,x_return_status OUT NOCOPY varchar2
144 ,x_msg_count OUT NOCOPY number
145 ,x_msg_data OUT NOCOPY varchar2
146 ,p_lrfv_tbl IN lrfv_tbl_type);
147
148 PROCEDURE update_row(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_lrfv_rec IN lrfv_rec_type
154 ,x_lrfv_rec OUT NOCOPY lrfv_rec_type);
155
156 PROCEDURE update_row(p_api_version IN number
157 ,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
158 ,x_return_status OUT NOCOPY varchar2
159 ,x_msg_count OUT NOCOPY number
160 ,x_msg_data OUT NOCOPY varchar2
161 ,p_lrfv_tbl IN lrfv_tbl_type
162 ,x_lrfv_tbl OUT NOCOPY lrfv_tbl_type);
163
164 PROCEDURE delete_row(p_api_version IN number
165 ,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
166 ,x_return_status OUT NOCOPY varchar2
167 ,x_msg_count OUT NOCOPY number
168 ,x_msg_data OUT NOCOPY varchar2
169 ,p_lrfv_rec IN lrfv_rec_type);
170
171 PROCEDURE delete_row(p_api_version IN number
172 ,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
173 ,x_return_status OUT NOCOPY varchar2
174 ,x_msg_count OUT NOCOPY number
175 ,x_msg_data OUT NOCOPY varchar2
176 ,p_lrfv_tbl IN lrfv_tbl_type);
177
178 PROCEDURE validate_row(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_lrfv_rec IN lrfv_rec_type);
184
185 PROCEDURE validate_row(p_api_version IN number
186 ,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
187 ,x_return_status OUT NOCOPY varchar2
188 ,x_msg_count OUT NOCOPY number
189 ,x_msg_data OUT NOCOPY varchar2
190 ,p_lrfv_tbl IN lrfv_tbl_type);
191
192 END okl_lrf_pvt;