APPS.IEU_WORK_ACTION_PVT dependencies on IEU_UWQ_MACTION_DEFS_TL

Line 236: temp_act_user_label IEU_UWQ_MACTION_DEFS_TL.action_user_label%type;

232: l_act_usr_lbl_count NUMBER(10);
233: l_temp_count NUMBER;
234: l_msg_count NUMBER(10);
235: l_msg_data VARCHAR2(2000);
236: temp_act_user_label IEU_UWQ_MACTION_DEFS_TL.action_user_label%type;
237: l_set_id_count NUMBER(10);
238:
239:
240: BEGIN

Line 251: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl,

247: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
248: l_set_id_count :=0;
249: temp_act_user_label := LTRIM(RTRIM(p_label));
250: select count(b.maction_def_id) into l_act_usr_lbl_count
251: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl,
252: ieu_wp_act_param_sets_b s
253: where
254: b.maction_def_id = tl.maction_def_id
255: and b.maction_def_type_flag = (select maction_def_type_flag

Line 523: insert INTO IEU_UWQ_MACTION_DEFS_TL

519: rec_obj.multi_select_flag
520: );
521: end if ;
522:
523: insert INTO IEU_UWQ_MACTION_DEFS_TL
524: (MACTION_DEF_ID,
525: LANGUAGE,
526: CREATED_BY,
527: CREATION_DATE,

Line 1040: DELETE FROM ieu_uwq_maction_defs_tl

1036:
1037: DELETE FROM ieu_wp_action_params
1038: WHERE wp_action_def_id = l_maction_def_id;
1039:
1040: DELETE FROM ieu_uwq_maction_defs_tl
1041: WHERE maction_def_id = l_maction_def_id;
1042:
1043: DELETE FROM ieu_uwq_maction_defs_b
1044: WHERE maction_def_id = l_maction_def_id;

Line 1047: DELETE FROM ieu_uwq_maction_defs_tl

1043: DELETE FROM ieu_uwq_maction_defs_b
1044: WHERE maction_def_id = l_maction_def_id;
1045: END IF;
1046: else
1047: DELETE FROM ieu_uwq_maction_defs_tl
1048: WHERE maction_def_id = x_maction_id;
1049:
1050: DELETE FROM ieu_uwq_maction_defs_b
1051: WHERE maction_def_id = x_maction_id;