[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,
1589: --Name: convert_text_to_attachment
1590: --Pre-reqs:
1591: -- None.
1592: --Modifies:
1593: -- FND_DOCUMENTS, FND_DOCUMENTS_LONG_TEXT, FND_ATTACHED_DOCUMENTS
1594: --Locks:
1595: -- None.
1596: --Function:
1597: -- Converts a LONG text to an Attachment.
1673: ( l_media_id
1674: , p_long_text
1675: );
1676:
1677: -- Insert into FND_ATTACHED_DOCUMENTS -------------------------------------
1678:
1679: SELECT max(seq_num)
1680: INTO l_seq_num
1681: FROM fnd_attached_documents
1677: -- Insert into FND_ATTACHED_DOCUMENTS -------------------------------------
1678:
1679: SELECT max(seq_num)
1680: INTO l_seq_num
1681: FROM fnd_attached_documents
1682: WHERE pk1_value = p_to_pk1_value
1683: AND entity_name = p_to_entity_name;
1684:
1685: l_seq_num := nvl(l_seq_num, 0) + 10;
1683: AND entity_name = p_to_entity_name;
1684:
1685: l_seq_num := nvl(l_seq_num, 0) + 10;
1686:
1687: INSERT INTO fnd_attached_documents
1688: ( attached_document_id
1689: , document_id
1690: , creation_date
1691: , created_by
1699: , automatically_added_flag
1700: , program_update_date
1701: )
1702: VALUES
1703: ( FND_ATTACHED_DOCUMENTS_S.nextval
1704: , l_document_id
1705: , nvl(p_who_rec.creation_date, sysdate)
1706: , nvl(p_who_rec.created_by, 0)
1707: , nvl(p_who_rec.last_update_date, sysdate)
1729: --Name: convert_text_to_attach_clob
1730: --Pre-reqs:
1731: -- None.
1732: --Modifies:
1733: -- FND_DOCUMENTS, FND_LOBS, FND_ATTACHED_DOCUMENTS
1734: --Locks:
1735: -- None.
1736: --Function:
1737: -- Converts a CLOB to an Attachment.
1833: SYSDATE,
1834: userenv('LANG'),
1835: l_file_charset,
1836: l_file_format);
1837: -- Insert into FND_ATTACHED_DOCUMENTS -------------------------------------
1838: SELECT max(seq_num)
1839: INTO l_seq_num
1840: FROM fnd_attached_documents
1841: WHERE pk1_value = p_to_pk1_value
1836: l_file_format);
1837: -- Insert into FND_ATTACHED_DOCUMENTS -------------------------------------
1838: SELECT max(seq_num)
1839: INTO l_seq_num
1840: FROM fnd_attached_documents
1841: WHERE pk1_value = p_to_pk1_value
1842: AND entity_name = p_to_entity_name;
1843: l_seq_num := nvl(l_seq_num, 0) + 10;
1844: INSERT INTO fnd_attached_documents
1840: FROM fnd_attached_documents
1841: WHERE pk1_value = p_to_pk1_value
1842: AND entity_name = p_to_entity_name;
1843: l_seq_num := nvl(l_seq_num, 0) + 10;
1844: INSERT INTO fnd_attached_documents
1845: ( attached_document_id
1846: , document_id
1847: , creation_date
1848: , created_by
1856: , automatically_added_flag
1857: , program_update_date
1858: )
1859: VALUES
1860: ( FND_ATTACHED_DOCUMENTS_S.nextval
1861: , l_document_id
1862: , nvl(p_who_rec.creation_date, sysdate)
1863: , nvl(p_who_rec.created_by, 0)
1864: , nvl(p_who_rec.last_update_date, sysdate)