APPS.CZ_UTILS SQL Statements

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

Line: 76

					SELECT VALUE FROM CZ_DB_SETTINGS WHERE SETTING_ID = sLogConst;

Line: 111

						INSERT INTO  CZ_DB_LOGS (LOGTIME, LOGUSER, URGENCY, CALLER, STATUSCODE, MESSAGE, RUN_ID)
								VALUES(SYSDATE, USER, URGENCY, ByCaller, StatusCode, Msg, RunId);

Line: 167

  SELECT DECODE(PK_USEEXPANSION,NULL,0,'0',0,1) INTO PK_USEEXPANSION_FLAG
  FROM CZ_XFR_TABLES WHERE DST_TABLE=TABLE_NAME AND XFR_GROUP=inXFR_GROUP
  AND ROWNUM=1;

Line: 180

FUNCTION GET_NOUPDATE_FLAG(TABLE_NAME IN VARCHAR2,
                           COLUMN_NAME IN VARCHAR2,
                           inXFR_GROUP IN VARCHAR2)
RETURN NUMBER IS
BEGIN
 DECLARE
  NOUPDATE_FLAG  CZ_XFR_FIELDS.NOUPDATE%TYPE;

Line: 188

  SELECT NOUPDATE INTO NOUPDATE_FLAG
  FROM CZ_XFR_FIELDS,CZ_XFR_TABLES
  WHERE CZ_XFR_TABLES.DST_TABLE=TABLE_NAME AND CZ_XFR_FIELDS.DST_FIELD=COLUMN_NAME
  AND CZ_XFR_TABLES.ORDER_SEQ=CZ_XFR_FIELDS.ORDER_SEQ
  AND CZ_XFR_TABLES.XFR_GROUP=CZ_XFR_FIELDS.XFR_GROUP
  AND CZ_XFR_FIELDS.XFR_GROUP=inXFR_GROUP AND ROWNUM=1;

Line: 195

  RETURN TO_NUMBER(NVL(NOUPDATE_FLAG,'0'));

Line: 200

      log_report('cz_utils', 'GET_NOUPDATE_FLAG', 1, SQLERRM, fnd_log.LEVEL_UNEXPECTED);

Line: 203

END GET_NOUPDATE_FLAG;

Line: 210

		SELECT TO_NUMBER(nVALUE) INTO xVALUE FROM DUAL;

Line: 224

		SELECT DISTINCT USERNAME INTO sUSER
			FROM ALL_USERS
			WHERE USER_ID=-forSPXID;

Line: 229

		SELECT USER_NAME INTO sFND
			FROM FND_USER
			WHERE USER_ID=forSPXID;

Line: 424

    'SELECT NULL FROM fnd_languages' || v_db_link || ' remote ' ||
    ' WHERE installed_flag IN (''B'', ''I'') AND NOT EXISTS ' ||
    '  (SELECT NULL FROM fnd_languages local ' ||
    '    WHERE local.language_code = remote.language_code ' ||
    '      AND local.installed_flag = remote.installed_flag) ' ||
    'UNION ' ||
    'SELECT NULL FROM fnd_languages local ' ||
    ' WHERE installed_flag IN (''B'', ''I'') AND NOT EXISTS ' ||
    '  (SELECT NULL FROM fnd_languages' || v_db_link || ' remote ' ||
    '    WHERE local.language_code = remote.language_code ' ||
    '      AND local.installed_flag = remote.installed_flag)';

Line: 491

  FOR c IN (SELECT intl_text_id, localized_str, language FROM cz_localized_texts
            -- WHERE deleted_flag = '0'
           ) LOOP

    textString := UPPER(c.localized_str);

Line: 510

  FOR c IN (SELECT ps_node_id, name FROM cz_ps_nodes
            -- WHERE deleted_flag = '0'
           ) LOOP

    textString := UPPER(c.name);

Line: 528

  FOR c IN (SELECT message_name, message_text FROM fnd_new_messages
             WHERE application_id = 708) LOOP

    textString := UPPER(c.message_text);

Line: 545

  FOR c IN (SELECT config_hdr_id, config_rev_nbr, config_input_id, input_val
              FROM cz_config_inputs
             WHERE input_type_code = 2
            --   AND deleted_flag = '0'
           ) LOOP

    textString := UPPER(c.input_val);

Line: 567

  FOR c IN (SELECT config_hdr_id, config_rev_nbr, config_item_id, item_val
              FROM cz_config_items
             WHERE value_type_code = 2
            --   AND deleted_flag = '0'
           ) LOOP


    textString := UPPER(c.item_val);

Line: 619

	SELECT FNDNAM_LINK_NAME
      INTO   v_db_link
      FROM   cz_servers
      WHERE  cz_servers.server_local_id = p_server_id;