[Home] [Help]
940: /*
941: Bug 5938614 : UNABLE TO CREATE STANDARD PO FROM SOURCING RFQ WHEN MULTIPLE REQUISITIONS USED ,
942: This is because when we create a sourcing RFQ that combines 2 req lines from 2 different requisitions
943: which are having the one time attachement , and if we publish a negotiation then it is inserting 2 lines
944: into fnd_attached_documents with pk1_value as negotiation number,and pk2_value
945: as requisition line number.
946: Before this fix , At the time of PO Creation ,the one time address is being copied from
947: entity type 'PON_AUCTION_ITEM_PRICES_ALL' which is causing the problem.
948: For a single req line it is inserting two rows into fnd_attached_documents because
944: into fnd_attached_documents with pk1_value as negotiation number,and pk2_value
945: as requisition line number.
946: Before this fix , At the time of PO Creation ,the one time address is being copied from
947: entity type 'PON_AUCTION_ITEM_PRICES_ALL' which is causing the problem.
948: For a single req line it is inserting two rows into fnd_attached_documents because
949: the below cursor returning two rows while selecting from entity type 'PON_AUCTION_ITEM_PRICES_ALL'.
950:
951: Modified the query so that the one time attachments will be copied from entity type 'REQ_LINES' .
952:
974: fdvl.doc_attribute11 dattr11, fdvl.doc_attribute12 dattr12,
975: fdvl.doc_attribute13 dattr13, fdvl.doc_attribute14 dattr14,
976: fdvl.doc_attribute15 dattr15,
977: fdvl.title, fdvl.url -- Bug 5000065
978: FROM fnd_attached_documents fad,
979: fnd_documents_vl fdvl
980: WHERE fad.document_id = fdvl.document_id
981: AND fad.entity_name = X_from_entity_name
982: AND fad.pk1_value = X_from_pk1_value
1136: );
1137:
1138: -- overwrite document_id from original
1139: -- cursor for later insert into
1140: -- fnd_attached_documents
1141: docrec.document_id := document_id_tmp;
1142:
1143: -- Duplicate short or long text
1144: IF (docrec.datatype_id = 1) THEN
1222: END IF; -- end if usage_type = 'O' and datatype in (1,2,6)
1223:
1224: -- Create attachment record
1225: x_progress :='009';
1226: INSERT INTO fnd_attached_documents
1227: (attached_document_id,
1228: document_id,
1229: creation_date,
1230: created_by,
1243: attribute5, attribute6, attribute7,
1244: attribute8, attribute9, attribute10,
1245: attribute11, attribute12, attribute13,
1246: attribute14, attribute15, column1) VALUES
1247: (fnd_attached_documents_s.nextval,
1248: docrec.document_id,
1249: sysdate,
1250: NVL(X_created_by,0),
1251: sysdate,
1510: --Name: convert_text_to_attachment
1511: --Pre-reqs:
1512: -- None.
1513: --Modifies:
1514: -- FND_DOCUMENTS, FND_DOCUMENTS_LONG_TEXT, FND_ATTACHED_DOCUMENTS
1515: --Locks:
1516: -- None.
1517: --Function:
1518: -- Converts a LONG text to an Attachment.
1585: ( l_media_id
1586: , p_long_text
1587: );
1588:
1589: -- Insert into FND_ATTACHED_DOCUMENTS -------------------------------------
1590:
1591: SELECT max(seq_num)
1592: INTO l_seq_num
1593: FROM fnd_attached_documents
1589: -- Insert into FND_ATTACHED_DOCUMENTS -------------------------------------
1590:
1591: SELECT max(seq_num)
1592: INTO l_seq_num
1593: FROM fnd_attached_documents
1594: WHERE pk1_value = p_to_pk1_value
1595: AND entity_name = p_to_entity_name;
1596:
1597: l_seq_num := nvl(l_seq_num, 0) + 10;
1595: AND entity_name = p_to_entity_name;
1596:
1597: l_seq_num := nvl(l_seq_num, 0) + 10;
1598:
1599: INSERT INTO fnd_attached_documents
1600: ( attached_document_id
1601: , document_id
1602: , creation_date
1603: , created_by
1610: , automatically_added_flag
1611: , program_update_date
1612: )
1613: VALUES
1614: ( FND_ATTACHED_DOCUMENTS_S.nextval
1615: , l_document_id
1616: , nvl(p_who_rec.creation_date, sysdate)
1617: , nvl(p_who_rec.created_by, 0)
1618: , nvl(p_who_rec.last_update_date, sysdate)