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_PARAMETERS

Line 2165: from iem_mc_parameters where mc_parameter_id = l_mc_parameter_id;

2161: END;
2162:
2163: if (l_mc_parameter_id > 0) then
2164: select action into l_mc_param_action
2165: from iem_mc_parameters where mc_parameter_id = l_mc_parameter_id;
2166: end if;
2167:
2168: -- set contact id for IH recording.
2169: l_ih_customer_id := p_customer_id;

Line 3461: -- Delete IEM_MC_PARAMETERS, and IEM_MC_CUSTOM_PARAM

3457: (select rt_media_item_id from iem_rt_media_items WHERE expire='Y');
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

Line 3468: delete from IEM_MC_PARAMETERS where MC_PARAMETER_ID in

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
3470: from IEM_MC_PARAMETERS, iem_rt_interactions
3471: where IEM_MC_PARAMETERS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3472: and iem_rt_interactions.expire = 'Y');

Line 3469: (select IEM_MC_PARAMETERS.MC_PARAMETER_ID

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
3470: from IEM_MC_PARAMETERS, iem_rt_interactions
3471: where IEM_MC_PARAMETERS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3472: and iem_rt_interactions.expire = 'Y');
3473:

Line 3470: from IEM_MC_PARAMETERS, iem_rt_interactions

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
3470: from IEM_MC_PARAMETERS, iem_rt_interactions
3471: where IEM_MC_PARAMETERS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3472: and iem_rt_interactions.expire = 'Y');
3473:
3474: -- Delete each record from iem_rt_interactions where expire = 'Y'

Line 3471: where IEM_MC_PARAMETERS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID

3467:
3468: delete from IEM_MC_PARAMETERS where MC_PARAMETER_ID in
3469: (select IEM_MC_PARAMETERS.MC_PARAMETER_ID
3470: from IEM_MC_PARAMETERS, iem_rt_interactions
3471: where IEM_MC_PARAMETERS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3472: and iem_rt_interactions.expire = 'Y');
3473:
3474: -- Delete each record from iem_rt_interactions where expire = 'Y'
3475: delete from iem_rt_interactions where expire = 'Y';

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 3499: delete from IEM_MC_PARAMETERS where MC_PARAMETER_ID in

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
3500: (select IEM_MC_PARAMETERS.MC_PARAMETER_ID
3501: from IEM_MC_PARAMETERS, iem_rt_interactions
3502: where IEM_MC_PARAMETERS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3503: and iem_rt_interactions.expire='N' and iem_rt_interactions.type='O' and

Line 3500: (select IEM_MC_PARAMETERS.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
3500: (select IEM_MC_PARAMETERS.MC_PARAMETER_ID
3501: from IEM_MC_PARAMETERS, iem_rt_interactions
3502: where IEM_MC_PARAMETERS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3503: and iem_rt_interactions.expire='N' and iem_rt_interactions.type='O' and
3504: SYSDATE - iem_rt_interactions.LAST_UPDATE_DATE > 30);

Line 3501: from IEM_MC_PARAMETERS, iem_rt_interactions

3497: SYSDATE - iem_rt_interactions.LAST_UPDATE_DATE > 30);
3498:
3499: delete from IEM_MC_PARAMETERS where MC_PARAMETER_ID in
3500: (select IEM_MC_PARAMETERS.MC_PARAMETER_ID
3501: from IEM_MC_PARAMETERS, iem_rt_interactions
3502: where IEM_MC_PARAMETERS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3503: and iem_rt_interactions.expire='N' and iem_rt_interactions.type='O' and
3504: SYSDATE - iem_rt_interactions.LAST_UPDATE_DATE > 30);
3505:

Line 3502: where IEM_MC_PARAMETERS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID

3498:
3499: delete from IEM_MC_PARAMETERS where MC_PARAMETER_ID in
3500: (select IEM_MC_PARAMETERS.MC_PARAMETER_ID
3501: from IEM_MC_PARAMETERS, iem_rt_interactions
3502: where IEM_MC_PARAMETERS.MC_PARAMETER_ID = iem_rt_interactions.MC_PARAMETER_ID
3503: and iem_rt_interactions.expire='N' and iem_rt_interactions.type='O' and
3504: SYSDATE - iem_rt_interactions.LAST_UPDATE_DATE > 30);
3505:
3506: FOR cr_rec in del_rt_csr LOOP