DBA Data[Home] [Help]

APPS.FND_DOCUMENTS_PKG dependencies on FND_LOBS

Line 108: SELECT fnd_lobs_s.nextval

104: SELECT fnd_documents_long_raw_s.nextval
105: INTO X_media_id
106: FROM dual;
107: ELSIF (X_datatype_id = 6 and X_media_id is NULL) THEN
108: SELECT fnd_lobs_s.nextval
109: INTO X_media_id
110: FROM dual;
111: END IF;
112:

Line 736: DELETE FROM fnd_lobs

732: (SELECT media_id
733: FROM fnd_documents
734: WHERE document_id = x_document_id);
735: ELSIF (X_datatype_id = 6) THEN
736: DELETE FROM fnd_lobs
737: WHERE file_id in
738: (SELECT media_id
739: from fnd_documents
740: WHERE document_id = x_document_id);