254:
255: CURSOR c_check_item_phase_status(cp_phase_id NUMBER
256: ,cp_status_code VARCHAR2)IS
257: SELECT 'Y'
258: FROM DUAL
259: WHERE EXISTS ( SELECT NULL
260: FROM mtl_item_Catalog_groups_b
261: WHERE NVL(NEW_ITEM_REQUEST_REQD,'N') = 'Y'
262: AND item_Catalog_group_id = P_Catalog_Group_Id)
350: Cursor c_check_item_phase_status
351: (cp_phase_id NUMBER
352: ,cp_status_code VARCHAR2)IS
353: SELECT 'Y'
354: FROM DUAL
355: WHERE EXISTS ( SELECT NULL
356: FROM mtl_system_items_b
357: WHERE inventory_item_id = P_Item_Id
358: AND organization_id = P_Org_Id
755: , cp_catalog_group_id IN NUMBER
756: )
757: IS
758: SELECT 'Y'
759: FROM DUAL
760: WHERE EXISTS ( SELECT NULL
761: FROM mtl_item_Catalog_groups_b
762: WHERE NVL(NEW_ITEM_REQUEST_REQD,'N') = 'Y'
763: AND item_Catalog_group_id = cp_catalog_group_id
2904:
2905: IF (INV_ITEM_UTIL.APPL_INST_EGO <> 0) THEN
2906: EXECUTE IMMEDIATE
2907: 'SELECT count(*)
2908: FROM dual
2909: WHERE EXISTS(SELECT 1 FROM ego_cat_grp_templates
2910: WHERE template_id = :p_template_id)'
2911: INTO l_template_exists
2912: USING p_template_id;