DBA Data[Home] [Help]

APPS.PON_BID_DEFAULTING_PKG dependencies on FND_DOCUMENT_CATEGORIES

Line 3038: select (select category_id from fnd_document_categories

3034: -- if it is a new round, and two-part flag has changed...
3035: if (l_is_new_round = 'Y' AND (l_curr_two_part <> l_prev_two_part)) THEN -- {
3036: -- target category id needs to be changed
3037: -- fetch target category ids.
3038: select (select category_id from fnd_document_categories
3039: where name = pon_auction_pkg.g_supplier_attachment),
3040: (select category_id from fnd_document_categories
3041: where name = pon_auction_pkg.g_technical_attachment)
3042: into l_categ_id_supp, l_categ_id_supp_tech

Line 3040: (select category_id from fnd_document_categories

3036: -- target category id needs to be changed
3037: -- fetch target category ids.
3038: select (select category_id from fnd_document_categories
3039: where name = pon_auction_pkg.g_supplier_attachment),
3040: (select category_id from fnd_document_categories
3041: where name = pon_auction_pkg.g_technical_attachment)
3042: into l_categ_id_supp, l_categ_id_supp_tech
3043: from fnd_document_categories
3044: where ROWNUM = 1;

Line 3043: from fnd_document_categories

3039: where name = pon_auction_pkg.g_supplier_attachment),
3040: (select category_id from fnd_document_categories
3041: where name = pon_auction_pkg.g_technical_attachment)
3042: into l_categ_id_supp, l_categ_id_supp_tech
3043: from fnd_document_categories
3044: where ROWNUM = 1;
3045:
3046: -- if prev round was two part, copy attachments to "FromSupplier"
3047: if (l_prev_two_part = 'Y') THEN -- {