DBA Data[Home] [Help]

APPS.EGO_WF_WRAPPER_PVT dependencies on MTL_CATEGORY_SETS_B

Line 562: FROM mtl_category_sets_b

558: IF p_catalog_id IS NOT NULL THEN
559: BEGIN
560: SELECT raise_item_cat_assign_event, raise_alt_cat_hier_chg_event, raise_catalog_cat_chg_event
561: INTO l_raise_item_cat_assign, l_raise_alt_cat_hier_chg, l_raise_catalog_cat_chg
562: FROM mtl_category_sets_b
563: WHERE category_set_id = p_catalog_id;
564:
565: IF l_event_name = 'oracle.apps.ego.item.postCatalogAssignmentChange' AND l_raise_item_cat_assign = 'Y' THEN
566: WF_EVENT.Raise( p_event_name => l_event_name

Line 652: FROM mtl_category_sets_b

648: IF p_category_set_id IS NOT NULL THEN
649: BEGIN
650: SELECT raise_item_cat_assign_event, raise_alt_cat_hier_chg_event, raise_catalog_cat_chg_event
651: INTO l_raise_item_cat_assign, l_raise_alt_cat_hier_chg, l_raise_catalog_cat_chg
652: FROM mtl_category_sets_b
653: WHERE category_set_id = p_category_set_id;
654:
655: IF l_event_name = 'oracle.apps.ego.item.postCatalogAssignmentChange' AND l_raise_item_cat_assign = 'Y' THEN
656: WF_EVENT.Raise( p_event_name => l_event_name