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_ELEMENTS

Line 44: FROM xnp_msg_elements

40: element_datatype,
41: mandatory_flag,
42: NVL ( element_default_value, 'NP_NULL' ) element_default_value ,
43: parameter_sequence
44: FROM xnp_msg_elements
45: WHERE msg_code = g_message_code
46: AND parameter_flag = 'Y'
47: ORDER BY parameter_sequence ;
48:

Line 214: FROM xnp_msg_elements

210:
211: BEGIN
212: SELECT msg_element_id
213: INTO lv_element_id
214: FROM xnp_msg_elements
215: WHERE name = p_child_element_name
216: AND msg_code = p_new_msg_code;
217:
218: RETURN lv_element_id ;

Line 239: FROM xnp_msg_elements

235: BEGIN
236:
237: SELECT msg_element_id
238: INTO lv_element_id
239: FROM xnp_msg_elements
240: WHERE name = p_element_name
241: AND msg_code = p_new_msg_code;
242:
243: RETURN lv_element_id ;

Line 373: FROM XNP_MSG_ELEMENTS

369: DATA_LENGTH,
370: PARAMETER_SEQUENCE,
371: MSG_ELEMENT_ID --- Added for msg_structure
372:
373: FROM XNP_MSG_ELEMENTS
374: WHERE MSG_CODE= p_old_msg_code;
375:
376: CURSOR c_old_master is
377: select str.SEQUENCE_IN_PARENT,

Line 386: xnp_msg_elements elm

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' ;
390:

Line 401: INSERT INTO XNP_MSG_ELEMENTS

397: ELSE
398: lv_element_name :=c_msg_element_rec.NAME;
399: END IF;
400:
401: INSERT INTO XNP_MSG_ELEMENTS
402: (
403: MSG_ELEMENT_ID ,
404: MSG_CODE ,
405: NAME ,

Line 418: XNP_MSG_ELEMENTS_S.NEXTVAL,

414: LAST_UPDATE_DATE ,
415: LAST_UPDATED_BY ,
416: LAST_UPDATE_LOGIN )
417: VALUES(
418: XNP_MSG_ELEMENTS_S.NEXTVAL,
419: p_new_msg_code,
420: lv_element_name,
421: c_msg_element_rec.MANDATORY_FLAG,
422: c_msg_element_rec.PARAMETER_FLAG,

Line 512: xnp_msg_elements elm

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;
516:

Line 1682: l_child XNP_MSG_ELEMENTS.name%TYPE ;

1678: ,P_PARAMETER_FLAG IN VARCHAR2
1679: )
1680: IS
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 ;

Line 1683: l_datatype XNP_MSG_ELEMENTS.element_datatype%TYPE ;

1679: )
1680: IS
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 ;

Line 1684: l_mandatory_indr XNP_MSG_ELEMENTS.mandatory_flag%TYPE ;

1680: IS
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 ;

Line 1689: l_parameter_flag XNP_MSG_ELEMENTS.parameter_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
1693: SELECT MET.name,

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 1705: SELECT msg_element_id FROM xnp_msg_elements MET1

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
1706: WHERE MET1.name = parent_name
1707: AND MET1.msg_code = g_message_code )
1708: ORDER BY MSE.sequence_in_parent ;
1709:

Line 2524: l_child XNP_MSG_ELEMENTS.name%TYPE ;

2520: )
2521: IS
2522: l_create_sig VARCHAR2(16000) ;
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 ;

Line 2525: l_datatype XNP_MSG_ELEMENTS.element_datatype%TYPE ;

2521: IS
2522: l_create_sig VARCHAR2(16000) ;
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 ;

Line 2526: l_mandatory_indr XNP_MSG_ELEMENTS.mandatory_flag%TYPE ;

2522: l_create_sig VARCHAR2(16000) ;
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 ;

Line 2531: l_parameter_flag XNP_MSG_ELEMENTS.parameter_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:
2535: CURSOR get_msg_type IS

Line 2549: FROM xnp_msg_elements MET,

2545: MSE.data_source,
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

Line 2554: FROM xnp_msg_elements MET1

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
2555: WHERE MET1.name = parent_name
2556: AND MET1.msg_code = g_message_code )
2557: ORDER BY MSE.sequence_in_parent ;
2558: