APPS.IEU_WORK_PANEL_PUB SQL Statements

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

Line: 21

PROCEDURE DeleteAction(x_return_status  OUT NOCOPY VARCHAR2,
                              x_msg_count OUT NOCOPY  NUMBER,
                              x_msg_data  OUT NOCOPY  VARCHAR2,
                              r_action_key IN ieu_uwq_maction_defs_b.maction_def_key%type)
As
v_cursor1               NUMBER;

Line: 31

l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;

Line: 40

SELECT DISTINCT a.sel_enum_id, b.application_id, c.maction_def_type_flag
FROM ieu_uwq_sel_enumerators a, ieu_wp_action_maps b, ieu_uwq_maction_defs_b c
WHERE a.enum_type_uuid = b.action_map_code
AND c.maction_def_key = LTRIM(RTRIM(r_action_key))
AND b.action_param_set_id IN (SELECT action_param_set_id
                              FROM ieu_wp_act_param_sets_b
                              WHERE wp_action_def_id  IN (SELECT maction_def_id
                                                            FROM ieu_uwq_maction_defs_b
                                                            WHERE maction_def_key = LTRIM(RTRIM(r_action_key))
                                                            )
                              );

Line: 55

select distinct a.action_param_set_id
from ieu_wp_act_param_sets_b a, ieu_uwq_maction_defs_b b
where b.MACTION_DEF_KEY = LTRIM(RTRIM(r_action_key))
and b.maction_def_id = a.wp_action_def_id;

Line: 61

select maction_def_id
from ieu_uwq_maction_defs_b
where MACTION_DEF_KEY = r_action_key;

Line: 66

    fnd_msg_pub.delete_msg();

Line: 76

      sql_stmt :=' select param_property_id, property_id'||
                 ' from ieu_wp_param_props_b '||
                 ' where action_param_set_id = :id';

Line: 91

        FETCH c_ref INTO l_delete_param_property_id, l_property_id;

Line: 94

        select VALUE_TRANSLATABLE_FLAG into l_trans_flag
        from ieu_wp_properties_b
        where property_id = l_property_id;

Line: 99

       delete from ieu_wp_param_props_tl where param_property_id = l_delete_param_property_id;

Line: 103

       delete from ieu_wp_param_props_b where param_property_id = l_delete_param_property_id;

Line: 110

    delete from ieu_wp_act_param_sets_b where action_param_set_id = cur_rec.action_param_set_id;

Line: 111

    delete from ieu_wp_act_param_sets_tl where action_param_set_id = cur_rec.action_param_set_id;

Line: 112

    delete from ieu_wp_action_maps where action_param_set_id = cur_rec.action_param_set_id;

Line: 118

    delete from ieu_uwq_maction_defs_b where maction_def_id = cur_rec.maction_def_id;

Line: 119

    delete from ieu_uwq_maction_defs_tl where maction_def_id = cur_rec.maction_def_id;

Line: 142

end DeleteAction;

Line: 160

PROCEDURE DeleteCloneAction (x_return_status  OUT NOCOPY VARCHAR2,
                              x_msg_count OUT NOCOPY  NUMBER,
                              x_msg_data  OUT NOCOPY  VARCHAR2,
                              r_Lang    IN  ieu_wp_act_param_sets_tl.language%type,
                              r_Action_Label IN ieu_wp_act_param_sets_tl.ACTION_PARAM_SET_LABEL%type,
                              r_node_id IN ieu_uwq_sel_enumerators.sel_enum_id%type)
As
v_cursor1               NUMBER;

Line: 172

l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;

Line: 185

select  action_param_set_id
from ieu_wp_act_param_sets_tl
where LANGUAGE = r_Lang
      AND ACTION_PARAM_SET_LABEL = LTRIM(RTRIM(r_Action_Label))
      AND action_param_set_id IN (SELECT action_param_set_id
                                  FROM ieu_wp_action_maps
                                  WHERE action_map_code IN (SELECT enum_type_uuid
                                                            FROM ieu_uwq_sel_enumerators
                                                            WHERE sel_enum_id = LTRIM(RTRIM(r_node_id))
                                                            )
                                  );

Line: 199

SELECT DISTINCT  b.application_id, c.maction_def_type_flag
FROM ieu_uwq_sel_enumerators a, ieu_wp_action_maps b, ieu_uwq_maction_defs_b c
WHERE a.enum_type_uuid = b.action_map_code
AND a.sel_enum_id = r_node_id
AND c.maction_def_id IN (SELECT wp_action_def_id
                         FROM ieu_wp_act_param_sets_b
                         WHERE action_param_set_id IN (SELECT action_param_set_id
                                                       FROM ieu_wp_act_param_sets_tl
                                                       WHERE action_param_set_label = LTRIM(RTRIM(r_Action_Label))
                                                       AND LANGUAGE = r_Lang
                                                       )
                         )
AND b.action_param_set_id IN (SELECT action_param_set_id
                              FROM ieu_wp_act_param_sets_tl
                              WHERE action_param_set_label = LTRIM(RTRIM(r_Action_Label))
                              );

Line: 217

    fnd_msg_pub.delete_msg();

