APPS.IEU_WP_ACT_PARAM_SETS_SEED_PKG dependencies on IEU_WP_ACT_PARAM_SETS_B

Line 8: UPDATE ieu_WP_ACT_PARAM_SETS_b SET

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

Line 136: delete from IEU_WP_ACT_PARAM_SETS_B

132: if (sql%notfound) then
133: raise no_data_found;
134: end if;
135:
136: delete from IEU_WP_ACT_PARAM_SETS_B
137: where ACTION_PARAM_SET_ID = X_ACTION_PARAM_SET_ID;
138:
139: if (sql%notfound) then
140: raise no_data_found;

Line 147: SELECT 'X' FROM ieu_WP_ACT_PARAM_SETS_b

143:
144: PROCEDURE Insert_Row (p_WP_ACT_PARAM_SETS_rec IN WP_ACT_PARAM_SETS_rec_type) IS
145:
146: CURSOR c IS
147: SELECT 'X' FROM ieu_WP_ACT_PARAM_SETS_b
148: WHERE ACTION_PARAM_SET_ID = p_WP_ACT_PARAM_SETS_rec.ACTION_PARAM_SET_ID;
149:
150: l_dummy CHAR(1);
151:

Line 155: insert into IEU_WP_ACT_PARAM_SETS_B

151:
152: BEGIN
153:
154: -- API body
155: insert into IEU_WP_ACT_PARAM_SETS_B
156: ( ACTION_PARAM_SET_ID,
157: CREATED_BY,
158: CREATION_DATE,
159: LAST_UPDATED_BY,

Line 224: from IEU_WP_ACT_PARAM_SETS_B B

220: begin
221: delete from IEU_WP_ACT_PARAM_SETS_TL T
222: where not exists
223: (select NULL
224: from IEU_WP_ACT_PARAM_SETS_B B
225: where B.ACTION_PARAM_SET_ID = T.ACTION_PARAM_SET_ID
226: );
227:
228: update IEU_WP_ACT_PARAM_SETS_TL T set (