APPS.PVX_ATTACHMENT_INT dependencies on FND_ATTACHED_DOCUMENTS

Line 181: l_entity_name FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE;

177: l_api_version CONSTANT NUMBER := 1.0;
178:
179: l_media_id NUMBER;
180: l_document_id NUMBER;
181: l_entity_name FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE;
182:
183: /* 2633826 - hyang: added checking of p_quote_header_id */
184: CURSOR c_get_media_id (l_attachment_id varchar2) IS
185: SELECT a.media_id, b.document_id

Line 186: FROM FND_ATTACHED_DOCUMENTS b

182:
183: /* 2633826 - hyang: added checking of p_quote_header_id */
184: CURSOR c_get_media_id (l_attachment_id varchar2) IS
185: SELECT a.media_id, b.document_id
186: FROM FND_ATTACHED_DOCUMENTS b
187: ,FND_DOCUMENTS_TL a
188: WHERE a.document_id = b.document_id
189: AND b.attached_document_id = l_attachment_id
190: AND b.pk1_value = p_quote_header_id

Line 195: FROM FND_ATTACHED_DOCUMENTS a

191: AND b.entity_name = 'PVATTACH';
192:
193: CURSOR c_get_document_id_rows (p_document_id number) IS
194: SELECT a.document_id
195: FROM FND_ATTACHED_DOCUMENTS a
196: WHERE a.document_id = p_document_id
197: AND a.pk1_value <> p_quote_header_id;
198: --AND a.entity_name <> 'ASO_QUOTE_HEADERS_ALL';
199:

Line 275: FND_ATTACHED_DOCUMENTS3_PKG.delete_row ( p_quote_attachment_ids(i),

271:
272: CLOSE c_get_media_id;
273:
274: -- Call the procedure to delete the attachment and document.
275: FND_ATTACHED_DOCUMENTS3_PKG.delete_row ( p_quote_attachment_ids(i),
276: '6', 'N' );
277:
278: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
279: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Check to see if the attachment was from an Opportunity...', 1, 'Y');