DBA Data[Home] [Help]

APPS.M4U_DMD_REQUESTS dependencies on DUAL

Line 108: FROM DUAL;

104:
105:
106: SELECT m4u_dmd_msgid_s.nextval
107: INTO l_msg_id
108: FROM DUAL;
109:
110:
111: m4u_dmd_utils.log('l_msg_id -|'|| l_msg_id ||'|',1);
112: m4u_dmd_utils.log('insert into m4u_dmd_messages' ,1);

Line 208: FROM dual;

204: --validation block ends
205:
206: SELECT m4u_dmd_payloadid_s.NEXTVAL
207: INTO l_payload_id
208: FROM dual;
209:
210: m4u_dmd_utils.log('l_payload_id -|'|| l_payload_id ||'|',1);
211: m4u_dmd_utils.log('insert into m4u_dmd_payloads' ,1);
212:

Line 453: FROM dual;

449:
450:
451: SELECT m4u_dmd_docid_s.NEXTVAL
452: INTO l_doc_id
453: FROM dual;
454:
455: IF p_orig_doc_id = 'GENERATE' THEN
456: l_orig_doc_id := p_type || '.' || to_char(sysdate,'DD-MM-RR') || '.' || '0' || '.' || l_doc_id;
457: ELSE