APPS.IEU_WORK_PANEL_PUB dependencies on IEU_WP_PARAM_PROPS_TL

Line 99: delete from ieu_wp_param_props_tl where param_property_id = l_delete_param_property_id;

95: from ieu_wp_properties_b
96: where property_id = l_property_id;
97:
98: if (l_trans_flag = 'Y') then
99: delete from ieu_wp_param_props_tl where param_property_id = l_delete_param_property_id;
100: --DBMS_OUTPUT.Put_Line(' delete ieu_wp_param_props_tl for id '|| l_delete_param_property_id);
101: end if ;
102:
103: delete from ieu_wp_param_props_b where param_property_id = l_delete_param_property_id;

Line 100: --DBMS_OUTPUT.Put_Line(' delete ieu_wp_param_props_tl for id '|| l_delete_param_property_id);

96: where property_id = l_property_id;
97:
98: if (l_trans_flag = 'Y') then
99: delete from ieu_wp_param_props_tl where param_property_id = l_delete_param_property_id;
100: --DBMS_OUTPUT.Put_Line(' delete ieu_wp_param_props_tl for id '|| l_delete_param_property_id);
101: end if ;
102:
103: delete from ieu_wp_param_props_b where param_property_id = l_delete_param_property_id;
104: --DBMS_OUTPUT.Put_Line(' delete ieu_wp_param_props_b for id '|| l_delete_param_property_id);

Line 252: -- delete from ieu_wp_param_props_tl where param_property_id = l_delete_param_property_id;

248: -- select VALUE_TRANSLATABLE_FLAG into l_trans_flag
249: -- from ieu_wp_properties_b
250: -- where property_id = l_property_id;
251: -- if (l_trans_flag = 'Y') then
252: -- delete from ieu_wp_param_props_tl where param_property_id = l_delete_param_property_id;
253: --DBMS_OUTPUT.Put_Line(' delete ieu_wp_param_props_tl for id '|| l_delete_param_property_id);
254: -- end if ;
255:
256: -- delete from ieu_wp_param_props_b where param_property_id = l_delete_param_property_id;

Line 253: --DBMS_OUTPUT.Put_Line(' delete ieu_wp_param_props_tl for id '|| l_delete_param_property_id);

249: -- from ieu_wp_properties_b
250: -- where property_id = l_property_id;
251: -- if (l_trans_flag = 'Y') then
252: -- delete from ieu_wp_param_props_tl where param_property_id = l_delete_param_property_id;
253: --DBMS_OUTPUT.Put_Line(' delete ieu_wp_param_props_tl for id '|| l_delete_param_property_id);
254: -- end if ;
255:
256: -- delete from ieu_wp_param_props_b where param_property_id = l_delete_param_property_id;
257: --DBMS_OUTPUT.Put_Line(' delete ieu_wp_param_props_b for id '|| l_delete_param_property_id);

Line 291: DELETE FROM ieu_wp_param_props_tl

287:
288: --3.
289: IF (l_num_map_entries = 1) THEN
290: --a.
291: DELETE FROM ieu_wp_param_props_tl
292: WHERE param_property_id IN
293: (SELECT param_property_id FROM ieu_wp_param_props_b
294: WHERE
295: action_param_set_id = cur_rec.action_param_set_id);

Line 426: delete from ieu_wp_param_props_tl where param_property_id = cur_rec.param_property_id;

422: from ieu_wp_properties_b
423: where property_id = cur_rec.property_id;
424:
425: if (l_trans_flag = 'Y') then
426: delete from ieu_wp_param_props_tl where param_property_id = cur_rec.param_property_id;
427: end if ;
428:
429: delete from ieu_wp_param_props_b where param_property_id = cur_rec.param_property_id;
430: