APPS.IEM_OUTBOX_PROC_PUB dependencies on IEM_RT_INTERACTIONS_S1

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 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 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 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,