175: Z_MODE in varchar2) return boolean is
176: begin
177: select L_MTE.MSG_CODE
178: into CURR_VAL.MSG_CODE
179: from XNP_MSG_TYPES_B L_MTE
180: where rownum = 1
181: and ( L_MTE.MSG_CODE = P_MSG_CODE );
182: return TRUE;
183: exception
309:
310: declare
311: cursor c1(zmode varchar2,srch varchar2) is
312: select L_MTE.MSG_CODE MSG_CODE
313: from XNP_MSG_TYPES_B L_MTE
314: where L_MTE.MSG_CODE like upper(srch)
315: order by L_MTE.MSG_CODE;
316: begin
317: for c1rec in c1(Z_MODE,L_SEARCH_STRING) loop
641: CET.REGISTERED_TIMESTAMP,
642: CET.WI_INSTANCE_ID,
643: CET.FA_INSTANCE_ID
644: FROM XNP_CALLBACK_EVENTS CET,
645: XNP_MSG_TYPES_B L_MTE';
646:
647: ZONE_SQL := ZONE_SQL || I_WHERE;
648: ZONE_SQL := ZONE_SQL || ' ORDER BY CET.CALLBACK_EVENT_ID Desc,
649: CET.REFERENCE_ID,