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.IEM_CLIENT_PUB dependencies on IEM_MC_CUSTOM_PARAMS

Line 3400: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in

3396:
3397: delete from iem_msg_parts where DELETE_FLAG = 'Y';
3398:
3399: -- Delete IEM_MC_PARAMETERS, and IEM_MC_CUSTOM_PARAM
3400: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in
3401: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID
3402: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions
3403: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3404: and iem_rt_interactions.expire = 'Y');

Line 3401: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID

3397: delete from iem_msg_parts where DELETE_FLAG = 'Y';
3398:
3399: -- Delete IEM_MC_PARAMETERS, and IEM_MC_CUSTOM_PARAM
3400: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in
3401: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID
3402: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions
3403: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3404: and iem_rt_interactions.expire = 'Y');
3405:

Line 3402: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions

3398:
3399: -- Delete IEM_MC_PARAMETERS, and IEM_MC_CUSTOM_PARAM
3400: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in
3401: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID
3402: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions
3403: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3404: and iem_rt_interactions.expire = 'Y');
3405:
3406: delete from IEM_MC_PARAMETERS where MC_PARAMETER_ID in

Line 3403: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID

3399: -- Delete IEM_MC_PARAMETERS, and IEM_MC_CUSTOM_PARAM
3400: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in
3401: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID
3402: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions
3403: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3404: and iem_rt_interactions.expire = 'Y');
3405:
3406: delete from IEM_MC_PARAMETERS where MC_PARAMETER_ID in
3407: (select IEM_MC_PARAMETERS.MC_PARAMETER_ID

Line 3428: -- Delete each record from IEM_MC_CUSTOM_PARAMS and IEM_MC_PARAMETERS where last_update_date is older than 30 days

3424: -- Delete each record from iem_agent_sessions where last_update_date is older than 30 days
3425: delete from iem_agent_sessions where SYSDATE - LAST_UPDATE_DATE > 30;
3426:
3427:
3428: -- Delete each record from IEM_MC_CUSTOM_PARAMS and IEM_MC_PARAMETERS where last_update_date is older than 30 days
3429:
3430: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in
3431: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID
3432: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions

Line 3430: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in

3426:
3427:
3428: -- Delete each record from IEM_MC_CUSTOM_PARAMS and IEM_MC_PARAMETERS where last_update_date is older than 30 days
3429:
3430: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in
3431: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID
3432: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions
3433: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3434: and iem_rt_interactions.expire='N' and iem_rt_interactions.type='O' and

Line 3431: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID

3427:
3428: -- Delete each record from IEM_MC_CUSTOM_PARAMS and IEM_MC_PARAMETERS where last_update_date is older than 30 days
3429:
3430: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in
3431: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID
3432: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions
3433: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3434: and iem_rt_interactions.expire='N' and iem_rt_interactions.type='O' and
3435: SYSDATE - iem_rt_interactions.LAST_UPDATE_DATE > 30);

Line 3432: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions

3428: -- Delete each record from IEM_MC_CUSTOM_PARAMS and IEM_MC_PARAMETERS where last_update_date is older than 30 days
3429:
3430: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in
3431: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID
3432: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions
3433: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3434: and iem_rt_interactions.expire='N' and iem_rt_interactions.type='O' and
3435: SYSDATE - iem_rt_interactions.LAST_UPDATE_DATE > 30);
3436:

Line 3433: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID

3429:
3430: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in
3431: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID
3432: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions
3433: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3434: and iem_rt_interactions.expire='N' and iem_rt_interactions.type='O' and
3435: SYSDATE - iem_rt_interactions.LAST_UPDATE_DATE > 30);
3436:
3437: delete from IEM_MC_PARAMETERS where MC_PARAMETER_ID in