APPS.IEM_MIGRATION_PVT dependencies on IEM_INTENTS

Line 1511: insert into iem_intents

1507: x_msg_data =>l_msg_data);
1508: -- Migrating Intent Data
1509: for v2 in c_intent LOOP
1510: l_intent_id:=v2.classification_id;
1511: insert into iem_intents
1512: (intent_id,
1513: intent,
1514: INTENT_LANG,
1515: THEME_ENABLED,

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

1624: END LOOP;
1625:
1626: -- Reset the Sequence to have highest intent id
1627:
1628: select nvl(max(intent_id),0) into l_max_id from iem_intents;
1629: LOOP
1630: select iem_intents_s1.nextval into l_val from dual;
1631: exit when l_val>l_max_id;
1632: END LOOP;

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

1626: -- Reset the Sequence to have highest intent id
1627:
1628: select nvl(max(intent_id),0) into l_max_id from iem_intents;
1629: LOOP
1630: select iem_intents_s1.nextval into l_val from dual;
1631: exit when l_val>l_max_id;
1632: END LOOP;
1633: -- Deleting OES Rule
1634: for v1 in c_rule LOOP