APPS.SO_ATT dependencies on FND_DOCUMENTS_TL

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 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 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 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 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