APPS.FND_DOCUMENTS_PKG dependencies on DUAL

Line 66: FROM dual;

62:
63: -- Get document_id from sequence
64: SELECT fnd_documents_s.nextval
65: INTO X_document_id
66: FROM dual;
67:
68:
69: -- Get media_id from the correct sequence depending on if it's
70: -- a short-text, long-text, ole_object, or db-stored image

Line 75: FROM dual;

71:
72: IF (X_datatype_id = 1) THEN
73: SELECT fnd_documents_short_text_s.nextval
74: INTO X_media_id
75: FROM dual;
76: IF (X_create_doc = 'Y') then
77: insert into fnd_documents_short_text
78: (media_id, short_text, app_source_version)
79: select X_media_id, short_text, app_source_version

Line 87: FROM dual;

83: END IF;
84: ELSIF (X_datatype_id = 2) THEN
85: SELECT fnd_documents_long_text_s.nextval
86: INTO X_media_id
87: FROM dual;
88: IF (X_create_doc = 'Y') then
89: select long_text,app_source_version into l_longtxt,l_app_s_v from fnd_documents_long_text
90: where media_id = l_media_id;
91: insert into fnd_documents_long_text

Line 100: FROM dual;

96: OR ( X_datatype_id = 3
97: AND X_storage_type = 1) ) THEN
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;

Line 104: FROM dual;

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:
107: -- First insert row into "base" table
108: INSERT INTO fnd_documents(