APPS.CZ_MODEL_MIGRATION_PVT dependencies on CZ_DEVL_PROJECTS

Line 151: WHERE devl_project_id= (select devl_project_id from cz_devl_projects

147: ) IS
148: PRAGMA AUTONOMOUS_TRANSACTION;
149: BEGIN
150: UPDATE CZ_PERSISTENT_REC_IDS SET max_persistent_rec_id = max_persistent_rec_id + 1
151: WHERE devl_project_id= (select devl_project_id from cz_devl_projects
152: where deleted_flag = '0' and devl_project_id=p_model_id
153: AND post_migr_change_flag <> 'L') and deleted_flag=0
154: --If no record returned, the value of the variable will not change.
155: RETURNING max_persistent_rec_id INTO x_new_record_id;

Line 252: l_model_name cz_devl_projects.name%TYPE;

248: l_ref_node_map complex_num_tbl_type;
249:
250: l_model_id NUMBER;
251: l_model_type INTEGER;
252: l_model_name cz_devl_projects.name%TYPE;
253: l_item_prj_map num_tbl_type_index_vc2;
254: l_item_tbl num_tbl_type;
255: l_name_tbl name_tbl_type;
256: l_prj_id NUMBER;

Line 292: FROM cz_devl_projects

288: WHERE deleted_flag = '0'
289: AND creation_date >= NVL(p_begin_date, cz_utils.EPOCH_BEGIN_)
290: AND creation_date <= NVL(p_end_date, SYSDATE)
291: AND persistent_component_id = (SELECT persistent_project_id
292: FROM cz_devl_projects
293: WHERE devl_project_id = p_model_id)
294: AND EXISTS (SELECT NULL FROM cz_config_items
295: WHERE config_hdr_id = hdr.config_hdr_id
296: AND config_rev_nbr = hdr.config_rev_nbr

Line 302: FROM cz_devl_projects

298: AND ps_node_name IS NULL);
299:
300: IF l_hdr_tbl.COUNT = 0 THEN
301: SELECT name INTO l_model_name
302: FROM cz_devl_projects
303: WHERE devl_project_id = p_model_id;
304: l_msg := cz_utils.get_text('CZ_UPGCFG_NO_CFG', 'MODELNAME', l_model_name);
305: log_msg(l_api_name, l_ndebug, l_msg, FND_LOG.LEVEL_STATEMENT);
306: x_retcode := CP_RETCODE_SUCCESS;

Line 324: FROM cz_devl_projects

320: -- Use the common model otherwise
321: l_model_id := p_model_id;
322: BEGIN
323: SELECT devl_project_id INTO l_model_id
324: FROM cz_devl_projects
325: WHERE devl_project_id = l_mdl_tbl(i) AND deleted_flag = '0';
326:
327: SELECT p_model_id INTO l_model_id
328: FROM cz_model_ref_expls re

Line 331: AND NOT EXISTS (SELECT 1 FROM cz_devl_projects

327: SELECT p_model_id INTO l_model_id
328: FROM cz_model_ref_expls re
329: WHERE deleted_flag = '0' AND model_id = l_mdl_tbl(i)
330: AND ps_node_type = PS_NODE_TYPE_REFERENCE
331: AND NOT EXISTS (SELECT 1 FROM cz_devl_projects
332: WHERE deleted_flag = '0' AND devl_project_id = re.component_id)
333: AND ROWNUM < 2;
334: EXCEPTION
335: WHEN NO_DATA_FOUND THEN

Line 495: l_model_id cz_devl_projects.devl_project_id%TYPE;

491: -- ,x_msg OUT NOCOPY VARCHAR2
492: )
493: IS
494: l_api_name CONSTANT VARCHAR2(30) := 'upgrade_configs_by_item';
495: l_model_id cz_devl_projects.devl_project_id%TYPE;
496: l_ndebug INTEGER;
497: l_msg VARCHAR2(1000);
498: l_msg_name VARCHAR2(30);
499: BEGIN

Line 713: l_model_id cz_devl_projects.devl_project_id%TYPE;

709: IS
710: l_api_name CONSTANT VARCHAR2(30) := 'upgrade_configs_by_product';
711: l_begin_date DATE;
712: l_end_date DATE;
713: l_model_id cz_devl_projects.devl_project_id%TYPE;
714: l_ndebug INTEGER;
715: l_msg VARCHAR2(1000);
716: l_msg_name VARCHAR2(30);
717: v_publication_id NUMBER;

Line 744: FROM cz_devl_projects dp

740: DECLARE
741: -- Check if the model is a migrated one
742: CURSOR cur_model_migrated IS
743: SELECT 'Y' migrated
744: FROM cz_devl_projects dp
745: WHERE dp.devl_project_id = l_model_id
746: AND dp.post_migr_change_flag IS NOT NULL
747: AND dp.post_migr_change_flag <> 'L';
748: rec_model_migrated cur_model_migrated%ROWTYPE;