APPS.IEU_WP_ACTION_PVT dependencies on IEU_WP_PARAM_PROPS_TL

Line 155: delete from IEU_WP_PARAM_PROPS_TL

151: EXIT WHEN c_cursor%NOTFOUND;
152: delete from IEU_WP_PARAM_PROPS_B
153: where param_property_id = cur_rec.param_property_id;
154:
155: delete from IEU_WP_PARAM_PROPS_TL
156: where param_property_id = cur_rec.param_property_id;
157: end LOOP;
158: CLOSE c_cursor;
159:

Line 743: v_language ieu_wp_param_props_tl.language%type;

739: v_SelectStmt Varchar2(500);
740: v_CursorID INTEGER;
741: v_Dummy INTEGER;
742: v_param_set_id ieu_wp_param_props_b.action_param_set_id%type;
743: v_language ieu_wp_param_props_tl.language%type;
744: v_enumId ieu_uwq_sel_enumerators.sel_enum_id%type;
745: v_responsibility_id ieu_wp_action_maps.responsibility_id%type;
746: cursor c_cur is
747: SELECT

Line 1113: delete from ieu_wp_param_props_tl where param_property_id in

1109: ( select param_property_id
1110: from ieu_wp_param_props_b
1111: where param_id not in (select param_id from ieu_wp_param_defs_b));
1112:
1113: delete from ieu_wp_param_props_tl where param_property_id in
1114: ( select param_property_id
1115: from ieu_wp_param_props_b
1116: where param_id not in (select param_id from ieu_wp_param_defs_b));
1117:

Line 1253: update ieu_wp_param_props_tl set

1249: where property_id = 10003;
1250:
1251: if (l_delete_param_property_id is not null ) then
1252: if (l_trans_flag = 'Y') then
1253: update ieu_wp_param_props_tl set
1254: PROPERTY_VALUE = null
1255: where param_property_id = l_delete_param_property_id;
1256: end if ;
1257: