DBA Data[Home] [Help]

APPS.FND_DOCUMENTS_PKG dependencies on FND_LOBS

Line 102: SELECT fnd_lobs_s.nextval

98: SELECT fnd_documents_long_raw_s.nextval
99: INTO X_media_id
100: FROM dual;
101: ELSIF (X_datatype_id = 6 and X_media_id is NULL) THEN
102: SELECT fnd_lobs_s.nextval
103: INTO X_media_id
104: FROM dual;
105: END IF;
106:

Line 708: DELETE FROM fnd_lobs

704: (SELECT media_id
705: FROM fnd_documents
706: WHERE document_id = x_document_id);
707: ELSIF (X_datatype_id = 6) THEN
708: DELETE FROM fnd_lobs
709: WHERE file_id in
710: (SELECT media_id
711: from fnd_documents
712: WHERE document_id = x_document_id);