APPS.IEM_MIGRATION_PVT dependencies on IEM_INTENTS

Line 1695: insert into iem_intents

1691: x_msg_data =>l_msg_data);
1692: -- Migrating Intent Data
1693: for v2 in c_intent LOOP
1694: l_intent_id:=v2.classification_id;
1695: insert into iem_intents
1696: (intent_id,
1697: intent,
1698: INTENT_LANG,
1699: THEME_ENABLED,

Line 1812: select nvl(max(intent_id),0) into l_max_id from iem_intents;

1808: END LOOP;
1809:
1810: -- Reset the Sequence to have highest intent id
1811:
1812: select nvl(max(intent_id),0) into l_max_id from iem_intents;
1813: LOOP
1814: select iem_intents_s1.nextval into l_val from dual;
1815: exit when l_val>l_max_id;
1816: END LOOP;

Line 1814: select iem_intents_s1.nextval into l_val from dual;

1810: -- Reset the Sequence to have highest intent id
1811:
1812: select nvl(max(intent_id),0) into l_max_id from iem_intents;
1813: LOOP
1814: select iem_intents_s1.nextval into l_val from dual;
1815: exit when l_val>l_max_id;
1816: END LOOP;
1817: -- Deleting OES Rule
1818: for v1 in c_rule LOOP