APPS.IEU_WP_PARAM_PROPS_SEED_PKG dependencies on IEU_WP_PARAM_PROPS_B

Line 8: UPDATE ieu_wp_param_props_b SET

4: PROCEDURE Update_Row (p_wp_param_props_rec IN wp_param_props_rec_type) IS
5:
6: BEGIN
7: -- API body
8: UPDATE ieu_wp_param_props_b SET
9: last_updated_by = p_wp_param_props_rec.last_updated_by,
10: last_update_date = p_wp_param_props_rec.last_update_date,
11: last_update_login = p_wp_param_props_rec.last_update_login,
12: ACTION_PARAM_SET_ID = p_wp_param_props_rec.ACTION_PARAM_SET_ID,

Line 134: delete from IEU_WP_PARAM_PROPS_B

130: if (sql%notfound) then
131: raise no_data_found;
132: end if;
133:
134: delete from IEU_WP_PARAM_PROPS_B
135: where PARAM_PROPERTY_ID = X_PARAM_PROPERTY_ID;
136:
137: if (sql%notfound) then
138: raise no_data_found;

Line 146: FROM ieu_wp_param_props_b

142: PROCEDURE Insert_Row (p_wp_param_props_rec IN wp_param_props_rec_type)
143: IS
144: CURSOR c IS
145: SELECT 'X'
146: FROM ieu_wp_param_props_b
147: WHERE param_property_id = p_wp_param_props_rec.param_property_id;
148:
149: l_dummy CHAR(1);
150: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;

Line 151: l_temp ieu_wp_param_props_b.property_value%type;

147: WHERE param_property_id = p_wp_param_props_rec.param_property_id;
148:
149: l_dummy CHAR(1);
150: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
151: l_temp ieu_wp_param_props_b.property_value%type;
152: l_sequence NUMBER;
153: BEGIN
154: -- API body
155: -- if (p_wp_param_props_rec.property_id <> 10000) then

Line 156: insert into IEU_WP_PARAM_PROPS_B

152: l_sequence NUMBER;
153: BEGIN
154: -- API body
155: -- if (p_wp_param_props_rec.property_id <> 10000) then
156: insert into IEU_WP_PARAM_PROPS_B
157: ( PARAM_PROPERTY_ID,
158: CREATED_BY,
159: CREATION_DATE,
160: LAST_UPDATED_BY,

Line 240: from IEU_WP_PARAM_PROPS_B B

236: begin
237: delete from IEU_WP_PARAM_PROPS_TL T
238: where not exists
239: (select NULL
240: from IEU_WP_PARAM_PROPS_B B
241: where B.PARAM_PROPERTY_ID = T.PARAM_PROPERTY_ID
242: );
243:
244: update IEU_WP_PARAM_PROPS_TL T set (