APPS.PO_ATT dependencies on FND_DOCUMENTS_SHORT_TEXT

Line 429: SELECT fnd_documents_short_text_s.nextval

425: get_category_id (x_usage_id, x_category_id);
426: /* -1 if cannot find corresponding category */
427:
428: IF x_datatype_id = 1 THEN
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

Line 491: INSERT INTO fnd_documents_short_text ( media_id, short_text, app_source_version )

487: userenv('LANG'), p_app_source_version
488: );
489:
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 );

Line 633: UPDATE fnd_documents_short_text

629:
630: IF x_datatype_id = 1 THEN
631: -- we could check if note >= 2000 even datatype_id=1, and set x_note to
632: -- 'note truncated'|| substr(x_note,1,1900). leave it this way for now.
633: UPDATE fnd_documents_short_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

Line 665: DELETE FROM fnd_documents_short_text

661: DELETE FROM fnd_documents_tl
662: WHERE document_id = p_document_id;
663:
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;