DBA Data[Home] [Help]

APPS.IEM_MIGRATION_PVT dependencies on IEM_INTENT_DTLS

Line 1549: -- Insert into IEM_INTENT_DTLS

1545: l_last_updated_by,
1546: sysdate,
1547: l_last_update_login);
1548:
1549: -- Insert into IEM_INTENT_DTLS
1550: for v3 in c1 LOOP
1551: select iem_intent_dtls_s1.nextval into l_intent_dtl_id from dual;
1552: l_mod:=mod(v3.score*100,10);
1553: if (l_mod=0 or l_mod>=5) then

Line 1551: select iem_intent_dtls_s1.nextval into l_intent_dtl_id from dual;

1547: l_last_update_login);
1548:
1549: -- Insert into IEM_INTENT_DTLS
1550: for v3 in c1 LOOP
1551: select iem_intent_dtls_s1.nextval into l_intent_dtl_id from dual;
1552: l_mod:=mod(v3.score*100,10);
1553: if (l_mod=0 or l_mod>=5) then
1554: l_weight:=ceil(v3.score*10);
1555: else

Line 1558: insert into iem_intent_dtls

1554: l_weight:=ceil(v3.score*10);
1555: else
1556: l_weight:=floor(v3.score*10);
1557: end if;
1558: insert into iem_intent_dtls
1559: (INTENT_DTL_ID,
1560: INTENT_ID,
1561: KEYWORD,
1562: WEIGHT,