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_PROPS_B

Line 1310: (SELECT param_property_id FROM ieu_wp_param_props_b

1306:
1307: --b.
1308: DELETE FROM ieu_wp_param_props_tl
1309: WHERE param_property_id IN
1310: (SELECT param_property_id FROM ieu_wp_param_props_b
1311: WHERE
1312: action_param_set_id = x_param_set_id);
1313:
1314: DELETE FROM ieu_wp_param_props_b

Line 1314: DELETE FROM ieu_wp_param_props_b

1310: (SELECT param_property_id FROM ieu_wp_param_props_b
1311: WHERE
1312: action_param_set_id = x_param_set_id);
1313:
1314: DELETE FROM ieu_wp_param_props_b
1315: WHERE action_param_set_id = x_param_set_id;
1316:
1317: DELETE FROM ieu_wp_act_param_sets_tl
1318: WHERE action_param_set_id = x_param_set_id;

Line 1832: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;

1828: l_msg_count NUMBER(2);
1829:
1830: l_msg_data VARCHAR2(2000);
1831:
1832: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
1833:
1834: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
1835:
1836: l_return_status VARCHAR2(4);

Line 1853: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;

1849:
1850:
1851: if ( p_property_id <> -1) then
1852:
1853: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
1854:
1855: insert INTO IEU_WP_PARAM_PROPS_B
1856: (PARAM_PROPERTY_ID,
1857: CREATED_BY,

Line 1855: insert INTO IEU_WP_PARAM_PROPS_B

1851: if ( p_property_id <> -1) then
1852:
1853: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
1854:
1855: insert INTO IEU_WP_PARAM_PROPS_B
1856: (PARAM_PROPERTY_ID,
1857: CREATED_BY,
1858: CREATION_DATE,
1859: LAST_UPDATED_BY,

Line 1981: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;

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:
1983: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
1984:
1985:

Line 2002: ' update IEU_WP_PARAM_PROPS_B set '||

1998: or p_property_id =10011 or p_property_id = 10022) then
1999:
2000:
2001: EXECUTE immediate
2002: ' update IEU_WP_PARAM_PROPS_B set '||
2003: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
2004: ' LAST_UPDATE_DATE = SYSDATE, '||
2005: ' LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, '||
2006: ' PROPERTY_VALUE = :1, '||

Line 2014: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;

2010: ' and PROPERTY_ID in ( 10010, 10021, 10011, 10022, 10003)'
2011: USING p_property_value, p_property_id,p_param_id,p_action_param_set_id;
2012: if (SQL%NOTFOUND OR (SQL%ROWCOUNT <= 0)) then
2013:
2014: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
2015:
2016:
2017: EXECUTE immediate
2018: ' INSERT INTO IEU_WP_PARAM_PROPS_B '||

Line 2018: ' INSERT INTO IEU_WP_PARAM_PROPS_B '||

2014: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
2015:
2016:
2017: EXECUTE immediate
2018: ' INSERT INTO IEU_WP_PARAM_PROPS_B '||
2019: ' (PARAM_PROPERTY_ID, '||
2020: ' CREATED_BY, '||
2021: ' CREATION_DATE,'||
2022: ' LAST_UPDATED_BY, '||

Line 2059: ' update IEU_WP_PARAM_PROPS_B set '||

2055:
2056:
2057:
2058: EXECUTE immediate
2059: ' update IEU_WP_PARAM_PROPS_B set '||
2060: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
2061: ' LAST_UPDATE_DATE = SYSDATE, '||
2062: ' LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, '||
2063: ' PROPERTY_VALUE = :1 '||

Line 2071: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;

2067: USING p_property_value,p_param_id, p_action_param_set_id, p_property_id ;
2068:
2069: if (SQL%NOTFOUND OR (SQL%ROWCOUNT <= 0)) then
2070:
2071: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
2072: EXECUTE immediate
2073: ' INSERT INTO IEU_WP_PARAM_PROPS_B'||
2074: ' (PARAM_PROPERTY_ID, '||
2075: ' CREATED_BY, '||

Line 2073: ' INSERT INTO IEU_WP_PARAM_PROPS_B'||

2069: if (SQL%NOTFOUND OR (SQL%ROWCOUNT <= 0)) then
2070:
2071: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
2072: EXECUTE immediate
2073: ' INSERT INTO IEU_WP_PARAM_PROPS_B'||
2074: ' (PARAM_PROPERTY_ID, '||
2075: ' CREATED_BY, '||
2076: ' CREATION_DATE, '||
2077: ' LAST_UPDATED_BY, '||

Line 2150: ' from IEU_WP_PARAM_PROPS_B '||

2146: begin
2147:
2148: execute immediate
2149: ' select PARAM_PROPERTY_ID '||
2150: ' from IEU_WP_PARAM_PROPS_B '||
2151: ' where PARAM_ID = :1 '||
2152: ' and ACTION_PARAM_SET_ID = :2 ' ||
2153: ' and PROPERTY_ID = :3 '
2154: into l_param_property_id USING p_param_id,p_action_param_set_id, p_property_id ;

Line 2209: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;

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:
2211: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
2212:
2213:

Line 2228: update IEU_WP_PARAM_PROPS_B set

2224: /*******************ADD FOR FORWARD PORT BUG5585922 BY MAJHA**********************/
2225: if (p_property_id = 10003 or p_property_id = 10022) then
2226: --if (p_property_id = 10003 or p_property_id = 10022 or p_property_id = 10011) then
2227: /*********************************************************************************/
2228: update IEU_WP_PARAM_PROPS_B set
2229: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2230: LAST_UPDATE_DATE = SYSDATE,
2231: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2232: PROPERTY_VALUE = p_property_value,

Line 2242: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;

2238: --and PROPERTY_ID in (10022, 10003, 10011);
2239: /*********************************************************************************/
2240: if (SQL%NOTFOUND OR (SQL%ROWCOUNT <= 0)) then
2241:
2242: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
2243:
2244:
2245: INSERT INTO IEU_WP_PARAM_PROPS_B
2246: (PARAM_PROPERTY_ID,

Line 2245: INSERT INTO IEU_WP_PARAM_PROPS_B

2241:
2242: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
2243:
2244:
2245: INSERT INTO IEU_WP_PARAM_PROPS_B
2246: (PARAM_PROPERTY_ID,
2247: CREATED_BY,
2248: CREATION_DATE,
2249: LAST_UPDATED_BY,

Line 2282: update IEU_WP_PARAM_PROPS_B set

2278: else
2279:
2280:
2281:
2282: update IEU_WP_PARAM_PROPS_B set
2283: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2284: LAST_UPDATE_DATE = SYSDATE,
2285: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2286: PROPERTY_VALUE = p_property_value

Line 2293: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;

2289: and PROPERTY_ID = p_property_id;
2290:
2291: if (SQL%NOTFOUND OR (SQL%ROWCOUNT <= 0)) then
2292:
2293: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
2294: INSERT INTO IEU_WP_PARAM_PROPS_B
2295: (PARAM_PROPERTY_ID,
2296: CREATED_BY,
2297: CREATION_DATE,

Line 2294: INSERT INTO IEU_WP_PARAM_PROPS_B

2290:
2291: if (SQL%NOTFOUND OR (SQL%ROWCOUNT <= 0)) then
2292:
2293: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
2294: INSERT INTO IEU_WP_PARAM_PROPS_B
2295: (PARAM_PROPERTY_ID,
2296: CREATED_BY,
2297: CREATION_DATE,
2298: LAST_UPDATED_BY,

Line 2363: from IEU_WP_PARAM_PROPS_B

2359:
2360: begin
2361:
2362: select PARAM_PROPERTY_ID into l_param_property_id
2363: from IEU_WP_PARAM_PROPS_B
2364: where PARAM_ID = p_param_id
2365: and ACTION_PARAM_SET_ID = p_action_param_set_id
2366: and PROPERTY_ID = p_property_id;
2367:

Line 2458: ' delete from IEU_WP_PARAM_PROPS_B ' ||

2454:
2455:
2456:
2457: EXECUTE immediate
2458: ' delete from IEU_WP_PARAM_PROPS_B ' ||
2459: ' where PARAM_ID = :1 '||
2460: ' and ACTION_PARAM_SET_ID = :2 '
2461: USING x_param_id, x_param_set_id;
2462:

Line 2471: ' from IEU_WP_PARAM_PROPS_B '||

2467: begin
2468:
2469: EXECUTE immediate
2470: ' select PARAM_PROPERTY_ID '||
2471: ' from IEU_WP_PARAM_PROPS_B '||
2472: ' where PARAM_ID = :1 ' ||
2473: ' and ACTION_PARAM_SET_ID= :2 '
2474: INTO l_param_property_id USING x_param_id, x_param_set_id;
2475:

Line 2493: delete from ieu_wp_param_props_b where param_property_id in

2489:
2490:
2491:
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:

Line 2495: from ieu_wp_param_props_b

2491:
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;

Line 2504: from ieu_wp_param_props_b

2500: end if;
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;

Line 2572: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;

2568: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;
2569:
2570:
2571:
2572: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
2573:
2574: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
2575:
2576:

Line 2637: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;

2633: l_enum_uuid IEU_UWQ_SEL_ENUMERATORS.ENUM_TYPE_UUID%type;
2634:
2635:
2636:
2637: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;
2638:
2639: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
2640:
2641:

Line 2920: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;

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:
2922: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
2923:
2924: cursor c_cur is

Line 2928: ieu_wp_param_props_b ppb

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
2932: and ap.param_id=p_param_id;

Line 2946: delete from ieu_wp_param_props_b

2942: x_msg_data := '';
2943:
2944:
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

Line 2950: ieu_wp_param_props_b ppb

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)
2954: and param_id =p_param_id

Line 2994: l_param_property_id IEU_WP_PARAM_PROPS_B.PARAM_PROPERTY_ID%TYPE;

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:
2996: l_trans_flag IEU_WP_PROPERTIES_B.VALUE_TRANSLATABLE_FLAG%TYPE;
2997:
2998:

Line 3008: delete from ieu_wp_param_props_b

3004: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
3005: x_msg_data := '';
3006:
3007:
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,

Line 3013: ieu_wp_param_props_b ppb

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

Line 3049: ieu_wp_param_props_b ppb

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
3053: and ppb.ACTION_PARAM_SET_ID = p_action_param_set_id

Line 3070: update ieu_wp_param_props_b

3066: x_msg_data := '';
3067: for c_rec in c_cur LOOP
3068: if l_count <> c_rec.PROPERTY_VALUE then
3069:
3070: update ieu_wp_param_props_b
3071: set property_value = l_count
3072: where param_id = c_rec.param_id
3073: and param_property_id = c_rec.param_property_id
3074: and property_value = c_rec.property_value