APPS.IEU_WORK_PANEL_PUB dependencies on IEU_WP_PARAM_DEFS_B

Line 342: -- r_PARAM_NAME IN ieu_wp_param_defs_b.param_id%type Required

338: -- Parameters
339: --
340: -- IN
341: --
342: -- r_PARAM_NAME IN ieu_wp_param_defs_b.param_id%type Required
343: -- r_ACTION_KEY IN ieu_uwq_maction_defs-b.maction_def_key%type --- Requried
344: -- End of Comments
345: -- ===============================================================
346:

Line 350: r_PARAM_NAME IN ieu_wp_param_defs_b.param_name%type,

346:
347: PROCEDURE DeleteActionParam(x_return_status OUT NOCOPY VARCHAR2,
348: x_msg_count OUT NOCOPY NUMBER,
349: x_msg_data OUT NOCOPY VARCHAR2,
350: r_PARAM_NAME IN ieu_wp_param_defs_b.param_name%type,
351: r_ACTION_KEY IN ieu_uwq_maction_defs_b.maction_def_key%type)
352: As
353: v_cursor1 NUMBER;
354: v_cursor NUMBER;

Line 379: from ieu_wp_param_defs_b

375: -- this cursor is to find outall action_param_set_id
376: --which wp_action_def_id is related to x_action_key
377: cursor c_cursor is
378: select param_id
379: from ieu_wp_param_defs_b
380: where param_name = LTRIM(RTRIM(r_param_name))
381: AND param_id IN (SELECT param_id
382: FROM ieu_wp_action_params
383: WHERE WP_ACTION_DEF_ID IN (SELECT maction_def_id

Line 391: from ieu_wp_param_props_b a, ieu_wp_param_defs_b b

387: );
388:
389: cursor c_cursor1 is
390: select a.param_property_id, a.property_id
391: from ieu_wp_param_props_b a, ieu_wp_param_defs_b b
392: where a.param_id = b.param_id
393: and b.param_name = LTRIM(RTRIM(r_param_name))
394: AND a.param_id IN (SELECT param_id
395: FROM ieu_wp_action_params

Line 404: from ieu_wp_action_params a, ieu_wp_param_defs_b b

400: );
401:
402: cursor c_cursor2 is
403: select a.ACTION_PARAM_MAP_ID
404: from ieu_wp_action_params a, ieu_wp_param_defs_b b
405: where a.param_id = b.param_id
406: and b.param_name = LTRIM(RTRIM(r_param_name))
407: AND a.param_id IN (SELECT param_id
408: FROM ieu_wp_action_params

Line 439: delete from ieu_wp_param_defs_b where param_ID= cur_rec.param_ID;

435: end LOOP;
436:
437: FOR cur_rec IN c_cursor
438: LOOP
439: delete from ieu_wp_param_defs_b where param_ID= cur_rec.param_ID;
440: delete from ieu_wp_param_defs_tl where param_ID= cur_rec.param_ID;
441: end LOOP;
442: FOR cur_rec IN c_cursor3
443: loop