[Home] [Help]
PACKAGE: APPS.OKL_LRV_PVT
Source
1 PACKAGE okl_lrv_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSLRVS.pls 120.1 2005/09/30 11:01:15 asawanka noship $ */
3
4 --------------------------------------------------------------------------------
5 --GLOBAL DATASTRUCTURES
6 --------------------------------------------------------------------------------
7
8 TYPE okl_lrvv_rec IS RECORD (
9 rate_set_version_id number,
10 object_version_number number,
11 arrears_yn okl_fe_rate_set_versions_v.arrears_yn%TYPE,
12 effective_from_date okl_fe_rate_set_versions_v.effective_from_date%TYPE,
13 effective_to_date okl_fe_rate_set_versions_v.effective_to_date%TYPE,
14 rate_set_id number,
15 end_of_term_ver_id number,
16 std_rate_tmpl_ver_id number,
17 adj_mat_version_id number,
18 version_number okl_fe_rate_set_versions_v.version_number%TYPE,
19 lrs_rate number,
20 rate_tolerance number,
21 residual_tolerance number,
22 deferred_pmts number,
23 advance_pmts number,
24 sts_code okl_fe_rate_set_versions_v.sts_code%TYPE,
25 created_by number,
26 creation_date okl_fe_rate_set_versions_v.creation_date%TYPE,
27 last_updated_by number,
28 last_update_date okl_fe_rate_set_versions_v.last_update_date%TYPE,
29 last_update_login number,
30 attribute_category okl_fe_rate_set_versions_v.attribute_category%TYPE,
31 attribute1 okl_fe_rate_set_versions_v.attribute1%TYPE,
32 attribute2 okl_fe_rate_set_versions_v.attribute2%TYPE,
33 attribute3 okl_fe_rate_set_versions_v.attribute3%TYPE,
34 attribute4 okl_fe_rate_set_versions_v.attribute4%TYPE,
35 attribute5 okl_fe_rate_set_versions_v.attribute5%TYPE,
36 attribute6 okl_fe_rate_set_versions_v.attribute6%TYPE,
37 attribute7 okl_fe_rate_set_versions_v.attribute7%TYPE,
38 attribute8 okl_fe_rate_set_versions_v.attribute8%TYPE,
39 attribute9 okl_fe_rate_set_versions_v.attribute9%TYPE,
40 attribute10 okl_fe_rate_set_versions_v.attribute10%TYPE,
41 attribute11 okl_fe_rate_set_versions_v.attribute11%TYPE,
42 attribute12 okl_fe_rate_set_versions_v.attribute12%TYPE,
43 attribute13 okl_fe_rate_set_versions_v.attribute13%TYPE,
44 attribute14 okl_fe_rate_set_versions_v.attribute14%TYPE,
45 attribute15 okl_fe_rate_set_versions_v.attribute15%TYPE,
46 standard_rate okl_fe_rate_set_versions_v.standard_rate%TYPE
47 );
48
49 TYPE okl_lrvv_tbl IS TABLE OF okl_lrvv_rec INDEX BY BINARY_INTEGER;
50
51 TYPE okl_lrv_rec IS RECORD (
52 rate_set_version_id number,
53 object_version_number number,
54 arrears_yn okl_fe_rate_set_versions.arrears_yn%TYPE,
55 effective_from_date okl_fe_rate_set_versions.effective_from_date%TYPE,
56 effective_to_date okl_fe_rate_set_versions.effective_to_date%TYPE,
57 rate_set_id number,
58 end_of_term_ver_id number,
59 std_rate_tmpl_ver_id number,
60 adj_mat_version_id number,
61 version_number okl_fe_rate_set_versions.version_number%TYPE,
62 lrs_rate number,
63 rate_tolerance number,
64 residual_tolerance number,
65 deferred_pmts number,
66 advance_pmts number,
67 sts_code okl_fe_rate_set_versions.sts_code%TYPE,
68 created_by number,
69 creation_date okl_fe_rate_set_versions.creation_date%TYPE,
70 last_updated_by number,
71 last_update_date okl_fe_rate_set_versions.last_update_date%TYPE,
72 last_update_login number,
76 attribute3 okl_fe_rate_set_versions.attribute3%TYPE,
73 attribute_category okl_fe_rate_set_versions.attribute_category%TYPE,
74 attribute1 okl_fe_rate_set_versions.attribute1%TYPE,
75 attribute2 okl_fe_rate_set_versions.attribute2%TYPE,
77 attribute4 okl_fe_rate_set_versions.attribute4%TYPE,
78 attribute5 okl_fe_rate_set_versions.attribute5%TYPE,
79 attribute6 okl_fe_rate_set_versions.attribute6%TYPE,
80 attribute7 okl_fe_rate_set_versions.attribute7%TYPE,
81 attribute8 okl_fe_rate_set_versions.attribute8%TYPE,
82 attribute9 okl_fe_rate_set_versions.attribute9%TYPE,
83 attribute10 okl_fe_rate_set_versions.attribute10%TYPE,
84 attribute11 okl_fe_rate_set_versions.attribute11%TYPE,
85 attribute12 okl_fe_rate_set_versions.attribute12%TYPE,
86 attribute13 okl_fe_rate_set_versions.attribute13%TYPE,
87 attribute14 okl_fe_rate_set_versions.attribute14%TYPE,
88 attribute15 okl_fe_rate_set_versions.attribute15%TYPE,
89 standard_rate okl_fe_rate_set_versions.standard_rate%TYPE
90 );
91
92 TYPE okl_lrv_tbl IS TABLE OF okl_lrv_rec INDEX BY BINARY_INTEGER;
93
94 --------------------------------------------------------------------------------
95 -- GLOBAL MESSAGE CONSTANTS
96 --------------------------------------------------------------------------------
97
98 g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
99 g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
100 g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
101 g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
102 g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
103 g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
104 g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
105 g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
106 g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
107 g_child_table_token CONSTANT varchar2(200) := okl_api.g_child_table_token;
108
109 --------------------------------------------------------------------------------
110 -- GLOBAL VARIABLES
111 --------------------------------------------------------------------------------
112
113 g_pkg_name CONSTANT varchar2(200) := 'OKL_LRV_PVT';
114 g_app_name CONSTANT varchar2(3) := okl_api.g_app_name;
115
116 --------------------------------------------------------------------------------
117 -- Procedures and Functions
118 --------------------------------------------------------------------------------
119
120 PROCEDURE change_version;
121
122 PROCEDURE api_copy;
123
124 PROCEDURE insert_row(p_api_version IN number
125 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
126 ,x_return_status OUT NOCOPY varchar2
127 ,x_msg_count OUT NOCOPY number
128 ,x_msg_data OUT NOCOPY varchar2
129 ,p_lrvv_rec IN okl_lrvv_rec
130 ,x_lrvv_rec OUT NOCOPY okl_lrvv_rec);
131
132 PROCEDURE insert_row(p_api_version IN number
133 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
134 ,x_return_status OUT NOCOPY varchar2
135 ,x_msg_count OUT NOCOPY number
136 ,x_msg_data OUT NOCOPY varchar2
137 ,p_lrvv_tbl IN okl_lrvv_tbl
138 ,x_lrvv_tbl OUT NOCOPY okl_lrvv_tbl);
139
140 PROCEDURE update_row(p_api_version IN number
141 ,p_init_msg_list IN varchar2 DEFAULT okl_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_lrvv_rec IN okl_lrvv_rec
146 ,x_lrvv_rec OUT NOCOPY okl_lrvv_rec);
147
148 PROCEDURE update_row(p_api_version IN number
149 ,p_init_msg_list IN varchar2 DEFAULT okl_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_lrvv_tbl IN okl_lrvv_tbl
154 ,x_lrvv_tbl OUT NOCOPY okl_lrvv_tbl);
155
156 PROCEDURE delete_row(p_api_version IN number
157 ,p_init_msg_list IN varchar2 DEFAULT okl_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_lrvv_rec IN okl_lrvv_rec);
162
163 PROCEDURE delete_row(p_api_version IN number
164 ,p_init_msg_list IN varchar2 DEFAULT okl_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_lrvv_tbl IN okl_lrvv_tbl);
169
170 END okl_lrv_pvt;