APPS.ICX_CAT_POPULATE_CATG_PVT dependencies on ICX_CAT_BUILD_CTX_SQL_PVT

Line 450: ICX_CAT_BUILD_CTX_SQL_PVT.checkIfAttributeIsSrchble

446:
447: l_err_loc := 800;
448: IF (l_searchable IS NULL) THEN
449: l_err_loc := 900;
450: ICX_CAT_BUILD_CTX_SQL_PVT.checkIfAttributeIsSrchble
451: ('SHOPPING_CATEGORY', l_searchable, l_section_tag);
452: END IF;
453:
454: l_err_loc := 1000;

Line 468: WHERE sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow

464: AND hdrs.req_template_line_num = dtls.req_template_line_num
465: AND hdrs.inventory_item_id = dtls.inventory_item_id
466: AND hdrs.org_id = dtls.org_id
467: AND hdrs.language = dtls.language)
468: WHERE sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow
469: AND EXISTS ( SELECT 'x' FROM icx_cat_items_ctx_hdrs_tlp hdrs
470: WHERE hdrs.po_line_id = dtls.po_line_id
471: AND hdrs.req_template_name = dtls.req_template_name
472: AND hdrs.req_template_line_num = dtls.req_template_line_num