APPS.CZ_MODEL_MIGRATION_PVT dependencies on CZ_DEVL_PROJECTS

Line 175: WHERE devl_project_id= (select devl_project_id from cz_devl_projects

171: ) IS
172: PRAGMA AUTONOMOUS_TRANSACTION;
173: BEGIN
174: UPDATE CZ_PERSISTENT_REC_IDS SET max_persistent_rec_id = max_persistent_rec_id + 1
175: WHERE devl_project_id= (select devl_project_id from cz_devl_projects
176: where deleted_flag = '0' and devl_project_id=p_model_id
177: AND post_migr_change_flag <> 'L') and deleted_flag=0
178: --If no record returned, the value of the variable will not change.
179: RETURNING max_persistent_rec_id INTO x_new_record_id;

Line 276: l_model_name cz_devl_projects.name%TYPE;

272: l_ref_node_map complex_num_tbl_type;
273:
274: l_model_id NUMBER;
275: l_model_type INTEGER;
276: l_model_name cz_devl_projects.name%TYPE;
277: l_item_prj_map num_tbl_type_index_vc2;
278: l_item_tbl num_tbl_type;
279: l_name_tbl name_tbl_type;
280: l_prj_id NUMBER;

Line 316: FROM cz_devl_projects

312: WHERE deleted_flag = '0'
313: AND creation_date >= NVL(p_begin_date, cz_utils.EPOCH_BEGIN_)
314: AND creation_date <= NVL(p_end_date, SYSDATE)
315: AND persistent_component_id = (SELECT persistent_project_id
316: FROM cz_devl_projects
317: WHERE devl_project_id = p_model_id)
318: AND EXISTS (SELECT NULL FROM cz_config_items
319: WHERE config_hdr_id = hdr.config_hdr_id
320: AND config_rev_nbr = hdr.config_rev_nbr

Line 326: FROM cz_devl_projects

322: AND ps_node_name IS NULL);
323:
324: IF l_hdr_tbl.COUNT = 0 THEN
325: SELECT name INTO l_model_name
326: FROM cz_devl_projects
327: WHERE devl_project_id = p_model_id;
328: l_msg := cz_utils.get_text('CZ_UPGCFG_NO_CFG', 'MODELNAME', l_model_name);
329: log_msg(l_api_name, l_ndebug, l_msg, FND_LOG.LEVEL_STATEMENT);
330: x_retcode := CP_RETCODE_SUCCESS;

Line 348: FROM cz_devl_projects

344: -- Use the common model otherwise
345: l_model_id := p_model_id;
346: BEGIN
347: SELECT devl_project_id INTO l_model_id
348: FROM cz_devl_projects
349: WHERE devl_project_id = l_mdl_tbl(i) AND deleted_flag = '0';
350:
351: SELECT p_model_id INTO l_model_id
352: FROM cz_model_ref_expls re

Line 355: AND NOT EXISTS (SELECT 1 FROM cz_devl_projects

351: SELECT p_model_id INTO l_model_id
352: FROM cz_model_ref_expls re
353: WHERE deleted_flag = '0' AND model_id = l_mdl_tbl(i)
354: AND ps_node_type = PS_NODE_TYPE_REFERENCE
355: AND NOT EXISTS (SELECT 1 FROM cz_devl_projects
356: WHERE deleted_flag = '0' AND devl_project_id = re.component_id)
357: AND ROWNUM < 2;
358: EXCEPTION
359: WHEN NO_DATA_FOUND THEN

Line 519: l_model_id cz_devl_projects.devl_project_id%TYPE;

515: -- ,x_msg OUT NOCOPY VARCHAR2
516: )
517: IS
518: l_api_name CONSTANT VARCHAR2(30) := 'upgrade_configs_by_item';
519: l_model_id cz_devl_projects.devl_project_id%TYPE;
520: l_ndebug INTEGER;
521: l_msg VARCHAR2(1000);
522: l_msg_name VARCHAR2(30);
523: BEGIN

Line 737: l_model_id cz_devl_projects.devl_project_id%TYPE;

733: IS
734: l_api_name CONSTANT VARCHAR2(30) := 'upgrade_configs_by_product';
735: l_begin_date DATE;
736: l_end_date DATE;
737: l_model_id cz_devl_projects.devl_project_id%TYPE;
738: l_ndebug INTEGER;
739: l_msg VARCHAR2(1000);
740: l_msg_name VARCHAR2(30);
741: v_publication_id NUMBER;

Line 768: FROM cz_devl_projects dp

764: DECLARE
765: -- Check if the model is a migrated one
766: CURSOR cur_model_migrated IS
767: SELECT 'Y' migrated
768: FROM cz_devl_projects dp
769: WHERE dp.devl_project_id = l_model_id
770: AND dp.post_migr_change_flag IS NOT NULL
771: AND dp.post_migr_change_flag <> 'L';
772: rec_model_migrated cur_model_migrated%ROWTYPE;