eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.M4U_XML_EXTN_UTILS dependencies on M4U_ELEMENT_MAPPINGS

Line 42: id m4u_element_mappings.node_id%TYPE,

38: -- Corresponds to rows from m4u_element_mapping table
39: -- node identified, type, hierachy, mapping information
40: TYPE elmnt_rec_typ IS RECORD
41: (
42: id m4u_element_mappings.node_id%TYPE,
43: seq m4u_element_mappings.node_sequence%TYPE,
44: name m4u_element_mappings.node_name%TYPE,
45: type m4u_element_mappings.node_type%TYPE,
46: lvl_id m4u_element_mappings.level_id%TYPE,

Line 43: seq m4u_element_mappings.node_sequence%TYPE,

39: -- node identified, type, hierachy, mapping information
40: TYPE elmnt_rec_typ IS RECORD
41: (
42: id m4u_element_mappings.node_id%TYPE,
43: seq m4u_element_mappings.node_sequence%TYPE,
44: name m4u_element_mappings.node_name%TYPE,
45: type m4u_element_mappings.node_type%TYPE,
46: lvl_id m4u_element_mappings.level_id%TYPE,
47: parent_id m4u_element_mappings.parent_node_id%TYPE,

Line 44: name m4u_element_mappings.node_name%TYPE,

40: TYPE elmnt_rec_typ IS RECORD
41: (
42: id m4u_element_mappings.node_id%TYPE,
43: seq m4u_element_mappings.node_sequence%TYPE,
44: name m4u_element_mappings.node_name%TYPE,
45: type m4u_element_mappings.node_type%TYPE,
46: lvl_id m4u_element_mappings.level_id%TYPE,
47: parent_id m4u_element_mappings.parent_node_id%TYPE,
48: map_typ m4u_element_mappings.mapping_type%TYPE,

Line 45: type m4u_element_mappings.node_type%TYPE,

41: (
42: id m4u_element_mappings.node_id%TYPE,
43: seq m4u_element_mappings.node_sequence%TYPE,
44: name m4u_element_mappings.node_name%TYPE,
45: type m4u_element_mappings.node_type%TYPE,
46: lvl_id m4u_element_mappings.level_id%TYPE,
47: parent_id m4u_element_mappings.parent_node_id%TYPE,
48: map_typ m4u_element_mappings.mapping_type%TYPE,
49: view_nam m4u_element_mappings.view_name%TYPE,

Line 46: lvl_id m4u_element_mappings.level_id%TYPE,

42: id m4u_element_mappings.node_id%TYPE,
43: seq m4u_element_mappings.node_sequence%TYPE,
44: name m4u_element_mappings.node_name%TYPE,
45: type m4u_element_mappings.node_type%TYPE,
46: lvl_id m4u_element_mappings.level_id%TYPE,
47: parent_id m4u_element_mappings.parent_node_id%TYPE,
48: map_typ m4u_element_mappings.mapping_type%TYPE,
49: view_nam m4u_element_mappings.view_name%TYPE,
50: col m4u_element_mappings.column_name%TYPE,

Line 47: parent_id m4u_element_mappings.parent_node_id%TYPE,

43: seq m4u_element_mappings.node_sequence%TYPE,
44: name m4u_element_mappings.node_name%TYPE,
45: type m4u_element_mappings.node_type%TYPE,
46: lvl_id m4u_element_mappings.level_id%TYPE,
47: parent_id m4u_element_mappings.parent_node_id%TYPE,
48: map_typ m4u_element_mappings.mapping_type%TYPE,
49: view_nam m4u_element_mappings.view_name%TYPE,
50: col m4u_element_mappings.column_name%TYPE,
51: view_lvl m4u_element_mappings.view_level_id%TYPE,

Line 48: map_typ m4u_element_mappings.mapping_type%TYPE,

44: name m4u_element_mappings.node_name%TYPE,
45: type m4u_element_mappings.node_type%TYPE,
46: lvl_id m4u_element_mappings.level_id%TYPE,
47: parent_id m4u_element_mappings.parent_node_id%TYPE,
48: map_typ m4u_element_mappings.mapping_type%TYPE,
49: view_nam m4u_element_mappings.view_name%TYPE,
50: col m4u_element_mappings.column_name%TYPE,
51: view_lvl m4u_element_mappings.view_level_id%TYPE,
52: var m4u_element_mappings.variable_name%TYPE,

Line 49: view_nam m4u_element_mappings.view_name%TYPE,

45: type m4u_element_mappings.node_type%TYPE,
46: lvl_id m4u_element_mappings.level_id%TYPE,
47: parent_id m4u_element_mappings.parent_node_id%TYPE,
48: map_typ m4u_element_mappings.mapping_type%TYPE,
49: view_nam m4u_element_mappings.view_name%TYPE,
50: col m4u_element_mappings.column_name%TYPE,
51: view_lvl m4u_element_mappings.view_level_id%TYPE,
52: var m4u_element_mappings.variable_name%TYPE,
53: const m4u_element_mappings.constant_val%TYPE

Line 50: col m4u_element_mappings.column_name%TYPE,

46: lvl_id m4u_element_mappings.level_id%TYPE,
47: parent_id m4u_element_mappings.parent_node_id%TYPE,
48: map_typ m4u_element_mappings.mapping_type%TYPE,
49: view_nam m4u_element_mappings.view_name%TYPE,
50: col m4u_element_mappings.column_name%TYPE,
51: view_lvl m4u_element_mappings.view_level_id%TYPE,
52: var m4u_element_mappings.variable_name%TYPE,
53: const m4u_element_mappings.constant_val%TYPE
54: );

Line 51: view_lvl m4u_element_mappings.view_level_id%TYPE,

47: parent_id m4u_element_mappings.parent_node_id%TYPE,
48: map_typ m4u_element_mappings.mapping_type%TYPE,
49: view_nam m4u_element_mappings.view_name%TYPE,
50: col m4u_element_mappings.column_name%TYPE,
51: view_lvl m4u_element_mappings.view_level_id%TYPE,
52: var m4u_element_mappings.variable_name%TYPE,
53: const m4u_element_mappings.constant_val%TYPE
54: );
55: -- Element for below table need to be processed in sequnce for generating XML

Line 52: var m4u_element_mappings.variable_name%TYPE,

48: map_typ m4u_element_mappings.mapping_type%TYPE,
49: view_nam m4u_element_mappings.view_name%TYPE,
50: col m4u_element_mappings.column_name%TYPE,
51: view_lvl m4u_element_mappings.view_level_id%TYPE,
52: var m4u_element_mappings.variable_name%TYPE,
53: const m4u_element_mappings.constant_val%TYPE
54: );
55: -- Element for below table need to be processed in sequnce for generating XML
56: TYPE g_elmnt_map_typ IS TABLE OF elmnt_rec_typ INDEX BY BINARY_INTEGER;

Line 53: const m4u_element_mappings.constant_val%TYPE

49: view_nam m4u_element_mappings.view_name%TYPE,
50: col m4u_element_mappings.column_name%TYPE,
51: view_lvl m4u_element_mappings.view_level_id%TYPE,
52: var m4u_element_mappings.variable_name%TYPE,
53: const m4u_element_mappings.constant_val%TYPE
54: );
55: -- Element for below table need to be processed in sequnce for generating XML
56: TYPE g_elmnt_map_typ IS TABLE OF elmnt_rec_typ INDEX BY BINARY_INTEGER;
57: g_elmnt_map g_elmnt_map_typ;

Line 82: view_nam m4u_element_mappings.view_name%TYPE,

78: -- View name, column listing, where clause, bind variable listing
79: -- number of rows fetched for the view
80: TYPE view_rec_typ IS RECORD
81: (
82: view_nam m4u_element_mappings.view_name%TYPE,
83: whr_claus VARCHAR2(4000),
84: bind_tab bind_tab_typ,
85: bind_count NUMBER,
86: exec_sql VARCHAR2(4000),