APPS.SO_ATT dependencies on FND_ATTACHED_DOCUMENTS

Line 750: x_entity_name fnd_attached_documents.entity_name%TYPE;

746: p_attached_document_id IN OUT NUMBER
747: ) IS
748:
749: x_document_id NUMBER;
750: x_entity_name fnd_attached_documents.entity_name%TYPE;
751:
752: BEGIN
753:
754: SELECT document_id

Line 761: SELECT fnd_attached_documents_s.nextval

757: WHERE note_id = p_note_id;
758:
759: x_entity_name := get_entity_name(p_header_id, p_line_id);
760:
761: SELECT fnd_attached_documents_s.nextval
762: INTO p_attached_document_id
763: FROM dual;
764:
765: INSERT INTO fnd_attached_documents (

Line 765: INSERT INTO fnd_attached_documents (

761: SELECT fnd_attached_documents_s.nextval
762: INTO p_attached_document_id
763: FROM dual;
764:
765: INSERT INTO fnd_attached_documents (
766: attached_document_id, document_id,
767: creation_date, created_by,
768: last_update_date, last_updated_by,
769: last_update_login, seq_num,

Line 848: UPDATE fnd_attached_documents

844: FROM so_notes
845: WHERE note_id = p_note_id;
846:
847: -- you can only update flex fields and sequence number.
848: UPDATE fnd_attached_documents
849: SET last_update_date = SYSDATE,
850: seq_num = p_sequence_number,
851: document_id = x_document_id,
852: attribute_category = p_context,

Line 879: DELETE FROM fnd_attached_documents

875: ) IS
876:
877: BEGIN
878:
879: DELETE FROM fnd_attached_documents
880: WHERE attached_document_id = p_attached_document_id;
881:
882: END;
883: