547: FROM pon_auction_item_prices_ext_b
548: WHERE line_Number IN ( select column_value from table(p_dest_line_ids_tbl))
549: AND auction_header_id = p_auction_header_id;
550:
551: LOG_MESSAGE(l_module,'About to insert into pon_auction_item_prices_ext_tl ');
552:
553: FORALL i IN 1..extension_id_tbl.Count
554: INSERT INTO pon_auction_item_prices_ext_tl
555: (
550:
551: LOG_MESSAGE(l_module,'About to insert into pon_auction_item_prices_ext_tl ');
552:
553: FORALL i IN 1..extension_id_tbl.Count
554: INSERT INTO pon_auction_item_prices_ext_tl
555: (
556: EXTENSION_ID,
557: ATTR_GROUP_ID,
558: line_number,
585:
586: FROM FND_LANGUAGES L
587: WHERE L.INSTALLED_FLAG in ('I', 'B')
588: AND NOT EXISTS
589: (SELECT 1 FROM pon_auction_item_prices_ext_tl pltl WHERE
590: pltl.extension_id = extension_id_tbl(i)
591: AND pltl.LANGUAGE = L.LANGUAGE_CODE);
592:
593: LOG_MESSAGE(l_module,'Inserted into pon_auction_item_prices_ext_tl ');
589: (SELECT 1 FROM pon_auction_item_prices_ext_tl pltl WHERE
590: pltl.extension_id = extension_id_tbl(i)
591: AND pltl.LANGUAGE = L.LANGUAGE_CODE);
592:
593: LOG_MESSAGE(l_module,'Inserted into pon_auction_item_prices_ext_tl ');
594:
595: DELETE FROM pon_auction_item_prices_ext_b WHERE line_Number = p_src_line_number
596: AND auction_header_id = p_auction_header_id;
597: