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_DIAGNOSTICS$XNP_MSGS dependencies on XNP_MSG_TYPES_B

Line 127: ,L_MTE_MSG_TYPE XNP_MSG_TYPES_B.MSG_TYPE%TYPE

123: FORM_VAL FORM_REC;
124:
125: TYPE NBT_REC IS RECORD
126: (XML_PAYLOAD_LINK VARCHAR2(2000)
127: ,L_MTE_MSG_TYPE XNP_MSG_TYPES_B.MSG_TYPE%TYPE
128: ,PRIORITY XNP_MSG_TYPES_B.PRIORITY%TYPE
129: ,LAST_COMPILED_DATE XNP_MSG_TYPES_B.LAST_COMPILED_DATE%TYPE
130: ,RESEND_LINK VARCHAR2(2000)
131: ,L_MTE_DEFAULT_PROCESS_LOGIC XNP_MSG_TYPES_B.DEFAULT_PROCESS_LOGIC%TYPE

Line 128: ,PRIORITY XNP_MSG_TYPES_B.PRIORITY%TYPE

124:
125: TYPE NBT_REC IS RECORD
126: (XML_PAYLOAD_LINK VARCHAR2(2000)
127: ,L_MTE_MSG_TYPE XNP_MSG_TYPES_B.MSG_TYPE%TYPE
128: ,PRIORITY XNP_MSG_TYPES_B.PRIORITY%TYPE
129: ,LAST_COMPILED_DATE XNP_MSG_TYPES_B.LAST_COMPILED_DATE%TYPE
130: ,RESEND_LINK VARCHAR2(2000)
131: ,L_MTE_DEFAULT_PROCESS_LOGIC XNP_MSG_TYPES_B.DEFAULT_PROCESS_LOGIC%TYPE
132: ,L_MTE_IN_PROCESS_LOGIC XNP_MSG_TYPES_B.IN_PROCESS_LOGIC%TYPE

Line 129: ,LAST_COMPILED_DATE XNP_MSG_TYPES_B.LAST_COMPILED_DATE%TYPE

125: TYPE NBT_REC IS RECORD
126: (XML_PAYLOAD_LINK VARCHAR2(2000)
127: ,L_MTE_MSG_TYPE XNP_MSG_TYPES_B.MSG_TYPE%TYPE
128: ,PRIORITY XNP_MSG_TYPES_B.PRIORITY%TYPE
129: ,LAST_COMPILED_DATE XNP_MSG_TYPES_B.LAST_COMPILED_DATE%TYPE
130: ,RESEND_LINK VARCHAR2(2000)
131: ,L_MTE_DEFAULT_PROCESS_LOGIC XNP_MSG_TYPES_B.DEFAULT_PROCESS_LOGIC%TYPE
132: ,L_MTE_IN_PROCESS_LOGIC XNP_MSG_TYPES_B.IN_PROCESS_LOGIC%TYPE
133: ,L_MTE_VALIDATE_LOGIC XNP_MSG_TYPES_B.VALIDATE_LOGIC%TYPE

Line 131: ,L_MTE_DEFAULT_PROCESS_LOGIC XNP_MSG_TYPES_B.DEFAULT_PROCESS_LOGIC%TYPE

127: ,L_MTE_MSG_TYPE XNP_MSG_TYPES_B.MSG_TYPE%TYPE
128: ,PRIORITY XNP_MSG_TYPES_B.PRIORITY%TYPE
129: ,LAST_COMPILED_DATE XNP_MSG_TYPES_B.LAST_COMPILED_DATE%TYPE
130: ,RESEND_LINK VARCHAR2(2000)
131: ,L_MTE_DEFAULT_PROCESS_LOGIC XNP_MSG_TYPES_B.DEFAULT_PROCESS_LOGIC%TYPE
132: ,L_MTE_IN_PROCESS_LOGIC XNP_MSG_TYPES_B.IN_PROCESS_LOGIC%TYPE
133: ,L_MTE_VALIDATE_LOGIC XNP_MSG_TYPES_B.VALIDATE_LOGIC%TYPE
134: ,L_MTE_OUT_PROCESS_LOGIC XNP_MSG_TYPES_B.OUT_PROCESS_LOGIC%TYPE
135: );

Line 132: ,L_MTE_IN_PROCESS_LOGIC XNP_MSG_TYPES_B.IN_PROCESS_LOGIC%TYPE

128: ,PRIORITY XNP_MSG_TYPES_B.PRIORITY%TYPE
129: ,LAST_COMPILED_DATE XNP_MSG_TYPES_B.LAST_COMPILED_DATE%TYPE
130: ,RESEND_LINK VARCHAR2(2000)
131: ,L_MTE_DEFAULT_PROCESS_LOGIC XNP_MSG_TYPES_B.DEFAULT_PROCESS_LOGIC%TYPE
132: ,L_MTE_IN_PROCESS_LOGIC XNP_MSG_TYPES_B.IN_PROCESS_LOGIC%TYPE
133: ,L_MTE_VALIDATE_LOGIC XNP_MSG_TYPES_B.VALIDATE_LOGIC%TYPE
134: ,L_MTE_OUT_PROCESS_LOGIC XNP_MSG_TYPES_B.OUT_PROCESS_LOGIC%TYPE
135: );
136: NBT_VAL NBT_REC;

Line 133: ,L_MTE_VALIDATE_LOGIC XNP_MSG_TYPES_B.VALIDATE_LOGIC%TYPE

129: ,LAST_COMPILED_DATE XNP_MSG_TYPES_B.LAST_COMPILED_DATE%TYPE
130: ,RESEND_LINK VARCHAR2(2000)
131: ,L_MTE_DEFAULT_PROCESS_LOGIC XNP_MSG_TYPES_B.DEFAULT_PROCESS_LOGIC%TYPE
132: ,L_MTE_IN_PROCESS_LOGIC XNP_MSG_TYPES_B.IN_PROCESS_LOGIC%TYPE
133: ,L_MTE_VALIDATE_LOGIC XNP_MSG_TYPES_B.VALIDATE_LOGIC%TYPE
134: ,L_MTE_OUT_PROCESS_LOGIC XNP_MSG_TYPES_B.OUT_PROCESS_LOGIC%TYPE
135: );
136: NBT_VAL NBT_REC;
137:

