APPS.IEU_UWQ_MACTION_DEFS_SEED_PKG dependencies on IEU_UWQ_MACTION_DEFS_B

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

1: PACKAGE BODY IEU_UWQ_MACTION_DEFS_SEED_PKG AS
2: /* $Header: IEUMACTB.pls 120.1 2005/07/07 02:18:38 appldev ship $ */
3: PROCEDURE Insert_Row (p_uwq_maction_defs_rec IN uwq_maction_defs_rec_type) IS
4:
5: CURSOR c IS SELECT 'X' FROM ieu_uwq_maction_defs_b
6: WHERE maction_def_id = p_uwq_maction_defs_rec.maction_def_id;
7:
8: l_dummy CHAR(1);
9:

Line 13: INSERT INTO ieu_uwq_maction_defs_b (

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

Line 88: UPDATE ieu_uwq_maction_defs_b SET

84: PROCEDURE Update_Row (p_uwq_maction_defs_rec IN uwq_maction_defs_rec_type) IS
85:
86: BEGIN
87: -- API body
88: UPDATE ieu_uwq_maction_defs_b SET
89: last_updated_by = p_uwq_maction_defs_rec.last_updated_by,
90: last_update_date = p_uwq_maction_defs_rec.last_update_date,
91: last_update_login = p_uwq_maction_defs_rec.last_update_login,
92: action_proc = p_uwq_maction_defs_rec.action_proc,

Line 233: from IEU_UWQ_MACTION_DEFS_B B

229: begin
230: delete from IEU_UWQ_MACTION_DEFS_TL T
231: where not exists
232: (select NULL
233: from IEU_UWQ_MACTION_DEFS_B B
234: where B.MACTION_DEF_ID = T.MACTION_DEF_ID
235: );
236:
237: update IEU_UWQ_MACTION_DEFS_TL T set (

Line 313: from IEU_UWQ_MACTION_DEFS_B

309: ACTION_PROC_TYPE_CODE,
310: MACTION_DEF_TYPE_FLAG,
311: APPLICATION_ID,
312: GLOBAL_FORM_PARAMS
313: from IEU_UWQ_MACTION_DEFS_B
314: where MACTION_DEF_ID = X_MACTION_DEF_ID
315: for update of MACTION_DEF_ID nowait;
316: recinfo c%rowtype;
317:

Line 377: delete from IEU_UWQ_MACTION_DEFS_B

373: if (sql%notfound) then
374: raise no_data_found;
375: end if;
376:
377: delete from IEU_UWQ_MACTION_DEFS_B
378: where MACTION_DEF_ID = X_MACTION_DEF_ID;
379:
380: if (sql%notfound) then
381: raise no_data_found;