APPS.PA_PCO_PKG dependencies on FND_ATTACHED_DOCUMENTS_PKG

Line 11: also. This is done by calling fnd_attached_documents_pkg.Insert_Row.

7: Purpose : This procedure first checks for the existance of a record in FND_LOBS for the passed primary_key values.
8: In this case, p_CR_id and p_CR_version_number form the primary key.
9: If a record is found, then only the data in FND_LOBS is deleted, and reinserted with empty_blob.
10: In case match is not found, an additional step is performed to insert data into fnd_documents and fnd_attached_documents
11: also. This is done by calling fnd_attached_documents_pkg.Insert_Row.
12:
13: Parameters Type Required Description and Purpose
14: ========== ==== ======== =======================
15: p_doc_category_name VARCHAR YES identifier in FND_LOBS

Line 87: Next value of X_media_id is derived, and l_call_Insert_Row is set to True to invoke fnd_attached_documents_pkg.Insert_Row to insert

83: null,
84: p_file_id);
85:
86: /* if p_file_id is returned as Null, it means attachments have not been created for this version of the change request.
87: Next value of X_media_id is derived, and l_call_Insert_Row is set to True to invoke fnd_attached_documents_pkg.Insert_Row to insert
88: new records into fnd_documents and fnd_attached_documents.
89:
90: Otherwise p_file_id conatins the file_id of the existing attachment, which is then deleted and record is inserted only into FND_LOBS.
91: */

Line 150: pa_debug.debug('500: Calling fnd_attached_documents_pkg.Insert_Row');

146: /* l_call_Insert_Row would be true only if its the first call for this version of the change request to create an attachment.
147: Only in that case, there is a need to insert records into fnd_documents and fnd_attached_documents
148: */
149: if (l_call_Insert_Row) then
150: pa_debug.debug('500: Calling fnd_attached_documents_pkg.Insert_Row');
151:
152: fnd_attached_documents_pkg.Insert_Row(
153: X_Rowid => X_Rowid
154: , X_attached_document_id => l_attached_document_id

Line 152: fnd_attached_documents_pkg.Insert_Row(

148: */
149: if (l_call_Insert_Row) then
150: pa_debug.debug('500: Calling fnd_attached_documents_pkg.Insert_Row');
151:
152: fnd_attached_documents_pkg.Insert_Row(
153: X_Rowid => X_Rowid
154: , X_attached_document_id => l_attached_document_id
155: , X_document_id => X_document_id
156: , X_creation_date => SYSDATE

Line 196: pa_debug.debug('600: After call to fnd_attached_documents_pkg.Insert_Row ');

192: , X_doc_attribute14 => NULL
193: , X_doc_attribute15 => NULL
194: );
195:
196: pa_debug.debug('600: After call to fnd_attached_documents_pkg.Insert_Row ');
197:
198: else
199: pa_debug.debug('700: Attachment records exist already, so not creating fresh records ');
200: end if;