APPS.IEU_UWQ_MACTION_DEFS_SEED_PVT dependencies on IEU_UWQ_MACTION_DEFS_B

Line 6: CURSOR c IS SELECT 'X' FROM ieu_uwq_maction_defs_b

2: /* $Header: IEUMACTB.pls 115.1 2000/02/29 15:55:10 pkm ship $ */
3:
4: PROCEDURE Insert_Row (p_uwq_maction_defs_rec IN uwq_maction_defs_rec_type) IS
5:
6: CURSOR c IS SELECT 'X' FROM ieu_uwq_maction_defs_b
7: WHERE maction_def_id = p_uwq_maction_defs_rec.maction_def_id;
8:
9: l_dummy CHAR(1);
10:

Line 14: INSERT INTO ieu_uwq_maction_defs_b (

10:
11: BEGIN
12:
13: -- API body
14: INSERT INTO ieu_uwq_maction_defs_b (
15: maction_def_id,
16: created_by,
17: creation_date,
18: last_updated_by,

Line 79: UPDATE ieu_uwq_maction_defs_b SET

75: PROCEDURE Update_Row (p_uwq_maction_defs_rec IN uwq_maction_defs_rec_type) IS
76:
77: BEGIN
78: -- API body
79: UPDATE ieu_uwq_maction_defs_b SET
80: last_updated_by = p_uwq_maction_defs_rec.last_updated_by,
81: last_update_date = p_uwq_maction_defs_rec.last_update_date,
82: last_update_login = p_uwq_maction_defs_rec.last_update_login,
83: action_proc = p_uwq_maction_defs_rec.action_proc

Line 190: from IEU_UWQ_MACTION_DEFS_B B

186: begin
187: delete from IEU_UWQ_MACTION_DEFS_TL T
188: where not exists
189: (select NULL
190: from IEU_UWQ_MACTION_DEFS_B B
191: where B.MACTION_DEF_ID = T.MACTION_DEF_ID
192: );
193:
194: update IEU_UWQ_MACTION_DEFS_TL T set (