APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_ITEM_TYPE_PROPERTIES

Line 4538: UPDATE cz_item_type_properties

4534: ----------------------------------
4535: -- delete the item type properties
4536: ----------------------------------
4537:
4538: UPDATE cz_item_type_properties
4539: SET deleted_flag ='1'
4540: WHERE item_type_id = p_item_type_id;
4541:
4542: -----------------------

Line 6730: FROM CZ_ITEM_TYPE_PROPERTIES

6726:
6727: BEGIN
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

Line 8080: FROM cz_item_type_properties itypr,

8076: AND ps.ps_node_id = psp.ps_node_id
8077: AND property_id = l_prp_ref(modelId)
8078: UNION
8079: SELECT devl_project_id
8080: FROM cz_item_type_properties itypr,
8081: cz_item_masters itm,
8082: cz_ps_nodes psnd
8083: WHERE itypr.deleted_flag = '0'
8084: AND itypr.item_type_id = itm.item_type_id

Line 8109: FROM CZ_ITEM_TYPE_PROPERTIES

8105:
8106: BEGIN
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)

Line 12170: SELECT item_type_id INTO l_item_type_exists FROM cz_item_type_properties

12166:
12167: -- check if cz_item_property_values exists, if not, then insert it.
12168: -- Not expecting item_type for this item is deleted.
12169: BEGIN
12170: SELECT item_type_id INTO l_item_type_exists FROM cz_item_type_properties
12171: WHERE item_type_id=l_item_type_id
12172: AND property_id=p_property_id;
12173:
12174: EXCEPTION

Line 12176: INSERT INTO cz_item_type_properties( item_type_id,property_id,deleted_flag,checkout_user)

12172: AND property_id=p_property_id;
12173:
12174: EXCEPTION
12175: WHEN NO_DATA_FOUND THEN
12176: INSERT INTO cz_item_type_properties( item_type_id,property_id,deleted_flag,checkout_user)
12177: VALUES(l_item_type_id, p_property_id,'0','API CREATED');
12178: WHEN OTHERS THEN
12179: x_return_status := 'F';
12180: x_msg_data := 'Error in Insert Item Type Property : '||sqlerrm;