DBA Data[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_ITEM_TYPES

Line 4546: UPDATE cz_item_types

4542: -----------------------
4543: -- delete the item type
4544: -----------------------
4545:
4546: UPDATE cz_item_types
4547: SET deleted_flag ='1'
4548: WHERE item_type_id = p_item_type_id;
4549:
4550: IF SQL%NOTFOUND THEN

Line 6732: from cz_item_types

6728: SELECT 1
6729: INTO l_item_prop_count
6730: FROM CZ_ITEM_TYPE_PROPERTIES
6731: WHERE item_type_id IN (select item_type_id
6732: from cz_item_types
6733: where deleted_flag = '0')
6734: AND property_id = p_property_id
6735: AND deleted_flag = '0';
6736: EXCEPTION

Line 8111: from cz_item_types

8107: SELECT 1
8108: INTO l_item_prop_count
8109: FROM CZ_ITEM_TYPE_PROPERTIES
8110: WHERE item_type_id IN (select item_type_id
8111: from cz_item_types
8112: where deleted_flag = '0')
8113: AND property_id = l_prp_ref(modelId)
8114: AND deleted_flag = '0';
8115: EXCEPTION