APPS.IEU_PUB SQL Statements

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

Line: 61

        Select
          default_res_cat_id
        into
          l_default_res_cat_id
        from
          ieu_uwq_sel_enumerators
        where
          sel_enum_id = p_sel_enum_id;

Line: 76

	  Select where_clause
	  into	 l_def_where
	  from 	 ieu_uwq_res_cats_b
	  where	 res_cat_id = l_default_res_cat_id;

Line: 120

    SELECT
      rt_nodes_bind_val.SEL_RT_NODE_ID,
      rt_nodes_bind_val.node_id,
      rt_nodes_bind_val.bind_var_name,
      rt_nodes_bind_val.bind_var_value
    FROM
      ieu_uwq_rtnode_bind_vals rt_nodes_bind_val
    WHERE
      (rt_nodes_bind_val.resource_id = p_resource_id) AND
      (rt_nodes_bind_val.node_id = l_node_id) AND
      (rt_nodes_bind_val.not_valid_flag = l_not_valid_flag);

Line: 136

     Select where_clause,
	 node_type,
         refresh_view_name,
         refresh_view_sum_col,
         view_name,
         sel_enum_id,
         sel_rt_node_id,
         res_cat_enum_flag
     into   l_extra_where_clause,
	 l_node_type,
         X_NODE_DETAIL_RECORD.REFRESH_VIEW_NAME,
         X_NODE_DETAIL_RECORD.refresh_view_sum_col,
         X_NODE_DETAIL_RECORD.view_name,
         l_sel_enum_id,
         l_sel_rt_node_id,
         l_res_cat_enum_flag
     from   ieu_uwq_sel_rt_nodes
     where  resource_id = p_resource_id
     and    node_id = p_node_id
     and   not_valid = l_not_valid;

Line: 165

          select
            where_clause
          into
            l_res_cat_where_clause
          from
            ieu_uwq_res_cats_b
          where
            res_cat_id = 10001;

Line: 204

   select
        decode(
          (instr(l_res_cat_where_clause, ':resource_id', 1, 1)), 0, 'F','T' )
   into
        l_enum_bind_var_flag
   from
        dual;

Line: 222

              SELECT REPLACE(l_where_clause,b.bind_var_name,b.bind_var_value)
              INTO   l_where_clause
              FROM   DUAL;

Line: 227

              SELECT REPLACE(l_extra_where_clause,b.bind_var_name,b.bind_var_value)
              INTO   l_extra_where_clause
              FROM   DUAL;

Line: 241

              SELECT REPLACE(l_where_clause,':resource_id',p_resource_id)
              INTO   l_where_clause
              FROM   DUAL;

Line: 273

    SELECT
      rt_nodes_bind_val.SEL_RT_NODE_ID,
      rt_nodes_bind_val.node_id,
      rt_nodes_bind_val.bind_var_name,
      rt_nodes_bind_val.bind_var_value,
      rt_nodes_bind_val.bind_var_datatype
    FROM
      ieu_uwq_rtnode_bind_vals rt_nodes_bind_val
    WHERE
      (rt_nodes_bind_val.resource_id = p_resource_id) AND
      (rt_nodes_bind_val.node_id = l_node_id) AND
      (rt_nodes_bind_val.not_valid_flag = l_not_valid_flag);

Line: 291

     Select where_clause,
	 node_type,
         refresh_view_name,
         refresh_view_sum_col,
         view_name,
         sel_enum_id,
         sel_rt_node_id,
         res_cat_enum_flag
     into   l_extra_where_clause,
	 l_node_type,
         X_NODE_DETAIL_RECORD.REFRESH_VIEW_NAME,
         X_NODE_DETAIL_RECORD.refresh_view_sum_col,
         X_NODE_DETAIL_RECORD.view_name,
         l_sel_enum_id,
         l_sel_rt_node_id,
         l_res_cat_enum_flag
     from   ieu_uwq_sel_rt_nodes
     where  resource_id = p_resource_id
     and    node_id = p_node_id
     and   not_valid = l_not_valid;

Line: 320

          select
            where_clause
          into
            l_res_cat_where_clause
          from
            ieu_uwq_res_cats_b
          where
            res_cat_id = 10001;

Line: 362

   select
        decode(
          (instr(l_res_cat_where_clause, ':resource_id', 1, 1)), 0, 'F','T' )
   into
        l_enum_bind_var_flag
   from
        dual;

Line: 380

              SELECT REPLACE(l_where_clause,b.bind_var_name,b.bind_var_value)
              INTO   l_where_clause
              FROM   DUAL;

Line: 385

              SELECT REPLACE(l_extra_where_clause,b.bind_var_name,b.bind_var_value)
              INTO   l_extra_where_clause
              FROM   DUAL;

Line: 402

              SELECT REPLACE(l_where_clause,':resource_id',p_resource_id)
              INTO   l_where_clause
              FROM   DUAL;