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_PARAM_DEFS_B

Line 1331: DELETE FROM ieu_wp_param_defs_b

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

Line 1413: l_temp_param_name ieu_wp_param_defs_b.PARAM_NAME%type;

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);

Line 1423: temp_param_name ieu_wp_param_defs_b.PARAM_NAME%type;

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:
1426: BEGIN
1427:

Line 1443: ieu_wp_param_defs_b b

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);
1447:

Line 1451: ieu_wp_param_defs_b b,

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
1455: and b.PARAM_ID = tl.PARAM_ID

Line 1568: l_param_id IEU_WP_PARAM_DEFS_B.PARAM_ID%TYPE;

1564: l_msg_count NUMBER(2);
1565:
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;

Line 1593: select IEU_WP_PARAM_DEFS_B_S1.NEXTVAL into l_param_id from sys.dual;

1589: l_msg_data,
1590: rec_obj, 'Y');
1591:
1592: if (l_return_status = 'S') then
1593: select IEU_WP_PARAM_DEFS_B_S1.NEXTVAL into l_param_id from sys.dual;
1594:
1595:
1596: insert INTO IEU_WP_PARAM_DEFS_B
1597: (PARAM_ID,

Line 1596: insert INTO IEU_WP_PARAM_DEFS_B

1592: if (l_return_status = 'S') then
1593: select IEU_WP_PARAM_DEFS_B_S1.NEXTVAL into l_param_id from sys.dual;
1594:
1595:
1596: insert INTO IEU_WP_PARAM_DEFS_B
1597: (PARAM_ID,
1598: CREATED_BY,
1599: CREATION_DATE,
1600: LAST_UPDATED_BY,

Line 1743: l_param_id IEU_WP_PARAM_DEFS_B.PARAM_ID%TYPE;

1739: l_msg_count NUMBER(2);
1740:
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;

Line 1762: update IEU_WP_PARAM_DEFS_B set

1758:
1759:
1760:
1761:
1762: update IEU_WP_PARAM_DEFS_B set
1763: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1764: LAST_UPDATE_DATE = SYSDATE,
1765: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1766: DATA_TYPE = rec_obj.data_type

Line 1978: l_param_id IEU_WP_PARAM_DEFS_B.PARAM_ID%TYPE;

1974: l_msg_count NUMBER(2);
1975:
1976: l_msg_data VARCHAR2(2000);
1977:
1978: l_param_id IEU_WP_PARAM_DEFS_B.PARAM_ID%TYPE;
1979:
1980:
1981: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
1982:

Line 2206: l_param_id IEU_WP_PARAM_DEFS_B.PARAM_ID%TYPE;

2202: l_msg_count NUMBER(2);
2203:
2204: l_msg_data VARCHAR2(2000);
2205:
2206: l_param_id IEU_WP_PARAM_DEFS_B.PARAM_ID%TYPE;
2207:
2208:
2209: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
2210:

Line 2448: ' delete from IEU_WP_PARAM_DEFS_B where PARAM_ID = :1 '

2444:
2445:
2446:
2447: EXECUTE immediate
2448: ' delete from IEU_WP_PARAM_DEFS_B where PARAM_ID = :1 '
2449: USING x_param_id;
2450:
2451: if (sql%notfound) then
2452: null;

Line 2496: where param_id not in (select param_id from ieu_wp_param_defs_b));

2492: --delete param props if param has been deleted by some actions
2493: delete from ieu_wp_param_props_b where param_property_id in
2494: (select param_property_id
2495: from ieu_wp_param_props_b
2496: where param_id not in (select param_id from ieu_wp_param_defs_b));
2497:
2498: if (sql%notfound) then
2499: null;
2500: end if;

Line 2505: where param_id not in (select param_id from ieu_wp_param_defs_b));

2501:
2502: delete from ieu_wp_param_props_tl where param_property_id in
2503: (select param_property_id
2504: from ieu_wp_param_props_b
2505: where param_id not in (select param_id from ieu_wp_param_defs_b));
2506:
2507: if (sql%notfound) then
2508: null;
2509: end if;

Line 2917: l_param_id IEU_WP_PARAM_DEFS_B.PARAM_ID%TYPE;

2913: l_msg_count NUMBER(2);
2914:
2915: l_msg_data VARCHAR2(2000);
2916:
2917: l_param_id IEU_WP_PARAM_DEFS_B.PARAM_ID%TYPE;
2918:
2919:
2920: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
2921:

Line 2991: l_param_id IEU_WP_PARAM_DEFS_B.PARAM_ID%TYPE;

2987: l_msg_count NUMBER(2);
2988:
2989: l_msg_data VARCHAR2(2000);
2990:
2991: l_param_id IEU_WP_PARAM_DEFS_B.PARAM_ID%TYPE;
2992:
2993:
2994: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
2995:

Line 3048: ieu_wp_param_defs_b pdb,

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
3052: and pdb.PARAM_ID = ppb.PARAM_ID