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_MSG_PARTS

Line 3422: -- Clean Iem_msg_parts table

3418:
3419: -----------------------Code------------------------
3420: BEGIN
3421:
3422: -- Clean Iem_msg_parts table
3423: FOR rt_expire_csr_rec in del_rt_expire_csr LOOP
3424: /* Commented due to perf issue bug 6875851 03/13/2008 Ranjan
3425: l_tmp_ref_key := rt_expire_csr_rec.RT_MEDIA_ITEM_ID;
3426:

Line 3431: select PART_NAME into l_tmp_ref_name from iem_msg_parts where to_char(ref_key) = l_tmp_ref_key

3427: LOOP
3428: l_tmp_ref_name := NULL;
3429:
3430: BEGIN
3431: select PART_NAME into l_tmp_ref_name from iem_msg_parts where to_char(ref_key) = l_tmp_ref_key
3432: and PART_TYPE = 'ATTACHMAIL' and rownum < 2;
3433: EXCEPTION WHEN NO_DATA_FOUND THEN
3434: EXIT;
3435: END;

Line 3440: update iem_msg_parts set DELETE_FLAG = 'Y' where to_char(REF_KEY) = l_tmp_ref_key;

3436:
3437:
3438: if (l_tmp_ref_name IS NOT NULL) THEN
3439: l_tmp_ref_key := l_tmp_ref_name;
3440: update iem_msg_parts set DELETE_FLAG = 'Y' where to_char(REF_KEY) = l_tmp_ref_key;
3441: END IF;
3442:
3443: END LOOP;
3444: modifed the query as below after the comment section

Line 3446: update iem_msg_parts

3442:
3443: END LOOP;
3444: modifed the query as below after the comment section
3445: */
3446: update iem_msg_parts
3447: set delete_flag='Y'
3448: where ref_key in (select part_name from iem_msg_parts where
3449: ref_key=rt_expire_csr_rec.RT_MEDIA_ITEM_ID and part_type='ATTACHMAIL');
3450:

Line 3448: where ref_key in (select part_name from iem_msg_parts where

3444: modifed the query as below after the comment section
3445: */
3446: update iem_msg_parts
3447: set delete_flag='Y'
3448: where ref_key in (select part_name from iem_msg_parts where
3449: ref_key=rt_expire_csr_rec.RT_MEDIA_ITEM_ID and part_type='ATTACHMAIL');
3450:
3451: END LOOP;
3452:

Line 3456: delete from iem_msg_parts where REF_KEY in

3452:
3453: -- delete outbox errors
3454: delete from iem_outbox_errors where expire = 'Y';
3455:
3456: delete from iem_msg_parts where REF_KEY in
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:

Line 3459: delete from iem_msg_parts where DELETE_FLAG = 'Y';

3455:
3456: delete from iem_msg_parts where REF_KEY in
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

Line 3536: -- Clean Iem_msg_parts table

3532: p_media_rec => l_media_rec
3533: );
3534:
3535:
3536: -- Clean Iem_msg_parts table
3537:
3538: l_tmp_ref_key := l_RT_MEDIA_ITEM_ID;
3539:
3540: /* Commented for perf issue as per bug 6875851

Line 3543: select PART_NAME into l_tmp_ref_name from iem_msg_parts where to_char(ref_key) = l_tmp_ref_key

3539:
3540: /* Commented for perf issue as per bug 6875851
3541: FOR i in 1..50 LOOP
3542: BEGIN
3543: select PART_NAME into l_tmp_ref_name from iem_msg_parts where to_char(ref_key) = l_tmp_ref_key
3544: and PART_TYPE = 'ATTACHMAIL' and rownum < 2;
3545: EXCEPTION WHEN NO_DATA_FOUND THEN
3546: EXIT;
3547: END;

Line 3552: update iem_msg_parts set DELETE_FLAG = 'Y' where to_char(REF_KEY) = l_tmp_ref_key;

3548:
3549:
3550: if (l_tmp_ref_name IS NOT NULL) THEN
3551: l_tmp_ref_key := l_tmp_ref_name;
3552: update iem_msg_parts set DELETE_FLAG = 'Y' where to_char(REF_KEY) = l_tmp_ref_key;
3553: END IF;
3554:
3555: END LOOP;
3556: modify the part as below.

Line 3558: update iem_msg_parts

3554:
3555: END LOOP;
3556: modify the part as below.
3557: */
3558: update iem_msg_parts
3559: set delete_flag='Y'
3560: where ref_key in (select part_name from iem_msg_parts where
3561: ref_key=l_RT_MEDIA_ITEM_ID and part_type='ATTACHMAIL');
3562:

Line 3560: where ref_key in (select part_name from iem_msg_parts where

3556: modify the part as below.
3557: */
3558: update iem_msg_parts
3559: set delete_flag='Y'
3560: where ref_key in (select part_name from iem_msg_parts where
3561: ref_key=l_RT_MEDIA_ITEM_ID and part_type='ATTACHMAIL');
3562:
3563: delete from iem_msg_parts where REF_KEY = l_RT_MEDIA_ITEM_ID;
3564: delete from iem_rt_media_items where RT_MEDIA_ITEM_ID = l_RT_MEDIA_ITEM_ID;

Line 3563: delete from iem_msg_parts where REF_KEY = l_RT_MEDIA_ITEM_ID;

3559: set delete_flag='Y'
3560: where ref_key in (select part_name from iem_msg_parts where
3561: ref_key=l_RT_MEDIA_ITEM_ID and part_type='ATTACHMAIL');
3562:
3563: delete from iem_msg_parts where REF_KEY = l_RT_MEDIA_ITEM_ID;
3564: delete from iem_rt_media_items where RT_MEDIA_ITEM_ID = l_RT_MEDIA_ITEM_ID;
3565: delete from iem_rt_interactions where rt_interaction_id = l_rt_interaction_id;
3566:
3567: END LOOP;

Line 3570: delete from iem_msg_parts where DELETE_FLAG = 'Y';

3566:
3567: END LOOP;
3568:
3569: -- Clean anything left
3570: delete from iem_msg_parts where DELETE_FLAG = 'Y';
3571: delete from iem_rt_interactions WHERE expire='N' and type = 'O'
3572: AND SYSDATE - LAST_UPDATE_DATE > 30;
3573:
3574: