32:
33: --
34: -- Global variables
35: --
36: g_user_id INTEGER := xla_environment_pkg.g_usr_id;
37: g_login_id INTEGER := xla_environment_pkg.g_login_id;
38: g_date DATE := SYSDATE;
39: g_prog_appl_id INTEGER := xla_environment_pkg.g_prog_appl_id;
40: g_prog_id INTEGER := xla_environment_pkg.g_prog_id;
33: --
34: -- Global variables
35: --
36: g_user_id INTEGER := xla_environment_pkg.g_usr_id;
37: g_login_id INTEGER := xla_environment_pkg.g_login_id;
38: g_date DATE := SYSDATE;
39: g_prog_appl_id INTEGER := xla_environment_pkg.g_prog_appl_id;
40: g_prog_id INTEGER := xla_environment_pkg.g_prog_id;
41: g_req_id INTEGER := NVL(xla_environment_pkg.g_req_id, -1);
35: --
36: g_user_id INTEGER := xla_environment_pkg.g_usr_id;
37: g_login_id INTEGER := xla_environment_pkg.g_login_id;
38: g_date DATE := SYSDATE;
39: g_prog_appl_id INTEGER := xla_environment_pkg.g_prog_appl_id;
40: g_prog_id INTEGER := xla_environment_pkg.g_prog_id;
41: g_req_id INTEGER := NVL(xla_environment_pkg.g_req_id, -1);
42:
43: --
36: g_user_id INTEGER := xla_environment_pkg.g_usr_id;
37: g_login_id INTEGER := xla_environment_pkg.g_login_id;
38: g_date DATE := SYSDATE;
39: g_prog_appl_id INTEGER := xla_environment_pkg.g_prog_appl_id;
40: g_prog_id INTEGER := xla_environment_pkg.g_prog_id;
41: g_req_id INTEGER := NVL(xla_environment_pkg.g_req_id, -1);
42:
43: --
44:
37: g_login_id INTEGER := xla_environment_pkg.g_login_id;
38: g_date DATE := SYSDATE;
39: g_prog_appl_id INTEGER := xla_environment_pkg.g_prog_appl_id;
40: g_prog_id INTEGER := xla_environment_pkg.g_prog_id;
41: g_req_id INTEGER := NVL(xla_environment_pkg.g_req_id, -1);
42:
43: --
44:
45: -- Cursor declarations