DBA Data[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;