Line: 274

  SELECT count(unique(action_map_code))
  INTO l_num_map_entries
  FROM ieu_wp_action_maps
  WHERE action_map_type_code = 'NODE' AND
        action_param_set_id = cur_rec.action_param_set_id;

Line: 281

  DELETE FROM ieu_wp_action_maps
  WHERE action_param_set_id = cur_rec.action_param_set_id AND
        action_map_type_code = 'NODE' AND
        action_map_code IN
          (SELECT enum_type_uuid FROM ieu_uwq_sel_enumerators
           WHERE sel_enum_id = r_node_id);

Line: 291

    DELETE FROM ieu_wp_param_props_tl
    WHERE param_property_id IN
            (SELECT param_property_id FROM ieu_wp_param_props_b
             WHERE
             action_param_set_id = cur_rec.action_param_set_id);

Line: 297

    DELETE FROM ieu_wp_param_props_b
    WHERE action_param_set_id = cur_rec.action_param_set_id;

Line: 300

    DELETE FROM ieu_wp_act_param_sets_tl
    WHERE action_param_set_id = cur_rec.action_param_set_id;

Line: 303

    DELETE FROM ieu_wp_act_param_sets_b
    WHERE action_param_set_id = cur_rec.action_param_set_id;

Line: 327

end DeleteCloneAction;

Line: 347

PROCEDURE DeleteActionParam(x_return_status  OUT NOCOPY VARCHAR2,
                             x_msg_count OUT NOCOPY  NUMBER,
                             x_msg_data  OUT NOCOPY  VARCHAR2,
                            r_PARAM_NAME IN ieu_wp_param_defs_b.param_name%type,
                            r_ACTION_KEY IN ieu_uwq_maction_defs_b.maction_def_key%type)
As
v_cursor1               NUMBER;

Line: 358

l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;

Line: 367

SELECT action_param_set_id
FROM ieu_wp_act_param_sets_b
WHERE wp_action_def_id IN (SELECT maction_def_id
                           FROM ieu_uwq_maction_defs_b
                           WHERE maction_def_key = LTRIM(RTRIM(r_action_key))
                           );

Line: 378

select param_id
from ieu_wp_param_defs_b
where param_name = LTRIM(RTRIM(r_param_name))
AND param_id IN (SELECT param_id
                 FROM ieu_wp_action_params
                 WHERE WP_ACTION_DEF_ID IN (SELECT maction_def_id
                                            FROM ieu_uwq_maction_defs_b
                                            WHERE MACTION_DEF_KEY = LTRIM(RTRIM(r_ACTION_KEY))
                                            )
                 );

Line: 390

select a.param_property_id, a.property_id
from ieu_wp_param_props_b a, ieu_wp_param_defs_b b
where a.param_id = b.param_id
and b.param_name = LTRIM(RTRIM(r_param_name))
AND a.param_id  IN (SELECT param_id
                 FROM ieu_wp_action_params
                 WHERE WP_ACTION_DEF_ID IN (SELECT maction_def_id
                                            FROM ieu_uwq_maction_defs_b
                                            WHERE MACTION_DEF_KEY = LTRIM(RTRIM(r_ACTION_KEY))
                                            )
                 );

Line: 403

select a.ACTION_PARAM_MAP_ID
from ieu_wp_action_params a, ieu_wp_param_defs_b b
where a.param_id = b.param_id
and b.param_name = LTRIM(RTRIM(r_param_name))
AND a.param_id  IN (SELECT param_id
                 FROM ieu_wp_action_params
                 WHERE WP_ACTION_DEF_ID IN (SELECT maction_def_id
                                            FROM ieu_uwq_maction_defs_b
                                            WHERE MACTION_DEF_KEY = LTRIM(RTRIM(r_ACTION_KEY))
                                            )
                 );

Line: 415

fnd_msg_pub.delete_msg();

Line: 421

        select VALUE_TRANSLATABLE_FLAG into l_trans_flag
        from ieu_wp_properties_b
        where property_id = cur_rec.property_id;

Line: 426

       delete from ieu_wp_param_props_tl where param_property_id = cur_rec.param_property_id;

Line: 429

       delete from ieu_wp_param_props_b where param_property_id = cur_rec.param_property_id;

Line: 434

       delete from ieu_wp_action_params where ACTION_PARAM_MAP_ID= cur_rec.ACTION_PARAM_MAP_ID;

Line: 439

       delete from ieu_wp_param_defs_b where param_ID= cur_rec.param_ID;

Line: 440

       delete from ieu_wp_param_defs_tl where param_ID= cur_rec.param_ID;

Line: 447

    sql_stmt1 := ' SELECT param_property_id, property_value '||
                 ' FROM ieu_wp_param_props_b '||
                 ' WHERE property_id = 10000 '||
                 ' AND action_param_set_id = :id ' ||
                 ' order by property_value';

Line: 469

          UPDATE ieu_wp_param_props_b
          SET PROPERTY_VALUE = l_count,
              last_update_date = sysdate,
              last_update_login = 0
          WHERE PARAM_PROPERTY_ID = l_param_property_id;

Line: 499

end DeleteActionParam;