-- apps_master.upOwnerAddress (PROCEDURE)
BEGIN
-- 	UPDATE apps_master.m_outlet_delivery_address
-- 	SET 
-- 	Address = Address1,
-- 	KodePos = KodePos1,
-- 	ProvinsiID = ProvinsiID1,
-- 	ProvinsiName = ProvinsiName1,
-- 	`KotaID` = KotaID1,
-- 	`KotaName` = KotaName1,
-- 	`KotaType` = KotaType1,
-- 	`KecamatanID` = KecamatanID1,
-- 	`KecamatanName` = KecamatanName1,
-- 	UpdatedBy = updatedBy1
-- 	WHERE
-- 	OutletID = OutletID1;
	
	INSERT INTO apps_master.m_outlet_delivery_address (UserID,OutletID,Address,KodePos,ProvinsiID,ProvinsiName,KotaID,KotaName,KecamatanID,KotaType,KecamatanName,UpdatedBy)
	VALUES (updatedBy1,OutletID1,Address1,KodePos1,ProvinsiID1,ProvinsiName1,KotaID1,KotaName1,KecamatanID1,KotaType1,KecamatanName1,updatedBy1)
	ON DUPLICATE KEY UPDATE Address = VALUES(Address), KodePos = VALUES(KodePos), ProvinsiID = VALUES(ProvinsiID), ProvinsiName = VALUES(ProvinsiName), KotaID = VALUES(KotaID),
	KotaName = VALUES(KotaName), KecamatanID = VALUES(KecamatanID), KotaType = VALUES(KotaType), KecamatanName = VALUES(KecamatanName), UpdatedBy = VALUES(UpdatedBy);

END