[Home] [Help]
205: -- have no effect.
206:
207: v_bidders_currency_rate NUMBER := 1;
208: v_att_category_id fnd_document_categories.category_id%TYPE;
209: v_seq_num fnd_attached_documents.seq_num%TYPE;
210: v_uom_code pon_auction_item_prices_all.uom_code%TYPE;
211: v_amount_based_lines NUMBER;
212:
213: v_contracts_doctype VARCHAR2(60);
1391: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1392: 'Copying over the (Line) attachments from the PON_ATTACHMENTS_INTERFACE table' );
1393: end if;
1394:
1395: INSERT INTO fnd_attached_documents
1396: ( attached_document_id,
1397: document_id,
1398: creation_date,
1399: created_by,
1409: pk5_value,
1410: automatically_added_flag,
1411: column1
1412: )
1413: SELECT fnd_attached_documents_s.nextval, -- attached_document_id
1414: document_id, -- document_id,
1415: Sysdate, -- creation_date
1416: g_header_rec.user_id, -- created_by
1417: Sysdate, -- last_update_date
1444: UPDATE pon_auction_item_prices_all
1445: SET attachment_flag = 'Y'
1446: WHERE auction_header_id = x_document_number
1447: AND line_number IN (SELECT to_number(pk2_value)
1448: FROM fnd_attached_documents
1449: WHERE entity_name = 'PON_AUCTION_ITEM_PRICES_ALL'
1450: AND pk1_value = to_char(x_document_number))
1451: AND line_number >= l_batch_start
1452: AND line_number <= l_batch_end;
1508: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
1509: 'Copying over the (header)attachments from the PON_ATTACHMENTS_INTERFACE table' );
1510: end if;
1511:
1512: INSERT INTO fnd_attached_documents
1513: ( attached_document_id,
1514: document_id,
1515: creation_date,
1516: created_by,
1527: automatically_added_flag,
1528: column1
1529: )
1530: SELECT
1531: fnd_attached_documents_s.nextval, -- attached_document_id
1532: document_id, -- document_id,
1533: Sysdate, -- creation_date
1534: g_header_rec.user_id, -- created_by
1535: Sysdate, -- last_update_date