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;
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;
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;
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;
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;
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;
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:
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: --------------------------------------------------------------------------------
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
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: --------------------------------------------------------------------------------
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: --------------------------------------------------------------------------------
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
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
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
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
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);
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);