DBA Data[Home] [Help]

APPS.DOM_ATTACHMENT_UTIL_PKG dependencies on FND_DOCUMENTS_SHORT_TEXT

Line 700: FROM fnd_documents_short_text

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

Line 810: INSERT INTO fnd_documents_short_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,

Line 1135: FROM fnd_documents_short_text

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

Line 1286: INSERT INTO fnd_documents_short_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,