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