APPS.IEU_WORKPANEL_PVT dependencies on IEU_WP_PARAM_PROPS_TL

Line 1308: DELETE FROM ieu_wp_param_props_tl

1304: WHERE action_param_set_id = x_param_set_id)
1305: GROUP BY wp_action_def_id;
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);

Line 1890: insert INTO IEU_WP_PARAM_PROPS_TL

1886: where property_id = p_property_id;
1887:
1888: if (l_trans_flag = 'Y') then
1889:
1890: insert INTO IEU_WP_PARAM_PROPS_TL
1891: (PARAM_PROPERTY_ID,
1892: CREATED_BY,
1893: CREATION_DATE,
1894: LAST_UPDATED_BY,

Line 2112: ' insert INTO IEU_WP_PARAM_PROPS_TL '||

2108:
2109: if (l_trans_flag = 'Y') then
2110:
2111: EXECUTE immediate
2112: ' insert INTO IEU_WP_PARAM_PROPS_TL '||
2113: ' (PARAM_PROPERTY_ID, '||
2114: ' CREATED_BY, '||
2115: ' CREATION_DATE, '||
2116: ' LAST_UPDATED_BY, '||

Line 2158: ' update IEU_WP_PARAM_PROPS_TL set '||

2154: into l_param_property_id USING p_param_id,p_action_param_set_id, p_property_id ;
2155:
2156:
2157: EXECUTE immediate
2158: ' update IEU_WP_PARAM_PROPS_TL set '||
2159: ' LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
2160: ' LAST_UPDATE_DATE = SYSDATE, '||
2161: ' LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID, '||
2162: ' PROPERTY_VALUE = :1 ' ||

Line 2329: insert INTO IEU_WP_PARAM_PROPS_TL

2325: where property_id = p_property_id;
2326:
2327: if (l_trans_flag = 'Y') then
2328:
2329: insert INTO IEU_WP_PARAM_PROPS_TL
2330: (PARAM_PROPERTY_ID,
2331: CREATED_BY,
2332: CREATION_DATE,
2333: LAST_UPDATED_BY,

Line 2369: update IEU_WP_PARAM_PROPS_TL set

2365: and ACTION_PARAM_SET_ID = p_action_param_set_id
2366: and PROPERTY_ID = p_property_id;
2367:
2368:
2369: update IEU_WP_PARAM_PROPS_TL set
2370: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2371: LAST_UPDATE_DATE = SYSDATE,
2372: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2373: PROPERTY_VALUE = p_property_value

Line 2422: l_param_property_id IEU_WP_PARAM_PROPS_TL.PARAM_PROPERTY_ID%type;

2418: PROCEDURE Delete_Parameter (x_param_id IN NUMBER, x_param_set_id IN NUMBER) AS
2419:
2420: l_language VARCHAR2(4);
2421:
2422: l_param_property_id IEU_WP_PARAM_PROPS_TL.PARAM_PROPERTY_ID%type;
2423: BEGIN
2424: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2425:
2426:

Line 2476: delete from IEU_WP_PARAM_PROPS_TL

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:
2476: delete from IEU_WP_PARAM_PROPS_TL
2477: where PARAM_PROPERTY_ID = l_param_property_id;
2478:
2479: if (sql%notfound) then
2480: null;

Line 2502: delete from ieu_wp_param_props_tl where param_property_id in

2498: if (sql%notfound) then
2499: null;
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: