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 3462: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in

3458:
3459: delete from iem_msg_parts where DELETE_FLAG = 'Y';
3460:
3461: -- Delete IEM_MC_PARAMETERS, and IEM_MC_CUSTOM_PARAM
3462: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in
3463: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID
3464: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions
3465: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3466: and iem_rt_interactions.expire = 'Y');

Line 3463: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID

3459: delete from iem_msg_parts where DELETE_FLAG = 'Y';
3460:
3461: -- Delete IEM_MC_PARAMETERS, and IEM_MC_CUSTOM_PARAM
3462: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in
3463: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID
3464: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions
3465: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3466: and iem_rt_interactions.expire = 'Y');
3467:

Line 3464: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions

3460:
3461: -- Delete IEM_MC_PARAMETERS, and IEM_MC_CUSTOM_PARAM
3462: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in
3463: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID
3464: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions
3465: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3466: and iem_rt_interactions.expire = 'Y');
3467:
3468: delete from IEM_MC_PARAMETERS where MC_PARAMETER_ID in

Line 3465: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID

3461: -- Delete IEM_MC_PARAMETERS, and IEM_MC_CUSTOM_PARAM
3462: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in
3463: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID
3464: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions
3465: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3466: and iem_rt_interactions.expire = 'Y');
3467:
3468: delete from IEM_MC_PARAMETERS where MC_PARAMETER_ID in
3469: (select IEM_MC_PARAMETERS.MC_PARAMETER_ID

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

3486: -- Delete each record from iem_agent_sessions where last_update_date is older than 30 days
3487: delete from iem_agent_sessions where SYSDATE - LAST_UPDATE_DATE > 30;
3488:
3489:
3490: -- Delete each record from IEM_MC_CUSTOM_PARAMS and IEM_MC_PARAMETERS where last_update_date is older than 30 days
3491:
3492: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in
3493: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID
3494: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions

Line 3492: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in

3488:
3489:
3490: -- Delete each record from IEM_MC_CUSTOM_PARAMS and IEM_MC_PARAMETERS where last_update_date is older than 30 days
3491:
3492: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in
3493: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID
3494: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions
3495: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3496: and iem_rt_interactions.expire='N' and iem_rt_interactions.type='O' and

Line 3493: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID

3489:
3490: -- Delete each record from IEM_MC_CUSTOM_PARAMS and IEM_MC_PARAMETERS where last_update_date is older than 30 days
3491:
3492: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in
3493: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID
3494: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions
3495: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3496: and iem_rt_interactions.expire='N' and iem_rt_interactions.type='O' and
3497: SYSDATE - iem_rt_interactions.LAST_UPDATE_DATE > 30);

Line 3494: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions

3490: -- Delete each record from IEM_MC_CUSTOM_PARAMS and IEM_MC_PARAMETERS where last_update_date is older than 30 days
3491:
3492: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in
3493: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID
3494: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions
3495: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3496: and iem_rt_interactions.expire='N' and iem_rt_interactions.type='O' and
3497: SYSDATE - iem_rt_interactions.LAST_UPDATE_DATE > 30);
3498:

Line 3495: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID

3491:
3492: delete from IEM_MC_CUSTOM_PARAMS where MC_PARAMETER_ID in
3493: (select IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID
3494: from IEM_MC_CUSTOM_PARAMS, iem_rt_interactions
3495: where IEM_MC_CUSTOM_PARAMS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3496: and iem_rt_interactions.expire='N' and iem_rt_interactions.type='O' and
3497: SYSDATE - iem_rt_interactions.LAST_UPDATE_DATE > 30);
3498:
3499: delete from IEM_MC_PARAMETERS where MC_PARAMETER_ID in