13: -----------------------------------------------------------------------------
14:
15: g_app_name CONSTANT varchar2(3) := okl_api.g_app_name;
16: g_api_version CONSTANT number := 1;
17: g_false CONSTANT varchar2(1) := fnd_api.g_false;
18: g_true CONSTANT varchar2(1) := fnd_api.g_true;
19: g_db_error CONSTANT varchar2(12) := 'OKL_DB_ERROR';
20: g_prog_name_token CONSTANT varchar2(9) := 'PROG_NAME';
21: g_sqlcode_token CONSTANT varchar2(7) := 'SQLCODE';
14:
15: g_app_name CONSTANT varchar2(3) := okl_api.g_app_name;
16: g_api_version CONSTANT number := 1;
17: g_false CONSTANT varchar2(1) := fnd_api.g_false;
18: g_true CONSTANT varchar2(1) := fnd_api.g_true;
19: g_db_error CONSTANT varchar2(12) := 'OKL_DB_ERROR';
20: g_prog_name_token CONSTANT varchar2(9) := 'PROG_NAME';
21: g_sqlcode_token CONSTANT varchar2(7) := 'SQLCODE';
22: g_sqlerrm_token CONSTANT varchar2(7) := 'SQLERRM';
19: g_db_error CONSTANT varchar2(12) := 'OKL_DB_ERROR';
20: g_prog_name_token CONSTANT varchar2(9) := 'PROG_NAME';
21: g_sqlcode_token CONSTANT varchar2(7) := 'SQLCODE';
22: g_sqlerrm_token CONSTANT varchar2(7) := 'SQLERRM';
23: g_ret_sts_success CONSTANT varchar2(1) := fnd_api.g_ret_sts_success;
24: g_ret_sts_unexp_error CONSTANT varchar2(1) := fnd_api.g_ret_sts_unexp_error;
25: g_ret_sts_error CONSTANT varchar2(1) := fnd_api.g_ret_sts_error;
26: g_miss_char CONSTANT varchar2(1) := fnd_api.g_miss_char;
27:
20: g_prog_name_token CONSTANT varchar2(9) := 'PROG_NAME';
21: g_sqlcode_token CONSTANT varchar2(7) := 'SQLCODE';
22: g_sqlerrm_token CONSTANT varchar2(7) := 'SQLERRM';
23: g_ret_sts_success CONSTANT varchar2(1) := fnd_api.g_ret_sts_success;
24: g_ret_sts_unexp_error CONSTANT varchar2(1) := fnd_api.g_ret_sts_unexp_error;
25: g_ret_sts_error CONSTANT varchar2(1) := fnd_api.g_ret_sts_error;
26: g_miss_char CONSTANT varchar2(1) := fnd_api.g_miss_char;
27:
28: ---------------------------------------------------------------------------
21: g_sqlcode_token CONSTANT varchar2(7) := 'SQLCODE';
22: g_sqlerrm_token CONSTANT varchar2(7) := 'SQLERRM';
23: g_ret_sts_success CONSTANT varchar2(1) := fnd_api.g_ret_sts_success;
24: g_ret_sts_unexp_error CONSTANT varchar2(1) := fnd_api.g_ret_sts_unexp_error;
25: g_ret_sts_error CONSTANT varchar2(1) := fnd_api.g_ret_sts_error;
26: g_miss_char CONSTANT varchar2(1) := fnd_api.g_miss_char;
27:
28: ---------------------------------------------------------------------------
29: -- DATA STRUCTURES
22: g_sqlerrm_token CONSTANT varchar2(7) := 'SQLERRM';
23: g_ret_sts_success CONSTANT varchar2(1) := fnd_api.g_ret_sts_success;
24: g_ret_sts_unexp_error CONSTANT varchar2(1) := fnd_api.g_ret_sts_unexp_error;
25: g_ret_sts_error CONSTANT varchar2(1) := fnd_api.g_ret_sts_error;
26: g_miss_char CONSTANT varchar2(1) := fnd_api.g_miss_char;
27:
28: ---------------------------------------------------------------------------
29: -- DATA STRUCTURES
30: ---------------------------------------------------------------------------