eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEU_WORKPANEL_PVT dependencies on IEU_WP_ACTION_PARAMS

Line 1328: (SELECT param_id FROM ieu_wp_action_params

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:
1331: DELETE FROM ieu_wp_param_defs_b
1332: WHERE param_id IN

Line 1333: (SELECT param_id FROM ieu_wp_action_params

1329: WHERE wp_action_def_id = l_maction_def_id);
1330:
1331: DELETE FROM ieu_wp_param_defs_b
1332: WHERE param_id IN
1333: (SELECT param_id FROM ieu_wp_action_params
1334: WHERE wp_action_def_id = l_maction_def_id);
1335:
1336: DELETE FROM ieu_wp_action_params
1337: WHERE wp_action_def_id = l_maction_def_id;

Line 1336: DELETE FROM ieu_wp_action_params

1332: WHERE param_id IN
1333: (SELECT param_id FROM ieu_wp_action_params
1334: WHERE wp_action_def_id = l_maction_def_id);
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;

Line 1442: from ieu_wp_action_params p,

1438: temp_param_name := LTRIM(RTRIM(rec_obj.param_name));
1439:
1440:
1441: select count(*) into l_param_name_count
1442: from ieu_wp_action_params p,
1443: ieu_wp_param_defs_b b
1444: where p.PARAM_ID = b.PARAM_ID
1445: and p.WP_ACTION_DEF_ID = rec_obj.wp_action_def_id
1446: and lower(b.PARAM_NAME) = lower(temp_param_name);

Line 1450: from ieu_wp_action_params p,

1446: and lower(b.PARAM_NAME) = lower(temp_param_name);
1447:
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

Line 1570: l_action_param_map_id IEU_WP_ACTION_PARAMS.ACTION_PARAM_MAP_ID%TYPE;

1566: l_msg_data VARCHAR2(2000);
1567:
1568: l_param_id IEU_WP_PARAM_DEFS_B.PARAM_ID%TYPE;
1569:
1570: l_action_param_map_id IEU_WP_ACTION_PARAMS.ACTION_PARAM_MAP_ID%TYPE;
1571:
1572: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%TYPE;
1573:
1574:

Line 1652: select IEU_WP_ACTION_PARAMS_S1.NEXTVAL into l_action_param_map_id from sys.dual;

1648: );
1649:
1650: --DBMS_OUTPUT.PUT_LINE('inserted into param defs tl ');
1651:
1652: select IEU_WP_ACTION_PARAMS_S1.NEXTVAL into l_action_param_map_id from sys.dual;
1653:
1654: insert INTO IEU_WP_ACTION_PARAMS
1655: (PARAM_ID,
1656: CREATED_BY,

Line 1654: insert INTO IEU_WP_ACTION_PARAMS

1650: --DBMS_OUTPUT.PUT_LINE('inserted into param defs tl ');
1651:
1652: select IEU_WP_ACTION_PARAMS_S1.NEXTVAL into l_action_param_map_id from sys.dual;
1653:
1654: insert INTO IEU_WP_ACTION_PARAMS
1655: (PARAM_ID,
1656: CREATED_BY,
1657: CREATION_DATE,
1658: LAST_UPDATED_BY,

Line 1745: l_action_param_map_id IEU_WP_ACTION_PARAMS.ACTION_PARAM_MAP_ID%TYPE;

1741: l_msg_data VARCHAR2(2000);
1742:
1743: l_param_id IEU_WP_PARAM_DEFS_B.PARAM_ID%TYPE;
1744:
1745: l_action_param_map_id IEU_WP_ACTION_PARAMS.ACTION_PARAM_MAP_ID%TYPE;
1746:
1747: l_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.ACTION_PARAM_SET_ID%TYPE;
1748:
1749: BEGIN

Line 2429: ' delete from ieu_wp_action_params where param_id = :1 '

2425:
2426:
2427:
2428: EXECUTE immediate
2429: ' delete from ieu_wp_action_params where param_id = :1 '
2430: USING x_param_id;
2431:
2432: if (sql%notfound) then
2433: null;

Line 2927: ieu_wp_action_params ap,

2923:
2924: cursor c_cur is
2925: select distinct ppb.action_param_set_id, ap.param_id
2926: from
2927: ieu_wp_action_params ap,
2928: ieu_wp_param_props_b ppb
2929: where
2930: ap.wp_action_def_id=p_wp_action_def_id
2931: and ap.param_id = ppb.param_id

Line 2949: ieu_wp_action_params ap,

2945:
2946: delete from ieu_wp_param_props_b
2947: where action_param_set_id in ( select distinct ppb.ACTION_PARAM_SET_ID
2948: from
2949: ieu_wp_action_params ap,
2950: ieu_wp_param_props_b ppb
2951: where
2952: ap.WP_ACTION_DEF_ID=p_wp_action_def_id
2953: and ap.PARAM_ID = ppb.PARAM_ID)

Line 3012: ieu_wp_action_params ap,

3008: delete from ieu_wp_param_props_b
3009: where property_id in(10010, 10003, 10021, 10011)
3010: and action_param_set_id in (select distinct ppb.ACTION_PARAM_SET_ID
3011: from
3012: ieu_wp_action_params ap,
3013: ieu_wp_param_props_b ppb
3014: where
3015: ap.WP_ACTION_DEF_ID= p_wp_action_def_id
3016: and ap.PARAM_ID = ppb.PARAM_ID);

Line 3047: from ieu_wp_action_params p,

3043: p_action_param_set_id IN NUMBER)
3044: As
3045: cursor c_cur is
3046: select ppb.PARAM_PROPERTY_ID, pdb.PARAM_ID, ppb.PROPERTY_VALUE
3047: from ieu_wp_action_params p,
3048: ieu_wp_param_defs_b pdb,
3049: ieu_wp_param_props_b ppb
3050: where p.WP_ACTION_DEF_ID = p_wp_action_def_id
3051: and p.PARAM_ID = pdb.PARAM_ID