APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_ITEM_TYPE_PROPERTIES

Line 4510: UPDATE cz_item_type_properties

4506: ----------------------------------
4507: -- delete the item type properties
4508: ----------------------------------
4509:
4510: UPDATE cz_item_type_properties
4511: SET deleted_flag ='1'
4512: WHERE item_type_id = p_item_type_id;
4513:
4514: -----------------------

Line 6701: FROM CZ_ITEM_TYPE_PROPERTIES

6697:
6698: BEGIN
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

Line 8022: FROM cz_item_type_properties itypr,

8018: AND ps.ps_node_id = psp.ps_node_id
8019: AND property_id = l_prp_ref(modelId)
8020: UNION
8021: SELECT devl_project_id
8022: FROM cz_item_type_properties itypr,
8023: cz_item_masters itm,
8024: cz_ps_nodes psnd
8025: WHERE itypr.deleted_flag = '0'
8026: AND itypr.item_type_id = itm.item_type_id

Line 8051: FROM CZ_ITEM_TYPE_PROPERTIES

8047:
8048: BEGIN
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)