[Home] [Help]
175: into l_attached_document_id from dual;
176:
177: if ( l_document_id is null ) THEN
178:
179: SELECT fnd_documents_s.nextval
180: INTO l_document_id
181: FROM dual;
182:
183: l_category_id := p_category_id;
249: file_name,
250: dm_node,
251: dm_type)
252: SELECT
253: fnd_documents_s.NEXTVAL,
254: creation_date,
255: created_by,
256: last_update_date,
257: last_updated_by,
270: WHERE x.document_id = l_document_id;
271:
272: select media_id, category_id, userenv('LANG') into l_media_id, l_category_id, l_language from fnd_documents where document_id = l_document_id;
273:
274: select fnd_documents_s.CURRVAL into l_document_id from dual;
275:
276: fnd_documents_pkg.insert_tl_row(
277: X_document_id => l_document_id,
278: X_creation_date => sysdate,
696: AND fd.document_id = X_from_document_id ;
697:
698: CURSOR shorttext (mid NUMBER) IS
699: SELECT short_text
700: FROM fnd_documents_short_text
701: WHERE media_id = mid;
702:
703: CURSOR longtext (mid NUMBER) IS
704: SELECT long_text
806: OPEN shorttext(docrec.media_id);
807: FETCH shorttext INTO short_text_tmp;
808: CLOSE shorttext;
809:
810: INSERT INTO fnd_documents_short_text (
811: media_id,
812: short_text)
813: VALUES (
814: media_id_tmp,
1131:
1132:
1133: CURSOR shorttext (mid NUMBER) IS
1134: SELECT short_text
1135: FROM fnd_documents_short_text
1136: WHERE media_id = mid;
1137:
1138: CURSOR longtext (mid NUMBER) IS
1139: SELECT long_text
1282: OPEN shorttext(docrec.media_id);
1283: FETCH shorttext INTO short_text_tmp;
1284: CLOSE shorttext;
1285:
1286: INSERT INTO fnd_documents_short_text (
1287: media_id,
1288: short_text)
1289: VALUES (
1290: media_id_tmp,