[Home] [Help]
885: SELECT rtrim(substr(orig_sys_ref,instr(orig_sys_ref,':',1,1)+1,length(substr(orig_sys_ref,instr(orig_sys_ref,':',1,1)+1)) -
886: length(substr(orig_sys_ref,instr(orig_sys_ref,':',1,2))) )) ,
887: rtrim(substr(orig_sys_ref,instr(orig_sys_ref,':',1,2)+1))
888: INTO lOrg_Id, lTop_Id
889: FROM cz_devl_projects
890: WHERE devl_project_id = p_devl_project_id
891: AND deleted_flag = '0';
892:
893: -- check the imp server
1849: -----------------------------------------------------------
1850: /*#
1851: * This is the public interface for force unlock operations on a model in Oracle Configurator
1852: * @param p_api_version Current version of the API is 1.0
1853: * @param p_model_id devl_project_id of the model from cz_devl_projects table
1854: * @param p_unlock_references A value of FND_API.G_TRUE indicates that the child models if any should be
1855: * force unlocked. A value of FND_API.G_FALSE indicates that only the root model
1856: * will be unlocked
1857: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.