APPS.IEU_WORKPANEL_PVT dependencies on IEU_WP_PROPERTIES_B

Line 1834: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;

1830: l_msg_data VARCHAR2(2000);
1831:
1832: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
1833:
1834: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
1835:
1836: l_return_status VARCHAR2(4);
1837:
1838:

Line 1885: from ieu_wp_properties_b

1881: );
1882: --dbms_outPUT.PUT_LINE('inserted into param props b ');
1883:
1884: select VALUE_TRANSLATABLE_FLAG into l_trans_flag
1885: from ieu_wp_properties_b
1886: where property_id = p_property_id;
1887:
1888: if (l_trans_flag = 'Y') then
1889:

Line 1983: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;

1979:
1980:
1981: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
1982:
1983: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
1984:
1985:
1986: BEGIN
1987:

Line 2105: ' from ieu_wp_properties_b '||

2101: p_action_param_set_id, p_param_id, p_property_id,
2102: p_property_value, 'F','0' ;
2103: EXECUTE immediate
2104: ' select VALUE_TRANSLATABLE_FLAG '||
2105: ' from ieu_wp_properties_b '||
2106: ' where property_id = :1 '
2107: into l_trans_flag USING p_property_id;
2108:
2109: if (l_trans_flag = 'Y') then

Line 2211: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;

2207:
2208:
2209: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
2210:
2211: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
2212:
2213:
2214: BEGIN
2215:

Line 2324: from ieu_wp_properties_b

2320: );
2321:
2322:
2323: select VALUE_TRANSLATABLE_FLAG into l_trans_flag
2324: from ieu_wp_properties_b
2325: where property_id = p_property_id;
2326:
2327: if (l_trans_flag = 'Y') then
2328:

Line 2574: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;

2570:
2571:
2572: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
2573:
2574: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
2575:
2576:
2577: BEGIN
2578:

Line 2639: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;

2635:
2636:
2637: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
2638:
2639: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
2640:
2641:
2642: BEGIN
2643:

Line 2922: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;

2918:
2919:
2920: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
2921:
2922: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
2923:
2924: cursor c_cur is
2925: select distinct ppb.action_param_set_id, ap.param_id
2926: from

Line 2996: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;

2992:
2993:
2994: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
2995:
2996: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
2997:
2998:
2999: BEGIN
3000: fnd_msg_pub.delete_msg();