[Home] [Help]
PACKAGE: APPS.OKL_LRL_PVT
Source
1 PACKAGE okl_lrl_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSLRLS.pls 120.1 2005/10/30 04:59:27 appldev noship $ */
3
4 --------------------------------------------------------------------------------
5 --GLOBAL DATASTRUCTURES
6 --------------------------------------------------------------------------------
7
8 TYPE okl_lrlv_rec IS RECORD (
9 rate_set_level_id number,
10 object_version_number number,
11 residual_percent number,
12 rate_set_id number,
13 rate_set_version_id number,
14 rate_set_factor_id number,
15 sequence_number number,
16 periods number,
17 lease_rate_factor number,
18 created_by number,
19 creation_date okl_fe_rate_set_levels_v.creation_date%TYPE,
20 last_updated_by number,
21 last_update_date okl_fe_rate_set_levels_v.last_update_date%TYPE,
22 last_update_login number,
23 attribute_category okl_fe_rate_set_levels_v.attribute_category%TYPE,
24 attribute1 okl_fe_rate_set_levels_v.attribute1%TYPE,
25 attribute2 okl_fe_rate_set_levels_v.attribute2%TYPE,
26 attribute3 okl_fe_rate_set_levels_v.attribute3%TYPE,
27 attribute4 okl_fe_rate_set_levels_v.attribute4%TYPE,
28 attribute5 okl_fe_rate_set_levels_v.attribute5%TYPE,
29 attribute6 okl_fe_rate_set_levels_v.attribute6%TYPE,
30 attribute7 okl_fe_rate_set_levels_v.attribute7%TYPE,
31 attribute8 okl_fe_rate_set_levels_v.attribute8%TYPE,
32 attribute9 okl_fe_rate_set_levels_v.attribute9%TYPE,
33 attribute10 okl_fe_rate_set_levels_v.attribute10%TYPE,
34 attribute11 okl_fe_rate_set_levels_v.attribute11%TYPE,
35 attribute12 okl_fe_rate_set_levels_v.attribute12%TYPE,
36 attribute13 okl_fe_rate_set_levels_v.attribute13%TYPE,
37 attribute14 okl_fe_rate_set_levels_v.attribute14%TYPE,
38 attribute15 okl_fe_rate_set_levels_v.attribute15%TYPE
39 );
40
41 TYPE okl_lrlv_tbl IS TABLE OF okl_lrlv_rec INDEX BY BINARY_INTEGER;
42
43 TYPE okl_lrl_rec IS RECORD (
44 rate_set_level_id number,
45 object_version_number number,
46 residual_percent number,
47 rate_set_id number,
48 rate_set_version_id number,
49 rate_set_factor_id number,
50 sequence_number number,
51 periods number,
52 lease_rate_factor number,
53 created_by number,
54 creation_date okl_fe_rate_set_levels.creation_date%TYPE,
55 last_updated_by number,
56 last_update_date okl_fe_rate_set_levels.last_update_date%TYPE,
57 last_update_login number,
58 attribute_category okl_fe_rate_set_levels.attribute_category%TYPE,
59 attribute1 okl_fe_rate_set_levels.attribute1%TYPE,
60 attribute2 okl_fe_rate_set_levels.attribute2%TYPE,
61 attribute3 okl_fe_rate_set_levels.attribute3%TYPE,
62 attribute4 okl_fe_rate_set_levels.attribute4%TYPE,
63 attribute5 okl_fe_rate_set_levels.attribute5%TYPE,
64 attribute6 okl_fe_rate_set_levels.attribute6%TYPE,
65 attribute7 okl_fe_rate_set_levels.attribute7%TYPE,
66 attribute8 okl_fe_rate_set_levels.attribute8%TYPE,
67 attribute9 okl_fe_rate_set_levels.attribute9%TYPE,
68 attribute10 okl_fe_rate_set_levels.attribute10%TYPE,
69 attribute11 okl_fe_rate_set_levels.attribute11%TYPE,
70 attribute12 okl_fe_rate_set_levels.attribute12%TYPE,
71 attribute13 okl_fe_rate_set_levels.attribute13%TYPE,
72 attribute14 okl_fe_rate_set_levels.attribute14%TYPE,
73 attribute15 okl_fe_rate_set_levels.attribute15%TYPE
74 );
75
76 TYPE okl_lrl_tbl IS TABLE OF okl_lrl_rec INDEX BY BINARY_INTEGER;
77
78 --------------------------------------------------------------------------------
79 -- GLOBAL MESSAGE CONSTANTS
80 --------------------------------------------------------------------------------
81
82 g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
83 g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
84 g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
85 g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
86 g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
87 g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
88 g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
89 g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
90 g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
91 g_child_table_token CONSTANT varchar2(200) := okl_api.g_child_table_token;
92 g_pkg_name CONSTANT varchar2(200) := 'OKL_LRL_PVT';
93 g_app_name CONSTANT varchar2(3) := okl_api.g_app_name;
94
95 --------------------------------------------------------------------------------
96 -- Procedures and Functions
97 --------------------------------------------------------------------------------
98
99 PROCEDURE change_version;
100
101 PROCEDURE api_copy;
102
103 PROCEDURE insert_row(p_api_version IN number
104 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
105 ,x_return_status OUT NOCOPY varchar2
106 ,x_msg_count OUT NOCOPY number
107 ,x_msg_data OUT NOCOPY varchar2
108 ,p_lrlv_rec IN okl_lrlv_rec
109 ,x_lrlv_rec OUT NOCOPY okl_lrlv_rec);
110
111 PROCEDURE insert_row(p_api_version IN number
112 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
113 ,x_return_status OUT NOCOPY varchar2
114 ,x_msg_count OUT NOCOPY number
115 ,x_msg_data OUT NOCOPY varchar2
116 ,p_lrlv_tbl IN okl_lrlv_tbl
117 ,x_lrlv_tbl OUT NOCOPY okl_lrlv_tbl);
118
119 PROCEDURE update_row(p_api_version IN number
120 ,p_init_msg_list IN varchar2 DEFAULT okl_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_lrlv_rec IN okl_lrlv_rec
125 ,x_lrlv_rec OUT NOCOPY okl_lrlv_rec);
126
127 PROCEDURE update_row(p_api_version IN number
128 ,p_init_msg_list IN varchar2 DEFAULT okl_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_lrlv_tbl IN okl_lrlv_tbl
133 ,x_lrlv_tbl OUT NOCOPY okl_lrlv_tbl);
134
135 PROCEDURE delete_row(p_api_version IN number
136 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
137 ,x_return_status OUT NOCOPY varchar2
138 ,x_msg_count OUT NOCOPY number
139 ,x_msg_data OUT NOCOPY varchar2
140 ,p_lrlv_rec IN okl_lrlv_rec);
141
142 PROCEDURE delete_row(p_api_version IN number
143 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
144 ,x_return_status OUT NOCOPY varchar2
145 ,x_msg_count OUT NOCOPY number
146 ,x_msg_data OUT NOCOPY varchar2
147 ,p_lrlv_tbl IN okl_lrlv_tbl);
148
149 END okl_lrl_pvt;