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_OUTBOX_PROC_PUB dependencies on IEM_RT_MEDIA_ITEMS

Line 316: FROM iem_rt_media_items WHERE rt_media_item_id = p_outbox_item_id;

312:
313: -----------------------Code------------------------
314: -- Expire rt_interactions and rt_media_items
315: SELECT rt_interaction_id INTO l_rt_interaction_id
316: FROM iem_rt_media_items WHERE rt_media_item_id = p_outbox_item_id;
317:
318: UPDATE iem_rt_media_items SET
319: expire = G_EXPIRE,
320: last_updated_by = l_last_updated_by,

Line 318: UPDATE iem_rt_media_items SET

314: -- Expire rt_interactions and rt_media_items
315: SELECT rt_interaction_id INTO l_rt_interaction_id
316: FROM iem_rt_media_items WHERE rt_media_item_id = p_outbox_item_id;
317:
318: UPDATE iem_rt_media_items SET
319: expire = G_EXPIRE,
320: last_updated_by = l_last_updated_by,
321: last_update_login = l_last_update_login
322: WHERE rt_interaction_id = l_rt_interaction_id;

Line 419: FROM iem_rt_media_items WHERE rt_media_item_id = p_outbox_item_id;

415:
416: -----------------------Code------------------------
417:
418: SELECT rt_interaction_id INTO l_rt_interaction_id
419: FROM iem_rt_media_items WHERE rt_media_item_id = p_outbox_item_id;
420:
421: SELECT status, decode(action_id, NULL, -1, action_id),
422: action_item_id, outcome_id, result_id, reason_id
423: INTO l_status, l_action_id, l_activity_type_id, l_outcome_id, l_result_id,

Line 774: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;

770: l_parent_ih_id, l_sr_id, null, l_interaction_id,
771: l_mc_parameter_id, l_ih_creator, 74, 45, 53, l_relationship_id);
772:
773:
774: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;
775: INSERT INTO iem_rt_media_items (
776: rt_interaction_id, rt_media_item_id, resource_id,
777: media_id, message_id, rfc822_message_id, folder_name,
778: folder_uid, email_account_id, db_server_id, email_type,

Line 775: INSERT INTO iem_rt_media_items (

771: l_mc_parameter_id, l_ih_creator, 74, 45, 53, l_relationship_id);
772:
773:
774: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;
775: INSERT INTO iem_rt_media_items (
776: rt_interaction_id, rt_media_item_id, resource_id,
777: media_id, message_id, rfc822_message_id, folder_name,
778: folder_uid, email_account_id, db_server_id, email_type,
779: status, expire, version, created_by, creation_date,

Line 1458: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;

1454: SYSDATE, l_last_updated_by, SYSDATE, l_last_update_login,
1455: p_to_account_id
1456: );
1457:
1458: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;
1459: INSERT INTO iem_rt_media_items (
1460: rt_interaction_id, rt_media_item_id, resource_id,
1461: media_id, message_id, rfc822_message_id, folder_name,
1462: folder_uid, email_account_id, db_server_id, email_type,

Line 1459: INSERT INTO iem_rt_media_items (

1455: p_to_account_id
1456: );
1457:
1458: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;
1459: INSERT INTO iem_rt_media_items (
1460: rt_interaction_id, rt_media_item_id, resource_id,
1461: media_id, message_id, rfc822_message_id, folder_name,
1462: folder_uid, email_account_id, db_server_id, email_type,
1463: status, expire, version, created_by, creation_date,

Line 1724: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;

1720: l_parent_ih_id, l_sr_id, null, l_interaction_id,
1721: l_mc_parameter_id, l_ih_creator, 73, 45, -1, -1, l_relationship_id);
1722:
1723:
1724: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;
1725: INSERT INTO iem_rt_media_items (
1726: rt_interaction_id, rt_media_item_id, resource_id,
1727: media_id, message_id, rfc822_message_id, folder_name,
1728: folder_uid, email_account_id, db_server_id, email_type,

Line 1725: INSERT INTO iem_rt_media_items (

1721: l_mc_parameter_id, l_ih_creator, 73, 45, -1, -1, l_relationship_id);
1722:
1723:
1724: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;
1725: INSERT INTO iem_rt_media_items (
1726: rt_interaction_id, rt_media_item_id, resource_id,
1727: media_id, message_id, rfc822_message_id, folder_name,
1728: folder_uid, email_account_id, db_server_id, email_type,
1729: status, expire, version, created_by, creation_date,

Line 2036: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;

2032: l_parent_ih_id, p_sr_id, null, l_interaction_id,
2033: l_mc_parameter_id, l_ih_creator, 22, 45, l_relationship_id,
2034: l_result_id, l_reason_id, l_outcome_id);
2035:
2036: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;
2037: INSERT INTO iem_rt_media_items (
2038: rt_interaction_id, rt_media_item_id, resource_id,
2039: media_id, message_id, rfc822_message_id, folder_name,
2040: folder_uid, email_account_id, db_server_id, email_type,

Line 2037: INSERT INTO iem_rt_media_items (

2033: l_mc_parameter_id, l_ih_creator, 22, 45, l_relationship_id,
2034: l_result_id, l_reason_id, l_outcome_id);
2035:
2036: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;
2037: INSERT INTO iem_rt_media_items (
2038: rt_interaction_id, rt_media_item_id, resource_id,
2039: media_id, message_id, rfc822_message_id, folder_name,
2040: folder_uid, email_account_id, db_server_id, email_type,
2041: status, expire, version, created_by, creation_date,