APPS.CZ_MODELOPERATIONS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 22

  SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

Line: 28

    SELECT 1
    INTO l_found
    FROM cz_rp_entries
    WHERE object_type = 'PRJ' AND object_id = p_devl_project_id AND deleted_flag = '0';

Line: 39

  SELECT MIN(urgency)
    INTO l_urgency
  FROM cz_db_logs
  WHERE run_id = x_run_id;

Line: 58

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 65

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 72

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 123

  SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

Line: 129

    SELECT 1
    INTO l_found
    FROM cz_rp_entries
    WHERE object_type = 'PRJ' AND object_id = p_devl_project_id AND deleted_flag = '0';

Line: 193

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 200

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 207

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 214

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 221

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 228

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 235

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 242

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 249

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 256

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 263

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 271

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 353

    SELECT 1
    INTO l_found
    FROM cz_rp_entries
    WHERE object_type = 'PRJ' AND object_id = p_devl_project_id AND deleted_flag = '0';

Line: 463

  SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

Line: 469

    SELECT 1
    INTO l_found_ui
    FROM cz_ui_defs
    WHERE ui_def_id = p_ui_def_id AND deleted_flag = '0';

Line: 479

    SELECT 1
    INTO l_found
    FROM cz_rp_entries rp, cz_ui_defs uidef
    WHERE object_type = 'PRJ' AND object_id = devl_project_id AND ui_def_id = p_ui_def_id
       AND rp.deleted_flag = '0' AND uidef.deleted_flag = '0';

Line: 494

    SELECT max(urgency)
      INTO l_urgency
    FROM cz_db_logs
    WHERE run_id = x_run_id;

Line: 513

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 520

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 527

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 535

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 600

    SELECT ui_style
    INTO l_ui_style
    FROM cz_ui_defs
    WHERE ui_def_id = p_ui_def_id AND deleted_flag = '0';

Line: 711

      SELECT fndnam_link_name,local_name    --10011026
      INTO l_db_link, l_local_name
      FROM cz_servers
      WHERE import_enabled = '1';

Line: 728

      'SELECT ''Y'' FROM cz_exv_item_properties where rownum < 2'
      INTO l_Exist;

Line: 767

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 774

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 781

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 788

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 795

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 802

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 808

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 814

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 821

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 877

    SELECT 1
    INTO l_found
    FROM cz_rp_entries
    WHERE object_type = 'PRJ'
    AND object_id = p_devl_project_id
    AND deleted_flag = '0';

Line: 889

  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)) -
              length(substr(orig_sys_ref,instr(orig_sys_ref,':',1,2)))  )) ,
    rtrim(substr(orig_sys_ref,instr(orig_sys_ref,':',1,2)+1))
  INTO lOrg_Id, lTop_Id
  FROM cz_devl_projects
  WHERE devl_project_id = p_devl_project_id
  AND deleted_flag = '0';

Line: 899

      SELECT fndnam_link_name
      INTO l_db_link
      FROM cz_servers
      WHERE import_enabled = '1';

Line: 916

      'SELECT ''Y'' FROM cz_exv_item_properties where rownum < 2'
      INTO l_Exist;

Line: 950

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 957

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 964

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 971

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 978

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 985

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 992

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 998

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 1004

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 1011

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 1043

  SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

Line: 1063

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 1070

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 1106

  SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

Line: 1112

    SELECT 1
    INTO l_found
    FROM cz_rp_entries
    WHERE object_type = 'PRJ' AND object_id = p_devl_project_id AND deleted_flag = '0';

Line: 1135

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 1142

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 1149

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 1195

  SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

Line: 1201

    SELECT NULL
    INTO l_found
    FROM cz_populators
    WHERE populator_id = p_populator_id AND deleted_flag = '0';

Line: 1224

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 1231

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 1239

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 1279

  SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

Line: 1285

    SELECT 1
    INTO l_found
    FROM cz_rp_entries
    WHERE object_type = 'PRJ' AND object_id = p_devl_project_id AND deleted_flag = '0';

Line: 1308

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 1315

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 1323

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 1367

  SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

Line: 1389

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 1396

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 1429

 SELECT 'X'
 FROM cz_rp_entries
 WHERE object_id = p_encl_folder_id
 AND object_type = 'FLD'
 AND deleted_flag = '0';

Line: 1437

 SELECT 'X'
 FROM cz_rp_entries
 WHERE object_id = p_rp_folder_id
 AND enclosing_folder = p_encl_folder_id
 AND object_type = 'FLD'
 AND deleted_flag = '0';

Line: 1446

 SELECT 'X'
 FROM cz_rp_entries
 WHERE object_id = p_rp_folder_id
 AND object_type = 'FLD'
 AND deleted_flag = '0';

