APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_CLASS_TBL_TYP

Line 3593: l_data iem_class_tbl_typ:=iem_class_tbl_typ();

3589: l_first varchar2(1);
3590: l_val number:=0;
3591: l_match varchar2(1):='F';
3592: l_msg_data varchar2(200);
3593: l_data iem_class_tbl_typ:=iem_class_tbl_typ();
3594: l_errmsg varchar2(200);
3595: l_str varchar2(200);
3596: l_class_scr varchar2(3500);
3597: l_wtot number:=0;

Line 3713: FOR x in (select * from the(select cast(l_data as iem_class_tbl_typ)

3709: l_class_count:=1;
3710: g_topclass:=null;
3711: g_topscore:=null;
3712: l_wtot:=0;
3713: FOR x in (select * from the(select cast(l_data as iem_class_tbl_typ)
3714: from dual)a where score>0 and rownum<8 order by score desc)
3715: LOOP
3716: l_wtot:=l_wtot+x.score;
3717: END LOOP;

Line 3718: FOR x in (select * from the(select cast(l_data as iem_class_tbl_typ)

3714: from dual)a where score>0 and rownum<8 order by score desc)
3715: LOOP
3716: l_wtot:=l_wtot+x.score;
3717: END LOOP;
3718: FOR x in (select * from the(select cast(l_data as iem_class_tbl_typ)
3719: from dual)a where score>0 and rownum<8 order by score desc)
3720: LOOP
3721: x.score:=x.score*100/l_wtot;
3722: IF x.score > 0 THEN -- -ve Classification score not allowed Start