APPS.ASO_ATTACHMENT_INT dependencies on FND_ATTACHED_DOCUMENTS

Line 313: l_entity_name FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE;

309: l_api_version CONSTANT NUMBER := 1.0;
310:
311: l_media_id NUMBER;
312: l_document_id NUMBER;
313: l_entity_name FND_ATTACHED_DOCUMENTS.ENTITY_NAME%TYPE;
314:
315: /* 2633826 - hyang: added checking of p_quote_header_id */
316: CURSOR c_get_media_id (l_attachment_id varchar2) IS
317: SELECT a.media_id, b.document_id

Line 318: FROM FND_ATTACHED_DOCUMENTS b

314:
315: /* 2633826 - hyang: added checking of p_quote_header_id */
316: CURSOR c_get_media_id (l_attachment_id varchar2) IS
317: SELECT a.media_id, b.document_id
318: FROM FND_ATTACHED_DOCUMENTS b
319: ,FND_DOCUMENTS_TL a
320: WHERE a.document_id = b.document_id
321: AND b.attached_document_id = l_attachment_id
322: AND b.pk1_value = p_quote_header_id

Line 327: FROM FND_ATTACHED_DOCUMENTS a

323: AND b.entity_name = 'ASO_QUOTE_HEADERS_ALL';
324:
325: CURSOR c_get_document_id_rows (p_document_id number) IS
326: SELECT a.document_id
327: FROM FND_ATTACHED_DOCUMENTS a
328: WHERE a.document_id = p_document_id
329: AND a.pk1_value <> p_quote_header_id;
330: --AND a.entity_name <> 'ASO_QUOTE_HEADERS_ALL';
331:

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

403:
404: CLOSE c_get_media_id;
405:
406: -- Call the procedure to delete the attachment and document.
407: FND_ATTACHED_DOCUMENTS3_PKG.delete_row ( p_quote_attachment_ids(i),
408: '6', 'N' );
409:
410: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
411: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Check to see if the attachment was from an Opportunity...', 1, 'Y');

Line 581: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(

577: aso_debug_pub.add('COPY_ATTACHMENTS: old_object_id: ' || p_old_object_id, 1, 'N');
578: aso_debug_pub.add('COPY_ATTACHMENTS: new_object_id: ' || p_new_object_id, 1, 'N');
579: END IF;
580:
581: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(
582: x_from_entity_name => p_old_object_code,
583: x_from_pk1_value => to_char(p_old_object_id),
584: x_to_entity_name => p_new_object_code,
585: x_to_pk1_value => to_char(p_new_object_id),