[Home] [Help]
1322:
1323: --c.
1324: IF (l_num_set_entries = 1) THEN
1325:
1326: DELETE FROM ieu_wp_param_defs_tl
1327: WHERE param_id IN
1328: (SELECT param_id FROM ieu_wp_action_params
1329: WHERE wp_action_def_id = l_maction_def_id);
1330:
1408: l_param_usr_lbl_count NUMBER(10);
1409:
1410: l_param_name_count NUMBER(10);
1411:
1412: l_temp_param_label ieu_wp_param_defs_TL.PARAM_USER_LABEL%type;
1413: l_temp_param_name ieu_wp_param_defs_b.PARAM_NAME%type;
1414:
1415:
1416: l_temp_count NUMBER(10);
1417: l_msg_count NUMBER(10);
1418: l_msg_data VARCHAR2(2000);
1419:
1420:
1421: temp_param_user_label ieu_wp_param_defs_TL.PARAM_USER_LABEL%type;
1422:
1423: temp_param_name ieu_wp_param_defs_b.PARAM_NAME%type;
1424:
1425:
1448:
1449: select count(*) into l_param_usr_lbl_count
1450: from ieu_wp_action_params p,
1451: ieu_wp_param_defs_b b,
1452: ieu_wp_param_defs_tl tl
1453: where p.PARAM_ID = b.PARAM_ID
1454: and p.WP_ACTION_DEF_ID = rec_obj.wp_action_def_id
1455: and b.PARAM_ID = tl.PARAM_ID
1456: and tl.LANGUAGE = l_language
1620: --dbms_outPUT.PUT_LINE('inserted into param defs b ');
1621: -- APPLICATION_ID
1622: --rec_obj.application_id
1623:
1624: insert INTO IEU_WP_PARAM_DEFS_TL
1625: (PARAM_ID,
1626: CREATED_BY,
1627: CREATION_DATE,
1628: LAST_UPDATED_BY,
1771: null;
1772: end if;
1773:
1774:
1775: update IEU_WP_PARAM_DEFS_TL set
1776: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1777: LAST_UPDATE_DATE = SYSDATE,
1778: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1779: PARAM_USER_LABEL = LTRIM(RTRIM(rec_obj.param_user_label)),
2434: end if;
2435:
2436:
2437: EXECUTE immediate
2438: ' delete from IEU_WP_PARAM_DEFS_TL where PARAM_ID = :1 '
2439: USING x_param_id;
2440:
2441: if (sql%notfound) then
2442: null;