Line: 1546

    SELECT 1 INTO l_dummy_nbr
    FROM cz_rp_entries
    WHERE object_id = p_encl_folder_id
    AND object_type = 'FLD'
    AND deleted_flag = '0';

Line: 1558

    SELECT object_id INTO x_new_folder_id
    FROM cz_rp_entries
    WHERE name = p_new_folder_name
    AND enclosing_folder = p_encl_folder_id
    AND object_type = 'FLD'
    AND deleted_flag = '0';

Line: 1568

         SELECT cz_rp_entries_s.NEXTVAL
         INTO l_new_object_id
         FROM DUAL;

Line: 1572

        INSERT INTO cz_rp_entries
                    (object_id
                    ,name
                    ,object_type
                    ,enclosing_folder
                    ,description
                    ,notes
                    )
              VALUES
                   (l_new_object_id
                   ,p_new_folder_name
                   ,'FLD'
                   ,p_encl_folder_id
                   ,p_folder_desc
                   ,p_folder_notes
                   );

Line: 1677

SELECT nvl(model_id,0)
FROM CZ_IMP_DEVL_PROJECT
WHERE rec_status IS NULL AND Run_ID = p_run_id;

Line: 1683

SELECT nvl(model_id,0), nvl(devl_project_id,0)
FROM CZ_IMP_DEVL_PROJECT
WHERE rec_status IS NOT NULL AND Run_ID = x_run_id;

Line: 1700

    SELECT 1 INTO l_dummy_nbr
    FROM cz_rp_entries
    WHERE object_id = p_rp_folder_id
    AND object_type = 'FLD'
    AND deleted_flag = '0';

Line: 1712

    l_model_id_tbl.DELETE;

Line: 1713

    l_all_locked_models_tbl.DELETE;

Line: 1724

            l_locked_models_tbl.DELETE;

Line: 1771

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_msg_data, 11276, G_PKG_NAME||'.'||l_api_name, 1, p_run_id, SYSDATE);

Line: 1778

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_msg_data, 11276, G_PKG_NAME||'.'||l_api_name, 1, p_run_id, SYSDATE);

Line: 1784

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_msg_data, 11276, G_PKG_NAME||'.'||l_api_name, 1, p_run_id, SYSDATE);

Line: 1790

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_msg_data, 11276, G_PKG_NAME||'.'||l_api_name, 1, p_run_id, SYSDATE);

Line: 1796

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_msg_data, 11276, G_PKG_NAME||'.'||l_api_name, 1, p_run_id, SYSDATE);

Line: 1802

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_msg_data, 11276, G_PKG_NAME||'.'||l_api_name, 1, p_run_id, SYSDATE);

Line: 1808

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_msg_data, 11276, G_PKG_NAME||'.'||l_api_name, 1, p_run_id, SYSDATE);

Line: 1815

         INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
         VALUES (l_msg_data, 11276, G_PKG_NAME||'.'||l_api_name, 1, p_run_id, SYSDATE);

Line: 1999

    SELECT model_usage_id
    INTO  v_usage_id
    FROM  CZ_MODEL_USAGES
    WHERE  LTRIM(RTRIM(UPPER(CZ_MODEL_USAGES.name))) = LTRIM(RTRIM(UPPER(p_usage_name)))
    AND   cz_model_usages.in_use = '1';

Line: 2055

 *                     Migration request is created by Developer and contains the list of all models selected
 *                     for Migration from the source's Configurator Repository, target Instance name and
 *                     target Repository Folder.
 * @param p_userid     Standard parameters required for locking. Represent calling user.
 * @param p_respid     Standard parameters required for locking. Represent calling responsibility.
 * @param p_applid     Standard parameters required for locking. Represent calling application.
 * @param p_run_id     Number identifying the session. If left NULL, the API will generate the number and
 *                     return it in x_run_id.
 * @param x_run_id     Output parameter containing internally generated session identifier if p_run_id
 *                     was NULL, otherwise equal to p_run_id.
 */

PROCEDURE migrate_models(p_api_version IN  NUMBER,
                         p_request_id  IN  NUMBER,
                         p_user_id     IN  NUMBER,
                         p_resp_id     IN  NUMBER,
                         p_appl_id     IN  NUMBER,
                         p_run_id      IN  NUMBER,
                         x_run_id      OUT NOCOPY NUMBER,
                         x_status      OUT NOCOPY VARCHAR2
                        ) IS

  l_api_name      CONSTANT VARCHAR2(30) := 'migrate_models';

Line: 2094

    INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
    VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, x_run_id, SYSDATE);

Line: 2150

	 INSERT INTO cz_db_logs (message, statuscode, caller, urgency, logtime)
	 VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, SYSDATE);

Line: 2156

	 INSERT INTO cz_db_logs (message, statuscode, caller, urgency, logtime)
	 VALUES (l_errbuf, 11276, G_PKG_NAME||'.'||l_api_name, 1, SYSDATE);