DBA Data[Home] [Help]

APPS.OKC_CDRL_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 64: FROM fnd_attached_documents att

60: CURSOR cur_attach (cdrl_id VARCHAR2)
61: IS
62: SELECT att.attached_document_id
63: ,doc.datatype_id
64: FROM fnd_attached_documents att
65: ,fnd_documents doc
66: WHERE att.document_id = doc.document_id
67: AND att.entity_name = OKC_DELIVERABLE_PROCESS_PVT.G_ENTITY_NAME
68: AND att.pk1_value = cdrl_id;

Line 95: fnd_attached_documents3_pkg.delete_row (

91: -- Delete attachments by calling attachment API for each deliverable.
92: FOR j IN 1..attach_doc_id_tbl.Count
93: LOOP
94: BEGIN
95: fnd_attached_documents3_pkg.delete_row (
96: X_attached_document_id => attach_doc_id_tbl(j),
97: X_datatype_id => datatype_id_tbl(j),
98: delete_document_flag => 'Y' );
99: EXCEPTION

Line 564: fnd_attached_documents2_pkg.copy_attachments(

560: IF OKC_DELIVERABLE_PROCESS_PVT.attachment_exists(
561: p_entity_name => OKC_DELIVERABLE_PROCESS_PVT.G_ENTITY_NAME
562: ,p_pk1_value => old_del_id_tbl(i)
563: ) THEN
564: fnd_attached_documents2_pkg.copy_attachments(
565: X_from_entity_name => OKC_DELIVERABLE_PROCESS_PVT.G_ENTITY_NAME,
566: X_from_pk1_value => To_Char(old_del_id_tbl(i)),
567: X_to_entity_name => OKC_DELIVERABLE_PROCESS_PVT.G_ENTITY_NAME,
568: X_to_pk1_value => to_char(new_del_id_tbl(i)),