31: met.parameter_flag,
32: mse.data_source,
33: mse.data_source_type,
34: mse.data_source_reference
35: FROM xnp_msg_elements met, xnp_msg_structures mse
36: WHERE met.msg_code = mse.msg_code
37: AND met.msg_code = p_msg_code
38: -- skilaru 03/27/2001
39: -- AND met.msg_element_id IN( mse.child_element_id);
312: IS
313:
314: CURSOR get_parent IS
315: --skilaru 03/27/2001
316: --SELECT * FROM xnp_msg_structures
317: SELECT 'Y' FROM xnp_msg_structures
318: WHERE parent_element_id = p_element_id ;
319: --skilaru 03/27/2001
320: --l_row xnp_msg_structures%ROWTYPE ;
313:
314: CURSOR get_parent IS
315: --skilaru 03/27/2001
316: --SELECT * FROM xnp_msg_structures
317: SELECT 'Y' FROM xnp_msg_structures
318: WHERE parent_element_id = p_element_id ;
319: --skilaru 03/27/2001
320: --l_row xnp_msg_structures%ROWTYPE ;
321: l_row VARCHAR2(1) ;
316: --SELECT * FROM xnp_msg_structures
317: SELECT 'Y' FROM xnp_msg_structures
318: WHERE parent_element_id = p_element_id ;
319: --skilaru 03/27/2001
320: --l_row xnp_msg_structures%ROWTYPE ;
321: l_row VARCHAR2(1) ;
322:
323: BEGIN
324: