eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.SO_ATT dependencies on FND_DOCUMENTS

Line 67: x_language fnd_documents_tl.language%TYPE;

63: p_document_id NUMBER
64: ) RETURN VARCHAR2 IS
65: x_note_name VARCHAR2(2000);
66: x_doc_desc VARCHAR2(30);
67: x_language fnd_documents_tl.language%TYPE;
68: x_check NUMBER;
69: CURSOR doc IS
70: SELECT SUBSTR(description,1,30)
71: FROM fnd_documents_tl

Line 71: FROM fnd_documents_tl

67: x_language fnd_documents_tl.language%TYPE;
68: x_check NUMBER;
69: CURSOR doc IS
70: SELECT SUBSTR(description,1,30)
71: FROM fnd_documents_tl
72: WHERE document_id = p_document_id
73: AND language = x_language;
74: CURSOR check_unique IS
75: SELECT 1

Line 242: FROM fnd_documents_tl fdt,

238: ) IS
239: BEGIN
240: SELECT fd.datatype_id, fdt.media_id
241: INTO p_datatype_id, p_media_id
242: FROM fnd_documents_tl fdt,
243: fnd_documents fd
244: WHERE fdt.language = fnd_global.current_language
245: AND fdt.document_id = fd.document_id
246: AND fd.document_id = p_document_id;

Line 243: fnd_documents fd

239: BEGIN
240: SELECT fd.datatype_id, fdt.media_id
241: INTO p_datatype_id, p_media_id
242: FROM fnd_documents_tl fdt,
243: fnd_documents fd
244: WHERE fdt.language = fnd_global.current_language
245: AND fdt.document_id = fd.document_id
246: AND fd.document_id = p_document_id;
247:

Line 256: fnd_documents fd

252: x_category_application NUMBER;
253: CURSOR get_doc_cat_app IS
254: SELECT fdc.application_id
255: FROM fnd_document_categories fdc,
256: fnd_documents fd
257: WHERE fd.category_id = fdc.category_id
258: AND fd.document_id = p_document_id;
259: BEGIN
260:

Line 308: fnd_documents_tl fdt,

304: CURSOR c1 IS
305: SELECT fd.document_id, fd.category_id,
306: fd.usage_type, fdc.application_id
307: FROM fnd_document_categories fdc,
308: fnd_documents_tl fdt,
309: fnd_documents fd
310: WHERE fdt.media_id = p_media_id
311: AND fdt.document_id = fd.document_id
312: AND fd.datatype_id = decode (p_short_long, 'S', 1, 2) --short/long

Line 309: fnd_documents fd

305: SELECT fd.document_id, fd.category_id,
306: fd.usage_type, fdc.application_id
307: FROM fnd_document_categories fdc,
308: fnd_documents_tl fdt,
309: fnd_documents fd
310: WHERE fdt.media_id = p_media_id
311: AND fdt.document_id = fd.document_id
312: AND fd.datatype_id = decode (p_short_long, 'S', 1, 2) --short/long
313: AND fd.category_id = fdc.category_id;

Line 466: INSERT INTO fnd_documents (

462:
463:
464: get_category_id (x_usage_id, x_category_id);
465:
466: INSERT INTO fnd_documents (
467: document_id, creation_date,
468: created_by, last_update_date,
469: last_updated_by, last_update_login,
470: datatype_id, category_id,

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 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 496: INSERT INTO fnd_documents_tl (

492: INTO x_media_id
493: FROM dual;
494: END IF;
495:
496: INSERT INTO fnd_documents_tl (
497: document_id, creation_date,
498: created_by, last_update_date,
499: last_updated_by, last_update_login,
500: language, description,

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 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 636: UPDATE fnd_documents

632: END;
633:
634: get_category_id(x_usage_id, x_category_id);
635:
636: UPDATE fnd_documents
637: SET app_source_version = 'SO_R10',
638: category_id = x_category_id,
639: usage_type = DECODE(x_note_type_code,'OT','O',
640: DECODE(x_override_flag,'Y','T',

Line 646: UPDATE fnd_documents_tl

642: start_date_active = x_start_date_active,
643: end_date_active = x_end_date_active
644: WHERE document_id = p_document_id;
645:
646: UPDATE fnd_documents_tl
647: SET app_source_version = 'SO_R10',
648: description = x_name,
649: doc_attribute_category = x_context,
650: doc_attribute1 = x_attribute1,

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 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 699: DELETE FROM fnd_documents

695: BEGIN
696:
697: get_media_id (p_document_id, x_media_id, x_datatype_id);
698:
699: DELETE FROM fnd_documents
700: WHERE document_id = p_document_id;
701:
702: DELETE FROM fnd_documents_tl
703: WHERE document_id = p_document_id;

Line 702: DELETE FROM fnd_documents_tl

698:
699: DELETE FROM fnd_documents
700: WHERE document_id = p_document_id;
701:
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

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;

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;