APPS.IEU_WP_PARAM_DEFS_SEED_PKG dependencies on IEU_WP_PARAM_DEFS_B

Line 8: UPDATE ieu_WP_PARAM_DEFS_b SET

4: PROCEDURE Update_Row (p_WP_PARAM_DEFS_rec IN WP_PARAM_DEFS_rec_type) IS
5:
6: BEGIN
7: -- API body
8: UPDATE ieu_WP_PARAM_DEFS_b SET
9: last_updated_by = p_WP_PARAM_DEFS_rec.last_updated_by,
10: last_update_date = p_WP_PARAM_DEFS_rec.last_update_date,
11: last_update_login = p_WP_PARAM_DEFS_rec.last_update_login,
12: param_name = p_WP_PARAM_DEFS_rec.param_name,

Line 138: delete from IEU_WP_PARAM_DEFS_B

134: if (sql%notfound) then
135: raise no_data_found;
136: end if;
137:
138: delete from IEU_WP_PARAM_DEFS_B
139: where PARAM_ID = r_PARAM_ID;
140:
141: if (sql%notfound) then
142: raise no_data_found;

Line 148: CURSOR c IS SELECT 'X' FROM ieu_WP_PARAM_DEFS_b

144: end DELETE_ROW;
145:
146: PROCEDURE Insert_Row (p_WP_PARAM_DEFS_rec IN WP_PARAM_DEFS_rec_type) IS
147:
148: CURSOR c IS SELECT 'X' FROM ieu_WP_PARAM_DEFS_b
149: WHERE PARAM_ID = p_WP_PARAM_DEFS_rec.PARAM_ID;
150:
151: l_dummy CHAR(1);
152:

Line 156: insert into IEU_WP_PARAM_DEFS_B

152:
153: BEGIN
154:
155: -- API body
156: insert into IEU_WP_PARAM_DEFS_B
157: ( PARAM_ID,
158: CREATED_BY,
159: CREATION_DATE,
160: LAST_UPDATED_BY,

Line 223: from IEU_WP_PARAM_DEFS_B B

219: begin
220: delete from IEU_WP_PARAM_DEFS_TL T
221: where not exists
222: (select NULL
223: from IEU_WP_PARAM_DEFS_B B
224: where B.PARAM_ID = T.PARAM_ID
225: );
226:
227: update IEU_WP_PARAM_DEFS_TL T set (