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 799: from fnd_attached_documents

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

Line 803: select fnd_attached_documents_s.nextval

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

Line 835: FND_ATTACHED_DOCUMENTS_PKG.INSERT_ROW

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

Line 962: FND_ATTACHED_DOCUMENTS2_PKG.Delete_Attachments

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