DBA Data[Home] [Help]

APPS.IEM_MS_MSGMETA_PVT dependencies on DUAL

Line 104: FROM dual;

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

Line 283: FROM dual;

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