APPS.CZ_PB_SYNC dependencies on CZ_DEVL_PROJECTS

Line 879: l_src_object_name cz_devl_projects.name%TYPE;

875: l_src_object_type cz_model_publications.object_type%TYPE;
876: l_tgt_object_type cz_model_publications.object_type%TYPE;
877: l_src_model_id cz_model_publications.model_id%TYPE;
878: l_src_ui_def_id cz_model_publications.ui_def_id%TYPE;
879: l_src_object_name cz_devl_projects.name%TYPE;
880: l_tgt_object_name cz_devl_projects.name%TYPE;
881:
882: l_link_name cz_servers.fndnam_link_name%TYPE;
883:

Line 880: l_tgt_object_name cz_devl_projects.name%TYPE;

876: l_tgt_object_type cz_model_publications.object_type%TYPE;
877: l_src_model_id cz_model_publications.model_id%TYPE;
878: l_src_ui_def_id cz_model_publications.ui_def_id%TYPE;
879: l_src_object_name cz_devl_projects.name%TYPE;
880: l_tgt_object_name cz_devl_projects.name%TYPE;
881:
882: l_link_name cz_servers.fndnam_link_name%TYPE;
883:
884: l_tgt_src_pub_tbl t_ref;

Line 953: FROM cz_devl_projects'||l_link_name||' t

949: l_tgt_object_id := l_tgt_object_id_tbl(i);
950: IF l_tgt_object_type_tbl(i) = OBJECT_TYPE_PROJECT THEN
951: OPEN l_model_cursor FOR
952: 'SELECT name
953: FROM cz_devl_projects'||l_link_name||' t
954: WHERE t.devl_project_id = '||l_tgt_object_id||'
955: AND t.deleted_flag = ''0'' ';
956: LOOP
957: FETCH l_model_cursor INTO l_tgt_object_name;

Line 1026: FROM cz_devl_projects

1022: END IF;
1023: END IF;
1024:
1025: SELECT name INTO l_src_object_name
1026: FROM cz_devl_projects
1027: WHERE cz_devl_projects.devl_project_id = l_src_object_id;
1028:
1029: IF (l_src_object_name <> l_tgt_object_name_tbl(i)) THEN
1030: l_tgt_object_name := l_tgt_object_name_tbl(i);

Line 1027: WHERE cz_devl_projects.devl_project_id = l_src_object_id;

1023: END IF;
1024:
1025: SELECT name INTO l_src_object_name
1026: FROM cz_devl_projects
1027: WHERE cz_devl_projects.devl_project_id = l_src_object_id;
1028:
1029: IF (l_src_object_name <> l_tgt_object_name_tbl(i)) THEN
1030: l_tgt_object_name := l_tgt_object_name_tbl(i);
1031: RAISE MODELNAME_MISMATCH_ERR;