2722: if (l_is_new_round = 'Y' AND (l_curr_two_part <> l_prev_two_part)) THEN -- {
2723: -- target category id needs to be changed
2724: -- fetch target category ids.
2725: select (select category_id from fnd_document_categories
2726: where name = pon_auction_pkg.g_supplier_attachment),
2727: (select category_id from fnd_document_categories
2728: where name = pon_auction_pkg.g_technical_attachment)
2729: into l_categ_id_supp, l_categ_id_supp_tech
2730: from fnd_document_categories
2724: -- fetch target category ids.
2725: select (select category_id from fnd_document_categories
2726: where name = pon_auction_pkg.g_supplier_attachment),
2727: (select category_id from fnd_document_categories
2728: where name = pon_auction_pkg.g_technical_attachment)
2729: into l_categ_id_supp, l_categ_id_supp_tech
2730: from fnd_document_categories
2731: where ROWNUM = 1;
2732: