APPS.SO_ATT dependencies on FND_DOCUMENTS_LONG_TEXT

Line 491: SELECT fnd_documents_long_text_s.nextval

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
492: INTO x_media_id
493: FROM dual;
494: END IF;
495:

Line 535: INSERT INTO fnd_documents_long_text (

531: SELECT
532: x_media_id, x_note, p_app_source_version
533: FROM dual;
534: ELSE
535: INSERT INTO fnd_documents_long_text (
536: media_id, long_text, app_source_version )
537: VALUES (
538: x_media_id, x_note, p_app_source_version);
539: END IF;

Line 679: UPDATE fnd_documents_long_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
679: UPDATE fnd_documents_long_text
680: SET app_source_version = 'SO_R10',
681: long_text = x_note
682: WHERE media_id = x_media_id;
683: END IF;

Line 709: DELETE FROM fnd_documents_long_text

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;
711: END IF;
712:
713: END;