APPS.CZ_FCE_COMPILE_UTILS SQL Statements

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

Line: 149

   timing_table.DELETE;

Line: 257

   stack traces associated with the message. In FCE we are inserting urgency
   code in place of status code.
   */

   INSERT INTO  CZ_DB_LOGS (
    LOGTIME, LOGUSER, URGENCY, CALLER, MESSAGE,
    RUN_ID, MODEL_ID, PS_NODE_ID, RULE_ID, ERROR_STACK, STATUSCODE, message_id )
   VALUES (
    SYSDATE, USER, p_urgency, 'CZ_FCE_COMPILE', l_fit_message,
    p_run_id, p_model_id, p_ps_node_id, p_rule_id, l_fit_error_stack, p_urgency, p_message_id );

Line: 427

   BEGIN --select name from cz_devl_projects where devl_project_id=285121
    EXECUTE IMMEDIATE 'SELECT NAME from cz_devl_projects where devl_project_id= :1'
    INTO l_model_name
    USING p_model_id;

Line: 450

    EXECUTE IMMEDIATE 'SELECT CASE WHEN rule_type = 30 THEN ''DCH'' WHEN rule_type=24 THEN ''XCP'' ELSE ''RUL'' END from cz_rules where rule_id = :1'
    INTO v_rule_type
    USING p_rule_id;

Line: 475

   BEGIN --select name from cz_devl_projects where devl_project_id=285121
    EXECUTE IMMEDIATE 'SELECT NAME from cz_ps_nodes where PS_NODE_ID = :1'
    INTO l_node_name
    USING p_node_id;

Line: 498

  EXECUTE IMMEDIATE 'select name from cz_properties where property_id=:1'
  INTO v_prop_name
  USING p_prop_id;

Line: 504

  EXECUTE IMMEDIATE 'select name from cz_system_properties_v where rule_id=:1'
  INTO v_prop_name
  USING p_prop_id;