[Home] [Help]
45: l_act_usr_lbl_count NUMBER(10);
46:
47: l_act_def_key_count NUMBER(10);
48:
49: l_temp_act_label IEU_UWQ_MACTION_DEFS_TL.ACTION_USER_LABEL%type;
50:
51: l_temp_pkg_name IEU_UWQ_MACTION_DEFS_B.ACTION_PROC%TYPE;
52:
53:
58: l_msg_data VARCHAR2(2000);
59:
60: l_set_id_count NUMBER(10);
61:
62: temp_act_user_label IEU_UWQ_MACTION_DEFS_TL.action_user_label%type;
63:
64: temp_act_key IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_KEY%type;
65:
66:
78:
79: temp_act_user_label := LTRIM(RTRIM(rec_obj.action_user_label));
80:
81: -- select count(b.maction_def_id) into l_act_usr_lbl_count
82: -- from IEU_UWQ_MACTION_DEFS_B b, IEU_UWQ_MACTION_DEFS_TL tl
83: -- where b.maction_def_id = tl.maction_def_id
84: -- and tl.language = l_language
85: -- and lower(tl.action_user_label) = lower(temp_act_user_label)
86: -- and b.maction_def_type_flag = p_maction_def_type_flag;
88:
89: if (p_maction_def_type_flag <> 'F' and p_maction_def_type_flag <> 'N' and p_maction_def_type_flag <> 'M' ) then
90:
91: select count(b.maction_def_id) into l_act_usr_lbl_count
92: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
93: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl
94: where e. sel_enum_id = rec_obj.enum_id
95: -- and e.application_id = m.application_id
96: and e.enum_type_uuid = m.action_map_code
114:
115:
116:
117: select count(b.maction_def_id) into l_set_id_count
118: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
119: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl
120: where e. sel_enum_id = rec_obj.enum_id
121: --and e.application_id = m.application_id
122: and e.enum_type_uuid = m.action_map_code
134:
135: elsif (p_maction_def_type_flag = 'F') then
136:
137: select count(b.maction_def_id) into l_act_usr_lbl_count
138: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
139: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e,
140: ieu_wp_act_param_sets_tl stl, ieu_uwq_node_ds ds
141: where e. sel_enum_id = rec_obj.enum_id
142: --and e.application_id = m.application_id
155:
156:
157:
158: select count(b.maction_def_id) into l_set_id_count
159: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
160: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e,
161: ieu_wp_act_param_sets_tl stl, ieu_uwq_node_ds ds
162: where e. sel_enum_id = rec_obj.enum_id
163: --and e.application_id = m.application_id
205: -- this check for media and non-media actions is always done
206: if (p_maction_def_type_flag = 'M' or p_maction_def_type_flag = 'N') then
207: -- count how many maction_defs of the same type have the same name, besides the current one
208: select count(mb.maction_def_id) into l_set_id_count
209: from ieu_uwq_maction_defs_tl mtl,
210: ieu_uwq_maction_defs_b mb
211: where mb.maction_def_id = mtl.maction_def_id and
212: mb.maction_def_id <> nvl(rec_obj.maction_def_id, -1) and -- ignore current action's record
213: nvl(mb.maction_def_type_flag, 'M') = p_maction_def_type_flag and
344:
345: l_temp_count NUMBER;
346: l_msg_count NUMBER(10);
347: l_msg_data VARCHAR2(2000);
348: temp_act_user_label IEU_UWQ_MACTION_DEFS_TL.action_user_label%type;
349: l_set_id_count NUMBER(10);
350:
351:
352: BEGIN
373:
374: if(p_maction_def_type_flag <> 'F') then
375:
376: select count(b.maction_def_id) into l_act_usr_lbl_count
377: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
378: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl
379: where e. sel_enum_id = p_enum_id
380: -- and e.application_id = m.application_id
381: and e.enum_type_uuid = m.action_map_code
392:
393: --DBMS_OUTPUT.PUT_LINE(' maction lable count : '||l_act_usr_lbl_count);
394:
395: select count(b.maction_def_id) into l_set_id_count
396: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
397: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl
398: where e. sel_enum_id = p_enum_id
399: --and e.application_id = m.application_id
400: and e.enum_type_uuid = m.action_map_code
411:
412: elsif (p_maction_def_type_flag = 'F') then
413:
414: select count(b.maction_def_id) into l_act_usr_lbl_count
415: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
416: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl,
417: IEU_UWQ_NODE_DS ds
418: where e. sel_enum_id = p_enum_id
419: --and e.application_id = m.application_id
433:
434:
435:
436: select count(b.maction_def_id) into l_set_id_count
437: from ieu_uwq_maction_defs_b b, ieu_uwq_maction_defs_tl tl, ieu_wp_action_maps m,
438: ieu_wp_act_param_sets_b s, ieu_uwq_sel_enumerators e, ieu_wp_act_param_sets_tl stl, IEU_UWQ_NODE_DS ds
439: where e. sel_enum_id = p_enum_id
440: --and e.application_id = m.application_id
441: and e.enum_type_uuid = ds.ENUM_TYPE_UUID
709: );
710:
711: --DBMS_OUTPUT.PUT_LINE('inserted in maction defs b: ');
712:
713: insert INTO IEU_UWQ_MACTION_DEFS_TL
714: (MACTION_DEF_ID,
715: LANGUAGE,
716: CREATED_BY,
717: CREATION_DATE,
1039: MULTI_SELECT_FLAG = rec_obj.multi_select_flag
1040: where MACTION_DEF_ID = p_param_set_id
1041: and nvl(MACTION_DEF_TYPE_FLAG,'M') = p_maction_def_type_flag;
1042:
1043: update IEU_UWQ_MACTION_DEFS_tl set
1044: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1045: LAST_UPDATE_DATE = SYSDATE,
1046: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1047: action_description = LTRIM(RTRIM(rec_obj.action_description)),
1126: if (sql%notfound) then
1127: null;
1128: end if;
1129:
1130: delete from IEU_UWQ_MACTION_DEFS_TL
1131: where MACTION_DEF_ID = x_action_def_id and language= l_language;
1132:
1133: if (sql%notfound) then
1134: null;
1335:
1336: DELETE FROM ieu_wp_action_params
1337: WHERE wp_action_def_id = l_maction_def_id;
1338:
1339: DELETE FROM ieu_uwq_maction_defs_tl
1340: WHERE maction_def_id = l_maction_def_id;
1341:
1342: DELETE FROM ieu_uwq_maction_defs_b
1343: WHERE maction_def_id = l_maction_def_id;