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.XNP_MSG_BUILDER dependencies on XNP_MSG_STRUCTURES

Line 385: from xnp_msg_structures str,

381: str.DATA_SOURCE_REFERENCE,
382: str.ELEMENT_POSITION,
383: str.ELEMENT_ALIGNMENT,
384: str.PADDING
385: from xnp_msg_structures str,
386: xnp_msg_elements elm
387: where str.parent_element_id = elm.msg_element_id
388: AND elm.msg_code=p_old_msg_code
389: AND elm.NAME='MESSAGE' ;

Line 511: FROM xnp_msg_structures str,

507: str.ELEMENT_POSITION,
508: str.ELEMENT_ALIGNMENT,
509: str.PADDING,
510: elm.NAME
511: FROM xnp_msg_structures str,
512: xnp_msg_elements elm
513: WHERE str.msg_code = p_old_msg_code
514: AND str.parent_element_id = p_element_id
515: AND str.child_element_id = elm.msg_element_id;

Line 585: INSERT INTO XNP_MSG_STRUCTURES

581:
582: BEGIN
583:
584: p_return_code:=0;
585: INSERT INTO XNP_MSG_STRUCTURES
586: (STRUCTURE_ID ,
587: PARENT_ELEMENT_ID ,
588: CHILD_ELEMENT_ID ,
589: MSG_CODE ,

Line 603: VALUES( XNP_MSG_STRUCTURES_S.NEXTVAL,

599: CREATION_DATE ,
600: LAST_UPDATED_BY ,
601: LAST_UPDATE_DATE ,
602: LAST_UPDATE_LOGIN )
603: VALUES( XNP_MSG_STRUCTURES_S.NEXTVAL,
604: P_PARENT_ELEMENT_ID ,
605: P_CHILD_ELEMENT_ID ,
606: P_MSG_CODE ,
607: P_SEQUENCE_IN_PARENT ,

Line 1685: l_data_source_type XNP_MSG_STRUCTURES.data_source_type%TYPE ;

1681:
1682: l_child XNP_MSG_ELEMENTS.name%TYPE ;
1683: l_datatype XNP_MSG_ELEMENTS.element_datatype%TYPE ;
1684: l_mandatory_indr XNP_MSG_ELEMENTS.mandatory_flag%TYPE ;
1685: l_data_source_type XNP_MSG_STRUCTURES.data_source_type%TYPE ;
1686: l_data_source XNP_MSG_STRUCTURES.data_source%TYPE ;
1687: l_data_source_ref XNP_MSG_STRUCTURES.data_source_reference%TYPE ;
1688: l_cardinality XNP_MSG_STRUCTURES.cardinality%TYPE ;
1689: l_parameter_flag XNP_MSG_ELEMENTS.parameter_flag%TYPE ;

Line 1686: l_data_source XNP_MSG_STRUCTURES.data_source%TYPE ;

1682: l_child XNP_MSG_ELEMENTS.name%TYPE ;
1683: l_datatype XNP_MSG_ELEMENTS.element_datatype%TYPE ;
1684: l_mandatory_indr XNP_MSG_ELEMENTS.mandatory_flag%TYPE ;
1685: l_data_source_type XNP_MSG_STRUCTURES.data_source_type%TYPE ;
1686: l_data_source XNP_MSG_STRUCTURES.data_source%TYPE ;
1687: l_data_source_ref XNP_MSG_STRUCTURES.data_source_reference%TYPE ;
1688: l_cardinality XNP_MSG_STRUCTURES.cardinality%TYPE ;
1689: l_parameter_flag XNP_MSG_ELEMENTS.parameter_flag%TYPE ;
1690: l_loop_counter NUMBER := 0 ;

Line 1687: l_data_source_ref XNP_MSG_STRUCTURES.data_source_reference%TYPE ;

1683: l_datatype XNP_MSG_ELEMENTS.element_datatype%TYPE ;
1684: l_mandatory_indr XNP_MSG_ELEMENTS.mandatory_flag%TYPE ;
1685: l_data_source_type XNP_MSG_STRUCTURES.data_source_type%TYPE ;
1686: l_data_source XNP_MSG_STRUCTURES.data_source%TYPE ;
1687: l_data_source_ref XNP_MSG_STRUCTURES.data_source_reference%TYPE ;
1688: l_cardinality XNP_MSG_STRUCTURES.cardinality%TYPE ;
1689: l_parameter_flag XNP_MSG_ELEMENTS.parameter_flag%TYPE ;
1690: l_loop_counter NUMBER := 0 ;
1691:

Line 1688: l_cardinality XNP_MSG_STRUCTURES.cardinality%TYPE ;

1684: l_mandatory_indr XNP_MSG_ELEMENTS.mandatory_flag%TYPE ;
1685: l_data_source_type XNP_MSG_STRUCTURES.data_source_type%TYPE ;
1686: l_data_source XNP_MSG_STRUCTURES.data_source%TYPE ;
1687: l_data_source_ref XNP_MSG_STRUCTURES.data_source_reference%TYPE ;
1688: l_cardinality XNP_MSG_STRUCTURES.cardinality%TYPE ;
1689: l_parameter_flag XNP_MSG_ELEMENTS.parameter_flag%TYPE ;
1690: l_loop_counter NUMBER := 0 ;
1691:
1692: CURSOR get_children ( parent_name IN VARCHAR2 ) IS

Line 1701: FROM xnp_msg_elements MET, xnp_msg_structures MSE

1697: MSE.data_source,
1698: MSE.data_source_reference,
1699: MSE.cardinality,
1700: MET.parameter_flag
1701: FROM xnp_msg_elements MET, xnp_msg_structures MSE
1702: WHERE MSE.msg_code = g_message_code
1703: AND MSE.child_element_id = MET.msg_element_id
1704: AND MSE.parent_element_id = (
1705: SELECT msg_element_id FROM xnp_msg_elements MET1

Line 2527: l_data_source_type XNP_MSG_STRUCTURES.data_source_type%TYPE ;

2523:
2524: l_child XNP_MSG_ELEMENTS.name%TYPE ;
2525: l_datatype XNP_MSG_ELEMENTS.element_datatype%TYPE ;
2526: l_mandatory_indr XNP_MSG_ELEMENTS.mandatory_flag%TYPE ;
2527: l_data_source_type XNP_MSG_STRUCTURES.data_source_type%TYPE ;
2528: l_data_source XNP_MSG_STRUCTURES.data_source%TYPE ;
2529: l_data_source_ref XNP_MSG_STRUCTURES.data_source_reference%TYPE ;
2530: l_cardinality XNP_MSG_STRUCTURES.cardinality%TYPE ;
2531: l_parameter_flag XNP_MSG_ELEMENTS.parameter_flag%TYPE ;

Line 2528: l_data_source XNP_MSG_STRUCTURES.data_source%TYPE ;

2524: l_child XNP_MSG_ELEMENTS.name%TYPE ;
2525: l_datatype XNP_MSG_ELEMENTS.element_datatype%TYPE ;
2526: l_mandatory_indr XNP_MSG_ELEMENTS.mandatory_flag%TYPE ;
2527: l_data_source_type XNP_MSG_STRUCTURES.data_source_type%TYPE ;
2528: l_data_source XNP_MSG_STRUCTURES.data_source%TYPE ;
2529: l_data_source_ref XNP_MSG_STRUCTURES.data_source_reference%TYPE ;
2530: l_cardinality XNP_MSG_STRUCTURES.cardinality%TYPE ;
2531: l_parameter_flag XNP_MSG_ELEMENTS.parameter_flag%TYPE ;
2532: l_fnd_message VARCHAR2(4000) ;

Line 2529: l_data_source_ref XNP_MSG_STRUCTURES.data_source_reference%TYPE ;

2525: l_datatype XNP_MSG_ELEMENTS.element_datatype%TYPE ;
2526: l_mandatory_indr XNP_MSG_ELEMENTS.mandatory_flag%TYPE ;
2527: l_data_source_type XNP_MSG_STRUCTURES.data_source_type%TYPE ;
2528: l_data_source XNP_MSG_STRUCTURES.data_source%TYPE ;
2529: l_data_source_ref XNP_MSG_STRUCTURES.data_source_reference%TYPE ;
2530: l_cardinality XNP_MSG_STRUCTURES.cardinality%TYPE ;
2531: l_parameter_flag XNP_MSG_ELEMENTS.parameter_flag%TYPE ;
2532: l_fnd_message VARCHAR2(4000) ;
2533: l_msg_type VARCHAR2(10) ;

Line 2530: l_cardinality XNP_MSG_STRUCTURES.cardinality%TYPE ;

2526: l_mandatory_indr XNP_MSG_ELEMENTS.mandatory_flag%TYPE ;
2527: l_data_source_type XNP_MSG_STRUCTURES.data_source_type%TYPE ;
2528: l_data_source XNP_MSG_STRUCTURES.data_source%TYPE ;
2529: l_data_source_ref XNP_MSG_STRUCTURES.data_source_reference%TYPE ;
2530: l_cardinality XNP_MSG_STRUCTURES.cardinality%TYPE ;
2531: l_parameter_flag XNP_MSG_ELEMENTS.parameter_flag%TYPE ;
2532: l_fnd_message VARCHAR2(4000) ;
2533: l_msg_type VARCHAR2(10) ;
2534:

Line 2550: xnp_msg_structures MSE

2546: MSE.data_source_reference,
2547: MSE.cardinality,
2548: MET.parameter_flag
2549: FROM xnp_msg_elements MET,
2550: xnp_msg_structures MSE
2551: WHERE MSE.msg_code = g_message_code
2552: AND MSE.child_element_id = MET.msg_element_id
2553: AND MSE.parent_element_id = ( SELECT msg_element_id
2554: FROM xnp_msg_elements MET1