APPS.FND_DOCUMENTS_PKG dependencies on DUAL

Line 72: FROM dual;

68:
69: -- Get document_id from sequence
70: SELECT fnd_documents_s.nextval
71: INTO X_document_id
72: FROM dual;
73:
74:
75: -- Get media_id from the correct sequence depending on if it's
76: -- a short-text, long-text, ole_object, or db-stored image

Line 81: FROM dual;

77:
78: IF (X_datatype_id = 1) THEN
79: SELECT fnd_documents_short_text_s.nextval
80: INTO X_media_id
81: FROM dual;
82: IF (X_create_doc = 'Y') then
83: insert into fnd_documents_short_text
84: (media_id, short_text, app_source_version)
85: select X_media_id, short_text, app_source_version

Line 93: FROM dual;

89: END IF;
90: ELSIF (X_datatype_id = 2) THEN
91: SELECT fnd_documents_long_text_s.nextval
92: INTO X_media_id
93: FROM dual;
94: IF (X_create_doc = 'Y') then
95: select long_text,app_source_version into l_longtxt,l_app_s_v from fnd_documents_long_text
96: where media_id = l_media_id;
97: insert into fnd_documents_long_text

Line 106: FROM dual;

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

Line 110: FROM dual;

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