APPS.PO_ATT dependencies on FND_DOCUMENTS_LONG_TEXT

Line 433: SELECT fnd_documents_long_text_s.nextval

429: SELECT fnd_documents_short_text_s.nextval
430: INTO x_media_id
431: FROM sys.dual;
432: ELSE
433: SELECT fnd_documents_long_text_s.nextval
434: INTO x_media_id
435: FROM sys.dual;
436: END IF;
437:

Line 494: INSERT INTO fnd_documents_long_text ( media_id, long_text, app_source_version )

490: IF x_datatype_id = 1 THEN
491: INSERT INTO fnd_documents_short_text ( media_id, short_text, app_source_version )
492: VALUES ( x_media_id, x_note, p_app_source_version );
493: ELSE
494: INSERT INTO fnd_documents_long_text ( media_id, long_text, app_source_version )
495: VALUES ( x_media_id, x_note, p_app_source_version );
496: END IF;
497:
498: END;

Line 638: UPDATE fnd_documents_long_text

634: SET app_source_version = 'PO_R10',
635: short_text = substr (x_note, 1, 1998)
636: WHERE media_id = x_media_id;
637: ELSE
638: UPDATE fnd_documents_long_text
639: SET app_source_version = 'PO_R10',
640: long_text = x_note
641: WHERE media_id = x_media_id;
642: END IF;

Line 668: DELETE FROM fnd_documents_long_text

664: IF x_datatype_id = 1 THEN
665: DELETE FROM fnd_documents_short_text
666: WHERE media_id = x_media_id;
667: ELSE
668: DELETE FROM fnd_documents_long_text
669: WHERE media_id = x_media_id;
670: END IF;
671:
672: END;