DBA Data[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_ITEM_TYPES

Line 4518: UPDATE cz_item_types

4514: -----------------------
4515: -- delete the item type
4516: -----------------------
4517:
4518: UPDATE cz_item_types
4519: SET deleted_flag ='1'
4520: WHERE item_type_id = p_item_type_id;
4521:
4522: IF SQL%NOTFOUND THEN

Line 6703: from cz_item_types

6699: SELECT 1
6700: INTO l_item_prop_count
6701: FROM CZ_ITEM_TYPE_PROPERTIES
6702: WHERE item_type_id IN (select item_type_id
6703: from cz_item_types
6704: where deleted_flag = '0')
6705: AND property_id = p_property_id
6706: AND deleted_flag = '0';
6707: EXCEPTION

Line 8053: from cz_item_types

8049: SELECT 1
8050: INTO l_item_prop_count
8051: FROM CZ_ITEM_TYPE_PROPERTIES
8052: WHERE item_type_id IN (select item_type_id
8053: from cz_item_types
8054: where deleted_flag = '0')
8055: AND property_id = l_prp_ref(modelId)
8056: AND deleted_flag = '0';
8057: EXCEPTION