APPS.OE_FND_ATTACHMENTS_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 548: from fnd_attached_documents

544: /*6896311
545: BEGIN
546: select 1
547: into l_attachment_exist
548: from fnd_attached_documents
549: where entity_name = p_entity_name
550: and pk1_value = p_pk1_value
551: and nvl(pk2_value,'NULL') = nvl(p_pk2_value,'NULL')
552: and nvl(pk3_value,'NULL') = nvl(p_pk3_value,'NULL')

Line 588: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS

584:
585: IF l_need_delete_insert THEN
586: 6896311*/
587:
588: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS
589: (x_entity_name => p_entity_name
590: ,x_pk1_value => p_pk1_value
591: ,x_pk2_value => p_pk2_value
592: ,x_pk3_value => p_pk3_value

Line 800: from fnd_attached_documents

796: -- the attached document id to be passed to the AOL API
797:
798: select (nvl(max(seq_num),0) + 10)
799: into l_seq_num
800: from fnd_attached_documents
801: where entity_name = p_entity_name
802: and pk1_value = p_pk1_value;
803:
804: select fnd_attached_documents_s.nextval

Line 804: select fnd_attached_documents_s.nextval

800: from fnd_attached_documents
801: where entity_name = p_entity_name
802: and pk1_value = p_pk1_value;
803:
804: select fnd_attached_documents_s.nextval
805: into l_attached_document_id
806: from dual;
807: --Code changes made to fix bug 1903257 Begin
808: begin

Line 836: FND_ATTACHED_DOCUMENTS_PKG.INSERT_ROW

832: end;
833: --Code changes made to fix bug 1903257 End
834: -- included a new parameter X_Create_doc below to fix bug 1903257
835:
836: FND_ATTACHED_DOCUMENTS_PKG.INSERT_ROW
837: (x_rowid => l_rowid
838: , x_attached_document_id => l_attached_document_id
839: , x_document_id => l_document_id
840: , x_seq_num => l_seq_num

Line 964: FND_ATTACHED_DOCUMENTS2_PKG.Delete_Attachments

960: BEGIN
961:
962: x_return_status := FND_API.G_RET_STS_SUCCESS;
963:
964: FND_ATTACHED_DOCUMENTS2_PKG.Delete_Attachments
965: (x_entity_name => p_entity_name
966: ,x_pk1_value => p_pk1_value
967: ,x_pk2_value => p_pk2_value
968: ,x_pk3_value => p_pk3_value