APPS.IEU_WORK_PANEL_PUB dependencies on IEU_WP_PROPERTIES_B

Line 32: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;

28: v_numrows1 NUMBER;
29: sql_stmt varchar2(2000);
30: l_property_id ieu_wp_param_props_b.property_id%type;
31: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;
32: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
33: l_enumID ieu_uwq_sel_enumerators.sel_enum_id%type;
34: l_applId ieu_wp_action_maps.application_id%type;
35: l_panel ieu_uwq_maction_defs_b.maction_def_type_flag%type;
36: TYPE c_cursor5 IS REF CURSOR;

Line 95: from ieu_wp_properties_b

91: FETCH c_ref INTO l_delete_param_property_id, l_property_id;
92: EXIT WHEN c_ref%NOTFOUND;
93:
94: select VALUE_TRANSLATABLE_FLAG into l_trans_flag
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;

Line 173: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;

169: v_numrows1 NUMBER;
170: sql_stmt varchar2(2000);
171: l_property_id ieu_wp_param_props_b.property_id%type;
172: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;
173: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
174: l_language VARCHAR2(4);
175:
176: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%type;
177: l_maction_def_id IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_ID%type;

Line 249: -- from ieu_wp_properties_b

245: --DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_delete_param_property_id);
246: --DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_property_id);
247:
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);

Line 359: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;

355: v_numrows1 NUMBER;
356: sql_stmt1 varchar2(2000);
357: l_property_id ieu_wp_param_props_b.property_id%type;
358: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;
359: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
360: l_count NUMBER := 0;
361: l_param_property_id NUMBER;
362: l_property_value VARCHAR2(4000);
363: TYPE c_cursor5 IS REF CURSOR;

Line 422: from ieu_wp_properties_b

418: x_msg_data := '';
419: FOR cur_rec IN c_cursor1
420: LOOP
421: select VALUE_TRANSLATABLE_FLAG into l_trans_flag
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;