<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap>
<!-- eg
<resultMap class="com.ais.bean.ExamBean" id="examBean">
<result property="id" column="ID"/>
<result property="examType" column="EXAM_TYPE"/>
<result property="examTypeChi" column="EXAM_TYPE_CHI"/>
<result property="examTypeChiSimp" column="EXAM_TYPE_CHI_SIMP"/>
<result property="createdBy" column="CREATED_BY"/>
<result property="createdDate" column="CREATED_DATE"/>
<result property="lastUpdatedBy" column="LAST_UPDATED_BY"/>
<result property="lastUpdatedDate" column="LAST_UPDATED_DATE"/>
<result property="activeInd" column="ACTIVE_IND"/>
</resultMap>
<parameterMap id="EXM_spGetExamList_param" class="java.util.Map">
<parameter property="PO_ERR_TYPE" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_ERR_TEXT" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_RETURNSTR" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
</parameterMap>
<procedure id="EXM_spGetExamList" parameterMap="EXM_spGetExamList_param" resultMap="examBean" >
{ call EXM_spGetExamList(?,?,?) }
</procedure>
-->
<resultMap class="com.ais.bean.OnlineCorpEnrollCorporateContact" id="corp_enroll_corporate_contact_result">
<result property="contactId" column="contactId"/>
<result property="corporateCode" column="corporateCode"/>
<result property="contactSurnameEn" column="contactSurnameEn"/>
<result property="contactFirstnameEn" column="contactFirstnameEn"/>
<result property="contactEmail" column="contactEmail"/>
</resultMap>
<parameterMap class="java.util.Map" id="corp_enroll_corporate_contact_param" >
<parameter property="corporateCode" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="corporateId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="contactId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="corporateEmail" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="PO_ERR_TYPE" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_ERR_TEXT" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_RETURNSTR" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
</parameterMap>
<procedure id="WEB_spGetCorporateContactList" parameterMap="corp_enroll_corporate_contact_param" resultMap="corp_enroll_corporate_contact_result" >
{ call WEB_spGetCorporateContactList(?,?,?,?,?,?,?) }
</procedure>
<resultMap class="com.ais.bean.OnlineCorpEnrollCorporateManager" id="corp_enroll_corporate_manager_result">
<result property="corporateCode" column="corporateCode"/>
<result property="contactId" column="contactId"/>
<result property="contactEmail" column="contactEmail"/>
<result property="coordinatorName" column="coordinatorName"/>
<result property="onlineActive" column="onlineActive"/>
</resultMap>
<parameterMap class="java.util.Map" id="corp_enroll_corporate_manager_param" >
<parameter property="corporateEmail" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="PO_ERR_TYPE" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_ERR_TEXT" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_RETURNSTR" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
</parameterMap>
<procedure id="WEB_spGetCorporateManagerList" parameterMap="corp_enroll_corporate_manager_param" resultMap="corp_enroll_corporate_manager_result" >
{ call WEB_spGetCorporateManagerList(?,?,?,?) }
</procedure>
<resultMap class="com.ais.bean.OnlineCorpEnrollCorporateManager" id="corp_enroll_corporate_manager_detail_result">
<result property="contactEmail" column="contact_email"/>
<result property="salutationEn" column="salutation_en"/>
<result property="salutationTc" column="salutation_tc"/>
<result property="contactNameTc" column="contact_name_tc"/>
<result property="contactSurnameEn" column="contact_surname_en"/>
<result property="contactFirstnameEn" column="contact_firstname_en"/>
<result property="deptName" column="deptName"/>
<result property="contactPost" column="contact_post"/>
<result property="contactTel1" column="contact_tel_1"/>
<result property="contactTel2" column="contact_tel_2"/>
<result property="contactTel3" column="contact_tel_3"/>
<result property="contactFax" column="contact_fax"/>
<result property="addressEn" column="address_en"/>
<result property="addressTc" column="address_tc"/>
<result property="district" column="district"/>
<result property="area" column="area"/>
</resultMap>
<parameterMap class="java.util.Map" id="corp_enroll_corporate_manager_detail_param" >
<parameter property="contactId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="PO_ERR_TYPE" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_ERR_TEXT" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_RETURNSTR" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
</parameterMap>
<procedure id="WEB_spGetCorporateManagerDetail" parameterMap="corp_enroll_corporate_manager_detail_param" resultMap="corp_enroll_corporate_manager_detail_result" >
{ call WEB_spGetCorporateManagerDetail(?,?,?,?) }
</procedure>
<resultMap class="com.ais.bean.OnlineCorpEnrollCorporateClass" id="corp_enroll_corporate_class_result">
<result property="classID" column="classID"/>
<result property="classCode" column="classCode"/>
<result property="acceptedCapacity" column="accepted_capacity"/>
<result property="classNameEn" column="className_en"/>
<result property="classNameTc" column="className_tc"/>
<result property="facetofaceStartdate" column="facetoface_startdate"/>
<result property="startDate" column="startDate"/>
<result property="endDate" column="endDate"/>
<result property="descriptionEn" column="description_en"/>
<result property="descriptionTc" column="description_tc"/>
<result property="billingContact" column="billing_contact"/>
</resultMap>
<parameterMap class="java.util.Map" id="corp_enroll_corporate_class_param" >
<parameter property="contactId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="CLASS_CODE" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="STATUS" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="START_DATE" jdbcType="DATE" javaType="java.util.Date" mode="IN" />
<parameter property="END_DATE" jdbcType="DATE" javaType="java.util.Date" mode="IN" />
<parameter property="PO_ERR_TYPE" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_ERR_TEXT" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_RETURNSTR" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
</parameterMap>
<procedure id="WEB_spGetCorporateClassList" parameterMap="corp_enroll_corporate_class_param" resultMap="corp_enroll_corporate_class_result" >
{ call WEB_spGetCorporateClassList(?,?,?,?,?,?,?,?) }
</procedure>
<resultMap class="com.ais.bean.OnlineCorpEnrollCorporateClass" id="corp_enroll_corporate_class_detail_result">
<result property="classID" column="classID"/>
<result property="courseCode" column="courseCode"/>
<result property="nameEn" column="name_en"/>
<result property="nameTc" column="name_tc"/>
<result property="classCode" column="classCode"/>
<result property="classNameEn" column="className_en"/>
<result property="classNameTc" column="className_tc"/>
<result property="classMode" column="classMode"/>
<result property="startDate" column="startDate"/>
<result property="duration" column="duration"/>
<result property="mediumEn" column="medium_en"/>
<result property="mediumTc" column="medium_tc"/>
<result property="statusEn" column="status_en"/>
<result property="statusTc" column="status_tc"/>
<result property="refValue" column="refValue"/>
<result property="intervalDays" column="intervalDays"/>
<result property="acceptedCapacity" column="capacity"/>
<result property="billingName" column="billing_name"/>
<result property="trainerName" column="trainer_name"/>
<result property="deliveryName" column="delivery_name"/>
<result property="deliveryAddress" column="delivery_address"/>
</resultMap>
<parameterMap class="java.util.Map" id="corp_enroll_corporate_class_detail_param" >
<parameter property="classCode" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="PO_ERR_TYPE" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_ERR_TEXT" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_RETURNSTR" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
</parameterMap>
<procedure id="WEB_spGetCorporateClassDetail" parameterMap="corp_enroll_corporate_class_detail_param" resultMap="corp_enroll_corporate_class_detail_result" >
{ call WEB_spGetCorporateClassDetail(?,?,?,?) }
</procedure>
<resultMap class="com.ais.bean.OnlineCorpEnrollCorporateClass" id="corp_enroll_corporate_class_session_result">
<result property="venue" column="venue"/>
<result property="startDate" column="startDate"/>
<result property="endDate" column="endDate"/>
</resultMap>
<procedure id="WEB_spGetCorporateClassSessionList" parameterMap="corp_enroll_corporate_class_detail_param" resultMap="corp_enroll_corporate_class_session_result" >
{ call WEB_spGetCorporateClassSessionList(?,?,?,?) }
</procedure>
<procedure id="WEB_spGetCorporateExamList" parameterMap="corp_enroll_corporate_class_detail_param" resultMap="corp_enroll_corporate_class_session_result" >
{ call WEB_spGetCorporateExamList(?,?,?,?) }
</procedure>
<resultMap class="com.ais.bean.OnlineCorpEnrollCorporateClass" id="corp_enroll_corporate_class_status_result">
<result property="refCodeItemID" column="refCodeItemID"/>
<result property="descriptionEn" column="description_en"/>
<result property="descriptionTc" column="description_tc"/>
</resultMap>
<parameterMap class="java.util.Map" id="corp_enroll_corporate_class_status_param" >
<parameter property="PO_ERR_TYPE" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_ERR_TEXT" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_RETURNSTR" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
</parameterMap>
<procedure id="WEB_spGetCorporateClassStatusList" parameterMap="corp_enroll_corporate_class_status_param" resultMap="corp_enroll_corporate_class_status_result" >
{ call WEB_spGetCorporateClassStatusList(?,?,?) }
</procedure>
<parameterMap class="java.util.Map" id="corp_enroll_corporate_inCompleted_class_param" >
<parameter property="contactId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="PO_ERR_TYPE" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_ERR_TEXT" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_RETURNSTR" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
</parameterMap>
<resultMap class="com.ais.bean.OnlineCorpEnrollCorporateClass" id="corp_enroll_corporate_incompleted_class_result">
<result property="classCode" column="classCode"/>
</resultMap>
<procedure id="WEB_spGetCorporateInCompletedClassList" parameterMap="corp_enroll_corporate_inCompleted_class_param" resultMap="corp_enroll_corporate_incompleted_class_result" >
{ call WEB_spGetCorporateInCompletedClassList(?,?,?,?) }
</procedure>
<resultMap class="com.ais.bean.OnlineCorpEnrollMaterialPurchase" id="corp_enroll_material_result">
<result property="itemId" column="itemId"/>
<result property="descEng" column="descEng"/>
<result property="descChi" column="descChi"/>
<result property="unitPrice" column="unitPrice"/>
<result property="defaultQty" column="defaultQty"/>
</resultMap>
<parameterMap class="java.util.Map" id="corp_enroll_material_param" >
<parameter property="COURSEID" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="REFCODE" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="REFVALUE" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="PO_ERR_TYPE" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_ERR_TEXT" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_RETURNSTR" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
</parameterMap>
<procedure id="WEB_spGetCorpCourseMaterialList" parameterMap="corp_enroll_material_param" resultMap="corp_enroll_material_result" >
{ call WEB_spGetCorpCourseMaterialList(?,?,?,?,?,?) }
</procedure>
<parameterMap class="java.util.Map" id="create_corp_enroll_basic_info_param" >
<parameter property="corpId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="corpNameEn" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="corpNameTc" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="industryId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="deptName" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="districtId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="areaId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="contactSalutationId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="contactFirstNameEn" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="contactSurNameEn" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="contactNameTc" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="contactPost" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="contactTel" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="contactFax" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="contactEmail" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="contactAddressEn1" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="contactAddressEn2" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="contactAddressEn3" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="contactAddressTc" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="contactAddressSc" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<!--<parameter property="aboutWebsite" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="aboutNewspager" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="aboutPoster" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="aboutOutdoor" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="aboutSocial" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="aboutFriends" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="aboutSchool" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="aboutOther" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
-->
<parameter property="joinChannel" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="joinChannelOther" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="courseId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="courseCode" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="suggestArea" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="medium" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="numStudent" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="equippedAed" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="aedModel" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="quoationCode" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="trainingVenue" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="courseDate " jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="status" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="createBy" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="updateBy" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="specialReq" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="fixedPrice" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="fixedPriceStudNum" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="pricePerStudentStudNum" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="agreementNo" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="healthWorker" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="erbTrainer" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="getEquipBy" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="getCertBy" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="remark" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="corpTel" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="otherTel" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="isMarketing" jdbcType="NUMERIC" javaType="java.math.BigDecimal" mode="IN" />
<parameter property="blContactSalutationId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="blContactNameTc" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="blContactSurNameEn" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="blContactFirstNameEn" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="blDeptName" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="blContactPost" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="blContactTel" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="blCorpTel" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="blOtherTel" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="blContactFax" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="blContactAddressEn1" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="blContactAddressEn2" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="blContactAddressEn3" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="blContactAddressTc" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="blDistrictId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="blAreaId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="blContactEmail" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="dlContactSalutationId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="dlContactNameTc" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="dlContactSurNameEn" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="dlContactFirstNameEn" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="dlDeptName" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="dlContactPost" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="dlContactTel" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="dlOtherTel" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="dlCorpTel" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="dlContactFax" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="dlContactAddressEn1" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="dlContactAddressEn2" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="dlContactAddressEn3" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="dlContactAddressTc" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="dlContactAddressSc" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="dlDistrictId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="dlAreaId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="dlContactEmail" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="isDelivery" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="deliveryIsStairCase" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="deliveryNeedPrereq" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="deliveryParkAdv" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="po_corp_enroll_id" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_ERR_TYPE" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_ERR_TEXT" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_RETURNSTR" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
</parameterMap>
<procedure id="WEB_spCreateCorpEnrollBasicInfo" parameterMap="create_corp_enroll_basic_info_param" >
{ call WEB_spCreateCorpEnrollBasicInfo(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) }
</procedure>
<parameterMap class="java.util.Map" id="create_class_venue_info_param" >
<parameter property="onlineCorpEnrollId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="sameAsMailAddress" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="rentVenue" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="address" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="sessionDate" jdbcType="TIMESTAMP" javaType="java.util.Date" mode="IN" />
<parameter property="startTime" jdbcType="TIMESTAMP" javaType="java.util.Date" mode="IN" />
<parameter property="endTime" jdbcType="TIMESTAMP" javaType="java.util.Date" mode="IN" />
<parameter property="createBy" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="PO_ERR_TYPE" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_ERR_TEXT" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_RETURNSTR" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
</parameterMap>
<procedure id="WEB_spCreateClassVenueInfo" parameterMap="create_class_venue_info_param" >
{ call WEB_spCreateClassVenueInfo(?,?,?,?,?,?,?,?,?,?,?) }
</procedure>
<procedure id="WEB_spCreateExamVenueInfo" parameterMap="create_class_venue_info_param" >
{ call WEB_spCreateExamVenueInfo(?,?,?,?,?,?,?,?,?,?,?) }
</procedure>
<parameterMap class="java.util.Map" id="create_provider_info_param" >
<parameter property="onlineCorpEnrollId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="itemId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="qty" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="createBy" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="PO_ERR_TYPE" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_ERR_TEXT" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_RETURNSTR" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
</parameterMap>
<procedure id="WEB_spCreateProvideInfo" parameterMap="create_provider_info_param" >
{ call WEB_spCreateProvideInfo(?,?,?,?,?,?,?) }
</procedure>
<parameterMap class="java.util.Map" id="create_material_purchase_info_param" >
<parameter property="onlineCorpEnrollId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="itemId" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="qty" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="unitPrice" jdbcType="DOUBLE" javaType="java.lang.Double" mode="IN" />
<parameter property="totalPrice" jdbcType="DOUBLE" javaType="java.lang.Double" mode="IN" />
<parameter property="createBy" jdbcType="NUMBERIC" javaType="java.lang.Integer" mode="IN" />
<parameter property="PO_ERR_TYPE" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_ERR_TEXT" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_RETURNSTR" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
</parameterMap>
<procedure id="WEB_spCreateMaterialPurchaseInfo" parameterMap="create_material_purchase_info_param" >
{ call WEB_spCreateMaterialPurchaseInfo(?,?,?,?,?,?,?,?,?) }
</procedure>
<select id="fnGetCourseCodeByCourseId" parameterClass="java.lang.String" resultClass="java.lang.String">
<![CDATA[
select dbo.fnGetCourseCodeByCourseId(#VALUE#)
]]>
</select>
<select id="fnGetCourseCategoryById" parameterClass="java.lang.String" resultClass="java.lang.String">
<![CDATA[
select dbo.fnGetCourseCategoryById(#VALUE#)
]]>
</select>
<select id="fnGetCompanyPhone" resultClass="java.lang.String">
<![CDATA[
select dbo.fnGetCompanyPhone()
]]>
</select>
<resultMap class="com.ais.bean.SystemUserBean" id="corp_enroll_system_user_list_result">
<result property="descriptionEn" column="descriptionEn"/>
<result property="descriptionTc" column="descriptionTc"/>
<result property="email" column="email"/>
</resultMap>
<parameterMap class="java.util.Map" id="corp_enroll_system_user_list_param" >
<parameter property="emailNofificationCode" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="PO_ERR_TYPE" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_ERR_TEXT" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_RETURNSTR" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
</parameterMap>
<procedure id="WEB_spGetSystemUserListByEmailNotificationCode" parameterMap="corp_enroll_system_user_list_param" resultMap="corp_enroll_system_user_list_result">
{ call WEB_spGetSystemUserListByEmailNotificationCode(?,?,?,?) }
</procedure>
<resultMap class="com.ais.bean.CourseBean" id="corp_enroll_init_system_course_list_result">
<result property="courseId" column="courseId"/>
<result property="category" column="category"/>
<result property="examRequire" column="examRequire"/>
</resultMap>
<parameterMap class="java.util.Map" id="corp_enroll_init_system_course_list_param" >
<parameter property="PO_ERR_TYPE" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_ERR_TEXT" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_RETURNSTR" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
</parameterMap>
<procedure id="WEB_spInitSystemCourseList" resultMap="corp_enroll_init_system_course_list_result" parameterMap="corp_enroll_init_system_course_list_param">
{ call WEB_spInitSystemCourseList(?,?,?) }
</procedure>
<parameterMap class="java.util.Map" id="WEB_spCreateStudentReg_param" >
<parameter property="classID" jdbcType="NUMBERIC" javaType="java.math.BigDecimal" mode="IN" />
<parameter property="examID" jdbcType="NUMBERIC" javaType="java.math.BigDecimal" mode="IN" />
<parameter property="salutationID" jdbcType="NUMBERIC" javaType="java.math.BigDecimal" mode="IN" />
<parameter property="firstNameEn" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="surNameEn" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="nameTc" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="hkid_1" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="hkid_2" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="hkid_3" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="passPort" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="email_1" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="mobile" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="signImageBase64" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />
<parameter property="PO_ERR_TYPE" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_ERR_TEXT" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="PO_RETURNSTR" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
</parameterMap>
<procedure id="WEB_spCreateStudentReg" parameterMap="WEB_spCreateStudentReg_param" >
{ call WEB_spCreateStudentReg(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) }
</procedure>
</sqlMap>