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_INTERACTIONS

Line 201: UPDATE iem_rt_interactions SET status = 'S' -- send

197: );
198:
199: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
200:
201: UPDATE iem_rt_interactions SET status = 'S' -- send
202: WHERE rt_interaction_id = l_rt_interaction_id;
203:
204: x_outbox_item_id := l_rt_media_item_id;
205:

Line 324: UPDATE iem_rt_interactions SET

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;
323:
324: UPDATE iem_rt_interactions SET
325: expire = G_EXPIRE,
326: last_updated_by = l_last_updated_by,
327: last_update_login = l_last_update_login
328: WHERE rt_interaction_id = l_rt_interaction_id;

Line 425: FROM iem_rt_interactions

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,
424: l_reason_id
425: FROM iem_rt_interactions
426: WHERE rt_interaction_id = l_rt_interaction_id;
427:
428: IEM_CLIENT_PUB.queueToOutbox (p_api_version_number => 1.0,
429: p_init_msg_list => fnd_api.g_false,

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 759: INSERT INTO iem_rt_interactions (

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,
763: service_request_id, inb_tag_id, interaction_id,

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 1446: INSERT INTO iem_rt_interactions (

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
1450: )

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 1709: INSERT INTO iem_rt_interactions (

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,
1713: service_request_id, inb_tag_id, interaction_id,

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 2021: INSERT INTO iem_rt_interactions (

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,
2025: service_request_id, inb_tag_id, interaction_id,