DBA Data[Home] [Help]

APPS.OKL_AUTO_INSURANCE_PVT dependencies on JTF_FM_REQUEST_GRP

Line 347: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

343: l_return_status VARCHAR2(1) :=
344: Okc_Api.G_RET_STS_SUCCESS;
345: ls_to_email varchar2(240);
346: ls_contract_number VARCHAR2(80);
347: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
348: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
349: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
350: l_content_id NUMBER;
351: l_agent_id NUMBER;

Line 348: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

344: Okc_Api.G_RET_STS_SUCCESS;
345: ls_to_email varchar2(240);
346: ls_contract_number VARCHAR2(80);
347: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
348: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
349: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
350: l_content_id NUMBER;
351: l_agent_id NUMBER;
352: l_subject VARCHAR2(80);

Line 349: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

345: ls_to_email varchar2(240);
346: ls_contract_number VARCHAR2(80);
347: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
348: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
349: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
350: l_content_id NUMBER;
351: l_agent_id NUMBER;
352: l_subject VARCHAR2(80);
353: l_email VARCHAR2(80);

Line 780: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

776: l_api_version CONSTANT NUMBER := 1;
777: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
778: ls_to_email varchar2(240);
779: ls_contract_number VARCHAR2(80);
780: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
781: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
782: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
783: l_content_id NUMBER;
784: l_agent_id NUMBER;

Line 781: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;

777: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
778: ls_to_email varchar2(240);
779: ls_contract_number VARCHAR2(80);
780: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
781: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
782: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
783: l_content_id NUMBER;
784: l_agent_id NUMBER;
785: l_subject VARCHAR2(80);

Line 782: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;

778: ls_to_email varchar2(240);
779: ls_contract_number VARCHAR2(80);
780: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
781: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
782: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE ;
783: l_content_id NUMBER;
784: l_agent_id NUMBER;
785: l_subject VARCHAR2(80);
786: l_email VARCHAR2(80);