DBA Data[Home] [Help]

APPS.IEX_OPEN_INTERFACE_PUB dependencies on HZ_CONTACT_POINTS

Line 600: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;

596: lx_retcode NUMBER;
597: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;
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;

Line 699: l_email HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;

695: l_case_number OKL_OPEN_INT.CASE_NUMBER%TYPE;
696: l_jtot_object1_code IEX_OPEN_INT_HST.JTOT_OBJECT1_CODE%TYPE;
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;