APPS.IEU_WP_ACTION_PVT dependencies on IEU_WP_PROPERTIES_B

Line 635: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;

631: l_msg_data VARCHAR2(2000);
632:
633: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
634:
635: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
636:
637: v_cursor1 NUMBER;
638: sql_stmt varchar2(2000);
639: sql_stmt1 varchar2(2000);

Line 723: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;

719: l_msg_data VARCHAR2(2000);
720:
721: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
722:
723: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
724:
725: v_cursor1 NUMBER;
726: sql_stmt varchar2(2000);
727: sql_stmt1 varchar2(2000);

Line 1059: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;

1055: l_count NUMBER :=0;
1056: l_language VARCHAR2(4);
1057: l_source_lang VARCHAR2(4);
1058: l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;
1059: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
1060: l_temp IEU_WP_PARAM_PROPS_B.action_param_set_id%type;
1061: l_ptemp IEU_WP_PARAM_PROPS_B.param_id%type;
1062:
1063: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;

Line 1248: from ieu_wp_properties_b

1244: LOOP
1245: FETCH c_ref2 INTO l_delete_param_property_id;
1246: EXIT WHEN c_ref2%NOTFOUND;
1247: select VALUE_TRANSLATABLE_FLAG into l_trans_flag
1248: from ieu_wp_properties_b
1249: where property_id = 10003;
1250:
1251: if (l_delete_param_property_id is not null ) then
1252: if (l_trans_flag = 'Y') then

Line 1480: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;

1476: l_msg_data VARCHAR2(2000);
1477:
1478: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
1479:
1480: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
1481:
1482: v_cursor1 NUMBER;
1483: sql_stmt varchar2(2000);
1484: sql_stmt1 varchar2(2000);