DBA Data[Home] [Help]

APPS.RCV_ASN_ATTACHMENT_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 39: from fnd_attached_documents fad,

35:
36:
37: CURSOR l_asn_attach_id_cur IS
38: select rti.asn_attach_id,rti.created_by,rti.last_update_login
39: from fnd_attached_documents fad,
40: rcv_transactions_interface rti
41: where rti.interface_transaction_id = p_interface_txn_id
42: and rti.asn_attach_id is not null
43: and to_char(rti.asn_attach_id) = fad.PK1_value

Line 81: fnd_attached_documents2_pkg.copy_attachments(

77: /* If Attachment exist for the line then call FND api to copy attachments. */
78: if (l_asn_attach_id <> 0) then
79:
80: BEGIN
81: fnd_attached_documents2_pkg.copy_attachments(
82: X_from_entity_name => 'ASN_ATTACH',
83: X_from_pk1_value => to_char(l_asn_attach_id),
84: X_to_entity_name => 'RCV_LINES',
85: X_to_pk1_value => to_char(p_shipment_line_id),

Line 232: FND_ATTACHED_DOCUMENTS FAD

228:
229: CURSOR l_doctype_cur IS
230: SELECT FD.datatype_id
231: FROM FND_DOCUMENTS FD,
232: FND_ATTACHED_DOCUMENTS FAD
233: WHERE FAD.entity_name = 'ASN_ATTACH'
234: AND FAD.pk1_value = to_char(p_asn_attach_id)
235: AND FD.document_id = FAD.document_id;
236:

Line 280: fnd_attached_documents2_pkg.delete_attachments(

276: l_delete_doc_flag := 'N';
277: END IF;
278:
279: BEGIN
280: fnd_attached_documents2_pkg.delete_attachments(
281: X_entity_name => 'ASN_ATTACH',
282: X_pk1_value => to_char(p_asn_attach_id),
283: X_delete_document_flag => l_delete_doc_flag);
284: