DBA Data[Home] [Help]

APPS.PON_BID_DEFAULTING_PKG dependencies on FND_DOCUMENT_CATEGORIES

Line 2725: select (select category_id from fnd_document_categories

2721: -- if it is a new round, and two-part flag has changed...
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

Line 2727: (select category_id from fnd_document_categories

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
2731: where ROWNUM = 1;

Line 2730: 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:
2733: -- if prev round was two part, copy attachments to "FromSupplier"
2734: if (l_prev_two_part = 'Y') THEN -- {