APPS.IEU_WORKPANEL_PVT dependencies on IEU_WP_PARAM_PROPS_B_S1

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,