DBA Data[Home] [Help]

APPS.AMS_ATTACHMENT_PVT dependencies on DUAL

Line 55: FROM dual;

51: l_create_Attached_Doc boolean := true;
52:
53: CURSOR c_attached_doc_id IS
54: SELECT FND_ATTACHED_DOCUMENTS_S.nextval
55: FROM dual;
56:
57: CURSOR c_attached_doc_id_exists (l_id IN NUMBER) IS
58: SELECT 1
59: FROM FND_ATTACHED_DOCUMENTS

Line 404: from dual;

400: if (p_Fnd_Attachment_rec.datatype_id = 1) then
401: if (p_Fnd_Attachment_rec.media_id is null) then
402: SELECT fnd_documents_short_text_s.nextval
403: INTO l_media_id
404: from dual;
405: end if;
406: end if;
407:
408: -- Invoke table handler(fnd_documents_pkg.update_row)

Line 568: from dual

564: /* Need to check if the file/text is referenced by any other document */
565: cursor c_check_media_id_reference(p_media_id number,p_document_id number,p_datatype_id number)
566: is
567: select 1
568: from dual
569: where exists
570: (select 1
571: from fnd_documents_tl tl
572: ,fnd_documents b