1923: l_count NUMBER;
1924:
1925: CURSOR child_model_csr IS
1926: SELECT reference_id
1927: FROM cz_ps_nodes
1928: WHERE devl_project_id = l_model_id
1929: AND ps_node_type = PS_NODE_TYPE_REFERENCE
1930: AND deleted_flag = NO_FLAG;
1931:
1935: l_reference_id := child_model_rec.reference_id;
1936: BEGIN
1937: SELECT to_number(substr(orig_sys_ref, instr(orig_sys_ref, ':', -1, 1)+1))
1938: INTO l_inventory_item_id
1939: FROM cz_ps_nodes
1940: WHERE ps_node_id = l_reference_id
1941: AND ib_trackable = YES_FLAG
1942: AND deleted_flag = NO_FLAG;
1943: