[Home] [Help]
223: -- have no effect.
224:
225: v_bidders_currency_rate NUMBER := 1;
226: v_att_category_id fnd_document_categories.category_id%TYPE;
227: v_seq_num fnd_attached_documents.seq_num%TYPE;
228: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;
229: v_amount_based_lines NUMBER;
230:
231: v_contracts_doctype VARCHAR2(60);
1815: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1816: 'Copying over the (Line) attachments from the PON_ATTACHMENTS_INTERFACE table' );
1817: end if;
1818:
1819: INSERT INTO fnd_attached_documents
1820: ( attached_document_id,
1821: document_id,
1822: creation_date,
1823: created_by,
1833: pk5_value,
1834: automatically_added_flag,
1835: column1
1836: )
1837: SELECT fnd_attached_documents_s.nextval, -- attached_document_id
1838: document_id, -- document_id,
1839: Sysdate, -- creation_date
1840: g_header_rec.user_id, -- created_by
1841: Sysdate, -- last_update_date
1868: UPDATE pon_auction_item_prices_all
1869: SET attachment_flag = 'Y'
1870: WHERE auction_header_id = x_document_number
1871: AND line_number IN (SELECT to_number(pk2_value)
1872: FROM fnd_attached_documents
1873: WHERE entity_name = 'PON_AUCTION_ITEM_PRICES_ALL'
1874: AND pk1_value = to_char(x_document_number))
1875: AND line_number >= l_batch_start
1876: AND line_number <= l_batch_end;
1993: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1994: 'Copying over the (header)attachments from the PON_ATTACHMENTS_INTERFACE table' );
1995: end if;
1996:
1997: INSERT INTO fnd_attached_documents
1998: ( attached_document_id,
1999: document_id,
2000: creation_date,
2001: created_by,
2012: automatically_added_flag,
2013: column1
2014: )
2015: SELECT
2016: fnd_attached_documents_s.nextval, -- attached_document_id
2017: document_id, -- document_id,
2018: Sysdate, -- creation_date
2019: g_header_rec.user_id, -- created_by
2020: Sysdate, -- last_update_date