APPS.PO_ATT dependencies on FND_DOCUMENTS_TL

Line 257: FROM fnd_documents_tl fdt,

253: BEGIN
254:
255: SELECT fd.datatype_id, fd.media_id
256: INTO p_datatype_id, p_media_id
257: FROM fnd_documents_tl fdt,
258: fnd_documents fd
259: WHERE fdt.language = userenv('LANG')
260: AND fdt.document_id = fd.document_id
261: AND fd.document_id = p_document_id;

Line 275: FROM fnd_documents_tl fdt,

271: BEGIN
272:
273: SELECT fd.document_id
274: INTO p_document_id
275: FROM fnd_documents_tl fdt,
276: fnd_documents fd
277: WHERE fd.media_id = p_media_id
278: AND fdt.document_id = fd.document_id
279: AND fd.datatype_id = decode (p_datatype_id, 'S', 1, 2) --short/long

Line 460: INSERT INTO fnd_documents_tl (

456: x_note_type, p_app_source_version,
457: NULL, x_media_id
458: );
459:
460: INSERT INTO fnd_documents_tl (
461: document_id, creation_date,
462: created_by, last_update_date,
463: last_updated_by, last_update_login,
464: language, description,

Line 606: UPDATE fnd_documents_tl

602: SET app_source_version = 'PO_R10',
603: category_id = x_category_id
604: WHERE document_id = x_document_id;
605:
606: UPDATE fnd_documents_tl
607: SET app_source_version = 'PO_R10',
608: description = x_title,
609: doc_attribute_category = x_attribute_category,
610: doc_attribute1 = x_attribute1,

Line 661: DELETE FROM fnd_documents_tl

657:
658: DELETE FROM fnd_documents
659: WHERE document_id = p_document_id;
660:
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