eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PCO_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 10: In case match is not found, an additional step is performed to insert data into fnd_documents and fnd_attached_documents

6: Type : Public
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: ========== ==== ======== =======================

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 88: new records into fnd_documents and fnd_attached_documents.

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: */
92: if p_file_id is null then

Line 141: select fnd_attached_documents_s.nextval

137: , 'binary');
138:
139: pa_debug.debug('400: After Insertion into fnd_lobs ');
140:
141: select fnd_attached_documents_s.nextval
142: into l_attached_document_id
143: from dual;
144:
145:

Line 147: Only in that case, there is a need to insert records into fnd_documents and fnd_attached_documents

143: from dual;
144:
145:
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:

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;

Line 217: and then checks for existence in fnd_documents and fnd_attached_documents.

213: /*
214: Procedure : get_attachment_file_id
215: Type : Public
216: Purpose : This procedure returns the file_id of the FND attachment. It accepts the primary key values
217: and then checks for existence in fnd_documents and fnd_attached_documents.
218:
219: Parameters Type Required Description and Purpose
220: ========== ==== ======== =======================
221: p_entity_name NUMBER YES identifier in FND_LOBS

Line 248: fnd_attached_documents ad

244:
245: select media_id
246: into l_file_id
247: from fnd_documents doc,
248: fnd_attached_documents ad
249: where ad.document_id = doc.document_id
250: and ad.entity_name = p_entity_name
251: and nvl(ad.pk1_value,'-99') = nvl(p_pk1_value,nvl(ad.pk1_value,'-99'))
252: and nvl(ad.pk2_value,'-99') = nvl(p_pk2_value,nvl(ad.pk2_value,'-99'))