598: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;
599: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
600: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
601: l_subject VARCHAR2(2000);
602: l_content_id JTF_AMV_ITEMS_B.ITEM_ID%TYPE;
603: l_from VARCHAR2(2000);
604: l_agent_id NUMBER;
605: BEGIN
606:
697:
698: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
699: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
700: l_subject VARCHAR2(2000);
701: l_content_id JTF_AMV_ITEMS_B.ITEM_ID%TYPE;
702: l_from VARCHAR2(2000);
703: l_agent_id NUMBER;
704: BEGIN
705: