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.CZ_MODEL_UTIL_PVT dependencies on CZ_MODEL_NODE_TBL_TYPE

Line 109: RETURN system.cz_model_node_tbl_type

105: --------------------------------------------------------------------------------
106: FUNCTION find_nodes_by_path(p_model_to_search IN NUMBER
107: ,p_namepath IN system.cz_varchar2_2000_tbl_type
108: )
109: RETURN system.cz_model_node_tbl_type
110: IS
111: nodelist system.cz_model_node_tbl_type;
112: BEGIN
113:

Line 111: nodelist system.cz_model_node_tbl_type;

107: ,p_namepath IN system.cz_varchar2_2000_tbl_type
108: )
109: RETURN system.cz_model_node_tbl_type
110: IS
111: nodelist system.cz_model_node_tbl_type;
112: BEGIN
113:
114: nodelist := find_unique_node_by_path (
115: p_model_to_search,

Line 129: RETURN "SYSTEM".cz_model_node_tbl_type

125: FUNCTION find_unique_node_by_path(p_model_to_search IN NUMBER
126: ,p_namepath IN system.cz_varchar2_2000_tbl_type
127: ,p_path_preference IN NUMBER
128: )
129: RETURN "SYSTEM".cz_model_node_tbl_type
130: /*
131: * Revision 2006-02-21 by ADW for ambiguous reference bug 4760372
132: * 1. moved marklist variables into main structure CZ_MODEL_NODE_OBJ_TYPE
133: * 2. removed marklist handling from routine

Line 148: retlist "SYSTEM".cz_model_node_tbl_type := "SYSTEM".cz_model_node_tbl_type();

144: * c. implement preference for 'root' paths
145: */
146:
147: IS
148: retlist "SYSTEM".cz_model_node_tbl_type := "SYSTEM".cz_model_node_tbl_type();
149: lastfound "SYSTEM".cz_model_node_tbl_type;
150:
151: /* ADW20040730:3a
152: * Set up a parallel structure to mark which entries are paths from root

Line 149: lastfound "SYSTEM".cz_model_node_tbl_type;

145: */
146:
147: IS
148: retlist "SYSTEM".cz_model_node_tbl_type := "SYSTEM".cz_model_node_tbl_type();
149: lastfound "SYSTEM".cz_model_node_tbl_type;
150:
151: /* ADW20040730:3a
152: * Set up a parallel structure to mark which entries are paths from root
153: * why overload the object types:1 1. need to do a table (cast), so an internal

Line 158: -- marklist "SYSTEM".cz_model_node_tbl_type := "SYSTEM".cz_model_node_tbl_type ();

154: * record type won't work; must be an object type; 2. do not want to create a
155: * new object type and table type in SYSTEM; 3. the structure is already almost
156: * exactly what is needed
157: */
158: -- marklist "SYSTEM".cz_model_node_tbl_type := "SYSTEM".cz_model_node_tbl_type ();
159: -- lastmarks "SYSTEM".cz_model_node_tbl_type;
160: root_closest_path_index number; -- 20040730:3b
161: root_closest_path_marker number;
162:

Line 159: -- lastmarks "SYSTEM".cz_model_node_tbl_type;

155: * new object type and table type in SYSTEM; 3. the structure is already almost
156: * exactly what is needed
157: */
158: -- marklist "SYSTEM".cz_model_node_tbl_type := "SYSTEM".cz_model_node_tbl_type ();
159: -- lastmarks "SYSTEM".cz_model_node_tbl_type;
160: root_closest_path_index number; -- 20040730:3b
161: root_closest_path_marker number;
162:
163: pathiter integer;

Line 181: retlist := "SYSTEM".cz_model_node_tbl_type();

177: -- copy RETLIST to another variable; it will be used as a query paremeter
178: lastfound := retlist;
179:
180: -- clear RETLIST to get the next set of nodes
181: retlist := "SYSTEM".cz_model_node_tbl_type();
182: foundcount := 0;
183:
184: -- ADW20040730:3a move last MARKLIST into LASTMARKS for later query and reinitialize MARKLIST
185: -- LASTMARKS := MARKLIST;

Line 186: -- MARKLIST := "SYSTEM".cz_model_node_tbl_type ();

182: foundcount := 0;
183:
184: -- ADW20040730:3a move last MARKLIST into LASTMARKS for later query and reinitialize MARKLIST
185: -- LASTMARKS := MARKLIST;
186: -- MARKLIST := "SYSTEM".cz_model_node_tbl_type ();
187: -- ADW20060221 don't really need marklist any more
188:
189: -- ADW20040730:3b
190: root_closest_path_marker := 10;

Line 319: -- table (cast (LASTMARKS AS cz_model_node_tbl_type)) PARMARK, -- ADW20040730:3a

315: --
316: PARNODE.NEAR_ROOT_MARKER -- ADW20040730:3a
317: FROM
318: CZ_EXPLMODEL_NODES_V XPLNODE,
319: -- table (cast (LASTMARKS AS cz_model_node_tbl_type)) PARMARK, -- ADW20040730:3a
320: table (cast (LASTFOUND as "SYSTEM".cz_model_node_tbl_type)) PARNODE
321: WHERE
322: XPLNODE.model_id = p_model_to_search
323: AND XPLNODE.name = p_namepath(pathiter)

Line 320: table (cast (LASTFOUND as "SYSTEM".cz_model_node_tbl_type)) PARNODE

316: PARNODE.NEAR_ROOT_MARKER -- ADW20040730:3a
317: FROM
318: CZ_EXPLMODEL_NODES_V XPLNODE,
319: -- table (cast (LASTMARKS AS cz_model_node_tbl_type)) PARMARK, -- ADW20040730:3a
320: table (cast (LASTFOUND as "SYSTEM".cz_model_node_tbl_type)) PARNODE
321: WHERE
322: XPLNODE.model_id = p_model_to_search
323: AND XPLNODE.name = p_namepath(pathiter)
324: AND XPLNODE.effective_parent_id = PARNODE.PS_NODE_ID

Line 373: lastfound := "SYSTEM".cz_model_node_tbl_type ();

369: foundcount > 1
370: and root_closest_path_index is not null
371: and root_closest_path_marker <= p_path_preference
372: then
373: lastfound := "SYSTEM".cz_model_node_tbl_type ();
374: lastfound.extend ();
375: lastfound (1) := retlist (root_closest_path_index);
376: return lastfound;
377: else