APPS.SO_ATT dependencies on FND_DOCUMENTS_SHORT_TEXT

Line 487: SELECT fnd_documents_short_text_s.nextval

483: x_start_date_active, x_end_date_active
484: FROM dual;
485:
486: IF x_datatype_id = 1 THEN
487: SELECT fnd_documents_short_text_s.nextval
488: INTO x_media_id
489: FROM dual;
490: ELSE
491: SELECT fnd_documents_long_text_s.nextval

Line 529: INSERT INTO fnd_documents_short_text (

525: p_app_source_version, fnd_global.current_language
526: FROM dual;
527:
528: IF x_datatype_id = 1 THEN
529: INSERT INTO fnd_documents_short_text (
530: media_id, short_text, app_source_version )
531: SELECT
532: x_media_id, x_note, p_app_source_version
533: FROM dual;

Line 674: UPDATE fnd_documents_short_text

670: IF x_datatype_id = 1 THEN
671: -- we could check if note >= 2000 even datatype_id=1, and set x_note to
672: -- 'note truncated'|| substr(x_note,1,1900). leave it this way for now.
673:
674: UPDATE fnd_documents_short_text
675: SET app_source_version = 'SO_R10',
676: short_text = substr (x_note, 1, 1998)
677: WHERE media_id = x_media_id;
678: ELSE

Line 706: DELETE FROM fnd_documents_short_text

702: DELETE FROM fnd_documents_tl
703: WHERE document_id = p_document_id;
704:
705: IF x_datatype_id = 1 THEN
706: DELETE FROM fnd_documents_short_text
707: WHERE media_id = x_media_id;
708: ELSE
709: DELETE FROM fnd_documents_long_text
710: WHERE media_id = x_media_id;