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 DUAL

Line 543: select iem_outbox_errors_s1.nextval into l_error_id from dual;

539: x_return_status := FND_API.G_RET_STS_SUCCESS;
540:
541: -----------------------Code------------------------
542:
543: select iem_outbox_errors_s1.nextval into l_error_id from dual;
544:
545: INSERT INTO iem_outbox_errors
546: ( OUTBOX_ERROR_ID, RT_MEDIA_ITEM_ID, ERROR_SUMMARY,
547: ERROR_MESSAGE, CREATE_DATE, EXPIRE )

Line 758: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;

754: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
755: -- Success.
756:
757:
758: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;
759: INSERT INTO iem_rt_interactions (
760: rt_interaction_id, resource_id, customer_id, contact_id, type,
761: status, expire, created_by, creation_date, last_updated_by,
762: last_update_date, last_update_login, parent_interaction_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 1445: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;

1441: SELECT name INTO l_folder_name
1442: FROM iem_route_classifications
1443: WHERE ROUTE_CLASSIFICATION_ID = l_classification_id;
1444:
1445: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;
1446: INSERT INTO iem_rt_interactions (
1447: rt_interaction_id, resource_id, type,
1448: status, expire, created_by, creation_date, last_updated_by,
1449: last_update_date, last_update_login, to_resource_id

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 1708: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;

1704: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1705: -- Success.
1706: --create outbound here
1707:
1708: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;
1709: INSERT INTO iem_rt_interactions (
1710: rt_interaction_id, resource_id, customer_id, contact_id, type,
1711: status, expire, created_by, creation_date, last_updated_by,
1712: last_update_date, last_update_login, parent_interaction_id,

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 2020: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;

2016: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2017: -- Success.
2018:
2019:
2020: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;
2021: INSERT INTO iem_rt_interactions (
2022: rt_interaction_id, resource_id, customer_id, contact_id, type,
2023: status, expire, created_by, creation_date, last_updated_by,
2024: last_update_date, last_update_login, parent_interaction_id,

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,