61: -- bind variable
62: -- View/Global variable from which bind value to be fetched
63: TYPE bind_rec_typ IS RECORD
64: (
65: nam m4u_view_binding.bind_variable%TYPE,
66: typ m4u_view_binding.bind_type%TYPE,
67: src_var m4u_view_binding.source_var%TYPE,
68: src_view m4u_view_binding.source_view%TYPE,
69: src_col m4u_view_binding.source_column%TYPE,
62: -- View/Global variable from which bind value to be fetched
63: TYPE bind_rec_typ IS RECORD
64: (
65: nam m4u_view_binding.bind_variable%TYPE,
66: typ m4u_view_binding.bind_type%TYPE,
67: src_var m4u_view_binding.source_var%TYPE,
68: src_view m4u_view_binding.source_view%TYPE,
69: src_col m4u_view_binding.source_column%TYPE,
70: src_lvl_id m4u_view_binding.source_level_id%TYPE
63: TYPE bind_rec_typ IS RECORD
64: (
65: nam m4u_view_binding.bind_variable%TYPE,
66: typ m4u_view_binding.bind_type%TYPE,
67: src_var m4u_view_binding.source_var%TYPE,
68: src_view m4u_view_binding.source_view%TYPE,
69: src_col m4u_view_binding.source_column%TYPE,
70: src_lvl_id m4u_view_binding.source_level_id%TYPE
71: );
64: (
65: nam m4u_view_binding.bind_variable%TYPE,
66: typ m4u_view_binding.bind_type%TYPE,
67: src_var m4u_view_binding.source_var%TYPE,
68: src_view m4u_view_binding.source_view%TYPE,
69: src_col m4u_view_binding.source_column%TYPE,
70: src_lvl_id m4u_view_binding.source_level_id%TYPE
71: );
72: -- Table of bind variable associate with each view
65: nam m4u_view_binding.bind_variable%TYPE,
66: typ m4u_view_binding.bind_type%TYPE,
67: src_var m4u_view_binding.source_var%TYPE,
68: src_view m4u_view_binding.source_view%TYPE,
69: src_col m4u_view_binding.source_column%TYPE,
70: src_lvl_id m4u_view_binding.source_level_id%TYPE
71: );
72: -- Table of bind variable associate with each view
73: TYPE bind_tab_typ IS TABLE OF bind_rec_typ INDEX BY BINARY_INTEGER;
66: typ m4u_view_binding.bind_type%TYPE,
67: src_var m4u_view_binding.source_var%TYPE,
68: src_view m4u_view_binding.source_view%TYPE,
69: src_col m4u_view_binding.source_column%TYPE,
70: src_lvl_id m4u_view_binding.source_level_id%TYPE
71: );
72: -- Table of bind variable associate with each view
73: TYPE bind_tab_typ IS TABLE OF bind_rec_typ INDEX BY BINARY_INTEGER;
74: -- Table of column names associated with each view