APPS.PO_ATT dependencies on FND_ATTACHED_DOCUMENTS

Line 91: FROM fnd_attached_documents

87: 'MTL_SYSTEM_ITEMS', 'MTL_SYSTEM_ITEMS',
88: 'PO_VENDORS', 'PO_VENDORS',
89: 'NOT_PO_TABLE' )
90: INTO x_table_name
91: FROM fnd_attached_documents
92: WHERE document_id = p_document_id
93: AND rownum < 2; -- make sure zero or one record returned
94:
95: EXCEPTION

Line 152: FROM fnd_attached_documents

148: 'MTL_SYSTEM_ITEMS', 'INVENTORY_ITEM_ID',
149: 'PO_VENDORS', 'VENDOR_ID',
150: 'NOT_PO_COLUMN' )
151: INTO x_column_name
152: FROM fnd_attached_documents
153: WHERE document_id = p_document_id
154: AND rownum < 2;
155:
156: EXCEPTION

Line 704: x_entity_name fnd_attached_documents.entity_name%TYPE;

700: p_attached_doc_id OUT NOCOPY NUMBER
701: ) IS
702:
703: x_document_id NUMBER;
704: x_entity_name fnd_attached_documents.entity_name%TYPE;
705:
706: BEGIN
707:
708: SELECT document_id

Line 715: SELECT fnd_attached_documents_s.nextval

711: WHERE po_note_id = p_po_note_id;
712:
713: x_entity_name := get_entity_name ( p_table_name );
714:
715: SELECT fnd_attached_documents_s.nextval
716: INTO p_attached_doc_id
717: FROM sys.dual;
718:
719: INSERT INTO fnd_attached_documents (

Line 719: INSERT INTO fnd_attached_documents (

715: SELECT fnd_attached_documents_s.nextval
716: INTO p_attached_doc_id
717: FROM sys.dual;
718:
719: INSERT INTO fnd_attached_documents (
720: attached_document_id, document_id,
721: creation_date, created_by,
722: last_update_date, last_updated_by,
723: last_update_login, seq_num,

Line 782: x_entity_name fnd_attached_documents.entity_name%TYPE;

778: p_attached_doc_id OUT NOCOPY NUMBER
779: ) IS
780:
781: x_document_id NUMBER;
782: x_entity_name fnd_attached_documents.entity_name%TYPE;
783: x_organization_id NUMBER;
784:
785: BEGIN
786:

Line 794: SELECT fnd_attached_documents_s.nextval

790: WHERE po_note_id = p_po_note_id;
791:
792: x_entity_name := get_entity_name ( p_table_name );
793:
794: SELECT fnd_attached_documents_s.nextval
795: INTO p_attached_doc_id
796: FROM sys.dual;
797:
798: /* MDAS In multi org scenario, this may fetch more than one row - Watch out */

Line 812: INSERT INTO fnd_attached_documents (

808: IF (x_organization_id = -1) THEN
809: NULL;
810: ELSE
811:
812: INSERT INTO fnd_attached_documents (
813: attached_document_id, document_id,
814: creation_date, created_by,
815: last_update_date, last_updated_by,
816: last_update_login, seq_num,

Line 887: UPDATE fnd_attached_documents

883: FROM po_notes
884: WHERE po_note_id = p_po_note_id;
885:
886: -- you can only update flex fields and sequence number.
887: UPDATE fnd_attached_documents
888: SET last_update_date = SYSDATE,
889: seq_num = p_sequence_num,
890: document_id = x_document_id,
891: attribute_category = p_attribute_category,

Line 918: DELETE FROM fnd_attached_documents

914: ) IS
915:
916: BEGIN
917:
918: DELETE FROM fnd_attached_documents
919: WHERE attached_document_id = p_attached_doc_id;
920:
921: END;
922: