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 DUAL

Line 680: select IEU_UWQ_MACTION_DEFS_B_S1.NEXTVAL into l_maction_def_id from sys.dual;

676: --dbms_output.put_line('out out from validate_action :' || l_return_status);
677:
678: if (l_return_status = 'S') then
679: --dbms_output.put_line('out out from validate_action is S');
680: select IEU_UWQ_MACTION_DEFS_B_S1.NEXTVAL into l_maction_def_id from sys.dual;
681:
682: insert INTO IEU_UWQ_MACTION_DEFS_B
683: (MACTION_DEF_ID,
684: CREATED_BY,

Line 741: select IEU_WP_ACT_PARAM_SETS_B_S1.NEXTVAL into l_action_param_set_id from sys.dual;

737: );
738:
739: --DBMS_OUTPUT.PUT_LINE('inserted in maction defs tl ');
740:
741: select IEU_WP_ACT_PARAM_SETS_B_S1.NEXTVAL into l_action_param_set_id from sys.dual;
742:
743: --DBMS_OUTPUT.PUT_LINE('got next val '|| l_action_param_set_id);
744:
745:

Line 917: select IEU_WP_NODE_SECTION_MAPS_S1.nextval into l_wp_node_section_map_id from sys.dual;

913:
914:
915: else
916:
917: select IEU_WP_NODE_SECTION_MAPS_S1.nextval into l_wp_node_section_map_id from sys.dual;
918:
919: insert INTO IEU_WP_NODE_SECTION_MAPS
920: (WP_NODE_SECTION_MAP_ID,
921: OBJECT_VERSION_NUMBER,

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 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 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 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 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 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 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 2842: select IEU_WP_NODE_SECTION_MAPS_S1.nextval into l_wp_node_section_map_id from sys.dual;

2838: where ENUM_TYPE_UUID = l_enum_uuid
2839: and APPLICATION_ID = p_application
2840: and SECTION_ID = l_section_id;
2841: else
2842: select IEU_WP_NODE_SECTION_MAPS_S1.nextval into l_wp_node_section_map_id from sys.dual;
2843: insert INTO IEU_WP_NODE_SECTION_MAPS
2844: (WP_NODE_SECTION_MAP_ID,
2845: OBJECT_VERSION_NUMBER,
2846: CREATED_BY,