APPS.IEM_MS_MSGMETA_PVT dependencies on DUAL

Line 106: FROM dual;

102: --SELECT iem_ms_mimemsgs_s1.nextval
103: if ( p_message_id = -1 ) then
104: SELECT iem_ms_base_headers_s1.nextval
105: INTO l_seq_id
106: FROM dual;
107: else
108: l_seq_id := p_message_id;
109: end if;
110:

Line 285: FROM dual;

281: FOR i IN p_msg_meta_id.FIRST..p_msg_meta_id.LAST LOOP
282:
283: SELECT iem_ms_EXTHDRS_s1.nextval
284: INTO l_seq_id
285: FROM dual;
286:
287: l_msg_meta_id := p_msg_meta_id(i);
288: l_name := substr( p_name_tbl(i),1,59);
289: l_value := substr( p_value_tbl(i), 1, 1999 );