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;
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);
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);
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;
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);
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);