Line 134: ,L_MTE_OUT_PROCESS_LOGIC XNP_MSG_TYPES_B.OUT_PROCESS_LOGIC%TYPE

130: ,RESEND_LINK VARCHAR2(2000)
131: ,L_MTE_DEFAULT_PROCESS_LOGIC XNP_MSG_TYPES_B.DEFAULT_PROCESS_LOGIC%TYPE
132: ,L_MTE_IN_PROCESS_LOGIC XNP_MSG_TYPES_B.IN_PROCESS_LOGIC%TYPE
133: ,L_MTE_VALIDATE_LOGIC XNP_MSG_TYPES_B.VALIDATE_LOGIC%TYPE
134: ,L_MTE_OUT_PROCESS_LOGIC XNP_MSG_TYPES_B.OUT_PROCESS_LOGIC%TYPE
135: );
136: NBT_VAL NBT_REC;
137:
138: ZONE_SQL VARCHAR2(4500) := null;

Line 224: from XNP_MSG_TYPES_B L_MTE

220: Z_MODE in varchar2) return boolean is
221: begin
222: select L_MTE.MSG_CODE
223: into CURR_VAL.MSG_CODE
224: from XNP_MSG_TYPES_B L_MTE
225: where rownum = 1
226: and ( L_MTE.MSG_CODE = P_MSG_CODE )
227: and ( L_MTE.MSG_TYPE = P_L_MTE_MSG_TYPE );
228: return TRUE;

Line 370: from XNP_MSG_TYPES_B L_MTE

366: , L_MTE.DEFAULT_PROCESS_LOGIC L_MTE_DEFAULT_PROCESS_LOGIC
367: , L_MTE.IN_PROCESS_LOGIC L_MTE_IN_PROCESS_LOGIC
368: , L_MTE.VALIDATE_LOGIC L_MTE_VALIDATE_LOGIC
369: , L_MTE.OUT_PROCESS_LOGIC L_MTE_OUT_PROCESS_LOGIC
370: from XNP_MSG_TYPES_B L_MTE
371: where L_MTE.MSG_CODE like upper(srch)
372: order by L_MTE.MSG_CODE;
373: begin
374: for c1rec in c1(Z_MODE,L_SEARCH_STRING) loop

Line 656: XNP_MSG_TYPES_B L_MTE';

652: MSG.SENDER_NAME,
653: MSG.ADAPTER_NAME,
654: MSG.FE_NAME
655: FROM XNP_MSGS MSG,
656: XNP_MSG_TYPES_B L_MTE';
657:
658: ZONE_SQL := ZONE_SQL || I_WHERE;
659: ZONE_SQL := ZONE_SQL || ' ORDER BY MSG.MSG_ID Desc ';
660: return true;

Line 1116: XNP_MSG_TYPES_B L_MTE

1112: NBT_VAL.L_MTE_IN_PROCESS_LOGIC,
1113: NBT_VAL.L_MTE_VALIDATE_LOGIC,
1114: NBT_VAL.L_MTE_OUT_PROCESS_LOGIC
1115: FROM XNP_MSGS MSG,
1116: XNP_MSG_TYPES_B L_MTE
1117: WHERE MSG.MSG_ID = CURR_VAL.MSG_ID
1118: AND L_MTE.MSG_CODE = MSG.MSG_CODE
1119: ;
1120:

Line 1177: XNP_MSG_TYPES_B L_MTE

1173: NBT_VAL.L_MTE_IN_PROCESS_LOGIC,
1174: NBT_VAL.L_MTE_VALIDATE_LOGIC,
1175: NBT_VAL.L_MTE_OUT_PROCESS_LOGIC
1176: FROM XNP_MSGS MSG,
1177: XNP_MSG_TYPES_B L_MTE
1178: WHERE MSG.MSG_ID = CURR_VAL.MSG_ID
1179: AND L_MTE.MSG_CODE = MSG.MSG_CODE
1180: ;
1181: