6: -----------------------------------------------------------------------------
7:
8: g_pkg_name CONSTANT varchar2(200) := 'OKL_LRF_GENERATE_PVT';
9: g_api_type CONSTANT varchar2(4) := '_PVT';
10: g_app_name CONSTANT varchar2(3) := okl_api.g_app_name;
11: g_api_version CONSTANT number := 1;
12: g_false CONSTANT varchar2(1) := okl_api.g_false;
13: g_true CONSTANT varchar2(1) := okl_api.g_true;
14: g_db_error CONSTANT varchar2(12) := 'OKL_DB_ERROR';
8: g_pkg_name CONSTANT varchar2(200) := 'OKL_LRF_GENERATE_PVT';
9: g_api_type CONSTANT varchar2(4) := '_PVT';
10: g_app_name CONSTANT varchar2(3) := okl_api.g_app_name;
11: g_api_version CONSTANT number := 1;
12: g_false CONSTANT varchar2(1) := okl_api.g_false;
13: g_true CONSTANT varchar2(1) := okl_api.g_true;
14: g_db_error CONSTANT varchar2(12) := 'OKL_DB_ERROR';
15: g_prog_name_token CONSTANT varchar2(9) := 'PROG_NAME';
16: g_sqlcode_token CONSTANT varchar2(7) := 'SQLCODE';
9: g_api_type CONSTANT varchar2(4) := '_PVT';
10: g_app_name CONSTANT varchar2(3) := okl_api.g_app_name;
11: g_api_version CONSTANT number := 1;
12: g_false CONSTANT varchar2(1) := okl_api.g_false;
13: g_true CONSTANT varchar2(1) := okl_api.g_true;
14: g_db_error CONSTANT varchar2(12) := 'OKL_DB_ERROR';
15: g_prog_name_token CONSTANT varchar2(9) := 'PROG_NAME';
16: g_sqlcode_token CONSTANT varchar2(7) := 'SQLCODE';
17: g_sqlerrm_token CONSTANT varchar2(7) := 'SQLERRM';
14: g_db_error CONSTANT varchar2(12) := 'OKL_DB_ERROR';
15: g_prog_name_token CONSTANT varchar2(9) := 'PROG_NAME';
16: g_sqlcode_token CONSTANT varchar2(7) := 'SQLCODE';
17: g_sqlerrm_token CONSTANT varchar2(7) := 'SQLERRM';
18: g_ret_sts_success CONSTANT varchar2(1) := okl_api.g_ret_sts_success;
19: g_ret_sts_unexp_error CONSTANT varchar2(1) := okl_api.g_ret_sts_unexp_error;
20: g_ret_sts_error CONSTANT varchar2(1) := okl_api.g_ret_sts_error;
21: g_miss_char CONSTANT varchar2(1) := okl_api.g_miss_char;
22: g_miss_num CONSTANT number := okl_api.g_miss_num;
15: g_prog_name_token CONSTANT varchar2(9) := 'PROG_NAME';
16: g_sqlcode_token CONSTANT varchar2(7) := 'SQLCODE';
17: g_sqlerrm_token CONSTANT varchar2(7) := 'SQLERRM';
18: g_ret_sts_success CONSTANT varchar2(1) := okl_api.g_ret_sts_success;
19: g_ret_sts_unexp_error CONSTANT varchar2(1) := okl_api.g_ret_sts_unexp_error;
20: g_ret_sts_error CONSTANT varchar2(1) := okl_api.g_ret_sts_error;
21: g_miss_char CONSTANT varchar2(1) := okl_api.g_miss_char;
22: g_miss_num CONSTANT number := okl_api.g_miss_num;
23: g_miss_date CONSTANT date := okl_api.g_miss_date;
16: g_sqlcode_token CONSTANT varchar2(7) := 'SQLCODE';
17: g_sqlerrm_token CONSTANT varchar2(7) := 'SQLERRM';
18: g_ret_sts_success CONSTANT varchar2(1) := okl_api.g_ret_sts_success;
19: g_ret_sts_unexp_error CONSTANT varchar2(1) := okl_api.g_ret_sts_unexp_error;
20: g_ret_sts_error CONSTANT varchar2(1) := okl_api.g_ret_sts_error;
21: g_miss_char CONSTANT varchar2(1) := okl_api.g_miss_char;
22: g_miss_num CONSTANT number := okl_api.g_miss_num;
23: g_miss_date CONSTANT date := okl_api.g_miss_date;
24: g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
17: g_sqlerrm_token CONSTANT varchar2(7) := 'SQLERRM';
18: g_ret_sts_success CONSTANT varchar2(1) := okl_api.g_ret_sts_success;
19: g_ret_sts_unexp_error CONSTANT varchar2(1) := okl_api.g_ret_sts_unexp_error;
20: g_ret_sts_error CONSTANT varchar2(1) := okl_api.g_ret_sts_error;
21: g_miss_char CONSTANT varchar2(1) := okl_api.g_miss_char;
22: g_miss_num CONSTANT number := okl_api.g_miss_num;
23: g_miss_date CONSTANT date := okl_api.g_miss_date;
24: g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
25: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
18: g_ret_sts_success CONSTANT varchar2(1) := okl_api.g_ret_sts_success;
19: g_ret_sts_unexp_error CONSTANT varchar2(1) := okl_api.g_ret_sts_unexp_error;
20: g_ret_sts_error CONSTANT varchar2(1) := okl_api.g_ret_sts_error;
21: g_miss_char CONSTANT varchar2(1) := okl_api.g_miss_char;
22: g_miss_num CONSTANT number := okl_api.g_miss_num;
23: g_miss_date CONSTANT date := okl_api.g_miss_date;
24: g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
25: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
26: g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
19: g_ret_sts_unexp_error CONSTANT varchar2(1) := okl_api.g_ret_sts_unexp_error;
20: g_ret_sts_error CONSTANT varchar2(1) := okl_api.g_ret_sts_error;
21: g_miss_char CONSTANT varchar2(1) := okl_api.g_miss_char;
22: g_miss_num CONSTANT number := okl_api.g_miss_num;
23: g_miss_date CONSTANT date := okl_api.g_miss_date;
24: g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
25: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
26: g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
27: g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
20: g_ret_sts_error CONSTANT varchar2(1) := okl_api.g_ret_sts_error;
21: g_miss_char CONSTANT varchar2(1) := okl_api.g_miss_char;
22: g_miss_num CONSTANT number := okl_api.g_miss_num;
23: g_miss_date CONSTANT date := okl_api.g_miss_date;
24: g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
25: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
26: g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
27: g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
28: g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
21: g_miss_char CONSTANT varchar2(1) := okl_api.g_miss_char;
22: g_miss_num CONSTANT number := okl_api.g_miss_num;
23: g_miss_date CONSTANT date := okl_api.g_miss_date;
24: g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
25: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
26: g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
27: g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
28: g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
29: g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
22: g_miss_num CONSTANT number := okl_api.g_miss_num;
23: g_miss_date CONSTANT date := okl_api.g_miss_date;
24: g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
25: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
26: g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
27: g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
28: g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
29: g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
30: g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
23: g_miss_date CONSTANT date := okl_api.g_miss_date;
24: g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
25: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
26: g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
27: g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
28: g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
29: g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
30: g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
31: g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
24: g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
25: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
26: g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
27: g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
28: g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
29: g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
30: g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
31: g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
32: g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
25: g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
26: g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
27: g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
28: g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
29: g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
30: g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
31: g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
32: g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
33: g_child_table_token CONSTANT varchar2(200) := okl_api.g_child_table_token;
26: g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
27: g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
28: g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
29: g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
30: g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
31: g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
32: g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
33: g_child_table_token CONSTANT varchar2(200) := okl_api.g_child_table_token;
34: g_unexpected_error CONSTANT varchar2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
27: g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
28: g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
29: g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
30: g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
31: g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
32: g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
33: g_child_table_token CONSTANT varchar2(200) := okl_api.g_child_table_token;
34: g_unexpected_error CONSTANT varchar2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
35: g_cp_mode varchar2(1) := 'N';
28: g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
29: g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
30: g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
31: g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
32: g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
33: g_child_table_token CONSTANT varchar2(200) := okl_api.g_child_table_token;
34: g_unexpected_error CONSTANT varchar2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
35: g_cp_mode varchar2(1) := 'N';
36:
29: g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
30: g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
31: g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
32: g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
33: g_child_table_token CONSTANT varchar2(200) := okl_api.g_child_table_token;
34: g_unexpected_error CONSTANT varchar2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
35: g_cp_mode varchar2(1) := 'N';
36:
37: SUBTYPE lrfv_tbl_type IS okl_lrf_pvt.lrfv_tbl_type;