25: -- Private Constants
26: G_MAX_PACKAGE_LINE_LENGTH CONSTANT INTEGER := 255;
27: G_CHR_QUOTE CONSTANT VARCHAR2(9) :='''';
28: G_CHR_SPACE CONSTANT VARCHAR2(9) :=' ';
29: G_CHR_NEWLINE CONSTANT VARCHAR2(10) := xla_environment_pkg.g_chr_newline;
30:
31:
32: --
33: -- Private exceptions
46:
47: --
48: -- Global variables
49: --
50: g_user_id INTEGER := xla_environment_pkg.g_usr_id;
51: g_login_id INTEGER := xla_environment_pkg.g_login_id;
52: g_date DATE := SYSDATE;
53: g_prog_appl_id INTEGER := xla_environment_pkg.g_prog_appl_id;
54: g_prog_id INTEGER := xla_environment_pkg.g_prog_id;
47: --
48: -- Global variables
49: --
50: g_user_id INTEGER := xla_environment_pkg.g_usr_id;
51: g_login_id INTEGER := xla_environment_pkg.g_login_id;
52: g_date DATE := SYSDATE;
53: g_prog_appl_id INTEGER := xla_environment_pkg.g_prog_appl_id;
54: g_prog_id INTEGER := xla_environment_pkg.g_prog_id;
55: g_req_id INTEGER := NVL(xla_environment_pkg.g_req_id, -1);
49: --
50: g_user_id INTEGER := xla_environment_pkg.g_usr_id;
51: g_login_id INTEGER := xla_environment_pkg.g_login_id;
52: g_date DATE := SYSDATE;
53: g_prog_appl_id INTEGER := xla_environment_pkg.g_prog_appl_id;
54: g_prog_id INTEGER := xla_environment_pkg.g_prog_id;
55: g_req_id INTEGER := NVL(xla_environment_pkg.g_req_id, -1);
56:
57: --
50: g_user_id INTEGER := xla_environment_pkg.g_usr_id;
51: g_login_id INTEGER := xla_environment_pkg.g_login_id;
52: g_date DATE := SYSDATE;
53: g_prog_appl_id INTEGER := xla_environment_pkg.g_prog_appl_id;
54: g_prog_id INTEGER := xla_environment_pkg.g_prog_id;
55: g_req_id INTEGER := NVL(xla_environment_pkg.g_req_id, -1);
56:
57: --
58:
51: g_login_id INTEGER := xla_environment_pkg.g_login_id;
52: g_date DATE := SYSDATE;
53: g_prog_appl_id INTEGER := xla_environment_pkg.g_prog_appl_id;
54: g_prog_id INTEGER := xla_environment_pkg.g_prog_id;
55: g_req_id INTEGER := NVL(xla_environment_pkg.g_req_id, -1);
56:
57: --
58:
59: -- Cursor declarations