APPS.FND_ATTACHED_DOCUMENTS_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 1: PACKAGE BODY fnd_attached_documents_pkg as

1: PACKAGE BODY fnd_attached_documents_pkg as
2: /* $Header: AFAKAADB.pls 120.3.12010000.2 2008/11/07 17:45:42 ctilley ship $ */
3:
4:
5: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,

Line 79: FROM fnd_attached_documents

75: tmp_rowid VARCHAR2(30);
76:
77:
78: CURSOR C IS SELECT rowid
79: FROM fnd_attached_documents
80: WHERE attached_document_id = X_attached_document_id;
81:
82: l_usage_type varchar2(1);
83: l_create_doc varchar2(1);

Line 149: INSERT INTO fnd_attached_documents (

145: X_title => X_title);
146:
147: END IF; -- done creating document
148:
149: INSERT INTO fnd_attached_documents (
150: attached_document_id,
151: document_id,
152: creation_date,
153: created_by,

Line 294: FROM fnd_attached_documents

290: X_url VARCHAR2 DEFAULT NULL,
291: X_title VARCHAR2 DEFAULT NULL) IS
292: CURSOR C IS
293: SELECT *
294: FROM fnd_attached_documents
295: WHERE rowid = X_Rowid
296: FOR UPDATE of attached_document_id NOWAIT;
297: Recinfo C%ROWTYPE;
298: BEGIN

Line 496: UPDATE fnd_attached_documents

492: X_title VARCHAR2 DEFAULT NULL) IS
493: BEGIN
494:
495: -- Update the attached_documents table
496: UPDATE fnd_attached_documents
497: SET attached_document_id = X_attached_document_id,
498: document_id = X_document_id,
499: last_update_date = X_last_update_date,
500: last_updated_by = X_last_updated_by,

Line 574: END fnd_attached_documents_pkg;

570: X_title => X_title);
571:
572: END update_row;
573:
574: END fnd_attached_documents_pkg;